Home United Kingdom Database Administrator
Home United Kingdom Database Administrator
Database Administrator
Job details
Role: Database AdministratorLocation: Leeds, LS15 8GB (with hybrid working after completion of training)Salary: £55,000 - £65,000 per annum plus extensive benefitsContract type: PermanentEmployment type: Full time/Part timeWorking hours: 40 hrs pw, Monday to FridayDo you want to work for the nation’s largest online pharmacy ensuring excellence for all our patients? We’re a market leader in the pharmacy world, with 20 years’ experience, helping over 750,000 patients in England manage their NHS prescriptions from request through to delivery.This is a challenging and dynamic opportunity in a small and highly focused team, supporting the business to achieve its goals by working alongside cloud engineers, architects, and developers to deliver projects that support the business. In this Database Administrator (DBA) role you will develop and maintain a highly available, secure, and performant data platform.Optimising and monitoring production databases across an estate of physical, cloud and PaaS environments. Working for a market leading organisation as DBA, you will be responsible for the configuration, availability, integrity and security of all databases and data sources. With a natural ability to identify, assess, prioritise, and deliver improvements to the environments you will be responsible for, you will proactively manage technology and processes to deliver high-quality architecture you can be proud of.What’s in it for you?Occupational sick payDiscounted insurance (Aviva)Employee assistance programmeHealth and wellbeing initiativesGreen car schemeRefer a friend bonusCommitment to CPD/trainingDiscounts & Exclusive offers at The Springs, Leeds25% Discount & health & beauty purchasesEnhanced maternity and paternity payEmployee discount siteIn-house mental health supportSocial events throughout the yearRegistration fees paid (GPhC, NMC, CIPD etc)Blue light cardHybrid working25 days annual leave increasing with serviceContributory pensionDiscounted gymsFree onsite parkingCycle to work schemeLong service bonusWhat you’ll be doing?Ensure all database platforms are highly availableEnsure all data sources are secure and access is controlled, reviewed, and auditedSupport BI developers, application experts and middleware developers in their efforts to integrate and report on data in an accurate and reliable mannerWork with third parties for new installations, upgrades, maintenance, testing, troubleshooting and general advice and guidance as required to ensure all delivered services meet requirementsRespond to support escalations from DevOps and technical colleagues, providing specific expertise for troubleshooting as requiredBuild strong relationships in the business to understand business objectives, specific data requirements and how the data you maintain adds value to the businessControlled execution of data management tasksConfigure, maintenance and get maximum value from proactive monitoring using tools such as Redgate and New RelicWho are we looking for?Proficiency in SQL Server 2019 and Azure SQLStrong operations experience in troubleshooting and root cause analysisExperience of performance tuning and optimisingStrong proficiency with Microsoft T-SQLExcellent written and verbal communication skills at all levelsHighly motivated and patient centricProduces accurate work with high attention to detail and experience of working in a regulated industryExperience using native and third-party performance monitoring tools such as Redgate SQL Monitor and New RelicLogical thinkerWhat happens next?Please click apply and if we think you are a good match, we will be in touch to arrange an interview.Applicants must prove they have the right to live in the UK.All successful applicants will be required to undergo a DBS check.Unsolicited agency applications will be treated as a gift.#INDTECH
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' => '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' ), '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' => true, 'profileInfo' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '13375', 'contributedJobCount' => '24', 'courseCount' => null ), 'environment' => 'production', 'langUrlPrefix' => '', 'langUrl' => 'https://jobs.laimoon.com/', 'themeUrl' => 'https://jobs.laimoon.com/', 'siteUrl' => 'https://jobs.laimoon.com/', 'staticUrl' => 'https://cdn.laimoon.com/jobs/', 'langCode' => 'en', 'pageScripts' => array( (int) 0 => 'page_script' ), 'pageName' => 'externalview', 'courseUrl' => 'https://courses.laimoon.com/', 'onlineCourses' => array( (int) 0 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ), (int) 1 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ) ), 'job' => array( 'Job' => array( 'id' => '39308583', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'Database Administrator', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<p>Role: Database AdministratorLocation: Leeds, LS15 8GB (with hybrid working after completion of training)Salary: £55,000 - £65,000 per annum plus extensive benefitsContract type: PermanentEmployment type: Full time/Part timeWorking hours: 40 hrs pw, Monday to FridayDo you want to work for the nation’s largest online pharmacy ensuring excellence for all our patients? We’re a market leader in the pharmacy world, with 20 years’ experience, helping over 750,000 patients in England manage their NHS prescriptions from request through to delivery.This is a challenging and dynamic opportunity in a small and highly focused team, supporting the business to achieve its goals by working alongside cloud engineers, architects, and developers to deliver projects that support the business. In this Database Administrator (DBA) role you will develop and maintain a highly available, secure, and performant data platform.Optimising and monitoring production databases across an estate of physical, cloud and PaaS environments. Working for a market leading organisation as DBA, you will be responsible for the configuration, availability, integrity and security of all databases and data sources. With a natural ability to identify, assess, prioritise, and deliver improvements to the environments you will be responsible for, you will proactively manage technology and processes to deliver high-quality architecture you can be proud of.What’s in it for you?Occupational sick payDiscounted insurance (Aviva)Employee assistance programmeHealth and wellbeing initiativesGreen car schemeRefer a friend bonusCommitment to CPD/trainingDiscounts & Exclusive offers at The Springs, Leeds25% Discount & health & beauty purchasesEnhanced maternity and paternity payEmployee discount siteIn-house mental health supportSocial events throughout the yearRegistration fees paid (GPhC, NMC, CIPD etc)Blue light cardHybrid working25 days annual leave increasing with serviceContributory pensionDiscounted gymsFree onsite parkingCycle to work schemeLong service bonusWhat you’ll be doing?Ensure all database platforms are highly availableEnsure all data sources are secure and access is controlled, reviewed, and auditedSupport BI developers, application experts and middleware developers in their efforts to integrate and report on data in an accurate and reliable mannerWork with third parties for new installations, upgrades, maintenance, testing, troubleshooting and general advice and guidance as required to ensure all delivered services meet requirementsRespond to support escalations from DevOps and technical colleagues, providing specific expertise for troubleshooting as requiredBuild strong relationships in the business to understand business objectives, specific data requirements and how the data you maintain adds value to the businessControlled execution of data management tasksConfigure, maintenance and get maximum value from proactive monitoring using tools such as Redgate and New RelicWho are we looking for?Proficiency in SQL Server 2019 and Azure SQLStrong operations experience in troubleshooting and root cause analysisExperience of performance tuning and optimisingStrong proficiency with Microsoft T-SQLExcellent written and verbal communication skills at all levelsHighly motivated and patient centricProduces accurate work with high attention to detail and experience of working in a regulated industryExperience using native and third-party performance monitoring tools such as Redgate SQL Monitor and New RelicLogical thinkerWhat happens next?Please click apply and if we think you are a good match, we will be in touch to arrange an interview.Applicants must prove they have the right to live in the UK.All successful applicants will be required to undergo a DBS check.Unsolicited agency applications will be treated as a gift.#INDTECH </p>', 'course_qualifications' => null, 'global_location_id' => '226', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => '', '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' => '219258', 'company_name' => 'Pharmacy2U Ltd', 'external_apply_url' => 'https://uk.jooble.org/external/237772428927681566?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_uk&extra_ars_request_id=f37fb1b2b86c8202e78dda5be6eb6d07', 'external_short_url' => '', 'apply_url' => null, 'contributed' => '0', 'created' => null, 'published' => '2024-01-09 07:18:23', 'closed_time' => null, 'updated' => null, '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' => '8', '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' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( [maximum depth reached] ) ), 'Company' => array( 'id' => '219258', 'name' => 'Pharmacy2U Ltd', 'website' => null, 'verified' => '0', 'photo' => 'Pharmacy2U_Ltd_aaeda440-d6bb-11e9-8563-8d2b2f614077.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ), 'jobsList' => array(), 'courses' => array(), 'promotedCourses' => array(), 'referer' => '/', 'urlKeyword' => 'Database ', 'profile' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '13375', 'contributedJobCount' => '24', 'courseCount' => null ), 'askLogin' => true, 'jobLinkTitle' => 'Database ', 'renderSchema' => 'yes', 'title_for_layout' => 'Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.', 'page_description' => 'Apply to Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.Find similar vacancies, jobs and salary information in United Kingdom.', 'locationForTitle' => 'United Kingdom', 'currentJobCity' => array( 'id' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( 'name' => 'United Kingdom', 'id' => '74', 'slug' => 'united-kingdom', 'code' => 'GB' ) ), 'jobCompanyPage' => array( 'CompanyPage' => array( 'id' => '12943', 'title' => 'Pharmacy2U Ltd', 'slug' => 'pharmacy2u-ltd', 'description' => '', 'meta_title' => 'Jobs from Pharmacy2U Ltd', 'meta_description' => 'Jobs from Pharmacy2U Ltd', 'meta_keywords' => 'Jobs from Pharmacy2U Ltd', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '12925', 'company_page_id' => '12943', 'title' => 'Pharmacy2U Ltd', 'slug' => 'pharmacy2u-ltd', 'summary' => null, 'description' => '', 'meta_title' => 'Jobs from Pharmacy2U Ltd', 'meta_description' => 'Jobs from Pharmacy2U Ltd', 'meta_keywords' => 'Jobs from Pharmacy2U Ltd', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ), 'location' => 'United Kingdom', 'breadCrumbs' => array( 'Job Details' => '' ), 'relCourseBanner' => array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'SQL Server', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management/sql-server' ), 'published' => '2024-01-09 07:18:23', 'daysleft' => (float) -98, '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' => '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' ) $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 = true $profileInfo = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '13375', 'contributedJobCount' => '24', 'courseCount' => null ) $environment = 'production' $langUrlPrefix = '' $langUrl = 'https://jobs.laimoon.com/' $themeUrl = 'https://jobs.laimoon.com/' $siteUrl = 'https://jobs.laimoon.com/' $staticUrl = 'https://cdn.laimoon.com/jobs/' $langCode = 'en' $pageScripts = array( (int) 0 => 'page_script' ) $pageName = 'externalview' $courseUrl = 'https://courses.laimoon.com/' $onlineCourses = array( (int) 0 => array( 'Course' => array( 'id' => '97558', 'seeder_id' => '0', 'edited_seeder_id' => '94', 'edited_client_id' => '8080', 'title' => 'Querying Microsoft SQL Server 2012', 'external_link' => 'https://www.globaledulink.co.uk/course/querying-microsoft-sql-server-2012-70-461-practice-lab/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 16 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Global Edulink', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '109', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '143', 'nondiscounted_base_price' => '953.33', 'currency' => 'GBP', 'discount' => '85% Off for Laimoon Users!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-461 Querying Microsoft SQL Server online course.<br /> <br /> Microsoft courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. Global Edulink provides excellent training which will guarantee your success in your chosen Microsoft exam. For those hoping to take the 70-461 Querying Microsoft SQL Server exam, this is the course for you. This is a practice lab course, which will allow you to develop practical skills, and will be necessary to enable you to successfully pass the 70-461 Querying Microsoft SQL Server exam.<br /> <br /> The 70-461 Practice Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012. By completing the lab tasks you will improve your practical skills in creating database objects, working with data, modifying data, and troubleshooting and optimisation.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Create database objects (20–25%)</li> <li>Work with data (25–30%)</li> <li>Modify data (20–25%)</li> <li>Troubleshoot and optimise (25–30%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>COURSE CURRICULUM </strong><br /> <br /> <strong><em>Module 01</em> :</strong> Create and alter tables using Transact SQL syntax<br /> <strong><em>Module 02</em> :</strong> Create and alter views<br /> <strong><em>Module 03</em> :</strong> Create and modify constraints<br /> <strong><em>Module 04</em> :</strong> Create and alter DML triggers<br /> <strong><em>Module 05</em> :</strong> Query data by using SELECT statements<br /> <strong><em>Module 06</em> :</strong> Implementing Sub queries<br /> <strong><em>Module 07</em> :</strong> Implementing Data Types<br /> <strong><em>Module 08</em> :</strong> Implementing Aggregate Queries<br /> <strong><em>Module 09 </em>:</strong> Query and Manage XML Data<br /> <strong><em>Module 10</em> :</strong> Modifying Data<br /> <strong><em>Module 11</em> :</strong> Working with Functions<br /> <strong><em>Module 12</em> :</strong> Optimizing Queries<br /> <strong><em>Module 13</em> :</strong> Troubleshooting Queries<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for SQL Server database administrators, system engineers and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-461 Querying Microsoft SQL Server 2012 certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and ;', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'about_school' => '', 'keywords' => 'Microsoft,MCSA,MCSE', 'job_matching_keywords' => null, 'instructor_bio' => '', 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '395', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '7646', 'trainer_ids' => '', 'created' => '2018-05-09 15:06:24', 'updated' => '2024-03-15 12:58:12', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@globaledulink.co.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'upto-sixteen-hours-querying-microsoft-sql-server-2012-global-edulink', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '1', 'accreditation' => '0', 'accreditation_logos' => 'CPD,iAP', 'invoice_type' => 'Free', 'payment_mode' => 'free', 'invoice_value' => '5', 'invoice_click_value' => '0.29', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Full Time', 'study_timings' => '1', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'New', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'IT Support Technician,Senior Database Administrator,Software Engineer', 'rank' => '{"default":8,"uae_rank":8,"saudi_arabia_rank":8,"oman_rank":8,"singapore_rank":8,"jordan_rank":8}', 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"5153_en_c":350000000,"65235_ar_c":350000000,"66677_ar_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99929092', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '7646', 'name' => 'Global Edulink', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'global-edulink', 'location' => null, 'customer_name' => 'Rushan Arachchige', 'seeder_id' => '43', 'phone_number' => '2034097966', 'pri_line_number' => '', 'address_street' => ' CityPoint, 1 Ropemaker Street,', 'address_building' => '', 'address_city' => 'London, EC2Y 9HU.', 'address_country' => 'United Kingdom', 'addresss' => ' CityPoint, 1 Ropemaker Street,, London, EC2Y 9HU., United Kingdom', 'invoice_email' => 'info@globaledulink.co.uk', 'student_enrolment' => '1', 'masked_emails' => '1', 'moneyback' => '1', 'student_enrolment_processing_percentage' => '50', 'invoice_missed_calls' => '0', 'budget_alerts' => '0', 'budget_amount' => '0', 'budget_start_date' => null, 'provider_code' => '', 'payment_type' => 'CPC', 'intl_leads_enabled' => '0', 'invoice_notification' => '0', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1578472083-go (White Background).jpg', 'logo_size' => '{"width":3461,"height":1200}', 'description' => 'Global Edulink is a leading online learning and training provider. We believe that everyone should have the opportunity to learn, no matter what their situation, which is why we strive to keep our resources cutting edge and easy-to-understand.<br /> <br /> Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.<br /> <br /> Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.<br /> ', 'website' => 'http://www.globaledulink.co.uk', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => 'opt_content_1528980709-8-06-14 at 4.52.50 PM.png', 'video_embed_code' => '<iframe width="854" height="480" src="https://www.youtube.com/embed/bn_ZJ_0B2jM" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@globaledulink.co.uk', 'contact_phone_number' => '+44 2034097966', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"3";s:7:"dec_avg";d:3;s:9:"whole_avg";d:3;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => null, 'instant_callback_disabled' => '1', 'show_map' => '1', 'same_place' => '0', 'tier' => 'tier2', 'featured_advertiser' => '0', 'institution_type' => 'Training Institute', 'certificate' => null, 'hyperlocal_leads' => '0', 'training_mode' => 'Online', 'establish' => null, 'verify_code' => '', 'verify_status' => '1', 'course_csa_keywords' => null, 'untrusted' => '0', 'mobile_cpc_disabled' => '0', 'deleted' => '0', 'created' => '2017-11-24 20:50:10', 'modified' => '2022-09-05 13:45:10', 'pageview_enabled' => '1', 'timezone' => 'Europe/London', 'provider_status' => 'performance', 'cpc_direct_linking' => 'no', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Received', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2018-08-17 18:12:33', 'profile_completed_time' => '2017-11-24 20:57:46', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => '/', 'course_type_ids' => '2', 'trusted' => '0', 'legacy' => '0', 'moderation_status' => 'verified', 'rfp_email_alerts' => '0', 'rfp_unsubscribed' => '0', 'offer_start_date' => '0000-00-00', 'offer_end_date' => '0000-00-00', 'offer_price' => '0', 'discount_percentage' => '0', 'offer_published' => '0', 'offer_text' => '', 'resized' => '1', 'is_corporate' => '0', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '1', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1662371099_Sample_Cer.jpg', 'lead_filters' => null, 'repeat_email_lead_alerts' => '1', 'load_blncr_weight' => '1', 'remote_option' => null, 'classroom_status' => 'pending', 'topup_info' => null, 'provider_rank' => '{"default":502,"rndm":677710,"r_84":502,"r_174":502,"r_777":502,"r_82":502,"r_401":502,"r_89":502,"r_229":502,"r_80":502,"r_114":502,"r_610":502,"r_615":502,"r_609":502,"r_66":502,"r_614":502,"r_805":502,"r_79":502,"r_374":502,"r_682":502,"r_636":502,"r_88":502,"r_215":502,"r_17":502,"r_357":502,"r_86":502,"r_388":502,"r_221":502,"r_81":502,"r_382":502,"r_592":502,"r_541":502,"r_193":502,"r_95":502,"r_762":502,"r_656":502,"r_85":502,"r_180":502,"r_113":502,"r_809":502,"r_255":502,"r_808":502,"r_253":502,"r_254":502,"r_389":502,"r_618":502,"r_593":502,"r_599":502,"r_738":502,"r_743":502,"r_387":502,"r_12":502,"r_231":502,"r_97":502,"r_10":502,"r_528":502,"r_931":502,"r_527":502,"r_843":502,"r_111":502,"r_112":502,"r_596":502,"r_122":502,"r_823":502,"r_912":502,"r_149":502,"r_83":502,"r_167":502,"r_657":502,"r_237":502,"r_236":502,"r_168":502,"r_256":502,"r_739":502,"r_312":502,"r_511":502,"r_588":502,"r_332":502,"r_313":502,"r_439":502,"r_385":502,"r_811":502,"r_183":502,"r_227":502,"r_329":502,"r_225":502,"r_944":502,"r_223":502,"r_169":502,"r_597":502,"r_526":502,"r_818":502,"r_884":502,"r_268":502,"r_269":502,"r_27":502,"r_830":502,"r_531":502,"r_794":502,"r_347":502,"r_755":502,"r_780":502,"r_779":502,"r_524":502,"r_148":502,"r_94":502,"r_419":502,"r_589":502,"r_847":502,"r_725":502,"r_840":502,"r_125":502,"r_226":502,"r_391":502,"r_15":502,"r_207":502,"r_652":502,"r_694":502,"r_270":502,"r_760":502,"r_507":502,"r_508":502,"r_403":502,"r_204":502,"r_272":502,"r_515":502,"r_519":502,"r_918":502,"r_195":502,"r_432":502,"r_142":502,"r_691":502,"r_393":502,"r_722":502,"r_398":502,"r_872":502,"r_394":502,"r_395":502,"r_400":502,"r_887":502,"r_196":502,"r_194":502,"r_345":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '126420', 'course_id' => '97558', 'title' => 'Querying Microsoft SQL Server 2012', 'slug' => 'upto-sixteen-hours-querying-microsoft-sql-server-2012-global-edulink', 'external_link' => 'https://www.globaledulink.co.uk/course/querying-microsoft-sql-server-2012-70-461-practice-lab/', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-461 Querying Microsoft SQL Server online course.<br /> <br /> Microsoft courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. Global Edulink provides excellent training which will guarantee your success in your chosen Microsoft exam. For those hoping to take the 70-461 Querying Microsoft SQL Server exam, this is the course for you. This is a practice lab course, which will allow you to develop practical skills, and will be necessary to enable you to successfully pass the 70-461 Querying Microsoft SQL Server exam.<br /> <br /> The 70-461 Practice Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012. By completing the lab tasks you will improve your practical skills in creating database objects, working with data, modifying data, and troubleshooting and optimisation.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Create database objects (20–25%)</li> <li>Work with data (25–30%)</li> <li>Modify data (20–25%)</li> <li>Troubleshoot and optimise (25–30%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>COURSE CURRICULUM </strong><br /> <br /> <strong><em>Module 01</em> :</strong> Create and alter tables using Transact SQL syntax<br /> <strong><em>Module 02</em> :</strong> Create and alter views<br /> <strong><em>Module 03</em> :</strong> Create and modify constraints<br /> <strong><em>Module 04</em> :</strong> Create and alter DML triggers<br /> <strong><em>Module 05</em> :</strong> Query data by using SELECT statements<br /> <strong><em>Module 06</em> :</strong> Implementing Sub queries<br /> <strong><em>Module 07</em> :</strong> Implementing Data Types<br /> <strong><em>Module 08</em> :</strong> Implementing Aggregate Queries<br /> <strong><em>Module 09 </em>:</strong> Query and Manage XML Data<br /> <strong><em>Module 10</em> :</strong> Modifying Data<br /> <strong><em>Module 11</em> :</strong> Working with Functions<br /> <strong><em>Module 12</em> :</strong> Optimizing Queries<br /> <strong><em>Module 13</em> :</strong> Troubleshooting Queries<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for SQL Server database administrators, system engineers and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-461 Querying Microsoft SQL Server 2012 certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and ;', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'IT Support Technician,Senior Database Administrator,Software Engineer', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'school' => 'Global Edulink', 'keywords' => 'Microsoft,MCSA,MCSE', 'location' => 'Online', 'duration' => 'Upto 16 Hours', 'timing' => null, 'cost' => null, 'discount' => '85% Off for Laimoon Users!', 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'en', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ), (int) 1 => array( 'Course' => array( 'id' => '141449', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => '99998627', 'title' => 'Microsoft SQL Server Development', 'external_link' => 'https://studyhub.org.uk/course/microsoft-sql-server-development-for-everyone/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => null, 'next_session' => null, 'schedules' => null, 'duration' => 'Upto 6 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'StudyHub', 'logo' => null, 'certificate_diploma' => 'yes', 'image' => null, 'brochure_url' => null, 'video' => null, 'cost' => null, 'price' => '49', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '13', 'nondiscounted_base_price' => '260', 'currency' => 'AED', 'discount' => '95% Off for Laimoon Users!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => 'Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It’s a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.<br /> <br /> In this <strong>Microsoft SQL Server Development for Everyone!</strong> course, you’ll learn the basics of SQL Server development. You’ll learn how to create and manage databases, tables, and data. You’ll also learn how to write SQL queries to manipulate data.<br /> <br /> Starting with a solid Introduction to SQL, you’ll grasp core concepts and gain a strong foundation. We’ll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.<br /> <br /> But we won’t stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You’ll create robust and reliable databases with enforced referential integrity. Next, we’ll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.<br /> <br /> To become a well-rounded SQL Server developer, we’ll conclude the course with Advanced SQL Server Objects and Concepts. You’ll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.<br /> <br /> By the end of this <strong>Microsoft SQL Server Development for Everyone! </strong>course, you’ll have a strong understanding of how to use SQL Server to manage and manipulate data. You’ll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!<br /> <br /> <strong>Learning Outcomes:</strong><br /> <br /> Through this comprehensive course, you should be able to: <ul> <li>Understand core concepts and gain a strong foundation in SQL Server development.</li> <li>Acquire skills to effectively manipulate tables and data.</li> <li>Establish relationships and enforce data integrity using foreign keys.</li> <li>Utilise group by and aggregate functions for efficient data analysis.</li> <li>Explore advanced SQL Server objects and concepts like stored procedures and views.</li> <li>Gain proficiency in implementing triggers and optimising database performance.</li> <li>Develop the ability to create robust and reliable databases.</li> </ul> <br /> <strong>COURSE CURRICULUM<br /> <br /> Microsoft SQL Server Development for Everyone</strong> <ul> <li>Introduction</li> <li>Manipulating Tables and Data</li> <li>Relationships and Foreign Keys</li> <li>Group By and Aggregate Functions</li> <li>Advanced SQL Server Objects and Concepts</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This <strong>Microsoft SQL Server Development for Everyone!</strong> course is perfect for: <ul> <li>Aspiring developers looking to enhance their programming skills.</li> <li>Professionals seeking to expand their knowledge of SQL Server development.</li> <li>Individuals interested in exploring the world of databases and data management.</li> <li>Students or graduates pursuing a career in database administration or development.</li> <li>Curious learners eager to harness the power of SQL Server.</li> </ul> <strong>Why choose this course?</strong> <ul> <li>Unlimited access to the course for a lifetime.</li> <li>Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.</li> <li>Structured lesson planning in line with industry standards.</li> <li>Immerse yourself in innovative and captivating course materials and activities.</li> <li>Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.</li> <li>Flexibility to complete the Course at your own pace, on your own schedule.</li> <li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li> </ul> <strong>Certification</strong><br /> <br /> After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £ Original Hard Copy certificates need to be ordered at an additional cost of £8.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => '<br /> This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start ;Microsoft SQL Server Development for Everyone! was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.', 'about_school' => null, 'keywords' => 'sql server development,microsoft sql developer,sql server 2019 developer,ms sql developer,sql server 2022 developer', 'job_matching_keywords' => null, 'instructor_bio' => null, 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '395', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '12272', 'trainer_ids' => '', 'created' => '2023-08-16 13:09:16', 'updated' => '2023-10-20 10:07:32', 'sort_order' => null, 'page' => 'JobListing', 'to_emails' => 'Info@studyhub.org.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '0', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'part-time-microsoft-sql-server-development-studyhub', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '0', 'accreditation' => null, 'accreditation_logos' => 'CPD Qualification Standards', 'invoice_type' => 'CPC', 'payment_mode' => 'paid', 'invoice_value' => '5', 'invoice_click_value' => '0.1', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Part Time', 'study_timings' => '2', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'New', 'online_method' => null, 'delivery_languages' => 'en', 'career_path' => 'SQL Developer,Database Developer,Data Analyst,Data Engineer,Business Intelligence Analyst,Big Data Engineer,Cloud Architect', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"5153_en_c":350000000,"128170_en_c":350000000,"5158_en_c":350000000,"180017_en_c":350000000,"72475_en_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => null, 'cpa_recommended' => null, 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99642037', '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":826695,"r_79":502,"r_345":502,"r_84":502,"r_328":502,"r_374":502,"r_682":502,"r_656":502,"r_755":502,"r_780":502,"r_347":502,"r_17":502,"r_443":502,"r_101":502,"r_66":502,"r_190":502,"r_97":502,"r_375":502,"r_662":502,"r_255":502,"r_82":502,"r_142":502,"r_653":502,"r_394":502,"r_396":502,"r_395":502,"r_401":502,"r_599":502,"r_12":502,"r_668":502,"r_86":502,"r_388":502,"r_174":502,"r_253":502,"r_87":502,"r_199":502,"r_652":502,"r_422":502,"r_403":502,"r_793":502,"r_89":502,"r_225":502,"r_941":502,"r_944":502,"r_85":502,"r_177":502,"r_384":502,"r_408":502,"r_432":502,"r_926":502,"r_242":502,"r_69":502,"r_582":502,"r_80":502,"r_111":502,"r_113":502,"r_809":502,"r_724":502,"r_779":502,"r_232":502,"r_14":502,"r_952":502,"r_583":502,"r_146":502,"r_871":502,"r_911":502,"r_88":502,"r_216":502,"r_215":502,"r_229":502,"r_224":502,"r_10":502,"r_725":502,"r_844":502,"r_440":502,"r_763":502,"r_851":502,"r_852":502,"r_900":502,"r_765":502,"r_404":502,"r_655":502,"r_953":502,"r_91":502,"r_261":502,"r_9":502,"r_151":502,"r_697":502,"r_320":502,"r_511":502,"r_588":502,"r_181":502,"r_798":502,"r_626":502,"r_436":502,"r_332":502,"r_808":502,"r_919":502,"r_615":502,"r_172":502,"r_393":502,"r_800":502,"r_143":502,"r_81":502,"r_126":502,"r_507":502,"r_508":502,"r_149":502,"r_870":502,"r_125":502,"r_854":502,"r_99":502,"r_673":502,"r_204":502,"r_608":502,"r_344":502,"r_27":502,"r_237":502,"r_884":502,"r_512":502,"r_812":502,"r_813":502,"r_915":502,"r_323":502,"r_383":502,"r_387":502,"r_790":502,"r_15":502,"r_365":502,"r_956":502,"r_700":502,"r_141":502,"r_726":502,"r_209":502,"r_95":502,"r_198":502,"r_391":502,"r_681":502,"r_695":502,"r_114":502,"r_609":502,"r_148":502,"r_355":502,"r_145":502,"r_737":502,"r_689":502,"r_898":502,"r_897":502,"r_722":502,"r_802":502,"r_888":502,"r_887":502,"r_694":502,"r_743":502,"r_398":502,"r_691":502,"r_720":502,"r_739":502,"r_738":502,"r_740":502,"r_954":502,"r_597":502,"r_631":502,"r_399":502,"r_826":502,"r_730":502,"r_863":502,"r_742":502,"r_799":502,"r_801":502,"r_806":502,"r_864":502,"r_873":502,"r_538":502,"r_875":502,"r_876":502,"r_877":502,"r_885":502,"r_899":502,"r_890":502,"r_891":502,"r_896":502,"r_963":502,"r_643":502,"r_924":502,"r_324":502,"r_605":502,"r_327":502,"r_20":502,"r_161":502,"r_163":502,"r_641":502,"r_266":502,"r_412":502,"r_769":502,"r_958":502,"r_164":502,"r_128":502,"r_381":502,"r_539":502,"r_361":502,"r_955":502,"r_223":502,"r_207":502,"r_734":502,"r_932":502,"r_214":502,"r_206":502,"r_943":502,"r_210":502,"r_696":502,"r_638":502,"r_227":502,"r_951":502,"r_949":502,"r_364":502,"r_315":502,"r_848":502,"r_441":502,"r_314":502,"r_797":502,"r_930":502,"r_319":502,"r_703":502,"r_312":502,"r_439":502,"r_528":502,"r_523":502,"r_672":502,"r_94":502,"r_226":502,"r_620":502,"r_931":502,"r_607":502,"r_527":502,"r_841":502,"r_840":502,"r_313":502,"r_933":502,"r_317":502,"r_530":502,"r_419":502,"r_589":502,"r_611":502,"r_671":502,"r_26":502,"r_292":502,"r_193":502,"r_791":502,"r_846":502,"r_845":502,"r_950":502,"r_959":502,"r_587":502,"r_762":502,"r_90":502,"r_248":502,"r_666":502,"r_110":502,"r_636":502,"r_601":502,"r_630":502,"r_792":502,"r_241":502,"r_427":502,"r_98":502,"r_343":502,"r_789":502,"r_346":502,"r_370":502,"r_201":502,"r_371":502,"r_425":502,"r_373":502,"r_423":502,"r_96":502,"r_305":502,"r_536":502,"r_616":502,"r_187":502,"r_385":502,"r_183":502,"r_188":502,"r_194":502,"r_195":502,"r_202":502,"r_433":502,"r_657":502,"r_196":502,"r_329":502,"r_810":502,"r_881":502,"r_197":502,"r_934":502,"r_590":502,"r_787":502,"r_122":502,"r_382":502,"r_749":502,"r_639":502,"r_823":502,"r_259":502,"r_786":502,"r_861":502,"r_124":502,"r_592":502,"r_750":502,"r_420":502,"r_123":502,"r_299":502,"r_784":502,"r_923":502,"r_785":502,"r_849":502,"r_121":502,"r_127":502,"r_308":502,"r_380":502,"r_633":502,"r_648":502,"r_748":502,"r_753":502,"r_788":502,"r_816":502,"r_822":502,"r_820":502,"r_819":502,"r_821":502,"r_850":502,"r_859":502,"r_862":502,"r_777":502,"r_805":502,"r_804":502,"r_865":502,"r_348":502,"r_912":502,"r_231":502,"r_918":502,"r_236":502,"r_281":502,"r_807":502,"r_350":502,"r_693":502,"r_230":502,"r_692":502,"r_940":502,"r_778":502,"r_378":502,"r_83":502,"r_707":502,"r_168":502,"r_670":502,"r_169":502,"r_191":502,"r_927":502,"r_757":502,"r_901":502,"r_167":502,"r_541":502,"r_658":502,"r_351":502,"r_817":502,"r_610":502,"r_614":502,"r_705":502,"r_180":502,"r_811":502,"r_112":502,"r_119":502,"r_709":502,"r_257":502,"r_842":502,"r_843":502,"r_866":502,"r_115":502,"r_596":502,"r_867":502,"r_254":502,"r_759":502,"r_847":502,"r_776":502,"r_781":502,"r_929":502,"r_405":502,"r_200":502,"r_406":502,"r_645":502,"r_531":502,"r_794":502,"r_795":502,"r_925":502,"r_247":502,"r_604":502,"r_948":502,"r_960":502,"r_52":502,"r_335":502,"r_330":502,"r_249":502,"r_690":502,"r_706":502,"r_21":502,"r_41":502,"r_42":502,"r_221":502,"r_268":502,"r_269":502,"r_830":502,"r_270":502,"r_272":502,"r_515":502,"r_520":502,"r_683":502,"r_271":502,"r_829":502,"r_258":502,"r_260":502,"r_526":502,"r_818":502,"r_173":502,"r_354":502,"r_916":502,"r_415":502,"r_211":502,"r_411":502,"r_516":502,"r_677":502,"r_222":502,"r_43":502,"r_256":502,"r_524":502,"r_494":502,"r_265":502,"r_496":502,"r_60":502,"r_321":502,"r_109":502,"r_108":502,"r_162":502,"r_731":502,"r_267":502,"r_234":502,"r_322":502,"r_325":502,"r_519":502,"r_629":502,"r_660":502,"r_165":502,"r_758":502,"r_170":502,"r_747":502,"r_352":502,"r_240":502,"r_585":502,"r_118":502,"r_760":502,"r_612":502,"r_291":502,"r_581":502,"r_421":502,"r_386":502,"r_914":502,"r_602":502,"r_203":502,"r_838":502,"r_761":502,"r_522":502,"r_617":502,"r_517":502,"r_600":502,"r_497":502,"r_263":502,"r_665":502,"r_316":502,"r_613":502,"r_205":502,"r_827":502,"r_155":502,"r_882":502,"r_409":502,"r_782":502,"r_646":502,"r_233":502,"r_147":502,"r_803":502,"r_868":502,"r_498":502,"r_513":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '218900', 'course_id' => '141449', 'title' => 'Microsoft SQL Server Development', 'slug' => 'part-time-microsoft-sql-server-development-studyhub', 'external_link' => 'https://studyhub.org.uk/course/microsoft-sql-server-development-for-everyone/', 'summary' => 'Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It’s a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.<br /> <br /> In this <strong>Microsoft SQL Server Development for Everyone!</strong> course, you’ll learn the basics of SQL Server development. You’ll learn how to create and manage databases, tables, and data. You’ll also learn how to write SQL queries to manipulate data.<br /> <br /> Starting with a solid Introduction to SQL, you’ll grasp core concepts and gain a strong foundation. We’ll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.<br /> <br /> But we won’t stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You’ll create robust and reliable databases with enforced referential integrity. Next, we’ll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.<br /> <br /> To become a well-rounded SQL Server developer, we’ll conclude the course with Advanced SQL Server Objects and Concepts. You’ll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.<br /> <br /> By the end of this <strong>Microsoft SQL Server Development for Everyone! </strong>course, you’ll have a strong understanding of how to use SQL Server to manage and manipulate data. You’ll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!<br /> <br /> <strong>Learning Outcomes:</strong><br /> <br /> Through this comprehensive course, you should be able to: <ul> <li>Understand core concepts and gain a strong foundation in SQL Server development.</li> <li>Acquire skills to effectively manipulate tables and data.</li> <li>Establish relationships and enforce data integrity using foreign keys.</li> <li>Utilise group by and aggregate functions for efficient data analysis.</li> <li>Explore advanced SQL Server objects and concepts like stored procedures and views.</li> <li>Gain proficiency in implementing triggers and optimising database performance.</li> <li>Develop the ability to create robust and reliable databases.</li> </ul> <br /> <strong>COURSE CURRICULUM<br /> <br /> Microsoft SQL Server Development for Everyone</strong> <ul> <li>Introduction</li> <li>Manipulating Tables and Data</li> <li>Relationships and Foreign Keys</li> <li>Group By and Aggregate Functions</li> <li>Advanced SQL Server Objects and Concepts</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This <strong>Microsoft SQL Server Development for Everyone!</strong> course is perfect for: <ul> <li>Aspiring developers looking to enhance their programming skills.</li> <li>Professionals seeking to expand their knowledge of SQL Server development.</li> <li>Individuals interested in exploring the world of databases and data management.</li> <li>Students or graduates pursuing a career in database administration or development.</li> <li>Curious learners eager to harness the power of SQL Server.</li> </ul> <strong>Why choose this course?</strong> <ul> <li>Unlimited access to the course for a lifetime.</li> <li>Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.</li> <li>Structured lesson planning in line with industry standards.</li> <li>Immerse yourself in innovative and captivating course materials and activities.</li> <li>Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.</li> <li>Flexibility to complete the Course at your own pace, on your own schedule.</li> <li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li> </ul> <strong>Certification</strong><br /> <br /> After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £ Original Hard Copy certificates need to be ordered at an additional cost of £8.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'SQL Developer,Database Developer,Data Analyst,Data Engineer,Business Intelligence Analyst,Big Data Engineer,Cloud Architect', 'eligibility' => '<br /> This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start ;Microsoft SQL Server Development for Everyone! was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.', 'school' => 'StudyHub', 'keywords' => 'sql server development,microsoft sql developer,sql server 2019 developer,ms sql developer,sql server 2022 developer', 'location' => 'Online', 'duration' => 'Upto 6 Hours', 'timing' => null, 'cost' => null, 'discount' => '95% Off for Laimoon Users!', 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'en', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ) ) $job = array( 'Job' => array( 'id' => '39308583', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'Database Administrator', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<p>Role: Database AdministratorLocation: Leeds, LS15 8GB (with hybrid working after completion of training)Salary: £55,000 - £65,000 per annum plus extensive benefitsContract type: PermanentEmployment type: Full time/Part timeWorking hours: 40 hrs pw, Monday to FridayDo you want to work for the nation’s largest online pharmacy ensuring excellence for all our patients? We’re a market leader in the pharmacy world, with 20 years’ experience, helping over 750,000 patients in England manage their NHS prescriptions from request through to delivery.This is a challenging and dynamic opportunity in a small and highly focused team, supporting the business to achieve its goals by working alongside cloud engineers, architects, and developers to deliver projects that support the business. In this Database Administrator (DBA) role you will develop and maintain a highly available, secure, and performant data platform.Optimising and monitoring production databases across an estate of physical, cloud and PaaS environments. Working for a market leading organisation as DBA, you will be responsible for the configuration, availability, integrity and security of all databases and data sources. With a natural ability to identify, assess, prioritise, and deliver improvements to the environments you will be responsible for, you will proactively manage technology and processes to deliver high-quality architecture you can be proud of.What’s in it for you?Occupational sick payDiscounted insurance (Aviva)Employee assistance programmeHealth and wellbeing initiativesGreen car schemeRefer a friend bonusCommitment to CPD/trainingDiscounts & Exclusive offers at The Springs, Leeds25% Discount & health & beauty purchasesEnhanced maternity and paternity payEmployee discount siteIn-house mental health supportSocial events throughout the yearRegistration fees paid (GPhC, NMC, CIPD etc)Blue light cardHybrid working25 days annual leave increasing with serviceContributory pensionDiscounted gymsFree onsite parkingCycle to work schemeLong service bonusWhat you’ll be doing?Ensure all database platforms are highly availableEnsure all data sources are secure and access is controlled, reviewed, and auditedSupport BI developers, application experts and middleware developers in their efforts to integrate and report on data in an accurate and reliable mannerWork with third parties for new installations, upgrades, maintenance, testing, troubleshooting and general advice and guidance as required to ensure all delivered services meet requirementsRespond to support escalations from DevOps and technical colleagues, providing specific expertise for troubleshooting as requiredBuild strong relationships in the business to understand business objectives, specific data requirements and how the data you maintain adds value to the businessControlled execution of data management tasksConfigure, maintenance and get maximum value from proactive monitoring using tools such as Redgate and New RelicWho are we looking for?Proficiency in SQL Server 2019 and Azure SQLStrong operations experience in troubleshooting and root cause analysisExperience of performance tuning and optimisingStrong proficiency with Microsoft T-SQLExcellent written and verbal communication skills at all levelsHighly motivated and patient centricProduces accurate work with high attention to detail and experience of working in a regulated industryExperience using native and third-party performance monitoring tools such as Redgate SQL Monitor and New RelicLogical thinkerWhat happens next?Please click apply and if we think you are a good match, we will be in touch to arrange an interview.Applicants must prove they have the right to live in the UK.All successful applicants will be required to undergo a DBS check.Unsolicited agency applications will be treated as a gift.#INDTECH </p>', 'course_qualifications' => null, 'global_location_id' => '226', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => '', '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' => '219258', 'company_name' => 'Pharmacy2U Ltd', 'external_apply_url' => 'https://uk.jooble.org/external/237772428927681566?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_uk&extra_ars_request_id=f37fb1b2b86c8202e78dda5be6eb6d07', 'external_short_url' => '', 'apply_url' => null, 'contributed' => '0', 'created' => null, 'published' => '2024-01-09 07:18:23', 'closed_time' => null, 'updated' => null, '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' => '8', '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' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( 'name' => 'United Kingdom', 'id' => '74', 'slug' => 'united-kingdom', 'code' => 'GB' ) ), 'Company' => array( 'id' => '219258', 'name' => 'Pharmacy2U Ltd', 'website' => null, 'verified' => '0', 'photo' => 'Pharmacy2U_Ltd_aaeda440-d6bb-11e9-8563-8d2b2f614077.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ) $jobsList = array() $courses = array() $promotedCourses = array() $referer = '/' $urlKeyword = 'Database ' $profile = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '13375', 'contributedJobCount' => '24', 'courseCount' => null ) $askLogin = true $jobLinkTitle = 'Database ' $renderSchema = 'yes' $title_for_layout = 'Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.' $page_description = 'Apply to Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.Find similar vacancies, jobs and salary information in United Kingdom.' $locationForTitle = 'United Kingdom' $currentJobCity = array( 'id' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( 'name' => 'United Kingdom', 'id' => '74', 'slug' => 'united-kingdom', 'code' => 'GB' ) ) $jobCompanyPage = array( 'CompanyPage' => array( 'id' => '12943', 'title' => 'Pharmacy2U Ltd', 'slug' => 'pharmacy2u-ltd', 'description' => '', 'meta_title' => 'Jobs from Pharmacy2U Ltd', 'meta_description' => 'Jobs from Pharmacy2U Ltd', 'meta_keywords' => 'Jobs from Pharmacy2U Ltd', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '12925', 'company_page_id' => '12943', 'title' => 'Pharmacy2U Ltd', 'slug' => 'pharmacy2u-ltd', 'summary' => null, 'description' => '', 'meta_title' => 'Jobs from Pharmacy2U Ltd', 'meta_description' => 'Jobs from Pharmacy2U Ltd', 'meta_keywords' => 'Jobs from Pharmacy2U Ltd', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ) $location = 'United Kingdom' $breadCrumbs = array( 'Job Details' => '' ) $relCourseBanner = array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'SQL Server', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management/sql-server' ) $published = '2024-01-09 07:18:23' $daysleft = (float) -98 $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/united-kingdom/Database ' $csaKeywords = array( (int) 0 => 'Database Administrator' ) $allowLoginClass = 'notlogin' $jobLocSlug = 'united-kingdom' $jobLocName = 'United Kingdom' $pfBackgrounds = '' $jobLink = 'https://jobs.laimoon.com/jobs/externalview/39308583' $companyName = ' at Pharmacy2U Ltd' $twitterText = 'Hiring now! Database Administrator at Pharmacy2U Ltd. Please apply or share https://jobs.laimoon.com/jobs/externalview/39308583' $emailText = 'Hiring now! Database Administrator at Pharmacy2U Ltd. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/39308583' $sCompanyName = false $csaSearchKey = 'Database Administrator' $jobDetails = 'job details' $btn_text = 'Apply on company website' $confidentialExists = false $showCompany = (int) 1 $mainCheck = (int) 1 $confidentialThumbClass = '' $cdnImageThumbPath = 'https://cdn.laimoon.com/profileimages/thumbnail/' $companyPageTitle = 'Pharmacy2U Ltd'include - APP/View/Jobs/externalview.ctp, line 206 View::_evaluate() - CORE/Cake/View/View.php, line 948 View::_render() - CORE/Cake/View/View.php, line 910 View::render() - CORE/Cake/View/View.php, line 471 Controller::render() - CORE/Cake/Controller/Controller.php, line 948 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 194 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162 [main] - APP/webroot/index.php, line 115
Hiring company
Pharmacy2U Ltd
-
Querying Microsoft SQL Server 2012 Global EdulinkAED 508
AED 3,502Duration: Upto 16 Hours -
Microsoft SQL Server Development StudyHubAED 49
AED 955Duration: Upto 6 Hours
Why are you reporting this job?
Job has expired Cannot view this pageAlternatively, you may click on the link below or copy/paste it into your browser.
https://uk.jooble.org/external/237772428927681566?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_uk&extra_ars_request_id=f37fb1b2b86c8202e78dda5be6eb6d07