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' => '12299', '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' => '43108195', '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=4141f5487e420865957a2fe29d07306c', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:08', 'published' => '2024-04-20 03:28:08', 'closed_time' => null, 'updated' => '2024-04-20 03:28:08', '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' => '12299', '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:08', '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' => '12299', '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' => '97528', 'seeder_id' => '0', 'edited_seeder_id' => '94', 'edited_client_id' => '0', 'title' => 'Microsoft 70-762 - Developing SQL Databases', 'external_link' => 'https://www.globaledulink.co.uk/course/microsoft-70-762-developing-sql-databases-live-practice-lab/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 29 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Global Edulink', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '79', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '106', 'nondiscounted_base_price' => '706.666666667', 'currency' => 'GBP', 'discount' => '85% off through Laimoon!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-762 Developing SQL Databases Practice Lab course.<br /> <br /> Microsoft Practice Lab courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. To gain a Microsoft certification, you’ll need to take a theory course, and a Practice Lab course. This Global Edulink 70-762 Practice Lab will provide excellent training which will guarantee your success in your chosen exam. For those hoping to take the 70-762 exam, this Practice Lab is a must.<br /> <br /> The 70-762 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the Practice Lab tasks, you will improve your practical skills in designing and implementing database objects, implementing programmability objects, managing database concurrency and optimizing database objects and SQL infrastructure. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-762 Developing SQL Databases exam.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Design and implement database objects (25–30%)</li> <li>Implement programmability objects (20–25%)</li> <li>Manage database concurrency (25–30%)</li> <li>Optimize database objects and SQL infrastructure (20–25%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>Course Units:</strong><br /> <br /> <strong>Module 01:</strong> Designing a Relational Database Schema<br /> <strong>Module 02:</strong> Creating Indexes<br /> <strong>Module 03:</strong> Best Practices in Index Creation<br /> <strong>Module 04:</strong> Creating and Implementing Views<br /> <strong>Module 05:</strong> Creating Columnstore Indexes<br /> <strong>Module 06:</strong> Maintaining Columnstore Indexes<br /> <strong>Module 07:</strong> Creating Constraints<br /> <strong>Module 08:</strong> Effects of Contraints on DML Statements<br /> <strong>Module 09:</strong> Creating Stored Procedures with Parameters<br /> <strong>Module 10:</strong> Error Handling and Streamlining Stored Procedures<br /> <strong>Module 11:</strong> Creating Triggers<br /> <strong>Module 12:</strong> Creating User-Defined Functions<br /> <strong>Module 13:</strong> Impact of Transactions on DML Statements<br /> <strong>Module 14:</strong> Implicit and Explicit Transactions – Creating Savepoints<br /> <strong>Module 15:</strong> Manage Isolation Levels<br /> <strong>Module 16:</strong> Serializable and Snapshot<br /> <strong>Module 17:</strong> Identifying and Analyzing Locking Issues<br /> <strong>Module 18:</strong> Implementing Memory-Optimized Tables and Native Stored Procedures<br /> <strong>Module 19:</strong> Optimizing Statistics<br /> <strong>Module 20:</strong> Optimizing Indexes<br /> <strong>Module 21:</strong> Optimizing Query Plans Part 1<br /> <strong>Module 22:</strong> Optimizing Query Plans Part 2<br /> <strong>Module 23:</strong> Monitoring Performance using SQL Trace and Extended Events<br /> <strong>Module 24:</strong> Optimizing Performance for Database Instances Part 1<br /> <strong>Module 25:</strong> Optimizing Performance for Database Instances Part 2<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-762 Developing SQL Databases certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and skills.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'about_school' => '', 'keywords' => 'Microsoft,MCSE,MCSA,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' => '395,393', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '7646', 'trainer_ids' => null, 'created' => '2018-05-09 14:18:49', 'updated' => '2018-05-17 13:29:50', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@globaledulink.co.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'upto-twenty-nine-hours-microsoft-70-762-developing-sql-databases-global-edulink', '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,iAP', 'invoice_type' => 'Free', 'payment_mode' => 'free', 'invoice_value' => '5', 'invoice_click_value' => '0.12', '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' => 'Full Time', 'study_timings' => '1', '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' => 'Systems Engineer,Customer Support Engineer,Network Engineer,Windows Server Administrator', 'rank' => '{"default":8,"uae_rank":8,"saudi_arabia_rank":8,"oman_rank":8,"singapore_rank":8,"jordan_rank":8}', 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"128170_en_c":350000000,"128167_en_c":350000000,"128171_en_c":350000000,"124983_en_c":350000000,"65222_ar_c":350000000,"124979_en_c":350000000,"124982_en_c":350000000,"66677_ar_c":350000000,"121812_en_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99894469', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '7646', 'name' => 'Global Edulink', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'global-edulink', 'location' => null, 'customer_name' => 'Rushan Arachchige', 'seeder_id' => '43', 'phone_number' => '2034097966', 'pri_line_number' => '', 'address_street' => ' CityPoint, 1 Ropemaker Street,', 'address_building' => '', 'address_city' => 'London, EC2Y 9HU.', 'address_country' => 'United Kingdom', 'addresss' => ' CityPoint, 1 Ropemaker Street,, London, EC2Y 9HU., United Kingdom', 'invoice_email' => 'info@globaledulink.co.uk', '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_1578472083-go (White Background).jpg', 'logo_size' => '{"width":3461,"height":1200}', 'description' => 'Global Edulink is a leading online learning and training provider. We believe that everyone should have the opportunity to learn, no matter what their situation, which is why we strive to keep our resources cutting edge and easy-to-understand.<br /> <br /> Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.<br /> <br /> Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.<br /> ', 'website' => 'http://www.globaledulink.co.uk', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => 'opt_content_1528980709-8-06-14 at 4.52.50 PM.png', 'video_embed_code' => '<iframe width="854" height="480" src="https://www.youtube.com/embed/bn_ZJ_0B2jM" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@globaledulink.co.uk', 'contact_phone_number' => '+44 2034097966', '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:1;s:12:"total_points";s:1:"3";s:7:"dec_avg";d:3;s:9:"whole_avg";d:3;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => null, 'instant_callback_disabled' => '1', 'show_map' => '1', 'same_place' => '0', 'tier' => 'tier2', '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' => '2017-11-24 20:50:10', 'modified' => '2022-09-05 13:45:10', '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' => 'Received', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2018-08-17 18:12:33', 'profile_completed_time' => '2017-11-24 20:57:46', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => '/', 'course_type_ids' => '2', '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' => '0', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '1', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1662371099_Sample_Cer.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":615872,"r_84":502,"r_174":502,"r_777":502,"r_82":502,"r_401":502,"r_89":502,"r_229":502,"r_80":502,"r_114":502,"r_610":502,"r_615":502,"r_609":502,"r_66":502,"r_614":502,"r_805":502,"r_79":502,"r_374":502,"r_682":502,"r_636":502,"r_88":502,"r_215":502,"r_17":502,"r_357":502,"r_86":502,"r_388":502,"r_221":502,"r_81":502,"r_382":502,"r_592":502,"r_541":502,"r_193":502,"r_95":502,"r_762":502,"r_656":502,"r_85":502,"r_180":502,"r_113":502,"r_809":502,"r_255":502,"r_808":502,"r_253":502,"r_254":502,"r_389":502,"r_618":502,"r_593":502,"r_599":502,"r_738":502,"r_743":502,"r_387":502,"r_12":502,"r_231":502,"r_10":502,"r_528":502,"r_931":502,"r_527":502,"r_843":502,"r_111":502,"r_112":502,"r_122":502,"r_823":502,"r_912":502,"r_149":502,"r_83":502,"r_167":502,"r_657":502,"r_237":502,"r_236":502,"r_168":502,"r_256":502,"r_739":502,"r_312":502,"r_511":502,"r_588":502,"r_332":502,"r_313":502,"r_439":502,"r_385":502,"r_811":502,"r_183":502,"r_227":502,"r_329":502,"r_225":502,"r_944":502,"r_223":502,"r_169":502,"r_597":502,"r_526":502,"r_818":502,"r_884":502,"r_268":502,"r_269":502,"r_27":502,"r_830":502,"r_531":502,"r_794":502,"r_347":502,"r_755":502,"r_780":502,"r_779":502,"r_524":502,"r_148":502,"r_94":502,"r_419":502,"r_589":502,"r_847":502,"r_725":502,"r_840":502,"r_125":502,"r_226":502,"r_391":502,"r_15":502,"r_207":502,"r_652":502,"r_694":502,"r_270":502,"r_760":502,"r_507":502,"r_508":502,"r_403":502,"r_204":502,"r_272":502,"r_515":502,"r_519":502,"r_97":502,"r_918":502,"r_195":502,"r_432":502,"r_142":502,"r_691":502,"r_393":502,"r_722":502,"r_398":502,"r_872":502,"r_394":502,"r_395":502,"r_400":502,"r_887":502,"r_196":502,"r_194":502,"r_345":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '126390', 'course_id' => '97528', 'title' => 'Microsoft 70-762 - Developing SQL Databases', 'slug' => 'upto-twenty-nine-hours-microsoft-70-762-developing-sql-databases-global-edulink', 'external_link' => 'https://www.globaledulink.co.uk/course/microsoft-70-762-developing-sql-databases-live-practice-lab/', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-762 Developing SQL Databases Practice Lab course.<br /> <br /> Microsoft Practice Lab courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. To gain a Microsoft certification, you’ll need to take a theory course, and a Practice Lab course. This Global Edulink 70-762 Practice Lab will provide excellent training which will guarantee your success in your chosen exam. For those hoping to take the 70-762 exam, this Practice Lab is a must.<br /> <br /> The 70-762 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the Practice Lab tasks, you will improve your practical skills in designing and implementing database objects, implementing programmability objects, managing database concurrency and optimizing database objects and SQL infrastructure. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-762 Developing SQL Databases exam.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Design and implement database objects (25–30%)</li> <li>Implement programmability objects (20–25%)</li> <li>Manage database concurrency (25–30%)</li> <li>Optimize database objects and SQL infrastructure (20–25%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>Course Units:</strong><br /> <br /> <strong>Module 01:</strong> Designing a Relational Database Schema<br /> <strong>Module 02:</strong> Creating Indexes<br /> <strong>Module 03:</strong> Best Practices in Index Creation<br /> <strong>Module 04:</strong> Creating and Implementing Views<br /> <strong>Module 05:</strong> Creating Columnstore Indexes<br /> <strong>Module 06:</strong> Maintaining Columnstore Indexes<br /> <strong>Module 07:</strong> Creating Constraints<br /> <strong>Module 08:</strong> Effects of Contraints on DML Statements<br /> <strong>Module 09:</strong> Creating Stored Procedures with Parameters<br /> <strong>Module 10:</strong> Error Handling and Streamlining Stored Procedures<br /> <strong>Module 11:</strong> Creating Triggers<br /> <strong>Module 12:</strong> Creating User-Defined Functions<br /> <strong>Module 13:</strong> Impact of Transactions on DML Statements<br /> <strong>Module 14:</strong> Implicit and Explicit Transactions – Creating Savepoints<br /> <strong>Module 15:</strong> Manage Isolation Levels<br /> <strong>Module 16:</strong> Serializable and Snapshot<br /> <strong>Module 17:</strong> Identifying and Analyzing Locking Issues<br /> <strong>Module 18:</strong> Implementing Memory-Optimized Tables and Native Stored Procedures<br /> <strong>Module 19:</strong> Optimizing Statistics<br /> <strong>Module 20:</strong> Optimizing Indexes<br /> <strong>Module 21:</strong> Optimizing Query Plans Part 1<br /> <strong>Module 22:</strong> Optimizing Query Plans Part 2<br /> <strong>Module 23:</strong> Monitoring Performance using SQL Trace and Extended Events<br /> <strong>Module 24:</strong> Optimizing Performance for Database Instances Part 1<br /> <strong>Module 25:</strong> Optimizing Performance for Database Instances Part 2<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-762 Developing SQL Databases certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and skills.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Systems Engineer,Customer Support Engineer,Network Engineer,Windows Server Administrator', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'school' => 'Global Edulink', 'keywords' => 'Microsoft,MCSE,MCSA,Sqlserver,SQL', 'location' => 'Online', 'duration' => 'Upto 29 Hours', 'timing' => null, 'cost' => null, 'discount' => '85% 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() ), (int) 1 => array( 'Course' => array( 'id' => '97558', 'seeder_id' => '0', 'edited_seeder_id' => '94', 'edited_client_id' => '8080', 'title' => 'Querying Microsoft SQL Server 2012', 'external_link' => 'https://www.globaledulink.co.uk/course/querying-microsoft-sql-server-2012-70-461-practice-lab/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 16 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Global Edulink', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '109', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '143', 'nondiscounted_base_price' => '953.33', 'currency' => 'GBP', 'discount' => '85% Off for Laimoon Users!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-461 Querying Microsoft SQL Server online course.<br /> <br /> Microsoft courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. Global Edulink provides excellent training which will guarantee your success in your chosen Microsoft exam. For those hoping to take the 70-461 Querying Microsoft SQL Server exam, this is the course for you. This is a practice lab course, which will allow you to develop practical skills, and will be necessary to enable you to successfully pass the 70-461 Querying Microsoft SQL Server exam.<br /> <br /> The 70-461 Practice Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012. By completing the lab tasks you will improve your practical skills in creating database objects, working with data, modifying data, and troubleshooting and optimisation.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Create database objects (20–25%)</li> <li>Work with data (25–30%)</li> <li>Modify data (20–25%)</li> <li>Troubleshoot and optimise (25–30%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>COURSE CURRICULUM </strong><br /> <br /> <strong><em>Module 01</em> :</strong> Create and alter tables using Transact SQL syntax<br /> <strong><em>Module 02</em> :</strong> Create and alter views<br /> <strong><em>Module 03</em> :</strong> Create and modify constraints<br /> <strong><em>Module 04</em> :</strong> Create and alter DML triggers<br /> <strong><em>Module 05</em> :</strong> Query data by using SELECT statements<br /> <strong><em>Module 06</em> :</strong> Implementing Sub queries<br /> <strong><em>Module 07</em> :</strong> Implementing Data Types<br /> <strong><em>Module 08</em> :</strong> Implementing Aggregate Queries<br /> <strong><em>Module 09 </em>:</strong> Query and Manage XML Data<br /> <strong><em>Module 10</em> :</strong> Modifying Data<br /> <strong><em>Module 11</em> :</strong> Working with Functions<br /> <strong><em>Module 12</em> :</strong> Optimizing Queries<br /> <strong><em>Module 13</em> :</strong> Troubleshooting Queries<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for SQL Server database administrators, system engineers and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-461 Querying Microsoft SQL Server 2012 certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and ;', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'about_school' => '', 'keywords' => 'Microsoft,MCSA,MCSE', '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' => '395', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '7646', 'trainer_ids' => '', 'created' => '2018-05-09 15:06:24', 'updated' => '2024-03-15 12:58:12', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@globaledulink.co.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'upto-sixteen-hours-querying-microsoft-sql-server-2012-global-edulink', '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' => '1', 'accreditation' => '0', 'accreditation_logos' => 'CPD,iAP', 'invoice_type' => 'Free', 'payment_mode' => 'free', 'invoice_value' => '5', 'invoice_click_value' => '0.29', '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' => 'Full Time', 'study_timings' => '1', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'New', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'IT Support Technician,Senior Database Administrator,Software Engineer', 'rank' => '{"default":8,"uae_rank":8,"saudi_arabia_rank":8,"oman_rank":8,"singapore_rank":8,"jordan_rank":8}', 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"5153_en_c":350000000,"128170_en_c":350000000,"128171_en_c":350000000,"124982_en_c":350000000,"124983_en_c":350000000,"65235_ar_c":350000000,"66677_ar_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99978939', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '7646', 'name' => 'Global Edulink', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'global-edulink', 'location' => null, 'customer_name' => 'Rushan Arachchige', 'seeder_id' => '43', 'phone_number' => '2034097966', 'pri_line_number' => '', 'address_street' => ' CityPoint, 1 Ropemaker Street,', 'address_building' => '', 'address_city' => 'London, EC2Y 9HU.', 'address_country' => 'United Kingdom', 'addresss' => ' CityPoint, 1 Ropemaker Street,, London, EC2Y 9HU., United Kingdom', 'invoice_email' => 'info@globaledulink.co.uk', '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_1578472083-go (White Background).jpg', 'logo_size' => '{"width":3461,"height":1200}', 'description' => 'Global Edulink is a leading online learning and training provider. We believe that everyone should have the opportunity to learn, no matter what their situation, which is why we strive to keep our resources cutting edge and easy-to-understand.<br /> <br /> Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.<br /> <br /> Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.<br /> ', 'website' => 'http://www.globaledulink.co.uk', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => 'opt_content_1528980709-8-06-14 at 4.52.50 PM.png', 'video_embed_code' => '<iframe width="854" height="480" src="https://www.youtube.com/embed/bn_ZJ_0B2jM" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@globaledulink.co.uk', 'contact_phone_number' => '+44 2034097966', '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:1;s:12:"total_points";s:1:"3";s:7:"dec_avg";d:3;s:9:"whole_avg";d:3;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => null, 'instant_callback_disabled' => '1', 'show_map' => '1', 'same_place' => '0', 'tier' => 'tier2', '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' => '2017-11-24 20:50:10', 'modified' => '2022-09-05 13:45:10', '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' => 'Received', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2018-08-17 18:12:33', 'profile_completed_time' => '2017-11-24 20:57:46', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => '/', 'course_type_ids' => '2', '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' => '0', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '1', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1662371099_Sample_Cer.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":615872,"r_84":502,"r_174":502,"r_777":502,"r_82":502,"r_401":502,"r_89":502,"r_229":502,"r_80":502,"r_114":502,"r_610":502,"r_615":502,"r_609":502,"r_66":502,"r_614":502,"r_805":502,"r_79":502,"r_374":502,"r_682":502,"r_636":502,"r_88":502,"r_215":502,"r_17":502,"r_357":502,"r_86":502,"r_388":502,"r_221":502,"r_81":502,"r_382":502,"r_592":502,"r_541":502,"r_193":502,"r_95":502,"r_762":502,"r_656":502,"r_85":502,"r_180":502,"r_113":502,"r_809":502,"r_255":502,"r_808":502,"r_253":502,"r_254":502,"r_389":502,"r_618":502,"r_593":502,"r_599":502,"r_738":502,"r_743":502,"r_387":502,"r_12":502,"r_231":502,"r_10":502,"r_528":502,"r_931":502,"r_527":502,"r_843":502,"r_111":502,"r_112":502,"r_122":502,"r_823":502,"r_912":502,"r_149":502,"r_83":502,"r_167":502,"r_657":502,"r_237":502,"r_236":502,"r_168":502,"r_256":502,"r_739":502,"r_312":502,"r_511":502,"r_588":502,"r_332":502,"r_313":502,"r_439":502,"r_385":502,"r_811":502,"r_183":502,"r_227":502,"r_329":502,"r_225":502,"r_944":502,"r_223":502,"r_169":502,"r_597":502,"r_526":502,"r_818":502,"r_884":502,"r_268":502,"r_269":502,"r_27":502,"r_830":502,"r_531":502,"r_794":502,"r_347":502,"r_755":502,"r_780":502,"r_779":502,"r_524":502,"r_148":502,"r_94":502,"r_419":502,"r_589":502,"r_847":502,"r_725":502,"r_840":502,"r_125":502,"r_226":502,"r_391":502,"r_15":502,"r_207":502,"r_652":502,"r_694":502,"r_270":502,"r_760":502,"r_507":502,"r_508":502,"r_403":502,"r_204":502,"r_272":502,"r_515":502,"r_519":502,"r_97":502,"r_918":502,"r_195":502,"r_432":502,"r_142":502,"r_691":502,"r_393":502,"r_722":502,"r_398":502,"r_872":502,"r_394":502,"r_395":502,"r_400":502,"r_887":502,"r_196":502,"r_194":502,"r_345":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '126420', 'course_id' => '97558', 'title' => 'Querying Microsoft SQL Server 2012', 'slug' => 'upto-sixteen-hours-querying-microsoft-sql-server-2012-global-edulink', 'external_link' => 'https://www.globaledulink.co.uk/course/querying-microsoft-sql-server-2012-70-461-practice-lab/', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-461 Querying Microsoft SQL Server online course.<br /> <br /> Microsoft courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. Global Edulink provides excellent training which will guarantee your success in your chosen Microsoft exam. For those hoping to take the 70-461 Querying Microsoft SQL Server exam, this is the course for you. This is a practice lab course, which will allow you to develop practical skills, and will be necessary to enable you to successfully pass the 70-461 Querying Microsoft SQL Server exam.<br /> <br /> The 70-461 Practice Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012. By completing the lab tasks you will improve your practical skills in creating database objects, working with data, modifying data, and troubleshooting and optimisation.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Create database objects (20–25%)</li> <li>Work with data (25–30%)</li> <li>Modify data (20–25%)</li> <li>Troubleshoot and optimise (25–30%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>COURSE CURRICULUM </strong><br /> <br /> <strong><em>Module 01</em> :</strong> Create and alter tables using Transact SQL syntax<br /> <strong><em>Module 02</em> :</strong> Create and alter views<br /> <strong><em>Module 03</em> :</strong> Create and modify constraints<br /> <strong><em>Module 04</em> :</strong> Create and alter DML triggers<br /> <strong><em>Module 05</em> :</strong> Query data by using SELECT statements<br /> <strong><em>Module 06</em> :</strong> Implementing Sub queries<br /> <strong><em>Module 07</em> :</strong> Implementing Data Types<br /> <strong><em>Module 08</em> :</strong> Implementing Aggregate Queries<br /> <strong><em>Module 09 </em>:</strong> Query and Manage XML Data<br /> <strong><em>Module 10</em> :</strong> Modifying Data<br /> <strong><em>Module 11</em> :</strong> Working with Functions<br /> <strong><em>Module 12</em> :</strong> Optimizing Queries<br /> <strong><em>Module 13</em> :</strong> Troubleshooting Queries<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for SQL Server database administrators, system engineers and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-461 Querying Microsoft SQL Server 2012 certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and ;', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'IT Support Technician,Senior Database Administrator,Software Engineer', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'school' => 'Global Edulink', 'keywords' => 'Microsoft,MCSA,MCSE', 'location' => 'Online', 'duration' => 'Upto 16 Hours', 'timing' => null, 'cost' => null, 'discount' => '85% Off for Laimoon Users!', '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' => '43108195', '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=4141f5487e420865957a2fe29d07306c', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:08', 'published' => '2024-04-20 03:28:08', 'closed_time' => null, 'updated' => '2024-04-20 03:28:08', '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' => '12299', '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:08' $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/43108195' $companyName = ' at Capgemini' $twitterText = 'Hiring now! SQL Developer at Capgemini. Please apply or share https://jobs.laimoon.com/jobs/externalview/43108195' $emailText = 'Hiring now! SQL Developer at Capgemini. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/43108195' $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.
-
Microsoft 70-762 - Developing SQL Databases Global EdulinkAED 364
AED 2,596Duration: Upto 29 Hours -
Querying Microsoft SQL Server 2012 Global EdulinkAED 503
AED 3,501Duration: Upto 16 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=4141f5487e420865957a2fe29d07306c