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' => '43108528', '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=1366f9b529f2abbe56d0982a6dfa380e', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:42', 'published' => '2024-04-20 03:28:42', 'closed_time' => null, 'updated' => '2024-04-20 03:28:42', '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:42', 'daysleft' => (float) 16, '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' => '141449', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => '99998627', 'title' => 'Microsoft SQL Server Development', 'external_link' => 'https://studyhub.org.uk/course/microsoft-sql-server-development-for-everyone/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => null, 'next_session' => null, 'schedules' => null, 'duration' => 'Upto 6 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'StudyHub', 'logo' => null, 'certificate_diploma' => 'yes', 'image' => null, 'brochure_url' => null, 'video' => null, 'cost' => null, 'price' => '49', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '13', 'nondiscounted_base_price' => '260', 'currency' => 'AED', 'discount' => '95% Off for Laimoon Users!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => 'Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It’s a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.<br /> <br /> In this <strong>Microsoft SQL Server Development for Everyone!</strong> course, you’ll learn the basics of SQL Server development. You’ll learn how to create and manage databases, tables, and data. You’ll also learn how to write SQL queries to manipulate data.<br /> <br /> Starting with a solid Introduction to SQL, you’ll grasp core concepts and gain a strong foundation. We’ll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.<br /> <br /> But we won’t stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You’ll create robust and reliable databases with enforced referential integrity. Next, we’ll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.<br /> <br /> To become a well-rounded SQL Server developer, we’ll conclude the course with Advanced SQL Server Objects and Concepts. You’ll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.<br /> <br /> By the end of this <strong>Microsoft SQL Server Development for Everyone! </strong>course, you’ll have a strong understanding of how to use SQL Server to manage and manipulate data. You’ll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!<br /> <br /> <strong>Learning Outcomes:</strong><br /> <br /> Through this comprehensive course, you should be able to: <ul> <li>Understand core concepts and gain a strong foundation in SQL Server development.</li> <li>Acquire skills to effectively manipulate tables and data.</li> <li>Establish relationships and enforce data integrity using foreign keys.</li> <li>Utilise group by and aggregate functions for efficient data analysis.</li> <li>Explore advanced SQL Server objects and concepts like stored procedures and views.</li> <li>Gain proficiency in implementing triggers and optimising database performance.</li> <li>Develop the ability to create robust and reliable databases.</li> </ul> <br /> <strong>COURSE CURRICULUM<br /> <br /> Microsoft SQL Server Development for Everyone</strong> <ul> <li>Introduction</li> <li>Manipulating Tables and Data</li> <li>Relationships and Foreign Keys</li> <li>Group By and Aggregate Functions</li> <li>Advanced SQL Server Objects and Concepts</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This <strong>Microsoft SQL Server Development for Everyone!</strong> course is perfect for: <ul> <li>Aspiring developers looking to enhance their programming skills.</li> <li>Professionals seeking to expand their knowledge of SQL Server development.</li> <li>Individuals interested in exploring the world of databases and data management.</li> <li>Students or graduates pursuing a career in database administration or development.</li> <li>Curious learners eager to harness the power of SQL Server.</li> </ul> <strong>Why choose this course?</strong> <ul> <li>Unlimited access to the course for a lifetime.</li> <li>Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.</li> <li>Structured lesson planning in line with industry standards.</li> <li>Immerse yourself in innovative and captivating course materials and activities.</li> <li>Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.</li> <li>Flexibility to complete the Course at your own pace, on your own schedule.</li> <li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li> </ul> <strong>Certification</strong><br /> <br /> After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £ Original Hard Copy certificates need to be ordered at an additional cost of £8.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => '<br /> This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start ;Microsoft SQL Server Development for Everyone! was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.', 'about_school' => null, 'keywords' => 'sql server development,microsoft sql developer,sql server 2019 developer,ms sql developer,sql server 2022 developer', 'job_matching_keywords' => null, 'instructor_bio' => null, 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '395', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '12272', 'trainer_ids' => '', 'created' => '2023-08-16 13:09:16', 'updated' => '2023-10-20 10:07:32', 'sort_order' => null, 'page' => 'JobListing', 'to_emails' => 'Info@studyhub.org.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '0', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'part-time-microsoft-sql-server-development-studyhub', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '0', 'accreditation' => null, 'accreditation_logos' => 'CPD Qualification Standards', 'invoice_type' => 'CPC', 'payment_mode' => 'paid', 'invoice_value' => '5', 'invoice_click_value' => '0.1', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Part Time', 'study_timings' => '2', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'New', 'online_method' => null, 'delivery_languages' => 'en', 'career_path' => 'SQL Developer,Database Developer,Data Analyst,Data Engineer,Business Intelligence Analyst,Big Data Engineer,Cloud Architect', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"128170_en_c":350000000,"5153_en_c":350000000,"124982_en_c":350000000,"5158_en_c":350000000,"121811_en_c":350000000,"72475_en_c":350000000,"128171_en_c":350000000,"180017_en_c":350000000,"89595_en_f":350000000,"124983_en_c":350000000,"180104_en_c":350000000,"121812_en_c":350000000,"411_en_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => null, 'cpa_recommended' => null, 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99505243', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '12272', 'name' => 'StudyHub', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'studyhub', 'location' => null, 'customer_name' => 'Leopold Ramsey', 'seeder_id' => '43', 'phone_number' => '02045328874', 'pri_line_number' => '', 'address_street' => null, 'address_building' => null, 'address_city' => null, 'address_country' => null, 'addresss' => 'London, United Kingdom', 'invoice_email' => 'Info@studyhub.org.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_1647319853-StudyHub_Logo.png', 'logo_size' => '{"width":4943,"height":1563}', 'description' => '<strong>Who Are We?</strong><br /> <br /> Our culture has evolved incessantly throughout the 15 years that make up the history of our company. Studyhub's core principles continue to be the values that govern our every action. Our values are central to our culture: they shape our behaviour, reinforce our customer-centric approach, and influence how we work with each other, with our learners, and with the community - all of which lead to a positive environment.<br /> <br /> Never before have we had so many options and opportunities at our fingertips. Now it is possible to learn and grow any skills in just a few hours. Train with the most experienced instructors on the planet and organise a revolution from home through the Internet.<br /> <br /> <strong>Why Studyhub?</strong> <ul> <li>Chance to get extensive training from industry expert instructors</li> <li>Study anytime from anywhere at your own pace</li> <li>Upskill and enhance your earning potential by completing a course and getting a CPD accredited certificate.</li> </ul> ', 'website' => 'http://www.studyhub.org.uk', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => null, 'video_embed_code' => '', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'Info@studyhub.org.uk', 'contact_phone_number' => '+44 02045328874', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '1035', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:3;s:12:"total_points";i:11;s:7:"dec_avg";d:3.7000000000000002;s:9:"whole_avg";d:4;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => null, 'instant_callback_disabled' => '1', 'show_map' => '1', 'same_place' => '0', 'tier' => 'tier3', 'featured_advertiser' => '0', 'institution_type' => 'Training Institute', 'certificate' => null, 'hyperlocal_leads' => '0', 'training_mode' => 'Online', 'establish' => null, 'verify_code' => '', 'verify_status' => '1', 'course_csa_keywords' => null, 'untrusted' => '0', 'mobile_cpc_disabled' => '0', 'deleted' => '0', 'created' => '2022-03-15 08:40:29', 'modified' => '2022-03-24 16:43:13', 'pageview_enabled' => '1', 'timezone' => 'Europe/London', 'provider_status' => 'performance', 'cpc_direct_linking' => 'yes', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Converted', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2022-03-18 10:00:24', 'profile_completed_time' => '2022-03-15 08:50:53', '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' => '0', 'is_corporate' => '1', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '0', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1648125684_studyhub-c.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":152959,"r_79":502,"r_345":502,"r_84":502,"r_328":502,"r_374":502,"r_682":502,"r_656":502,"r_755":502,"r_780":502,"r_347":502,"r_17":502,"r_443":502,"r_101":502,"r_66":502,"r_190":502,"r_97":502,"r_375":502,"r_662":502,"r_255":502,"r_82":502,"r_142":502,"r_653":502,"r_394":502,"r_396":502,"r_395":502,"r_401":502,"r_599":502,"r_12":502,"r_668":502,"r_86":502,"r_388":502,"r_174":502,"r_253":502,"r_87":502,"r_199":502,"r_652":502,"r_422":502,"r_403":502,"r_793":502,"r_89":502,"r_225":502,"r_941":502,"r_944":502,"r_85":502,"r_177":502,"r_384":502,"r_408":502,"r_432":502,"r_926":502,"r_242":502,"r_69":502,"r_582":502,"r_80":502,"r_111":502,"r_113":502,"r_809":502,"r_724":502,"r_779":502,"r_232":502,"r_14":502,"r_952":502,"r_583":502,"r_146":502,"r_871":502,"r_911":502,"r_88":502,"r_216":502,"r_215":502,"r_229":502,"r_224":502,"r_10":502,"r_725":502,"r_844":502,"r_440":502,"r_763":502,"r_851":502,"r_852":502,"r_900":502,"r_765":502,"r_404":502,"r_655":502,"r_953":502,"r_91":502,"r_261":502,"r_9":502,"r_151":502,"r_697":502,"r_320":502,"r_511":502,"r_588":502,"r_181":502,"r_798":502,"r_626":502,"r_436":502,"r_332":502,"r_808":502,"r_919":502,"r_615":502,"r_172":502,"r_393":502,"r_800":502,"r_143":502,"r_81":502,"r_126":502,"r_507":502,"r_508":502,"r_149":502,"r_870":502,"r_125":502,"r_854":502,"r_99":502,"r_673":502,"r_204":502,"r_608":502,"r_344":502,"r_27":502,"r_237":502,"r_884":502,"r_512":502,"r_812":502,"r_813":502,"r_915":502,"r_323":502,"r_383":502,"r_387":502,"r_790":502,"r_15":502,"r_365":502,"r_956":502,"r_700":502,"r_141":502,"r_726":502,"r_209":502,"r_95":502,"r_198":502,"r_391":502,"r_681":502,"r_695":502,"r_114":502,"r_609":502,"r_148":502,"r_355":502,"r_145":502,"r_737":502,"r_689":502,"r_898":502,"r_897":502,"r_722":502,"r_802":502,"r_888":502,"r_887":502,"r_694":502,"r_743":502,"r_398":502,"r_691":502,"r_720":502,"r_739":502,"r_738":502,"r_740":502,"r_954":502,"r_597":502,"r_631":502,"r_399":502,"r_826":502,"r_730":502,"r_863":502,"r_742":502,"r_799":502,"r_801":502,"r_806":502,"r_864":502,"r_873":502,"r_538":502,"r_875":502,"r_876":502,"r_877":502,"r_885":502,"r_899":502,"r_890":502,"r_891":502,"r_896":502,"r_963":502,"r_643":502,"r_924":502,"r_324":502,"r_605":502,"r_327":502,"r_20":502,"r_161":502,"r_163":502,"r_641":502,"r_266":502,"r_412":502,"r_769":502,"r_958":502,"r_164":502,"r_128":502,"r_381":502,"r_539":502,"r_361":502,"r_955":502,"r_223":502,"r_207":502,"r_734":502,"r_932":502,"r_214":502,"r_206":502,"r_943":502,"r_210":502,"r_696":502,"r_638":502,"r_227":502,"r_951":502,"r_949":502,"r_364":502,"r_315":502,"r_848":502,"r_441":502,"r_314":502,"r_797":502,"r_930":502,"r_319":502,"r_703":502,"r_312":502,"r_439":502,"r_528":502,"r_523":502,"r_672":502,"r_94":502,"r_226":502,"r_620":502,"r_931":502,"r_607":502,"r_527":502,"r_841":502,"r_840":502,"r_313":502,"r_933":502,"r_317":502,"r_530":502,"r_419":502,"r_589":502,"r_611":502,"r_671":502,"r_26":502,"r_292":502,"r_193":502,"r_791":502,"r_846":502,"r_845":502,"r_950":502,"r_959":502,"r_587":502,"r_762":502,"r_90":502,"r_248":502,"r_666":502,"r_110":502,"r_636":502,"r_601":502,"r_630":502,"r_792":502,"r_241":502,"r_427":502,"r_98":502,"r_343":502,"r_789":502,"r_346":502,"r_370":502,"r_201":502,"r_371":502,"r_425":502,"r_373":502,"r_423":502,"r_96":502,"r_305":502,"r_536":502,"r_616":502,"r_187":502,"r_385":502,"r_183":502,"r_188":502,"r_194":502,"r_195":502,"r_202":502,"r_433":502,"r_657":502,"r_196":502,"r_329":502,"r_810":502,"r_881":502,"r_197":502,"r_934":502,"r_590":502,"r_787":502,"r_122":502,"r_382":502,"r_749":502,"r_639":502,"r_823":502,"r_259":502,"r_786":502,"r_861":502,"r_124":502,"r_592":502,"r_750":502,"r_420":502,"r_123":502,"r_299":502,"r_784":502,"r_923":502,"r_785":502,"r_849":502,"r_121":502,"r_127":502,"r_308":502,"r_380":502,"r_633":502,"r_648":502,"r_748":502,"r_753":502,"r_788":502,"r_816":502,"r_822":502,"r_820":502,"r_819":502,"r_821":502,"r_850":502,"r_859":502,"r_862":502,"r_777":502,"r_805":502,"r_804":502,"r_865":502,"r_348":502,"r_912":502,"r_231":502,"r_918":502,"r_236":502,"r_281":502,"r_807":502,"r_350":502,"r_693":502,"r_230":502,"r_692":502,"r_940":502,"r_778":502,"r_378":502,"r_83":502,"r_707":502,"r_168":502,"r_670":502,"r_169":502,"r_191":502,"r_927":502,"r_757":502,"r_901":502,"r_167":502,"r_541":502,"r_658":502,"r_351":502,"r_817":502,"r_610":502,"r_614":502,"r_705":502,"r_180":502,"r_811":502,"r_112":502,"r_119":502,"r_709":502,"r_257":502,"r_842":502,"r_843":502,"r_866":502,"r_115":502,"r_596":502,"r_867":502,"r_254":502,"r_759":502,"r_847":502,"r_776":502,"r_781":502,"r_929":502,"r_405":502,"r_200":502,"r_406":502,"r_645":502,"r_531":502,"r_794":502,"r_795":502,"r_925":502,"r_247":502,"r_604":502,"r_948":502,"r_960":502,"r_52":502,"r_335":502,"r_330":502,"r_249":502,"r_690":502,"r_706":502,"r_21":502,"r_41":502,"r_42":502,"r_221":502,"r_268":502,"r_269":502,"r_830":502,"r_270":502,"r_272":502,"r_515":502,"r_520":502,"r_683":502,"r_271":502,"r_829":502,"r_258":502,"r_260":502,"r_526":502,"r_818":502,"r_173":502,"r_354":502,"r_916":502,"r_415":502,"r_211":502,"r_411":502,"r_516":502,"r_677":502,"r_222":502,"r_43":502,"r_256":502,"r_524":502,"r_494":502,"r_265":502,"r_496":502,"r_60":502,"r_321":502,"r_109":502,"r_108":502,"r_162":502,"r_731":502,"r_267":502,"r_234":502,"r_322":502,"r_325":502,"r_519":502,"r_629":502,"r_660":502,"r_165":502,"r_758":502,"r_170":502,"r_747":502,"r_352":502,"r_240":502,"r_585":502,"r_118":502,"r_760":502,"r_612":502,"r_291":502,"r_581":502,"r_421":502,"r_386":502,"r_914":502,"r_602":502,"r_203":502,"r_838":502,"r_761":502,"r_522":502,"r_617":502,"r_517":502,"r_600":502,"r_497":502,"r_263":502,"r_665":502,"r_316":502,"r_613":502,"r_205":502,"r_827":502,"r_155":502,"r_882":502,"r_409":502,"r_782":502,"r_646":502,"r_233":502,"r_147":502,"r_803":502,"r_868":502,"r_498":502,"r_513":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '218900', 'course_id' => '141449', 'title' => 'Microsoft SQL Server Development', 'slug' => 'part-time-microsoft-sql-server-development-studyhub', 'external_link' => 'https://studyhub.org.uk/course/microsoft-sql-server-development-for-everyone/', 'summary' => 'Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It’s a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.<br /> <br /> In this <strong>Microsoft SQL Server Development for Everyone!</strong> course, you’ll learn the basics of SQL Server development. You’ll learn how to create and manage databases, tables, and data. You’ll also learn how to write SQL queries to manipulate data.<br /> <br /> Starting with a solid Introduction to SQL, you’ll grasp core concepts and gain a strong foundation. We’ll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.<br /> <br /> But we won’t stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You’ll create robust and reliable databases with enforced referential integrity. Next, we’ll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.<br /> <br /> To become a well-rounded SQL Server developer, we’ll conclude the course with Advanced SQL Server Objects and Concepts. You’ll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.<br /> <br /> By the end of this <strong>Microsoft SQL Server Development for Everyone! </strong>course, you’ll have a strong understanding of how to use SQL Server to manage and manipulate data. You’ll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!<br /> <br /> <strong>Learning Outcomes:</strong><br /> <br /> Through this comprehensive course, you should be able to: <ul> <li>Understand core concepts and gain a strong foundation in SQL Server development.</li> <li>Acquire skills to effectively manipulate tables and data.</li> <li>Establish relationships and enforce data integrity using foreign keys.</li> <li>Utilise group by and aggregate functions for efficient data analysis.</li> <li>Explore advanced SQL Server objects and concepts like stored procedures and views.</li> <li>Gain proficiency in implementing triggers and optimising database performance.</li> <li>Develop the ability to create robust and reliable databases.</li> </ul> <br /> <strong>COURSE CURRICULUM<br /> <br /> Microsoft SQL Server Development for Everyone</strong> <ul> <li>Introduction</li> <li>Manipulating Tables and Data</li> <li>Relationships and Foreign Keys</li> <li>Group By and Aggregate Functions</li> <li>Advanced SQL Server Objects and Concepts</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This <strong>Microsoft SQL Server Development for Everyone!</strong> course is perfect for: <ul> <li>Aspiring developers looking to enhance their programming skills.</li> <li>Professionals seeking to expand their knowledge of SQL Server development.</li> <li>Individuals interested in exploring the world of databases and data management.</li> <li>Students or graduates pursuing a career in database administration or development.</li> <li>Curious learners eager to harness the power of SQL Server.</li> </ul> <strong>Why choose this course?</strong> <ul> <li>Unlimited access to the course for a lifetime.</li> <li>Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.</li> <li>Structured lesson planning in line with industry standards.</li> <li>Immerse yourself in innovative and captivating course materials and activities.</li> <li>Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.</li> <li>Flexibility to complete the Course at your own pace, on your own schedule.</li> <li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li> </ul> <strong>Certification</strong><br /> <br /> After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £ Original Hard Copy certificates need to be ordered at an additional cost of £8.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'SQL Developer,Database Developer,Data Analyst,Data Engineer,Business Intelligence Analyst,Big Data Engineer,Cloud Architect', 'eligibility' => '<br /> This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start ;Microsoft SQL Server Development for Everyone! was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.', 'school' => 'StudyHub', 'keywords' => 'sql server development,microsoft sql developer,sql server 2019 developer,ms sql developer,sql server 2022 developer', 'location' => 'Online', 'duration' => 'Upto 6 Hours', 'timing' => null, 'cost' => null, 'discount' => '95% 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() ), (int) 1 => array( 'Course' => array( 'id' => '97492', 'seeder_id' => '0', 'edited_seeder_id' => '94', 'edited_client_id' => '0', 'title' => 'Developing Microsoft SQL Server 2012 Databases', 'external_link' => 'https://www.globaledulink.co.uk/course/developing-microsoft-sql-server-2012-databases-70-464-practice-lab/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 19 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-464 Developing 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-464 Developing 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-464 Developing Microsoft SQL Server exam.<br /> <br /> The 70-464 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 implementing database objects, implementing programming objects, designing database objects, and optimising and troubleshooting queries. In addition, during this70-464 Developing Microsoft SQL Server course you will learn to create automation scripts, manage views and indexes, tune queries and use estimation plans.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Implement database objects (30–35%)</li> <li>Implement programming objects (15-20%)</li> <li>Design database objects (25–30%)</li> <li>Optimise and troubleshoot queries (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>Module 01:</strong> Create and alter tables<br /> <strong>Module 02:</strong> Design, implement, and troubleshoot security<br /> <strong>Module 03:</strong> Design the locking granularity level<br /> <strong>Module 04:</strong> Maintain indexes<br /> <strong>Module 05: </strong>Implement data types<br /> <strong>Module 06:</strong> Create and modify constraints<br /> <strong>Module 07: </strong>Work with XML data<br /> <strong>Module 08:</strong> Write automation scripts<br /> <strong>Module 09:</strong> Design and implement stored procedures<br /> <strong>Module 10:</strong> Design T-SQL table-valued and scalar functions<br /> <strong>Module 11: </strong>Create, use, and alter user-defined functions (UDFs)<br /> <strong>Module 12:</strong> Create and alter views<br /> <strong>Module 13:</strong> Create and alter indexes<br /> <strong>Module 14: </strong>Optimize and tune queries<br /> <strong>Module 15:</strong> Troubleshoot and resolve performance problems<br /> <strong>Module 16:</strong> Optimize indexing strategies<br /> <strong>Module 17:</strong> Capture and analyse execution plans<br /> <strong>Module 18:</strong> Collect performance and system information<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 organisations and who ensure high levels of data availability. Their responsibilities include creating database files, data types and tables; planning, creating and optimising 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-464 Developing Microsoft SQL Server 2012 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' => 'Mysql,PHP,Webdevelopment,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', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '7646', 'trainer_ids' => null, 'created' => '2018-05-09 13:18:19', '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-nineteen-hours-developing-microsoft-sql-server-2012-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' => 'Configuration Manager,Network Analyst,Network Administrator,Network Manager', '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,"128171_en_c":350000000,"124983_en_c":350000000,"66677_ar_c":350000000,"65235_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' => '99829941', '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":419738,"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' => '126354', 'course_id' => '97492', 'title' => 'Developing Microsoft SQL Server 2012 Databases', 'slug' => 'upto-nineteen-hours-developing-microsoft-sql-server-2012-databases-global-edulink', 'external_link' => 'https://www.globaledulink.co.uk/course/developing-microsoft-sql-server-2012-databases-70-464-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-464 Developing 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-464 Developing 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-464 Developing Microsoft SQL Server exam.<br /> <br /> The 70-464 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 implementing database objects, implementing programming objects, designing database objects, and optimising and troubleshooting queries. In addition, during this70-464 Developing Microsoft SQL Server course you will learn to create automation scripts, manage views and indexes, tune queries and use estimation plans.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Implement database objects (30–35%)</li> <li>Implement programming objects (15-20%)</li> <li>Design database objects (25–30%)</li> <li>Optimise and troubleshoot queries (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>Module 01:</strong> Create and alter tables<br /> <strong>Module 02:</strong> Design, implement, and troubleshoot security<br /> <strong>Module 03:</strong> Design the locking granularity level<br /> <strong>Module 04:</strong> Maintain indexes<br /> <strong>Module 05: </strong>Implement data types<br /> <strong>Module 06:</strong> Create and modify constraints<br /> <strong>Module 07: </strong>Work with XML data<br /> <strong>Module 08:</strong> Write automation scripts<br /> <strong>Module 09:</strong> Design and implement stored procedures<br /> <strong>Module 10:</strong> Design T-SQL table-valued and scalar functions<br /> <strong>Module 11: </strong>Create, use, and alter user-defined functions (UDFs)<br /> <strong>Module 12:</strong> Create and alter views<br /> <strong>Module 13:</strong> Create and alter indexes<br /> <strong>Module 14: </strong>Optimize and tune queries<br /> <strong>Module 15:</strong> Troubleshoot and resolve performance problems<br /> <strong>Module 16:</strong> Optimize indexing strategies<br /> <strong>Module 17:</strong> Capture and analyse execution plans<br /> <strong>Module 18:</strong> Collect performance and system information<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 organisations and who ensure high levels of data availability. Their responsibilities include creating database files, data types and tables; planning, creating and optimising 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-464 Developing Microsoft SQL Server 2012 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' => 'Configuration Manager,Network Analyst,Network Administrator,Network Manager', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'school' => 'Global Edulink', 'keywords' => 'Mysql,PHP,Webdevelopment,Sqlserver,SQL', 'location' => 'Online', 'duration' => 'Upto 19 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() ) ) $job = array( 'Job' => array( 'id' => '43108528', '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=1366f9b529f2abbe56d0982a6dfa380e', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:42', 'published' => '2024-04-20 03:28:42', 'closed_time' => null, 'updated' => '2024-04-20 03:28:42', '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:42' $daysleft = (float) 16 $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/43108528' $companyName = ' at Capgemini' $twitterText = 'Hiring now! SQL Developer at Capgemini. Please apply or share https://jobs.laimoon.com/jobs/externalview/43108528' $emailText = 'Hiring now! SQL Developer at Capgemini. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/43108528' $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 SQL Server Development StudyHubAED 49
AED 955Duration: Upto 6 Hours -
Developing Microsoft SQL Server 2012 Databases Global EdulinkAED 364
AED 2,596Duration: Upto 19 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=1366f9b529f2abbe56d0982a6dfa380e