الصفحة الرئيسية مصر SQL Developer
الصفحة الرئيسية مصر SQL Developer
SQL Developer
دوام كامل
في Capgemini
في
Egypt
نُشرت يوم April 20, 2024
تفاصيل الوظيفة
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' => '13389', 'contributedJobCount' => '24', 'courseCount' => null ), 'environment' => 'production', 'langUrlPrefix' => 'ar/', 'langUrl' => 'https://jobs.laimoon.com/ar/', 'themeUrl' => 'https://jobs.laimoon.com/', 'siteUrl' => 'https://jobs.laimoon.com/', 'staticUrl' => 'https://cdn.laimoon.com/jobs/', 'langCode' => 'ar', 'pageScripts' => array( (int) 0 => 'page_script' ), 'pageName' => 'externalview', 'courseUrl' => 'https://courses.laimoon.com/ar/', 'onlineCourses' => array( (int) 0 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ), (int) 1 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ) ), 'job' => array( 'Job' => array( 'id' => '43108195', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'SQL Developer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<h2> Job Description </h2><p> As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus. </p>', 'course_qualifications' => null, 'global_location_id' => '64', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => 'Full time', 'salaryFrom' => null, 'salaryTo' => null, 'currency_id' => null, 'hide_salary' => '0', 'benefits' => null, 'salary_type_id' => null, 'travel_type_id' => null, 'travel_id' => null, 'education_id' => null, 'education_background' => null, 'language_id' => null, 'position_level_id' => null, 'position_type' => null, 'number_of_staffs_mange' => null, 'experiance' => null, 'sales_experience' => null, 'sales_focus' => null, 'sales_cycle_id' => null, 'reporting_to' => null, 'otherAssignments' => null, 'otherConsiderations' => null, 'ideal_candidate' => null, 'company_info' => null, 'company_id' => '52091', 'company_name' => 'Capgemini', 'external_apply_url' => 'https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=4141f5487e420865957a2fe29d07306c', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:08', 'published' => '2024-04-20 03:28:08', 'closed_time' => null, 'updated' => '2024-04-20 03:28:08', 'hideCompany' => null, 'hide_contact_info' => '0', 'application_count' => '0', 'closed' => '0', 'draft' => '0', 'rejected' => '0', 'deleted' => '0', 'moderated' => '1', 'boosted' => '0', 'rejectnote' => null, 'job_extended' => '0', 'purchased' => '0', 'seeder_id' => '113', 'source_id' => 'jooble', 'course_keywords' => null, 'shortlist_magic_applied' => '0', 'shortlist_magic_keywords' => null, 'living_in' => '0', 'age_limit' => null, 'is_managerial' => '0', 'application_email' => null, 'quality_score' => null, 'reopened' => '0', 'quality_type' => 'White', 'promoted' => '0' ), 'Recruiter' => array( 'first_name' => 'Jooble Jobs', 'last_name' => null, 'recruiter_type' => 'company' ), 'GlobalLocation' => array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( [maximum depth reached] ) ), 'Company' => array( 'id' => '52091', 'name' => 'Capgemini', 'website' => 'https://www.capgemini.com/in-en/', 'verified' => '0', 'photo' => 'Capgemini_e08058a0-f1f5-11e9-bbf3-15f76e7ed41e.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ), 'jobsList' => array(), 'courses' => array(), 'promotedCourses' => array(), 'referer' => '/', 'urlKeyword' => 'SQL ', 'profile' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '13389', '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' ), 'CompanyPageTranslation' => array( 'id' => null, 'company_page_id' => null, 'title' => null, 'slug' => null, 'summary' => null, 'description' => null, 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'company_matching_keywords' => null, 'draft' => null, 'lang_code' => null ) ), 'location' => 'Egypt', 'breadCrumbs' => array( 'Job Details' => '' ), 'relCourseBanner' => array( 'relatedUrl' => 'https://courses.laimoon.com/ar/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'مايكروسوفت إس كيو إل سيرفر', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/ar/online/it-computing-and-technology/database-management/sql-server' ), 'published' => '2024-04-20 03:28:08', 'daysleft' => (float) 2, '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' => '13389', 'contributedJobCount' => '24', 'courseCount' => null ) $environment = 'production' $langUrlPrefix = 'ar/' $langUrl = 'https://jobs.laimoon.com/ar/' $themeUrl = 'https://jobs.laimoon.com/' $siteUrl = 'https://jobs.laimoon.com/' $staticUrl = 'https://cdn.laimoon.com/jobs/' $langCode = 'ar' $pageScripts = array( (int) 0 => 'page_script' ) $pageName = 'externalview' $courseUrl = 'https://courses.laimoon.com/ar/' $onlineCourses = array( (int) 0 => array( 'Course' => array( 'id' => '135683', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => '99998627', 'title' => 'SQL Database Administrator', 'external_link' => 'https://studyhub.org.uk/course/sql-database-administrator/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 8 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'StudyHub', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', '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' => '', 'laimoon_offer' => '1', 'summary' => '<strong>Uplift Your Career & Skill Up to Your Dream Job – Learning Simplified From Home!</strong><br> <br> Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special <strong>SQL Database Administrator </strong>Course. You’ll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today’s workplaces.<br> <br> The <strong>SQL Database Administrator</strong> Course is one of the most prestigious trainings offered at StudyHub and is highly valued by employers for good reason. This <strong>SQL Database Administrator</strong> Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field.<br> <br> This<strong> SQL Database Administrator</strong> Course, like every one of Study Hub’s courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly.<br> At StudyHub, we don’t just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support.<br> <br> <br> <strong>COURSE CURRICULUM</strong> <ul> <li>Course Introduction</li> <li>Introduction</li> <li>Course Curriculum Overview</li> <li>Overview of Databases</li> <li>SQL Environment Setup</li> <li>MySQL Installation</li> <li>MySQL Workbench Installation</li> <li>Connecting to MySQL using Console</li> <li>SQL Statement Basics</li> <li>GROUP BY Statements</li> <li>Overview of GROUP BY</li> <li>Aggregation function SUM()</li> <li>Aggregation MIN() and MAX()</li> <li>GROUP BY – One</li> <li>GROUP BY – Two</li> <li>HAVING Clause</li> <li>JOINS</li> <li>Overview of JOINS</li> <li>Introduction to JOINS</li> <li>AS Statement table</li> <li>INNER Joins</li> <li>FULL Outer Join</li> <li>LEFT Outer JOIN</li> <li>RIGHT JOIN</li> <li>Union</li> <li>Advanced SQL Commands / Statements</li> <li>Timestamps</li> <li>EXTRACT from timestamp</li> <li>Mathematical Functions</li> <li>String Functions</li> <li>SUBQUERY</li> <li>Creating Database and Tables</li> <li>Basic Database and Tables</li> <li>DataTypes</li> <li>Primary key and Foreign key</li> <li>Create Table in SQL Script</li> <li>Insert</li> <li>Update</li> <li>Delete</li> <li>Alter Table</li> <li>Drop-Table</li> <li>NOT NULL<em> Constraint</em></li> <li>UNIQUE Constraint</li> <li>Databases and Tables</li> <li>Creating a Database backup</li> <li>10a Overview of Databases and Tables</li> <li>10c Restoring a Database</li> </ul> <br> <strong>Why buy this SQL Database Administrator?</strong> <ul> <li>Unlimited access to the course for forever</li> <li><strong>Digital Certificate, Transcript, student ID</strong> all included in the price</li> <li>Absolutely no hidden fees</li> <li>Directly receive <strong>CPD </strong>accredited qualifications after course completion</li> <li>Receive one to one assistance on every weekday from professionals</li> <li>Immediately receive the PDF certificate after passing</li> <li>Receive the original copies of your certificate and transcript on the next working day</li> <li>Easily learn the skills and knowledge from the comfort of your home</li> </ul> <br> <strong>Certification</strong><br> <br> After studying the course materials of the <strong>SQL Database Administrator</strong> there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered<br> <br> <br> <strong>Who is this course for?</strong><br> <br> This <strong>SQL Database Administrator</strong> course is ideal for <ul> <li>Students</li> <li>Recent graduates</li> <li>Job Seekers</li> <li>Anyone interested in this topic</li> <li>People already working in the relevant fields and want to polish their knowledge and skill.</li> </ul> <br> <strong>Career path</strong><br> <br> As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This SQL Database Administrator is a great way for you to gain multiple skills from the comfort of your home.<br> <br> ', 'outline' => '', 'who_should_take_this_course' => '', 'eligibility' => 'This SQL Database Administrator does not require you to have any prior qualifications or experience. You can just enrol and start learning. This SQL Database Administrator 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' => '', 'keywords' => 'SQL,SQL Database Administrator,visual basic,database administrator, SQL Database Administrator', 'job_matching_keywords' => 'SQL Database Administrator', 'instructor_bio' => '', 'external_course_info' => null, 'eligibility_criteria' => '', 'career_opportunity' => '', 'targetted_roles' => '', 'targetted_industries' => '', 'targetted_locations' => '', 'gender' => '0', 'targetted_course_categories' => '393,800,395', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '12272', 'trainer_ids' => '', 'created' => '2022-04-26 12:56:07', 'updated' => '2023-10-20 09:32:28', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'Info@studyhub.org.uk', 'cc_emails' => '', 'phone_number' => '', 'pri_line_number' => '', 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'part-time-sql-database-administrator-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' => '2022-04-27 14:15:00', 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '0', 'accreditation' => '0', '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' => '', 'language_program_level' => '', 'language_program_type' => '', 'language_study_mode' => '', 'badge_url' => null, 'last_revision_status' => 'New', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'SQL developer,SQL database administrator,SQL Coordinator,sql developer,SQL Developer - entry', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"65130_ar_f":350000000,"5153_en_c":350000000,"128171_en_c":350000000,"69562_en_f":350000000,"65756_ar_f":350000000,"72471_en_f":350000000,"65222_ar_c":350000000,"65756_ar_c":350000000,"245696_en_c":350000000,"5158_en_c":350000000,"65240_en_c":350000000,"393_en_f":350000000,"46625_ar_c":350000000,"61332_en_f":350000000,"66677_ar_c":350000000,"180017_en_c":350000000,"245547_en_c":350000000,"72475_en_c":350000000,"88998_en_f":350000000,"126460_en_c":350000000,"245615_en_f":350000000,"46624_ar_f":350000000,"65240_ar_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '0', 'course_certificate' => '', 'bundle_id' => null, 'randomizer' => '99910549', '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":300011,"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' => '211947', 'course_id' => '135683', 'title' => 'SQL Database Administrator', 'slug' => 'part-time-sql-database-administrator-studyhub', 'external_link' => 'https://studyhub.org.uk/course/sql-database-administrator/', 'summary' => '<strong>Uplift Your Career & Skill Up to Your Dream Job – Learning Simplified From Home!</strong><br> <br> Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special <strong>SQL Database Administrator </strong>Course. You’ll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today’s workplaces.<br> <br> The <strong>SQL Database Administrator</strong> Course is one of the most prestigious trainings offered at StudyHub and is highly valued by employers for good reason. This <strong>SQL Database Administrator</strong> Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field.<br> <br> This<strong> SQL Database Administrator</strong> Course, like every one of Study Hub’s courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly.<br> At StudyHub, we don’t just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support.<br> <br> <br> <strong>COURSE CURRICULUM</strong> <ul> <li>Course Introduction</li> <li>Introduction</li> <li>Course Curriculum Overview</li> <li>Overview of Databases</li> <li>SQL Environment Setup</li> <li>MySQL Installation</li> <li>MySQL Workbench Installation</li> <li>Connecting to MySQL using Console</li> <li>SQL Statement Basics</li> <li>GROUP BY Statements</li> <li>Overview of GROUP BY</li> <li>Aggregation function SUM()</li> <li>Aggregation MIN() and MAX()</li> <li>GROUP BY – One</li> <li>GROUP BY – Two</li> <li>HAVING Clause</li> <li>JOINS</li> <li>Overview of JOINS</li> <li>Introduction to JOINS</li> <li>AS Statement table</li> <li>INNER Joins</li> <li>FULL Outer Join</li> <li>LEFT Outer JOIN</li> <li>RIGHT JOIN</li> <li>Union</li> <li>Advanced SQL Commands / Statements</li> <li>Timestamps</li> <li>EXTRACT from timestamp</li> <li>Mathematical Functions</li> <li>String Functions</li> <li>SUBQUERY</li> <li>Creating Database and Tables</li> <li>Basic Database and Tables</li> <li>DataTypes</li> <li>Primary key and Foreign key</li> <li>Create Table in SQL Script</li> <li>Insert</li> <li>Update</li> <li>Delete</li> <li>Alter Table</li> <li>Drop-Table</li> <li>NOT NULL<em> Constraint</em></li> <li>UNIQUE Constraint</li> <li>Databases and Tables</li> <li>Creating a Database backup</li> <li>10a Overview of Databases and Tables</li> <li>10c Restoring a Database</li> </ul> <br> <strong>Why buy this SQL Database Administrator?</strong> <ul> <li>Unlimited access to the course for forever</li> <li><strong>Digital Certificate, Transcript, student ID</strong> all included in the price</li> <li>Absolutely no hidden fees</li> <li>Directly receive <strong>CPD </strong>accredited qualifications after course completion</li> <li>Receive one to one assistance on every weekday from professionals</li> <li>Immediately receive the PDF certificate after passing</li> <li>Receive the original copies of your certificate and transcript on the next working day</li> <li>Easily learn the skills and knowledge from the comfort of your home</li> </ul> <br> <strong>Certification</strong><br> <br> After studying the course materials of the <strong>SQL Database Administrator</strong> there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered<br> <br> <br> <strong>Who is this course for?</strong><br> <br> This <strong>SQL Database Administrator</strong> course is ideal for <ul> <li>Students</li> <li>Recent graduates</li> <li>Job Seekers</li> <li>Anyone interested in this topic</li> <li>People already working in the relevant fields and want to polish their knowledge and skill.</li> </ul> <br> <strong>Career path</strong><br> <br> As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This SQL Database Administrator is a great way for you to gain multiple skills from the comfort of your home.<br> <br> ', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'SQL developer,SQL database administrator,SQL Coordinator,sql developer,SQL Developer - entry', 'eligibility' => 'This SQL Database Administrator does not require you to have any prior qualifications or experience. You can just enrol and start learning. This SQL Database Administrator 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,SQL Database Administrator,visual basic,database administrator, SQL Database Administrator', 'location' => 'Online', 'duration' => 'Upto 8 Hours', 'timing' => null, 'cost' => null, 'discount' => '95% Off for Laimoon Users!', 'eligibility_criteria' => null, 'job_matching_keywords' => 'SQL Database Administrator', 'boosted' => null, 'lang_code' => 'ar', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ), (int) 1 => array( 'Course' => array( 'id' => '95848', 'seeder_id' => '0', 'edited_seeder_id' => '94', 'edited_client_id' => '8102', 'title' => 'SpeedGrade CC', 'external_link' => 'https://www.1training.org/course/speedgrade-cc/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 14 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => '1TRAINING', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '17', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '23', 'nondiscounted_base_price' => '153.333333333', 'currency' => 'GBP', 'discount' => '%85 خصم لعملاء ليمون!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> This excellent <strong>SpeedGrade CC</strong> course will teach you many of the SQL functions that allow you to manipulate the data within the database. Upon completion of this course you will be thoroughly versed in SQL and writing queries for your database. SQL is a domain-specific language used in programming, and if you hope to work in database management, as a backend developer, as a data analyst, or as a data scientist. These kinds of positions are in high demand, and command large salaries, so develop the key skills for a successful career with 1Training!<br /> <br /> This <strong>SpeedGrade CC</strong> course will be the ideal solution and the easiest course you will experience. We will offer you the opportunity to study 24/7 wherever you are in the world. This course is opened to anyone with an interest in the topic and give you access to world-class learning led by 1Training International.<br /> <br /> <strong>1Training International works in partnership with NUS, so all registered 1Training learners can get an NUS Extra discount card, which gives you amazing discounts on thousands of products from the biggest companies.</strong><br /> <br /> <strong>Why should I choose 1Training?</strong> <ul> <li>Free both e-certificate and printed certificate</li> <li>Accredited qualification</li> <li>Excellent quality video tutorials</li> <li>You'll be eligible for an NUS Discount Card</li> <li>Get one year's access to the course</li> <li>Get support by phone, live chat, and email</li> <li>Join our friendly online learning platform</li> <li>Our Course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. So, you can access your course on Wi-Fi, 3G or 4G.</li> </ul> <strong>Description</strong><br /> <br /> Learn for less with 1Training <strong>discount courses</strong> online! You’ll love 1Training’s excellent quality, competitive prices, and first class learner support. With this excellent discount course you can expect professional qualification, which will enable you to enhance your CV in no time, and for less!<br /> <br /> <strong>What skills am I going to get from this course?</strong> <ul> <li>Cover many of the SQL functions that allow you to manipulate the data within the database</li> <li>Upon completion of this series you will be thoroughly versed in SQL and writing queries for your database</li> </ul> <strong>Course Duration:</strong><br /> <br /> Learners will have <strong>365 days access</strong> to their chosen course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.<br /> <br /> <strong>COURSE CURRICULUM</strong> <ol> <li>Getting Started</li> <li>Advanced Search Functions</li> <li>Searching Multiple Tables</li> <li>Creating and Structuring Databases</li> <li>Special Data Functions and Instructions</li> <li>Working with Dates</li> <li>SQL Functions</li> </ol> <strong>How will I be assessed?</strong> <ul> <li>You will have one Assignment.</li> <li>You only need to pay £19 for assessment when you submit your assignment.</li> </ul> <strong>What Certification am I going to receive?</strong><br /> <br /> Those who successfully pass this course will be awarded a SpeedGrade CC certificate<strong>.</strong>. Anyone eligible for certification will receive both <strong>FREE e-certificate</strong> (PDF format), and <strong>printed certificate</strong>.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => '<ul> <li>You must be 16 or over</li> <li>You should have a basic understanding of English, Maths and ICT</li> <li>You will need a computer or tablet with internet connection (or access to one)</li> </ul> ', 'about_school' => '', 'keywords' => 'SpeedGrade,Editor,Developer', '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' => '7662', 'trainer_ids' => null, 'created' => '2018-04-18 10:42:20', 'updated' => '2024-05-15 15:03:25', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@1training.org', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'upto-fourteen-hours-speedgrade-cc-1training', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '1', 'accreditation' => '0', 'accreditation_logos' => 'CPD,iAP', 'invoice_type' => 'Free', 'payment_mode' => 'free', 'invoice_value' => '5', 'invoice_click_value' => '0.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' => 'Full Time', 'study_timings' => '1', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'New', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'Database Manager,Backend Developer,Data Analyst', 'rank' => '{"default":8,"uae_rank":8,"saudi_arabia_rank":8,"oman_rank":8,"singapore_rank":8,"jordan_rank":8}', 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"5153_en_c":350000000,"66677_ar_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '0', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99577948', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '7662', 'name' => '1TRAINING', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => '1training', 'location' => null, 'customer_name' => 'Rushan Arachchige', 'seeder_id' => '43', 'phone_number' => '2086109650', 'pri_line_number' => '', 'address_street' => '63/66 Hatton Garden, Fifth Floor, Suite 23,', 'address_building' => '', 'address_city' => 'London EC1N 8LE', 'address_country' => 'United Kingdom', 'addresss' => '63/66 Hatton Garden, Fifth Floor, Suite 23,, London EC1N 8LE, United Kingdom', 'invoice_email' => 'info@1training.org', 'student_enrolment' => '1', 'masked_emails' => '1', 'moneyback' => '1', 'student_enrolment_processing_percentage' => '50', 'invoice_missed_calls' => '0', 'budget_alerts' => '0', 'budget_amount' => '0', 'budget_start_date' => null, 'provider_code' => '', 'payment_type' => 'CPC', 'intl_leads_enabled' => '0', 'invoice_notification' => '0', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1528731987-8-06-11 at 7.46.46 PM.png', 'logo_size' => '{"width":396,"height":144}', 'description' => 'We believe that online learning should be modern and innovative, which is why we created 1Training. Offering courses on a wide range of topics, we can help you find the career of your dreams, and will help you every step of the way. Cutting edge teaching techniques, a wide range of topics, and the personal touch is our recipe for deliciously simple learning. If you don’t believe us, just ask the 10,000+ people we’ve already helped to realise their full potential.', 'website' => 'http://www.1training.org', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => 'opt_content_1528980895-8-06-14 at 4.55.54 PM.png', 'video_embed_code' => '<iframe src="https://player.vimeo.com/video/233856018" width="640" height="360" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe> <p><a href="https://vimeo.com/233856018">1 Training</a> from <a href="https://vimeo.com/1training">1 Training</a> on <a href="https://vimeo.com">Vimeo</a>.</p>', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@1training.org', 'contact_phone_number' => '+44 2086109650', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => '1', '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-29 17:55:37', 'modified' => '2021-10-18 16:29:27', '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' => 'Converted', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2018-08-17 18:41:39', 'profile_completed_time' => '2017-11-29 17:56:34', '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/1534423199_1training.png', '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":878758,"r_82":502,"r_401":502,"r_599":502,"r_86":502,"r_193":502,"r_195":502,"r_83":52,"r_169":52,"r_81":502,"r_382":502,"r_747":502,"r_79":502,"r_374":502,"r_636":502,"r_748":502,"r_142":502,"r_400":502,"r_126":502,"r_66":502,"r_253":502,"r_750":502,"r_521":502,"r_308":502,"r_834":502,"r_639":502,"r_751":502,"r_832":502,"r_143":502,"r_394":502,"r_395":502,"r_398":502,"r_255":502,"r_592":502,"r_753":502,"r_425":502,"r_95":502,"r_762":502,"r_507":502,"r_508":502,"r_689":502,"r_897":502,"r_128":502,"r_743":502,"r_656":502,"r_12":502,"r_237":502,"r_231":502,"r_80":502,"r_114":502,"r_610":502,"r_122":502,"r_10":502,"r_528":502,"r_17":502,"r_60":502,"r_682":502,"r_419":502,"r_589":502,"r_760":502,"r_609":502,"r_111":502,"r_112":502,"r_527":502,"r_843":502,"r_931":502,"r_97":502,"r_346":502,"r_234":502,"r_232":502,"r_668":502,"r_84":502,"r_173":502,"r_172":502,"r_388":502,"r_387":502,"r_254":502,"r_188":502,"r_113":502,"r_85":502,"r_180":502,"r_615":502,"r_88":502,"r_221":502,"r_348":502,"r_174":502,"r_357":502,"r_194":502,"r_433":502,"r_919":502,"r_268":502,"r_269":502,"r_830":502,"r_614":502,"r_89":502,"r_229":502,"r_777":502,"r_353":502,"r_312":502,"r_541":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '156523', 'course_id' => '95848', 'title' => 'SpeedGrade CC', 'slug' => 'upto-fourteen-hours-speedgrade-cc-1training', 'external_link' => 'https://www.1training.org/course/speedgrade-cc/', 'summary' => '<strong>Overview</strong><br /> <br /> This excellent <strong>SpeedGrade CC</strong> course will teach you many of the SQL functions that allow you to manipulate the data within the database. Upon completion of this course you will be thoroughly versed in SQL and writing queries for your database. SQL is a domain-specific language used in programming, and if you hope to work in database management, as a backend developer, as a data analyst, or as a data scientist. These kinds of positions are in high demand, and command large salaries, so develop the key skills for a successful career with 1Training!<br /> <br /> This <strong>SpeedGrade CC</strong> course will be the ideal solution and the easiest course you will experience. We will offer you the opportunity to study 24/7 wherever you are in the world. This course is opened to anyone with an interest in the topic and give you access to world-class learning led by 1Training International.<br /> <br /> <strong>1Training International works in partnership with NUS, so all registered 1Training learners can get an NUS Extra discount card, which gives you amazing discounts on thousands of products from the biggest companies.</strong><br /> <br /> <strong>Why should I choose 1Training?</strong> <ul> <li>Free both e-certificate and printed certificate</li> <li>Accredited qualification</li> <li>Excellent quality video tutorials</li> <li>You'll be eligible for an NUS Discount Card</li> <li>Get one year's access to the course</li> <li>Get support by phone, live chat, and email</li> <li>Join our friendly online learning platform</li> <li>Our Course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. So, you can access your course on Wi-Fi, 3G or 4G.</li> </ul> <strong>Description</strong><br /> <br /> Learn for less with 1Training <strong>discount courses</strong> online! You’ll love 1Training’s excellent quality, competitive prices, and first class learner support. With this excellent discount course you can expect professional qualification, which will enable you to enhance your CV in no time, and for less!<br /> <br /> <strong>What skills am I going to get from this course?</strong> <ul> <li>Cover many of the SQL functions that allow you to manipulate the data within the database</li> <li>Upon completion of this series you will be thoroughly versed in SQL and writing queries for your database</li> </ul> <strong>Course Duration:</strong><br /> <br /> Learners will have <strong>365 days access</strong> to their chosen course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.<br /> <br /> <strong>COURSE CURRICULUM</strong> <ol> <li>Getting Started</li> <li>Advanced Search Functions</li> <li>Searching Multiple Tables</li> <li>Creating and Structuring Databases</li> <li>Special Data Functions and Instructions</li> <li>Working with Dates</li> <li>SQL Functions</li> </ol> <strong>How will I be assessed?</strong> <ul> <li>You will have one Assignment.</li> <li>You only need to pay £19 for assessment when you submit your assignment.</li> </ul> <strong>What Certification am I going to receive?</strong><br /> <br /> Those who successfully pass this course will be awarded a SpeedGrade CC certificate<strong>.</strong>. Anyone eligible for certification will receive both <strong>FREE e-certificate</strong> (PDF format), and <strong>printed certificate</strong>.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Database Manager,Backend Developer,Data Analyst', 'eligibility' => '<ul> <li>You must be 16 or over</li> <li>You should have a basic understanding of English, Maths and ICT</li> <li>You will need a computer or tablet with internet connection (or access to one)</li> </ul> ', 'school' => '1TRAINING', 'keywords' => 'SpeedGrade,Editor,Developer', 'location' => 'Online', 'duration' => 'Upto 14 Hours', 'timing' => null, 'cost' => null, 'discount' => '%85 خصم لعملاء ليمون!', 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'ar', 'status' => 'active', 'auto_translated' => '1', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ) ) $job = array( 'Job' => array( 'id' => '43108195', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'SQL Developer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<h2> Job Description </h2><p> As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus. </p>', 'course_qualifications' => null, 'global_location_id' => '64', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => 'Full time', 'salaryFrom' => null, 'salaryTo' => null, 'currency_id' => null, 'hide_salary' => '0', 'benefits' => null, 'salary_type_id' => null, 'travel_type_id' => null, 'travel_id' => null, 'education_id' => null, 'education_background' => null, 'language_id' => null, 'position_level_id' => null, 'position_type' => null, 'number_of_staffs_mange' => null, 'experiance' => null, 'sales_experience' => null, 'sales_focus' => null, 'sales_cycle_id' => null, 'reporting_to' => null, 'otherAssignments' => null, 'otherConsiderations' => null, 'ideal_candidate' => null, 'company_info' => null, 'company_id' => '52091', 'company_name' => 'Capgemini', 'external_apply_url' => 'https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=4141f5487e420865957a2fe29d07306c', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:08', 'published' => '2024-04-20 03:28:08', 'closed_time' => null, 'updated' => '2024-04-20 03:28:08', 'hideCompany' => null, 'hide_contact_info' => '0', 'application_count' => '0', 'closed' => '0', 'draft' => '0', 'rejected' => '0', 'deleted' => '0', 'moderated' => '1', 'boosted' => '0', 'rejectnote' => null, 'job_extended' => '0', 'purchased' => '0', 'seeder_id' => '113', 'source_id' => 'jooble', 'course_keywords' => null, 'shortlist_magic_applied' => '0', 'shortlist_magic_keywords' => null, 'living_in' => '0', 'age_limit' => null, 'is_managerial' => '0', 'application_email' => null, 'quality_score' => null, 'reopened' => '0', 'quality_type' => 'White', 'promoted' => '0' ), 'Recruiter' => array( 'first_name' => 'Jooble Jobs', 'last_name' => null, 'recruiter_type' => 'company' ), 'GlobalLocation' => array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( 'name' => 'Egypt', 'id' => '61', 'slug' => 'egypt', 'code' => 'EG' ) ), 'Company' => array( 'id' => '52091', 'name' => 'Capgemini', 'website' => 'https://www.capgemini.com/in-en/', 'verified' => '0', 'photo' => 'Capgemini_e08058a0-f1f5-11e9-bbf3-15f76e7ed41e.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ) $jobsList = array() $courses = array() $promotedCourses = array() $referer = '/' $urlKeyword = 'SQL ' $profile = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '13389', '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' ), 'CompanyPageTranslation' => array( 'id' => null, 'company_page_id' => null, 'title' => null, 'slug' => null, 'summary' => null, 'description' => null, 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'company_matching_keywords' => null, 'draft' => null, 'lang_code' => null ) ) $location = 'Egypt' $breadCrumbs = array( 'Job Details' => '' ) $relCourseBanner = array( 'relatedUrl' => 'https://courses.laimoon.com/ar/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'مايكروسوفت إس كيو إل سيرفر', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/ar/online/it-computing-and-technology/database-management/sql-server' ) $published = '2024-04-20 03:28:08' $daysleft = (float) 2 $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/ar/egypt/SQL ' $csaKeywords = array( (int) 0 => 'SQL Developer' ) $allowLoginClass = 'notlogin' $jobLocSlug = 'egypt' $jobLocName = 'Egypt' $pfBackgrounds = '' $jobLink = 'https://jobs.laimoon.com/jobs/externalview/43108195' $companyName = ' at Capgemini' $twitterText = 'Hiring now! SQL Developer at Capgemini. Please apply or share https://jobs.laimoon.com/jobs/externalview/43108195' $emailText = 'Hiring now! SQL Developer at Capgemini. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/43108195' $sCompanyName = false $csaSearchKey = 'SQL Developer' $jobDetails = 'تفاصيل الوظيفة' $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
الشركة المعلنة عن الوظيفة
Capgemini
تحسين فرصتك لحصول على وظيفة
خذ دورة عبر الإنترنت على مايكروسوفت إس كيو إل سيرفر ابتداءً من الآن.
-
SQL Database Administrator StudyHub49 درهم
955 درهممدة الدورة التدريبية: Upto 8 Hours -
SpeedGrade CC 1TRAINING79 درهم
563 درهممدة الدورة التدريبية: Upto 14 Hours
X
لماذا تقوم بالإبلاغ عن هذه الوظيفة؟
Job has expired لا يمكن عرض هذه الصفحةبدلًا من ذلك، يمكنك النقر على الرابط أدناه أو نسخ/لصق الرابط في متصفح الإنترنت الخاص بك.
https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=4141f5487e420865957a2fe29d07306c