Job details
Job Description
As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus.Apply safely
To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.
Notice (8): Use of undefined constant border - assumed 'border' [APP/View/Jobs/externalview.ctp, line 206]Code Context'title'=> empty($job['Company']['hideName']) ? $job['Company']['name'] : 'Confidential Company',
'alt'=> empty($job['Company']['hideName']) ? $job['Company']['name'] : 'Confidential Company',
border=>"0"
$viewFile = '/var/www/html/laimoon/View/Jobs/externalview.ctp' $dataForView = array( 'uaPopup' => '', 'Urls' => array( 'providers' => 'https://providers.laimoon.com', 'recruiters' => 'https://partners.laimoon.com', 'canonical' => 'https://jobs.laimoon.com', 'courses' => 'https://courses.laimoon.com', '7days' => 'http://courses.7daysindubai.com', 'careers' => 'http://careers.7daysindubai.com', 'careerguide' => 'https://laimoon.com', 'jobs' => 'https://jobs.laimoon.com', 'cms' => 'http://cms.laimoon.com', 'profiles' => 'https://profiles.laimoon.com' ), 'availLocations' => array( 'uae' => array( 'name' => 'UAE', 'country_id' => '2', 'country_code' => 'ae', 'slug' => 'uae', 'global_location_id' => '225', 'rel_gloc_ids' => '251,250,249,248,247,246,245,244,225', 'currency' => 'AED', 'currency_name' => 'UAE Dirham', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Dubai', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'saudi' => array( 'name' => 'Saudi Arabia', 'country_id' => '183', 'country_code' => 'sa', 'slug' => 'saudi', 'global_location_id' => '187', 'rel_gloc_ids' => '274,273,272,271,269,268,267,266,265,264,263,262,261,260,259,258,257,256,255,254,253,187', 'currency' => 'SAR', 'currency_name' => 'Saudi Riyal', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Riyadh', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'india' => array( 'name' => 'India', 'country_id' => '99', 'country_code' => 'in', 'slug' => 'india', 'global_location_id' => '100', 'rel_gloc_ids' => '100,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,976,994,1263,1264', 'currency' => 'INR', 'currency_name' => 'Indian Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kolkata', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'south-africa' => array( 'name' => 'South Africa', 'country_id' => '236', 'country_code' => 'za', 'slug' => 'south-africa', 'global_location_id' => '197', 'rel_gloc_ids' => '197,498,499,500,501,502,503,504', 'currency' => 'ZAR', 'currency_name' => 'South African Rand', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Johannesburg', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'egypt' => array( 'name' => 'Egypt', 'country_id' => '61', 'country_code' => 'eg', 'slug' => 'egypt', 'global_location_id' => '64', 'rel_gloc_ids' => '64,955,957,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115', 'currency' => 'EGP', 'currency_name' => 'Egyptian pound', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Africa/Cairo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'singapore' => array( 'name' => 'Singapore', 'country_id' => '188', 'country_code' => 'sg', 'slug' => 'singapore', 'global_location_id' => '192', 'rel_gloc_ids' => '192,382,432,438,445,453', 'currency' => 'SGD', 'currency_name' => 'Singapore Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Singapore', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'qatar' => array( 'name' => 'Qatar', 'country_id' => '178', 'country_code' => 'qa', 'slug' => 'qatar', 'global_location_id' => '176', 'rel_gloc_ids' => '176,252', 'currency' => 'QAR', 'currency_name' => 'Qatar Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Qatar', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'pakistan' => array( 'name' => 'Pakistan', 'country_id' => '169', 'country_code' => 'pk', 'slug' => 'pakistan', 'global_location_id' => '164', 'rel_gloc_ids' => '164,979,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071', 'currency' => 'PKR', 'currency_name' => 'Pakistani rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Karachi', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'kuwait' => array( 'name' => 'Kuwait', 'country_id' => '116', 'country_code' => 'kw', 'slug' => 'kuwait', 'global_location_id' => '116', 'rel_gloc_ids' => '116,276,277,278,279,280,281', 'currency' => 'KWD', 'currency_name' => 'Kuwait Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuwait', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'oman' => array( 'name' => 'Oman', 'country_id' => '163', 'country_code' => 'om', 'slug' => 'oman', 'global_location_id' => '163', 'rel_gloc_ids' => '163,282,283,284,285,286,287,288,289,290,291', 'currency' => 'OMR', 'currency_name' => 'Oman Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Muscat', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'jordan' => array( 'name' => 'Jordan', 'country_id' => '106', 'country_code' => 'jo', 'slug' => 'jordan', 'global_location_id' => '110', 'rel_gloc_ids' => '110,958,959,1101,1247,1246,1245,1244,1243,1242,1241,1240,1239', 'currency' => 'JOD', 'currency_name' => 'Jordanian Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Amman', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'philippines' => array( 'name' => 'Philippines', 'country_id' => '168', 'country_code' => 'ph', 'slug' => 'philippines', 'global_location_id' => '171', 'rel_gloc_ids' => '171,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,1262', 'currency' => 'PHP', 'currency_name' => 'Philippine Peso', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Manila', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'bahrain' => array( 'name' => 'Bahrain', 'country_id' => '23', 'country_code' => 'bh', 'slug' => 'bahrain', 'global_location_id' => '17', 'rel_gloc_ids' => '17,292,293,294,295,314,297,298,299,300,301,302,303,304,1276,1277', 'currency' => 'BHD', 'currency_name' => 'Bahrain Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bahrain', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'sri-lanka' => array( 'name' => 'Sri Lanka', 'country_id' => '123', 'country_code' => 'lk', 'slug' => 'sri-lanka', 'global_location_id' => '200', 'rel_gloc_ids' => '200,1047,1048,1049,1084,1085,1086', 'currency' => 'LKR', 'currency_name' => 'Sri Lankan rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Colombo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'united-kingdom' => array( 'name' => 'United Kingdom', 'country_id' => '74', 'country_code' => 'gb', 'slug' => 'united-kingdom', 'global_location_id' => '226', 'rel_gloc_ids' => '226,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1050,1259,1260,1261,1267', 'currency' => 'GBP', 'currency_name' => 'British Pound', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/London', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'malaysia' => array( 'name' => 'Malaysia', 'country_id' => '149', 'country_code' => 'my', 'slug' => 'malaysia', 'global_location_id' => '131', 'rel_gloc_ids' => '131,131,980,1051', 'currency' => 'MYR', 'currency_name' => 'Ringgit', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuala_Lumpur', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nepal' => array( 'name' => 'Nepal', 'country_id' => '159', 'country_code' => 'np', 'slug' => 'nepal', 'global_location_id' => '151', 'rel_gloc_ids' => '151,981,1096,1097,1098', 'currency' => 'NPR', 'currency_name' => 'Nepalese Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kathmandu', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nigeria' => array( 'name' => 'Nigeria', 'country_id' => '155', 'country_code' => 'ng', 'slug' => 'nigeria', 'global_location_id' => '158', 'rel_gloc_ids' => '158,995,996,997,1095', 'currency' => 'NGN', 'currency_name' => 'Nigerian Naira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Lagos ', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'newzealand' => array( 'name' => 'New Zealand', 'country_id' => '162', 'country_code' => 'nz', 'slug' => 'newzealand', 'global_location_id' => '155', 'rel_gloc_ids' => '155,998,999,1080,1081,1082,1083', 'currency' => 'NZD', 'currency_name' => 'New Zealand Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Pacific/Auckland', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'brasil' => array( 'name' => 'Brasil', 'country_id' => '29', 'country_code' => 'br', 'slug' => 'brasil', 'global_location_id' => '30', 'rel_gloc_ids' => '30,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013', 'currency' => 'BRL', 'currency_name' => 'Brazilian Real', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'America/Sao_Paulo', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'portugal' => array( 'name' => 'Portugal', 'country_id' => '175', 'country_code' => 'pt', 'slug' => 'portugal', 'global_location_id' => '174', 'rel_gloc_ids' => '174,1014,1015,1087,1088,1089,1090', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Europe/Lisbon', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'canada' => array( 'name' => 'Canada', 'country_id' => '36', 'country_code' => 'ca', 'slug' => 'canada', 'global_location_id' => '38', 'rel_gloc_ids' => '38,1019,1020,1021,1022,1023,1024,1025', 'currency' => 'CAD', 'currency_name' => 'Canadian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Canada/Saskatchewan', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'united-states' => array( 'name' => 'United States', 'country_id' => '221', 'country_code' => 'us', 'slug' => 'united-states', 'global_location_id' => '227', 'rel_gloc_ids' => '227,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'America/New_York', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'angola' => array( 'name' => 'Angola', 'country_id' => '9', 'country_code' => 'ao', 'slug' => 'angola', 'global_location_id' => '6', 'rel_gloc_ids' => '6,1016,1091,1092,1093,1094', 'currency' => 'AOA', 'currency_name' => 'Angolan Kwanza', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Africa/Luanda', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'australia' => array( 'name' => 'Australia', 'country_id' => '14', 'country_code' => 'au', 'slug' => 'australia', 'global_location_id' => '13', 'rel_gloc_ids' => '13,1026,1027,1028,1029,1030', 'currency' => 'AUD', 'currency_name' => 'Australian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Australia/Melbourne', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'kenya' => array( 'name' => 'Kenya', 'country_id' => '108', 'country_code' => 'ke', 'slug' => 'kenya', 'global_location_id' => '112', 'rel_gloc_ids' => '112,1031,1032,1075,1076,1077,1078,1079', 'currency' => 'KES', 'currency_name' => 'Kenyan Shilling', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Nairobi', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ghana' => array( 'name' => 'Ghana', 'country_id' => '78', 'country_code' => 'gh', 'slug' => 'ghana', 'global_location_id' => '83', 'rel_gloc_ids' => '83,1033,1034,1072,1073,1074', 'currency' => 'GHS', 'currency_name' => 'Ghanaian Cedi', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Accra', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ireland' => array( 'name' => 'Ireland', 'country_id' => '98', 'country_code' => 'ie', 'slug' => 'ireland', 'global_location_id' => '104', 'rel_gloc_ids' => '104,104,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Dublin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'vietnam' => array( 'name' => 'Vietnam', 'country_id' => '229', 'country_code' => 'vn', 'slug' => 'vietnam', 'global_location_id' => '234', 'rel_gloc_ids' => '234,1170,1171', 'currency' => 'VND', 'currency_name' => 'Vietnamese Dong', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Ho_Chi_Minh', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'cyprus' => array( 'name' => 'Cyprus', 'country_id' => '51', 'country_code' => 'cy', 'slug' => 'cyprus', 'global_location_id' => '55', 'rel_gloc_ids' => '55,1230,1231,1232,1233', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Nicosia', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'malta' => array( 'name' => 'Malta', 'country_id' => '144', 'country_code' => 'mt', 'slug' => 'malta', 'global_location_id' => '134', 'rel_gloc_ids' => '134,1255,1254,1253,1252,1251,1250,1249,1248', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Malta', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'maldives' => array( 'name' => 'Maldives', 'country_id' => '146', 'country_code' => 'mv', 'slug' => 'maldives', 'global_location_id' => '132', 'rel_gloc_ids' => '132,1172', 'currency' => 'MVR', 'currency_name' => 'Maldivian rufiyaa', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Indian/Maldives', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'turkey' => array( 'name' => 'Turkey', 'country_id' => '213', 'country_code' => 'tr', 'slug' => 'turkey', 'global_location_id' => '219', 'rel_gloc_ids' => '219,1173,1174,1175,1176', 'currency' => 'TRY', 'currency_name' => 'Turkish lira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Istanbul', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'thailand' => array( 'name' => 'Thailand', 'country_id' => '206', 'country_code' => 'th', 'slug' => 'thailand', 'global_location_id' => '213', 'rel_gloc_ids' => '213,1177', 'currency' => 'THB', 'currency_name' => 'Baht', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bangkok', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'hong-kong' => array( 'name' => 'Hong Kong', 'country_id' => '91', 'country_code' => 'hk', 'slug' => 'hong-kong', 'global_location_id' => '97', 'rel_gloc_ids' => '97', 'currency' => 'HKD', 'currency_name' => 'Hong Kong dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Hong_Kong', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'germany' => array( 'name' => 'Germany', 'country_id' => '53', 'country_code' => 'de', 'slug' => 'germany', 'global_location_id' => '82', 'rel_gloc_ids' => '82,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Berlin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'netherlands' => array( 'name' => 'Netherlands', 'country_id' => '157', 'country_code' => 'nl', 'slug' => 'netherlands', 'global_location_id' => '152', 'rel_gloc_ids' => '152,1188,1189,1190,1191,1192,1193', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Amsterdam', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'japan' => array( 'name' => 'Japan', 'country_id' => '107', 'country_code' => 'jp', 'slug' => 'japan', 'global_location_id' => '108', 'rel_gloc_ids' => '108,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337', 'currency' => 'YEN', 'currency_name' => 'Japanese yen', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Search Results Web results Asia/Tokyo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'global' => array( 'name' => 'Global', 'country_id' => (int) 251, 'country_code' => 'on', 'slug' => 'global', 'global_location_id' => '275', 'rel_gloc_ids' => '275', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => null, 'job_location' => '0', 'published' => '1', 'show' => '1' ) ), 'currentLocation' => array( 'name' => 'Egypt', 'country_id' => '61', 'country_code' => 'eg', 'slug' => 'egypt', 'global_location_id' => '64', 'rel_gloc_ids' => '64,955,957,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115', 'currency' => 'EGP', 'currency_name' => 'Egyptian pound', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Africa/Cairo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'cityLists' => array( (int) 0 => array( 'name' => 'Dubai', 'slug' => 'dubai' ), (int) 1 => array( 'name' => 'Abu Dhabi', 'slug' => 'abu-dhabi' ), (int) 2 => array( 'name' => 'Ras al Khaimah', 'slug' => 'ras-al-khaimah' ), (int) 3 => array( 'name' => 'Al Ain', 'slug' => 'al-ain' ), (int) 4 => array( 'name' => 'Sharjah', 'slug' => 'sharjah' ), (int) 5 => array( 'name' => 'Fujairah', 'slug' => 'fujairah' ), (int) 6 => array( 'name' => 'Ajman', 'slug' => 'ajman' ), (int) 7 => array( 'name' => 'Umm Al Quwain', 'slug' => 'umm-al-quwain' ) ), 'menuState' => 'loggedoutmenu', 'showCVReviewLink' => false, 'profileInfo' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12152', 'contributedJobCount' => '24', 'courseCount' => null ), 'environment' => 'production', 'langUrlPrefix' => '', 'langUrl' => 'https://jobs.laimoon.com/', 'themeUrl' => 'https://jobs.laimoon.com/', 'siteUrl' => 'https://jobs.laimoon.com/', 'staticUrl' => 'https://cdn.laimoon.com/jobs/', 'langCode' => 'en', 'pageScripts' => array( (int) 0 => 'page_script' ), 'pageName' => 'externalview', 'courseUrl' => 'https://courses.laimoon.com/', 'onlineCourses' => array( (int) 0 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ), (int) 1 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ) ), 'job' => array( 'Job' => array( 'id' => '43108456', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'SQL Developer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<h2> Job Description </h2><p> As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus. </p>', 'course_qualifications' => null, 'global_location_id' => '64', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => 'Full time', 'salaryFrom' => null, 'salaryTo' => null, 'currency_id' => null, 'hide_salary' => '0', 'benefits' => null, 'salary_type_id' => null, 'travel_type_id' => null, 'travel_id' => null, 'education_id' => null, 'education_background' => null, 'language_id' => null, 'position_level_id' => null, 'position_type' => null, 'number_of_staffs_mange' => null, 'experiance' => null, 'sales_experience' => null, 'sales_focus' => null, 'sales_cycle_id' => null, 'reporting_to' => null, 'otherAssignments' => null, 'otherConsiderations' => null, 'ideal_candidate' => null, 'company_info' => null, 'company_id' => '52091', 'company_name' => 'Capgemini', 'external_apply_url' => 'https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=281324350fbc44b9d6d5144cdc739e1e', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:37', 'published' => '2024-04-20 03:28:37', 'closed_time' => null, 'updated' => '2024-04-20 03:28:37', 'hideCompany' => null, 'hide_contact_info' => '0', 'application_count' => '0', 'closed' => '0', 'draft' => '0', 'rejected' => '0', 'deleted' => '0', 'moderated' => '1', 'boosted' => '0', 'rejectnote' => null, 'job_extended' => '0', 'purchased' => '0', 'seeder_id' => '113', 'source_id' => 'jooble', 'course_keywords' => null, 'shortlist_magic_applied' => '0', 'shortlist_magic_keywords' => null, 'living_in' => '0', 'age_limit' => null, 'is_managerial' => '0', 'application_email' => null, 'quality_score' => null, 'reopened' => '0', 'quality_type' => 'White', 'promoted' => '0' ), 'Recruiter' => array( 'first_name' => 'Jooble Jobs', 'last_name' => null, 'recruiter_type' => 'company' ), 'GlobalLocation' => array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( [maximum depth reached] ) ), 'Company' => array( 'id' => '52091', 'name' => 'Capgemini', 'website' => 'https://www.capgemini.com/in-en/', 'verified' => '0', 'photo' => 'Capgemini_e08058a0-f1f5-11e9-bbf3-15f76e7ed41e.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ), 'jobsList' => array(), 'courses' => array(), 'promotedCourses' => array(), 'referer' => '/', 'urlKeyword' => 'SQL ', 'profile' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12152', 'contributedJobCount' => '24', 'courseCount' => null ), 'askLogin' => true, 'jobLinkTitle' => 'SQL ', 'renderSchema' => 'yes', 'title_for_layout' => 'SQL Developer jobs in Capgemini in Egypt.', 'page_description' => 'Apply to SQL Developer jobs in Capgemini in Egypt.Find similar vacancies, jobs and salary information in Egypt.', 'locationForTitle' => 'Egypt', 'currentJobCity' => array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( 'name' => 'Egypt', 'id' => '61', 'slug' => 'egypt', 'code' => 'EG' ) ), 'jobCompanyPage' => array( 'CompanyPage' => array( 'id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '28520', 'company_page_id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'summary' => null, 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ), 'location' => 'Egypt', 'breadCrumbs' => array( 'Job Details' => '' ), 'relCourseBanner' => array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'SQL Server', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management/sql-server' ), 'published' => '2024-04-20 03:28:37', 'daysleft' => (float) 17, 'isLoggedIn' => false, 'facebookSession' => null, 'fbConfig' => array( 'AppId' => '151651858238476', 'APIKey' => '1c032aa6c89b302e8ec5dea94dc89104', 'AppSecret' => 'f2b69d3a25fe65601f146efe7178e72a' ), 'linkedInConfig' => array( 'APIKey' => '779yus3aqi524z', 'AppSecret' => 'XCdGJxUokce5Ygf6' ), 'criticalCSSes' => array( 'jobdetail' => 'jobdetail-critical-css', 'companylist' => 'companylist-critical-css', 'companyview' => 'companyview-critical-css', 'agencylist' => 'agencylist-critical-css', 'agencyview' => 'agencyview-critical-css', 'laimoonverified' => 'laimoonverified-critical-css', 'seopages' => 'seopages-critical-css', 'externalview' => 'externalview-critical-css', 'popularjobsearches' => 'popularjobsearches-critical-css' ), 'basicProfileIncomplete' => true ) $uaPopup = '' $Urls = array( 'providers' => 'https://providers.laimoon.com', 'recruiters' => 'https://partners.laimoon.com', 'canonical' => 'https://jobs.laimoon.com', 'courses' => 'https://courses.laimoon.com', '7days' => 'http://courses.7daysindubai.com', 'careers' => 'http://careers.7daysindubai.com', 'careerguide' => 'https://laimoon.com', 'jobs' => 'https://jobs.laimoon.com', 'cms' => 'http://cms.laimoon.com', 'profiles' => 'https://profiles.laimoon.com' ) $availLocations = array( 'uae' => array( 'name' => 'UAE', 'country_id' => '2', 'country_code' => 'ae', 'slug' => 'uae', 'global_location_id' => '225', 'rel_gloc_ids' => '251,250,249,248,247,246,245,244,225', 'currency' => 'AED', 'currency_name' => 'UAE Dirham', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Dubai', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'saudi' => array( 'name' => 'Saudi Arabia', 'country_id' => '183', 'country_code' => 'sa', 'slug' => 'saudi', 'global_location_id' => '187', 'rel_gloc_ids' => '274,273,272,271,269,268,267,266,265,264,263,262,261,260,259,258,257,256,255,254,253,187', 'currency' => 'SAR', 'currency_name' => 'Saudi Riyal', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Riyadh', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'india' => array( 'name' => 'India', 'country_id' => '99', 'country_code' => 'in', 'slug' => 'india', 'global_location_id' => '100', 'rel_gloc_ids' => '100,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,976,994,1263,1264', 'currency' => 'INR', 'currency_name' => 'Indian Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kolkata', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'south-africa' => array( 'name' => 'South Africa', 'country_id' => '236', 'country_code' => 'za', 'slug' => 'south-africa', 'global_location_id' => '197', 'rel_gloc_ids' => '197,498,499,500,501,502,503,504', 'currency' => 'ZAR', 'currency_name' => 'South African Rand', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Johannesburg', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'egypt' => array( 'name' => 'Egypt', 'country_id' => '61', 'country_code' => 'eg', 'slug' => 'egypt', 'global_location_id' => '64', 'rel_gloc_ids' => '64,955,957,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115', 'currency' => 'EGP', 'currency_name' => 'Egyptian pound', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Africa/Cairo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'singapore' => array( 'name' => 'Singapore', 'country_id' => '188', 'country_code' => 'sg', 'slug' => 'singapore', 'global_location_id' => '192', 'rel_gloc_ids' => '192,382,432,438,445,453', 'currency' => 'SGD', 'currency_name' => 'Singapore Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Singapore', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'qatar' => array( 'name' => 'Qatar', 'country_id' => '178', 'country_code' => 'qa', 'slug' => 'qatar', 'global_location_id' => '176', 'rel_gloc_ids' => '176,252', 'currency' => 'QAR', 'currency_name' => 'Qatar Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Qatar', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'pakistan' => array( 'name' => 'Pakistan', 'country_id' => '169', 'country_code' => 'pk', 'slug' => 'pakistan', 'global_location_id' => '164', 'rel_gloc_ids' => '164,979,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071', 'currency' => 'PKR', 'currency_name' => 'Pakistani rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Karachi', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'kuwait' => array( 'name' => 'Kuwait', 'country_id' => '116', 'country_code' => 'kw', 'slug' => 'kuwait', 'global_location_id' => '116', 'rel_gloc_ids' => '116,276,277,278,279,280,281', 'currency' => 'KWD', 'currency_name' => 'Kuwait Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuwait', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'oman' => array( 'name' => 'Oman', 'country_id' => '163', 'country_code' => 'om', 'slug' => 'oman', 'global_location_id' => '163', 'rel_gloc_ids' => '163,282,283,284,285,286,287,288,289,290,291', 'currency' => 'OMR', 'currency_name' => 'Oman Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Muscat', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'jordan' => array( 'name' => 'Jordan', 'country_id' => '106', 'country_code' => 'jo', 'slug' => 'jordan', 'global_location_id' => '110', 'rel_gloc_ids' => '110,958,959,1101,1247,1246,1245,1244,1243,1242,1241,1240,1239', 'currency' => 'JOD', 'currency_name' => 'Jordanian Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Amman', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'philippines' => array( 'name' => 'Philippines', 'country_id' => '168', 'country_code' => 'ph', 'slug' => 'philippines', 'global_location_id' => '171', 'rel_gloc_ids' => '171,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,1262', 'currency' => 'PHP', 'currency_name' => 'Philippine Peso', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Manila', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'bahrain' => array( 'name' => 'Bahrain', 'country_id' => '23', 'country_code' => 'bh', 'slug' => 'bahrain', 'global_location_id' => '17', 'rel_gloc_ids' => '17,292,293,294,295,314,297,298,299,300,301,302,303,304,1276,1277', 'currency' => 'BHD', 'currency_name' => 'Bahrain Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bahrain', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'sri-lanka' => array( 'name' => 'Sri Lanka', 'country_id' => '123', 'country_code' => 'lk', 'slug' => 'sri-lanka', 'global_location_id' => '200', 'rel_gloc_ids' => '200,1047,1048,1049,1084,1085,1086', 'currency' => 'LKR', 'currency_name' => 'Sri Lankan rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Colombo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'united-kingdom' => array( 'name' => 'United Kingdom', 'country_id' => '74', 'country_code' => 'gb', 'slug' => 'united-kingdom', 'global_location_id' => '226', 'rel_gloc_ids' => '226,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1050,1259,1260,1261,1267', 'currency' => 'GBP', 'currency_name' => 'British Pound', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/London', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'malaysia' => array( 'name' => 'Malaysia', 'country_id' => '149', 'country_code' => 'my', 'slug' => 'malaysia', 'global_location_id' => '131', 'rel_gloc_ids' => '131,131,980,1051', 'currency' => 'MYR', 'currency_name' => 'Ringgit', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuala_Lumpur', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nepal' => array( 'name' => 'Nepal', 'country_id' => '159', 'country_code' => 'np', 'slug' => 'nepal', 'global_location_id' => '151', 'rel_gloc_ids' => '151,981,1096,1097,1098', 'currency' => 'NPR', 'currency_name' => 'Nepalese Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kathmandu', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nigeria' => array( 'name' => 'Nigeria', 'country_id' => '155', 'country_code' => 'ng', 'slug' => 'nigeria', 'global_location_id' => '158', 'rel_gloc_ids' => '158,995,996,997,1095', 'currency' => 'NGN', 'currency_name' => 'Nigerian Naira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Lagos ', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'newzealand' => array( 'name' => 'New Zealand', 'country_id' => '162', 'country_code' => 'nz', 'slug' => 'newzealand', 'global_location_id' => '155', 'rel_gloc_ids' => '155,998,999,1080,1081,1082,1083', 'currency' => 'NZD', 'currency_name' => 'New Zealand Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Pacific/Auckland', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'brasil' => array( 'name' => 'Brasil', 'country_id' => '29', 'country_code' => 'br', 'slug' => 'brasil', 'global_location_id' => '30', 'rel_gloc_ids' => '30,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013', 'currency' => 'BRL', 'currency_name' => 'Brazilian Real', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'America/Sao_Paulo', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'portugal' => array( 'name' => 'Portugal', 'country_id' => '175', 'country_code' => 'pt', 'slug' => 'portugal', 'global_location_id' => '174', 'rel_gloc_ids' => '174,1014,1015,1087,1088,1089,1090', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Europe/Lisbon', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'canada' => array( 'name' => 'Canada', 'country_id' => '36', 'country_code' => 'ca', 'slug' => 'canada', 'global_location_id' => '38', 'rel_gloc_ids' => '38,1019,1020,1021,1022,1023,1024,1025', 'currency' => 'CAD', 'currency_name' => 'Canadian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Canada/Saskatchewan', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'united-states' => array( 'name' => 'United States', 'country_id' => '221', 'country_code' => 'us', 'slug' => 'united-states', 'global_location_id' => '227', 'rel_gloc_ids' => '227,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'America/New_York', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'angola' => array( 'name' => 'Angola', 'country_id' => '9', 'country_code' => 'ao', 'slug' => 'angola', 'global_location_id' => '6', 'rel_gloc_ids' => '6,1016,1091,1092,1093,1094', 'currency' => 'AOA', 'currency_name' => 'Angolan Kwanza', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Africa/Luanda', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'australia' => array( 'name' => 'Australia', 'country_id' => '14', 'country_code' => 'au', 'slug' => 'australia', 'global_location_id' => '13', 'rel_gloc_ids' => '13,1026,1027,1028,1029,1030', 'currency' => 'AUD', 'currency_name' => 'Australian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Australia/Melbourne', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'kenya' => array( 'name' => 'Kenya', 'country_id' => '108', 'country_code' => 'ke', 'slug' => 'kenya', 'global_location_id' => '112', 'rel_gloc_ids' => '112,1031,1032,1075,1076,1077,1078,1079', 'currency' => 'KES', 'currency_name' => 'Kenyan Shilling', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Nairobi', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ghana' => array( 'name' => 'Ghana', 'country_id' => '78', 'country_code' => 'gh', 'slug' => 'ghana', 'global_location_id' => '83', 'rel_gloc_ids' => '83,1033,1034,1072,1073,1074', 'currency' => 'GHS', 'currency_name' => 'Ghanaian Cedi', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Accra', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ireland' => array( 'name' => 'Ireland', 'country_id' => '98', 'country_code' => 'ie', 'slug' => 'ireland', 'global_location_id' => '104', 'rel_gloc_ids' => '104,104,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Dublin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'vietnam' => array( 'name' => 'Vietnam', 'country_id' => '229', 'country_code' => 'vn', 'slug' => 'vietnam', 'global_location_id' => '234', 'rel_gloc_ids' => '234,1170,1171', 'currency' => 'VND', 'currency_name' => 'Vietnamese Dong', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Ho_Chi_Minh', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'cyprus' => array( 'name' => 'Cyprus', 'country_id' => '51', 'country_code' => 'cy', 'slug' => 'cyprus', 'global_location_id' => '55', 'rel_gloc_ids' => '55,1230,1231,1232,1233', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Nicosia', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'malta' => array( 'name' => 'Malta', 'country_id' => '144', 'country_code' => 'mt', 'slug' => 'malta', 'global_location_id' => '134', 'rel_gloc_ids' => '134,1255,1254,1253,1252,1251,1250,1249,1248', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Malta', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'maldives' => array( 'name' => 'Maldives', 'country_id' => '146', 'country_code' => 'mv', 'slug' => 'maldives', 'global_location_id' => '132', 'rel_gloc_ids' => '132,1172', 'currency' => 'MVR', 'currency_name' => 'Maldivian rufiyaa', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Indian/Maldives', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'turkey' => array( 'name' => 'Turkey', 'country_id' => '213', 'country_code' => 'tr', 'slug' => 'turkey', 'global_location_id' => '219', 'rel_gloc_ids' => '219,1173,1174,1175,1176', 'currency' => 'TRY', 'currency_name' => 'Turkish lira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Istanbul', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'thailand' => array( 'name' => 'Thailand', 'country_id' => '206', 'country_code' => 'th', 'slug' => 'thailand', 'global_location_id' => '213', 'rel_gloc_ids' => '213,1177', 'currency' => 'THB', 'currency_name' => 'Baht', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bangkok', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'hong-kong' => array( 'name' => 'Hong Kong', 'country_id' => '91', 'country_code' => 'hk', 'slug' => 'hong-kong', 'global_location_id' => '97', 'rel_gloc_ids' => '97', 'currency' => 'HKD', 'currency_name' => 'Hong Kong dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Hong_Kong', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'germany' => array( 'name' => 'Germany', 'country_id' => '53', 'country_code' => 'de', 'slug' => 'germany', 'global_location_id' => '82', 'rel_gloc_ids' => '82,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Berlin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'netherlands' => array( 'name' => 'Netherlands', 'country_id' => '157', 'country_code' => 'nl', 'slug' => 'netherlands', 'global_location_id' => '152', 'rel_gloc_ids' => '152,1188,1189,1190,1191,1192,1193', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Amsterdam', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'japan' => array( 'name' => 'Japan', 'country_id' => '107', 'country_code' => 'jp', 'slug' => 'japan', 'global_location_id' => '108', 'rel_gloc_ids' => '108,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337', 'currency' => 'YEN', 'currency_name' => 'Japanese yen', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Search Results Web results Asia/Tokyo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'global' => array( 'name' => 'Global', 'country_id' => (int) 251, 'country_code' => 'on', 'slug' => 'global', 'global_location_id' => '275', 'rel_gloc_ids' => '275', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => null, 'job_location' => '0', 'published' => '1', 'show' => '1' ) ) $currentLocation = array( 'name' => 'Egypt', 'country_id' => '61', 'country_code' => 'eg', 'slug' => 'egypt', 'global_location_id' => '64', 'rel_gloc_ids' => '64,955,957,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115', 'currency' => 'EGP', 'currency_name' => 'Egyptian pound', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Africa/Cairo', 'job_location' => '1', 'published' => '1', 'show' => '1' ) $cityLists = array( (int) 0 => array( 'name' => 'Dubai', 'slug' => 'dubai' ), (int) 1 => array( 'name' => 'Abu Dhabi', 'slug' => 'abu-dhabi' ), (int) 2 => array( 'name' => 'Ras al Khaimah', 'slug' => 'ras-al-khaimah' ), (int) 3 => array( 'name' => 'Al Ain', 'slug' => 'al-ain' ), (int) 4 => array( 'name' => 'Sharjah', 'slug' => 'sharjah' ), (int) 5 => array( 'name' => 'Fujairah', 'slug' => 'fujairah' ), (int) 6 => array( 'name' => 'Ajman', 'slug' => 'ajman' ), (int) 7 => array( 'name' => 'Umm Al Quwain', 'slug' => 'umm-al-quwain' ) ) $menuState = 'loggedoutmenu' $showCVReviewLink = false $profileInfo = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12152', 'contributedJobCount' => '24', 'courseCount' => null ) $environment = 'production' $langUrlPrefix = '' $langUrl = 'https://jobs.laimoon.com/' $themeUrl = 'https://jobs.laimoon.com/' $siteUrl = 'https://jobs.laimoon.com/' $staticUrl = 'https://cdn.laimoon.com/jobs/' $langCode = 'en' $pageScripts = array( (int) 0 => 'page_script' ) $pageName = 'externalview' $courseUrl = 'https://courses.laimoon.com/' $onlineCourses = array( (int) 0 => array( 'Course' => array( 'id' => '144623', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => null, 'title' => 'Certified PostgreSQL Professional', 'external_link' => 'https://www.vskills.in/certification/postgreSQL-certification', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => null, 'next_session' => null, 'schedules' => null, 'duration' => '1 To 2 Months', 'base_duration' => '0', 'timing' => 'Flexible', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Vskills', 'logo' => null, 'certificate_diploma' => 'yes', 'image' => null, 'brochure_url' => null, 'video' => null, 'cost' => null, 'price' => '3499', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '42', 'nondiscounted_base_price' => null, 'currency' => 'INR', 'discount' => '50% off through Laimoon!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<br /> PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. The certification acts as a proof of your skills on professional social media like LinkedIn and for better job prospects.<br /> <br /> <strong>Why should one take PostgreSQL Professional Certification?</strong><br /> Earning Vskills PostgreSQL Professional Certification can help candidate differentiate in today's competitive job market, broaden their employment opportunities by displaying their advanced skills, and result in higher earning potential.<br /> <br /> This Course is intended for professionals and graduates wanting to excel in their chosen areas. It is also well suited for those who are already working and would like to take certification for further career progression.<br /> <br /> <strong>Who will benefit from taking PostgreSQL Professional Certification?</strong><br /> Job seekers looking to find employment in database, software development, or IT departments of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.<br /> <br /> <strong>Benefits of Certification</strong> <ul> <li><strong>Government certification</strong></li> <li>Certification valid for life</li> <li>Lifelong e-learning access</li> <li>Learning Hours: 12+ hrs</li> </ul> <br /> <strong>How It Works</strong> <ol> <li>Select Certification & Register</li> <li>Receive Online e-Learning Access (LMS)</li> <li>Take exam online anywhere, anytime</li> <li>Get certified & Increase Employability</li> </ol> <strong>Test Details</strong> <ul> <li>Duration: 60 minutes</li> <li>No. of questions: 50</li> <li>Maximum marks: 50, Passing marks: 25 (50%).</li> <li>There is NO negative marking in this module.</li> <li>Online exam.</li> </ul> <br /> <strong>TABLE OF CONTENT</strong><br /> <br /> <strong>Database Basics</strong> <ul> <li>Client/Server Basics</li> <li>What is a Data?</li> <li>What is a Database?</li> <li>What is DBMS or Database Management System?</li> <li>Data Models</li> <li>Relational Theory</li> <li>Relational Model</li> <li>Databases and Tables</li> <li>What is RDBMS?</li> <li>RDBMS Architecture</li> <li>Database Communication Protocols</li> <li>SQL and the Relational Model</li> <li>Relational Operations</li> <li>SQL Evolution</li> </ul> <strong>PostgreSQL Basics</strong> <ul> <li>Understanding PostgreSQL and Its Uses</li> <li>Download and Install PostgreSQL Client pgAdmin</li> <li>Setup a Practice Database Using Referenced .tar File</li> <li>Create Database, Table, Insert, and Query Data – Part 1</li> <li>Create Database, Table, Insert, and Query Data – Part 2</li> <li>PostgreSQL Relationships Using What’s Called a Primary Key and Foreign Key</li> </ul> <strong>PostgreSQL Data Retrieval</strong> <ul> <li>Introduction to the SELECT Statement to Retrieve Rows of Data</li> <li>Introduction to the SELECT DISTINCT Statement</li> <li>SELECT Statement with WHERE Clause</li> <li>Insert Data into Tables, Update, and Delete Rows</li> </ul> <strong>Count Rows in PostgreSQL</strong> <ul> <li>Count All Rows Using the COUNT Function</li> <li>Use COUNT with the DISTINCT Clause</li> <li>Order Query Results with the ORDER BY Clause</li> <li>Using ORDER BY with ASC and DESC Modifiers</li> </ul> <strong>PostgreSQL Conditional Clauses</strong> <ul> <li>Query Rows of Data Using the BETWEEN Operator</li> <li>Introduction to NOT BETWEEN</li> <li>Search for a Specified Pattern in a Column Using the LIKE Operator</li> <li>Match a Value to a List of Values with the IN Operator</li> </ul> <strong>PostgreSQL Mathematical Operations</strong> <ul> <li>Using MIN and MAX Functions</li> <li>Using MIN and MAX with the ROUND Function</li> <li>Using the AVG and SUM Functions</li> <li>Using AVG and SUM with the ROUND Function</li> </ul> <strong>Using Joins in PostgreSQL</strong> <ul> <li>Group Data with the GROUP BY Clause</li> <li>The HAVING Clause</li> <li>PostgreSQL Aliases and the LIMIT Clause</li> <li>Exploring Inner Joins</li> <li>Exploring Outer Joins</li> </ul> <strong>PostgreSQL Datatypes and Table Constraints</strong> <ul> <li>Common PostgreSQL Datatypes</li> <li>Common PostgreSQL Constraints</li> <li>Advanced Administration of Your Database with ALTER TABLE</li> </ul> <strong>PostgreSQL Administration</strong> <ul> <li>Server Configuration</li> <li>Logging</li> <li>Backup and Recovery</li> <li>Client Authentication</li> <li>Vacuuming</li> <li>Database Roles</li> <li>Database Monitoring</li> </ul> ', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Anyone can apply for the online certification', 'about_school' => null, 'keywords' => 'Project Management,Database,PostgreSQL,database management,IT', 'job_matching_keywords' => null, 'instructor_bio' => null, 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '394,395', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '5788', 'trainer_ids' => null, 'created' => '2023-12-19 11:04:07', 'updated' => '2023-12-19 11:09:17', 'sort_order' => null, 'page' => 'JobListing', 'to_emails' => 'info@vskills.in', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '0', 'status' => 'active', 'collect_mode' => 'provider_verified', 'slug' => 'part-time-certified-postgresql-professional-vskills', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '0', 'accreditation' => null, 'accreditation_logos' => null, 'invoice_type' => 'CPC', 'payment_mode' => 'paid', 'invoice_value' => '5', 'invoice_click_value' => '0', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Part Time', 'study_timings' => '2', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'None', 'online_method' => null, 'delivery_languages' => 'en', 'career_path' => 'Database Administrator,Data Warehouse Manager,Systems Administrator', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"128170_en_c":350000000,"128171_en_c":350000000,"124982_en_c":350000000,"5153_en_c":350000000,"124983_en_c":350000000,"127944_en_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => null, 'cpa_recommended' => null, 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99468432', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '5788', 'name' => 'Vskills', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => null, 'location' => null, 'customer_name' => 'Rajat Kakkar', 'seeder_id' => '43', 'phone_number' => '47344723', 'pri_line_number' => '', 'address_street' => '711, Tower-2, ', 'address_building' => 'Pearls Omaxe, Netaji Subhash Place,', 'address_city' => 'Delhi', 'address_country' => 'India', 'addresss' => '711, Tower-2, , Pearls Omaxe, Netaji Subhash Place,, Delhi, India', 'invoice_email' => 'info@vskills.in', 'student_enrolment' => '1', 'masked_emails' => '1', 'moneyback' => '1', 'student_enrolment_processing_percentage' => '50', 'invoice_missed_calls' => '0', 'budget_alerts' => '0', 'budget_amount' => '0', 'budget_start_date' => null, 'provider_code' => '', 'payment_type' => null, 'intl_leads_enabled' => '0', 'invoice_notification' => '1', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1469622248-vskills-logo.jpg', 'logo_size' => '{"width":118,"height":82}', 'description' => null, 'website' => 'http://www.vskills.in/certification/', 'no_of_courses' => null, 'course_types' => 'Online/Distance education,Professional qualifications,Professional short courses,Corporate training', 'spotlight' => null, 'video_thumb' => null, 'video_embed_code' => '', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@vskills.in', 'contact_phone_number' => '+971 47344723', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:3;s:12:"total_points";i:3;s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => 'Yes', 'instant_callback_disabled' => '0', 'show_map' => '0', 'same_place' => '0', 'tier' => 'tier3', 'featured_advertiser' => '0', 'institution_type' => 'Training Institute', 'certificate' => null, 'hyperlocal_leads' => '0', 'training_mode' => 'Online', 'establish' => null, 'verify_code' => '', 'verify_status' => '1', 'course_csa_keywords' => null, 'untrusted' => '0', 'mobile_cpc_disabled' => '0', 'deleted' => '0', 'created' => '2016-07-22 09:38:49', 'modified' => '2023-12-14 14:30:13', 'pageview_enabled' => '1', 'timezone' => 'Asia/Kolkata', 'provider_status' => 'performance', 'cpc_direct_linking' => 'no', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Received', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => '{"ProfileCompleted":1,"B&WCourses":"254"}', 'verified_time' => '2023-10-26 16:45:07', 'profile_completed_time' => null, 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => null, 'course_type_ids' => '2', 'trusted' => '1', 'legacy' => '0', 'moderation_status' => 'trusted', 'rfp_email_alerts' => '0', 'rfp_unsubscribed' => '0', 'offer_start_date' => '0000-00-00', 'offer_end_date' => '0000-00-00', 'offer_price' => '0', 'discount_percentage' => '0', 'offer_published' => '0', 'offer_text' => '', 'resized' => '1', 'is_corporate' => '0', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '0', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1560255278_vskills-ce.jpg', 'lead_filters' => null, 'repeat_email_lead_alerts' => '1', 'load_blncr_weight' => '1', 'remote_option' => null, 'classroom_status' => 'pending', 'topup_info' => null, 'provider_rank' => '{"default":502,"rndm":988382,"r_82":502,"r_145":502,"r_737":502,"r_894":502,"r_79":502,"r_375":502,"r_662":502,"r_97":502,"r_95":502,"r_98":502,"r_14":502,"r_952":502,"r_142":502,"r_143":502,"r_400":502,"r_369":502,"r_383":502,"r_666":502,"r_86":502,"r_197":502,"r_20":502,"r_388":502,"r_87":502,"r_203":502,"r_80":502,"r_119":502,"r_15":502,"r_365":502,"r_361":502,"r_21":502,"r_115":502,"r_111":502,"r_17":502,"r_281":502,"r_12":502,"r_237":502,"r_399":502,"r_350":502,"r_398":502,"r_873":502,"r_653":502,"r_394":502,"r_9":502,"r_101":502,"r_323":502,"r_10":502,"r_607":502,"r_81":502,"r_123":502,"r_690":502,"r_146":502,"r_148":502,"r_381":502,"r_539":502,"r_364":502,"r_799":502,"r_206":502,"r_42":502,"r_114":502,"r_596":502,"r_536":502,"r_199":502,"r_422":502,"r_808":502,"r_112":502,"r_613":502,"r_84":502,"r_174":502,"r_401":502,"r_85":502,"r_177":502,"r_231":502,"r_187":502,"r_180":502,"r_918":502,"r_538":502,"r_738":502,"r_694":502,"r_597":502,"r_695":502,"r_963":502,"r_196":502,"r_194":502,"r_193":502,"r_652":502,"r_954":502,"r_599":502,"r_348":502,"r_752":502,"r_236":502,"r_188":502,"r_202":502,"r_88":502,"r_221":502,"r_219":502,"r_127":502,"r_124":502,"r_785":502,"r_955":502,"r_216":502,"r_215":502,"r_373":502,"r_370":502,"r_603":502,"r_351":502,"r_609":502,"r_610":502,"r_195":502,"r_192":502,"r_691":502,"r_890":502,"r_234":502,"r_267":502,"r_387":502,"r_173":502,"r_433":502,"r_113":502,"r_779":502,"r_689":502,"r_897":502,"r_214":502,"r_205":502,"r_681":502,"r_118":502,"r_66":502,"r_254":502,"r_253":502,"r_641":502,"r_403":502,"r_204":502,"r_207":502,"r_807":502,"r_898":502,"r_83":502,"r_758":502,"r_899":502,"r_149":502,"r_688":502,"r_809":502,"r_380":502,"r_730":502,"r_395":502,"r_726":502,"r_871":502,"r_887":502,"r_126":502,"r_891":502,"r_344":502,"r_911":502,"r_164":502,"r_498":502,"r_513":502,"r_161":502,"r_43":502,"r_210":502,"r_266":502,"r_810":502,"r_191":502,"r_646":502,"r_668":502,"r_151":502,"r_443":502,"r_432":502,"r_926":502,"r_419":502,"r_589":502,"r_847":502,"r_541":502,"r_705":502,"r_255":502,"r_697":502,"r_678":502,"r_436":502,"r_198":502,"r_362":502,"r_211":502,"r_345":502,"r_686":502,"r_346":502,"r_956":502,"r_347":502,"r_201":502,"r_420":502,"r_200":502,"r_826":502,"r_232":502,"r_700":502,"r_147":502,"r_406":502,"r_693":502,"r_888":502,"r_585":502,"r_382":502,"r_592":502,"r_128":502,"r_396":502,"r_860":502,"r_857":502,"r_424":502,"r_384":502,"r_89":502,"r_638":502,"r_514":502,"r_949":502,"r_916":502,"r_99":502,"r_178":502,"r_608":502,"r_439":502,"r_217":502,"r_960":502,"r_91":502,"r_261":502,"r_259":502,"r_734":502,"r_225":502,"r_696":502,"r_229":502,"r_731":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '222115', 'course_id' => '144623', 'title' => 'Certified PostgreSQL Professional', 'slug' => 'part-time-certified-postgresql-professional-vskills', 'external_link' => 'https://www.vskills.in/certification/postgreSQL-certification', 'summary' => '<br /> PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. The certification acts as a proof of your skills on professional social media like LinkedIn and for better job prospects.<br /> <br /> <strong>Why should one take PostgreSQL Professional Certification?</strong><br /> Earning Vskills PostgreSQL Professional Certification can help candidate differentiate in today's competitive job market, broaden their employment opportunities by displaying their advanced skills, and result in higher earning potential.<br /> <br /> This Course is intended for professionals and graduates wanting to excel in their chosen areas. It is also well suited for those who are already working and would like to take certification for further career progression.<br /> <br /> <strong>Who will benefit from taking PostgreSQL Professional Certification?</strong><br /> Job seekers looking to find employment in database, software development, or IT departments of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.<br /> <br /> <strong>Benefits of Certification</strong> <ul> <li><strong>Government certification</strong></li> <li>Certification valid for life</li> <li>Lifelong e-learning access</li> <li>Learning Hours: 12+ hrs</li> </ul> <br /> <strong>How It Works</strong> <ol> <li>Select Certification & Register</li> <li>Receive Online e-Learning Access (LMS)</li> <li>Take exam online anywhere, anytime</li> <li>Get certified & Increase Employability</li> </ol> <strong>Test Details</strong> <ul> <li>Duration: 60 minutes</li> <li>No. of questions: 50</li> <li>Maximum marks: 50, Passing marks: 25 (50%).</li> <li>There is NO negative marking in this module.</li> <li>Online exam.</li> </ul> <br /> <strong>TABLE OF CONTENT</strong><br /> <br /> <strong>Database Basics</strong> <ul> <li>Client/Server Basics</li> <li>What is a Data?</li> <li>What is a Database?</li> <li>What is DBMS or Database Management System?</li> <li>Data Models</li> <li>Relational Theory</li> <li>Relational Model</li> <li>Databases and Tables</li> <li>What is RDBMS?</li> <li>RDBMS Architecture</li> <li>Database Communication Protocols</li> <li>SQL and the Relational Model</li> <li>Relational Operations</li> <li>SQL Evolution</li> </ul> <strong>PostgreSQL Basics</strong> <ul> <li>Understanding PostgreSQL and Its Uses</li> <li>Download and Install PostgreSQL Client pgAdmin</li> <li>Setup a Practice Database Using Referenced .tar File</li> <li>Create Database, Table, Insert, and Query Data – Part 1</li> <li>Create Database, Table, Insert, and Query Data – Part 2</li> <li>PostgreSQL Relationships Using What’s Called a Primary Key and Foreign Key</li> </ul> <strong>PostgreSQL Data Retrieval</strong> <ul> <li>Introduction to the SELECT Statement to Retrieve Rows of Data</li> <li>Introduction to the SELECT DISTINCT Statement</li> <li>SELECT Statement with WHERE Clause</li> <li>Insert Data into Tables, Update, and Delete Rows</li> </ul> <strong>Count Rows in PostgreSQL</strong> <ul> <li>Count All Rows Using the COUNT Function</li> <li>Use COUNT with the DISTINCT Clause</li> <li>Order Query Results with the ORDER BY Clause</li> <li>Using ORDER BY with ASC and DESC Modifiers</li> </ul> <strong>PostgreSQL Conditional Clauses</strong> <ul> <li>Query Rows of Data Using the BETWEEN Operator</li> <li>Introduction to NOT BETWEEN</li> <li>Search for a Specified Pattern in a Column Using the LIKE Operator</li> <li>Match a Value to a List of Values with the IN Operator</li> </ul> <strong>PostgreSQL Mathematical Operations</strong> <ul> <li>Using MIN and MAX Functions</li> <li>Using MIN and MAX with the ROUND Function</li> <li>Using the AVG and SUM Functions</li> <li>Using AVG and SUM with the ROUND Function</li> </ul> <strong>Using Joins in PostgreSQL</strong> <ul> <li>Group Data with the GROUP BY Clause</li> <li>The HAVING Clause</li> <li>PostgreSQL Aliases and the LIMIT Clause</li> <li>Exploring Inner Joins</li> <li>Exploring Outer Joins</li> </ul> <strong>PostgreSQL Datatypes and Table Constraints</strong> <ul> <li>Common PostgreSQL Datatypes</li> <li>Common PostgreSQL Constraints</li> <li>Advanced Administration of Your Database with ALTER TABLE</li> </ul> <strong>PostgreSQL Administration</strong> <ul> <li>Server Configuration</li> <li>Logging</li> <li>Backup and Recovery</li> <li>Client Authentication</li> <li>Vacuuming</li> <li>Database Roles</li> <li>Database Monitoring</li> </ul> ', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Database Administrator,Data Warehouse Manager,Systems Administrator', 'eligibility' => 'Anyone can apply for the online certification', 'school' => 'Vskills', 'keywords' => 'Project Management,Database,PostgreSQL,database management,IT', 'location' => 'Online', 'duration' => '1 To 2 Months', 'timing' => 'Flexible', 'cost' => null, 'discount' => null, 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'en', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ), (int) 1 => array( 'Course' => array( 'id' => '128869', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => '0', 'title' => 'MCSA Windows Server 2016 (70-740) ', 'external_link' => 'https://lead-academy.org/course/mcsa-windows-server-2016-70-740/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 6 Hours', 'base_duration' => '0', 'timing' => 'Flexible', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Lead Academy', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '20', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '12', 'nondiscounted_base_price' => '390', 'currency' => 'GBP', 'discount' => '97% off through Laimoon!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this MCSA Windows Server ) course will set you up with a solid foundation to become a confident networking engineer and develop more advanced skills.<br /> <br /> This comprehensive MCSA Windows Server ) course is the perfect way to kickstart your career in the field of windows server and networking. This accredited course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.<br /> <br /> As one of the leading course providers and most renowned e-learning specialists online, we’re dedicated to giving you the best educational experience possible. This course is crafted by industry experts, to enable you to learn quickly and efficiently, and at your own pace and convenience.<br /> <br /> <strong>How Will I Benefit?</strong> <ul> <li>Boost your career in windows server and networking</li> <li>Deepen your knowledge and skills in your chosen field just in hours not years!</li> <li>Study a course that has been designed by industry professionals.</li> <li>Save money and time by studying your convenient time</li> <li>Have access to a tutor whenever you are in need</li> </ul> So, what are you thinking about! Start getting the benefits by enrolling today!<br /> <br /> <strong>Why Choose Lead Academy:</strong> <ul> <li>Lifetime Access</li> <li>High-quality e-learning study materials </li> <li>The UK and globally recognized qualification</li> <li>Self-paced, no fixed schedules</li> <li>24/7 customer support through email</li> <li>Available to students anywhere in the world</li> <li>No hidden fee</li> <li>Study in a user-friendly, advanced online learning platform</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This comprehensive MCSA Windows Server ) course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of windows server and networking.<br /> <br /> <strong>Certification</strong><br /> <br /> On successful completion of the MCSA Windows Server ) course, you will be eligible to obtain a verifiable certificate as proof of your new qualification. This means that you/your employer can verify your qualification through our website. Certificate can be obtained in PDF version at a cost of £10, and there is an additional fee to obtain a printed copy certificate which is £29.<br /> <br /> <strong>Career path</strong><br /> <br /> This MCSA Windows Server ) course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your qualifications to your CV, enhance your career, and become more competitive in your chosen industry.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => '<ul> <li>There are no academic entry requirements for this MCSA Windows Server ) course, and it is open to students of all academic ;</li> <li>As long as you are aged seventeen or over and have a basic grasp of English, numeracy, and ICT, you will be eligible to enroll.</li> </ul> ', 'about_school' => '', 'keywords' => 'MCSA,Microsoft,MCSE,Sqlserver,SQL', 'job_matching_keywords' => null, 'instructor_bio' => '', 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '890,395,872', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '10236', 'trainer_ids' => null, 'created' => '2020-10-17 17:52:57', 'updated' => '2020-10-17 18:09:58', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@lead-academy.org', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider_verified', 'slug' => 'part-time-mcsa-windows-server-2016-70-740-lead-academy', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '0', 'accreditation' => '0', 'accreditation_logos' => 'CPD Certification Service,IPHM', 'invoice_type' => 'Free', 'payment_mode' => 'paid', 'invoice_value' => '5', 'invoice_click_value' => '0', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Part Time', 'study_timings' => '2', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'None', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'Internship Program in MCSA,Windows Engineer,Window Assembler', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"88907_en_f":350000000,"222415_en_c":350000000,"5153_en_c":350000000,"128170_en_c":350000000,"128028_en_c":350000000,"128171_en_c":350000000,"128027_en_c":350000000,"222078_en_c":350000000,"179470_en_c":350000000,"70404_en_f":350000000,"217094_en_c":350000000,"217424_en_c":350000000,"89595_en_f":350000000,"124983_en_c":350000000,"217303_en_c":350000000,"71011_en_f":350000000,"124982_en_c":350000000,"217396_en_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '0', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99900425', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '10236', 'name' => 'Lead Academy', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'lead-academy', 'location' => null, 'customer_name' => 'David Foster', 'seeder_id' => '43', 'phone_number' => '+447960579006', 'pri_line_number' => '', 'address_street' => 'Office 15, Pure Offices, Kembrey Park', 'address_building' => '', 'address_city' => 'Swindon', 'address_country' => 'United Kingdom', 'addresss' => 'Office 15, Pure Offices, Kembrey Park, Swindon, United Kingdom', 'invoice_email' => 'info@lead-academy.org', 'student_enrolment' => '1', 'masked_emails' => '1', 'moneyback' => '1', 'student_enrolment_processing_percentage' => '50', 'invoice_missed_calls' => '0', 'budget_alerts' => '0', 'budget_amount' => '0', 'budget_start_date' => null, 'provider_code' => '', 'payment_type' => 'CPC', 'intl_leads_enabled' => '0', 'invoice_notification' => '0', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1581072749-d-Academy-New-blackbg.jpg', 'logo_size' => '{"width":1450,"height":310}', 'description' => 'Lead Academy is a leading online training company providing state-of-the-art training and qualifications. At Lead Academy, we know that everyone is different, that’s why we offer a comprehensive range of courses to suit all needs.<br /> <br /> We are committed to providing exceptional learning experiences that support learning and development through the use of innovative online training techniques that not only educate and enhance the skills of our learners but ultimately help them to succeed.<br /> <br /> We work in conjunction with leading industry sector professionals to produce high-quality, affordable courses designed to develop the practical skills and knowledge required to take back to and implement in the workplace, delivering real results for you and your business to thrive.<br /> <br /> <br /> We offer a wide range of courses suitable for all levels. Whether you want to advance your career or simply learn something new, we’ll have the course for you.<br /> ', 'website' => 'https://lead-academy.org/', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => null, 'video_embed_code' => '', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@lead-academy.org', 'contact_phone_number' => '+44 7960579006', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => 'a:1:{s:2:"r1";a:2:{s:7:"dec_avg";d:0;s:9:"whole_avg";d:0;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => 'No', 'instant_callback_disabled' => '1', 'show_map' => '0', 'same_place' => '0', 'tier' => 'tier3', 'featured_advertiser' => '0', 'institution_type' => 'Training Institute', 'certificate' => null, 'hyperlocal_leads' => '0', 'training_mode' => 'Online', 'establish' => null, 'verify_code' => '', 'verify_status' => '1', 'course_csa_keywords' => null, 'untrusted' => '0', 'mobile_cpc_disabled' => '0', 'deleted' => '0', 'created' => '2019-12-04 19:49:20', 'modified' => '2021-08-30 18:28:42', 'pageview_enabled' => '1', 'timezone' => 'Europe/London', 'provider_status' => 'performance', 'cpc_direct_linking' => 'no', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Contacted', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2019-12-20 11:56:45', 'profile_completed_time' => '2019-12-04 19:57:37', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => 'https://partners.laimoon.com/', 'course_type_ids' => '2,7', 'trusted' => '0', 'legacy' => '0', 'moderation_status' => 'verified', 'rfp_email_alerts' => '0', 'rfp_unsubscribed' => '0', 'offer_start_date' => '0000-00-00', 'offer_end_date' => '0000-00-00', 'offer_price' => '0', 'discount_percentage' => '0', 'offer_published' => '0', 'offer_text' => '', 'resized' => '1', 'is_corporate' => '1', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '0', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1630332968_lead-acade.jpg', 'lead_filters' => null, 'repeat_email_lead_alerts' => '1', 'load_blncr_weight' => '1', 'remote_option' => null, 'classroom_status' => 'pending', 'topup_info' => null, 'provider_rank' => '{"default":502,"rndm":889517,"r_79":502,"r_369":502,"r_373":502,"r_98":502,"r_425":502,"r_95":502,"r_419":502,"r_589":502,"r_763":502,"r_852":502,"r_851":502,"r_10":502,"r_94":502,"r_759":502,"r_527":502,"r_441":502,"r_315":502,"r_848":502,"r_776":502,"r_312":502,"r_81":502,"r_382":502,"r_592":502,"r_955":502,"r_126":502,"r_511":502,"r_588":502,"r_795":502,"r_656":502,"r_762":502,"r_12":502,"r_231":502,"r_69":502,"r_52":502,"r_335":502,"r_330":502,"r_332":502,"r_66":502,"r_254":502,"r_884":502,"r_294":502,"r_26":502,"r_17":502,"r_348":502,"r_86":502,"r_183":502,"r_715":502,"r_541":502,"r_725":502,"r_840":502,"r_723":502,"r_89":502,"r_229":502,"r_292":502,"r_378":502,"r_607":502,"r_268":502,"r_269":502,"r_345":502,"r_27":502,"r_847":502,"r_844":502,"r_88":502,"r_217":502,"r_388":502,"r_193":502,"r_85":502,"r_385":502,"r_811":502,"r_80":502,"r_114":502,"r_610":502,"r_596":502,"r_797":502,"r_900":502,"r_111":502,"r_226":502,"r_933":502,"r_14":502,"r_266":502,"r_660":502,"r_439":502,"r_791":502,"r_320":502,"r_82":502,"r_146":502,"r_617":502,"r_490":502,"r_375":502,"r_700":502,"r_383":502,"r_90":502,"r_497":502,"r_313":502,"r_60":502,"r_253":502,"r_112":502,"r_658":502,"r_281":502,"r_83":502,"r_927":502,"r_257":502,"r_757":502,"r_707":502,"r_611":502,"r_814":502,"r_846":502,"r_845":502,"r_209":502,"r_367":502,"r_523":502,"r_760":502,"r_929":502,"r_901":502,"r_415":502,"r_148":502,"r_195":502,"r_87":502,"r_198":502,"r_657":502,"r_170":502,"r_168":502,"r_670":502,"r_167":502,"r_314":502,"r_122":502,"r_821":502,"r_113":502,"r_778":502,"r_838":502,"r_831":502,"r_829":502,"r_614":502,"r_945":502,"r_502":502,"r_689":502,"r_897":502,"r_299":502,"r_255":502,"r_839":502,"r_830":502,"r_128":502,"r_120":502,"r_747":502,"r_142":502,"r_143":502,"r_799":502,"r_507":502,"r_508":502,"r_859":502,"r_381":502,"r_736":502,"r_590":502,"r_539":502,"r_697":502,"r_807":502,"r_888":502,"r_216":502,"r_221":502,"r_215":502,"r_119":502,"r_911":502,"r_609":502,"r_222":502,"r_514":502,"r_227":502,"r_96":502,"r_823":502,"r_912":502,"r_639":502,"r_749":502,"r_819":502,"r_861":502,"r_857":502,"r_850":502,"r_223":502,"r_943":502,"r_914":502,"r_798":502,"r_403":502,"r_404":502,"r_655":502,"r_118":502,"r_809":502,"r_237":502,"r_512":502,"r_786":502,"r_256":502,"r_329":502,"r_125":502,"r_910":502,"r_854":502,"r_866":502,"r_70":502,"r_500":502,"r_147":502,"r_387":502,"r_922":502,"r_779":502,"r_20":502,"r_163":502,"r_166":502,"r_164":502,"r_401":502,"r_599":502,"r_196":502,"r_123":502,"r_204":502,"r_731":502,"r_802":502,"r_633":502,"r_820":502,"r_930":502,"r_233":502,"r_110":502,"r_582":502,"r_15":502,"r_207":502,"r_188":502,"r_860":502,"r_97":502,"r_370":502,"r_709":502,"r_316":502,"r_683":502,"r_812":502,"r_882":502,"r_374":502,"r_636":502,"r_816":502,"r_394":502,"r_397":502,"r_84":502,"r_174":502,"r_194":502,"r_187":502,"r_230":502,"r_705":502,"r_251":502,"r_436":502,"r_180":502,"r_354":502,"r_380":502,"r_399":502,"r_826":502,"r_351":502,"r_703":502,"r_671":502,"r_959":502,"r_124":502,"r_784":502,"r_923":502,"r_127":502,"r_867":502,"r_190":502,"r_953":502,"r_813":502,"r_785":502,"r_746":502,"r_587":502,"r_531":502,"r_794":502,"r_887":502,"r_788":502,"r_864":502,"r_865":502,"r_956":502,"r_349":502,"r_808":502,"r_9":502,"r_496":502,"r_242":502,"r_581":502,"r_323":502,"r_421":502,"r_91":502,"r_261":502,"r_259":502,"r_734":502,"r_755":502,"r_780":502,"r_726":502,"r_267":502,"r_265":502,"r_652":502,"r_954":502,"r_201":502,"r_679":502,"r_199":502,"r_161":502,"r_353":502,"r_352":502,"r_672":502,"r_777":502,"r_236":502,"r_918":502,"r_205":502,"r_364":502,"r_608":502,"r_665":502,"r_389":502,"r_618":502,"r_593":502,"r_890":502,"r_395":502,"r_398":502,"r_872":502,"r_400":502,"r_653":502,"r_694":502,"r_357":502,"r_597":502,"r_396":502,"r_738":502,"r_743":502,"r_521":502,"r_832":502,"r_203":502,"r_241":502,"r_745":502,"r_842":502,"r_516":502,"r_232":502,"r_526":502,"r_761":502,"r_818":502,"r_898":502,"r_781":502,"r_309":502,"r_412":502,"r_769":502,"r_843":502,"r_754":502,"r_748":502,"r_121":502,"r_758":502,"r_169":502,"r_319":502,"r_668":502,"r_822":502,"r_420":502,"r_328":502,"r_218":502,"r_192":502,"r_234":502,"r_645":502,"r_533":502,"r_181":502,"r_868":502,"r_362":502,"r_211":502,"r_619":502,"r_391":502,"r_691":502,"r_408":502,"r_724":502,"r_393":502,"r_637":502,"r_43":502,"r_172":502,"r_615":502,"r_805":502,"r_626":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '201462', 'course_id' => '128869', 'title' => 'MCSA Windows Server 2016 (70-740) ', 'slug' => 'part-time-mcsa-windows-server-2016-70-740-lead-academy', 'external_link' => 'https://lead-academy.org/course/mcsa-windows-server-2016-70-740/', 'summary' => '<strong>Overview</strong><br /> <br /> Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this MCSA Windows Server ) course will set you up with a solid foundation to become a confident networking engineer and develop more advanced skills.<br /> <br /> This comprehensive MCSA Windows Server ) course is the perfect way to kickstart your career in the field of windows server and networking. This accredited course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.<br /> <br /> As one of the leading course providers and most renowned e-learning specialists online, we’re dedicated to giving you the best educational experience possible. This course is crafted by industry experts, to enable you to learn quickly and efficiently, and at your own pace and convenience.<br /> <br /> <strong>How Will I Benefit?</strong> <ul> <li>Boost your career in windows server and networking</li> <li>Deepen your knowledge and skills in your chosen field just in hours not years!</li> <li>Study a course that has been designed by industry professionals.</li> <li>Save money and time by studying your convenient time</li> <li>Have access to a tutor whenever you are in need</li> </ul> So, what are you thinking about! Start getting the benefits by enrolling today!<br /> <br /> <strong>Why Choose Lead Academy:</strong> <ul> <li>Lifetime Access</li> <li>High-quality e-learning study materials </li> <li>The UK and globally recognized qualification</li> <li>Self-paced, no fixed schedules</li> <li>24/7 customer support through email</li> <li>Available to students anywhere in the world</li> <li>No hidden fee</li> <li>Study in a user-friendly, advanced online learning platform</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This comprehensive MCSA Windows Server ) course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of windows server and networking.<br /> <br /> <strong>Certification</strong><br /> <br /> On successful completion of the MCSA Windows Server ) course, you will be eligible to obtain a verifiable certificate as proof of your new qualification. This means that you/your employer can verify your qualification through our website. Certificate can be obtained in PDF version at a cost of £10, and there is an additional fee to obtain a printed copy certificate which is £29.<br /> <br /> <strong>Career path</strong><br /> <br /> This MCSA Windows Server ) course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your qualifications to your CV, enhance your career, and become more competitive in your chosen industry.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Internship Program in MCSA,Windows Engineer,Window Assembler', 'eligibility' => '<ul> <li>There are no academic entry requirements for this MCSA Windows Server ) course, and it is open to students of all academic ;</li> <li>As long as you are aged seventeen or over and have a basic grasp of English, numeracy, and ICT, you will be eligible to enroll.</li> </ul> ', 'school' => 'Lead Academy', 'keywords' => 'MCSA,Microsoft,MCSE,Sqlserver,SQL', 'location' => 'Online', 'duration' => 'Upto 6 Hours', 'timing' => 'Flexible', 'cost' => null, 'discount' => '97% off through Laimoon!', 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'en', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ) ) $job = array( 'Job' => array( 'id' => '43108456', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'SQL Developer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<h2> Job Description </h2><p> As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus. </p>', 'course_qualifications' => null, 'global_location_id' => '64', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => 'Full time', 'salaryFrom' => null, 'salaryTo' => null, 'currency_id' => null, 'hide_salary' => '0', 'benefits' => null, 'salary_type_id' => null, 'travel_type_id' => null, 'travel_id' => null, 'education_id' => null, 'education_background' => null, 'language_id' => null, 'position_level_id' => null, 'position_type' => null, 'number_of_staffs_mange' => null, 'experiance' => null, 'sales_experience' => null, 'sales_focus' => null, 'sales_cycle_id' => null, 'reporting_to' => null, 'otherAssignments' => null, 'otherConsiderations' => null, 'ideal_candidate' => null, 'company_info' => null, 'company_id' => '52091', 'company_name' => 'Capgemini', 'external_apply_url' => 'https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=281324350fbc44b9d6d5144cdc739e1e', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:37', 'published' => '2024-04-20 03:28:37', 'closed_time' => null, 'updated' => '2024-04-20 03:28:37', 'hideCompany' => null, 'hide_contact_info' => '0', 'application_count' => '0', 'closed' => '0', 'draft' => '0', 'rejected' => '0', 'deleted' => '0', 'moderated' => '1', 'boosted' => '0', 'rejectnote' => null, 'job_extended' => '0', 'purchased' => '0', 'seeder_id' => '113', 'source_id' => 'jooble', 'course_keywords' => null, 'shortlist_magic_applied' => '0', 'shortlist_magic_keywords' => null, 'living_in' => '0', 'age_limit' => null, 'is_managerial' => '0', 'application_email' => null, 'quality_score' => null, 'reopened' => '0', 'quality_type' => 'White', 'promoted' => '0' ), 'Recruiter' => array( 'first_name' => 'Jooble Jobs', 'last_name' => null, 'recruiter_type' => 'company' ), 'GlobalLocation' => array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( 'name' => 'Egypt', 'id' => '61', 'slug' => 'egypt', 'code' => 'EG' ) ), 'Company' => array( 'id' => '52091', 'name' => 'Capgemini', 'website' => 'https://www.capgemini.com/in-en/', 'verified' => '0', 'photo' => 'Capgemini_e08058a0-f1f5-11e9-bbf3-15f76e7ed41e.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ) $jobsList = array() $courses = array() $promotedCourses = array() $referer = '/' $urlKeyword = 'SQL ' $profile = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12152', 'contributedJobCount' => '24', 'courseCount' => null ) $askLogin = true $jobLinkTitle = 'SQL ' $renderSchema = 'yes' $title_for_layout = 'SQL Developer jobs in Capgemini in Egypt.' $page_description = 'Apply to SQL Developer jobs in Capgemini in Egypt.Find similar vacancies, jobs and salary information in Egypt.' $locationForTitle = 'Egypt' $currentJobCity = array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( 'name' => 'Egypt', 'id' => '61', 'slug' => 'egypt', 'code' => 'EG' ) ) $jobCompanyPage = array( 'CompanyPage' => array( 'id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '28520', 'company_page_id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'summary' => null, 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ) $location = 'Egypt' $breadCrumbs = array( 'Job Details' => '' ) $relCourseBanner = array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'SQL Server', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management/sql-server' ) $published = '2024-04-20 03:28:37' $daysleft = (float) 17 $isLoggedIn = false $facebookSession = null $fbConfig = array( 'AppId' => '151651858238476', 'APIKey' => '1c032aa6c89b302e8ec5dea94dc89104', 'AppSecret' => 'f2b69d3a25fe65601f146efe7178e72a' ) $linkedInConfig = array( 'APIKey' => '779yus3aqi524z', 'AppSecret' => 'XCdGJxUokce5Ygf6' ) $criticalCSSes = array( 'jobdetail' => 'jobdetail-critical-css', 'companylist' => 'companylist-critical-css', 'companyview' => 'companyview-critical-css', 'agencylist' => 'agencylist-critical-css', 'agencyview' => 'agencyview-critical-css', 'laimoonverified' => 'laimoonverified-critical-css', 'seopages' => 'seopages-critical-css', 'externalview' => 'externalview-critical-css', 'popularjobsearches' => 'popularjobsearches-critical-css' ) $basicProfileIncomplete = true $seeAllJobLink = 'https://jobs.laimoon.com/egypt/SQL ' $csaKeywords = array( (int) 0 => 'SQL Developer' ) $allowLoginClass = 'notlogin' $jobLocSlug = 'egypt' $jobLocName = 'Egypt' $pfBackgrounds = '' $jobLink = 'https://jobs.laimoon.com/jobs/externalview/43108456' $companyName = ' at Capgemini' $twitterText = 'Hiring now! SQL Developer at Capgemini. Please apply or share https://jobs.laimoon.com/jobs/externalview/43108456' $emailText = 'Hiring now! SQL Developer at Capgemini. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/43108456' $sCompanyName = false $csaSearchKey = 'SQL Developer' $jobDetails = 'job details' $btn_text = 'Apply on company website' $confidentialExists = false $showCompany = (int) 1 $mainCheck = (int) 1 $confidentialThumbClass = '' $cdnImageThumbPath = 'https://cdn.laimoon.com/profileimages/thumbnail/' $companyPageTitle = 'Capgemini'include - APP/View/Jobs/externalview.ctp, line 206 View::_evaluate() - CORE/Cake/View/View.php, line 948 View::_render() - CORE/Cake/View/View.php, line 910 View::render() - CORE/Cake/View/View.php, line 471 Controller::render() - CORE/Cake/Controller/Controller.php, line 948 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 194 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162 [main] - APP/webroot/index.php, line 115
Hiring company
Capgemini
Improve your chance to get this job.
Do an online course on SQL Server starting now.
-
AED 154Duration: 1 To 2 Months
-
MCSA Windows Server 2016 (70-740) Lead AcademyAED 92
AED 1,432Duration: Upto 6 Hours
X
Why are you reporting this job?
Job has expired Cannot view this pageAlternatively, you may click on the link below or copy/paste it into your browser.
https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=281324350fbc44b9d6d5144cdc739e1e