Querying Microsoft SQL Server 2012 Online Course

Description

Although the exam(s) associated with this course has been retired by Microsoft, this course still retains value as a training resource & learners will receive a certificate of completion after completing the course.nThis Querying Microsoft SQL Server 2012 online course will teach you how to write queries using SQL Server 2012. Learn to create and alter tables with T-SQL, implement subqueries, manage transactions, and more, as you prepare for Microsoft’s 70-461 exam, one of three exams that must be passed to receive your MCSA: SQL Server 2012/2014 certification.nLearning ObjectivenBy the end of this course delegates will be able to:nApply built-in scalar functionsnApply ranking functionsnCombine datasetsnCreates and altersnDesign T-SQL stored procedures and viewsnImplementing aggregate queries, error handling, sequence generation and data typesnManage transactionsnModify data by using INSERT, UPDATE, DELETE and MERGE statementsnOptimizing queriesnQuery data using SELECT statements and Managing XML datanOUTPUT clause to return datanEntry RequirementsnThe course has no formal entry requirements, and has been designed to give you real-world knowledge that you can put to use from day one. It’s highly flexible, so you can set your own timetable and study at your own pace – you can start learning right away.nBenefitsnImprove your career prospects.nLearn valuable knowledge, skills, advice and guidance to help you achieve success.nStudy online from anywhere.nStudy at your own pace.nDownload and print your certificate of completion.nBulk discountsnBulk discounts are available on purchases of 10 or more courses.nIf you wish to discuss a large individual order for this course, and/or would like to be invoiced in advance, please call our sales team on 01707 828 751 to make an enquiry.n