This short course covers basic database queries using Microsoft T-SQL 2012.
• Introduction to Databases
• Introduction to MS SQL Management Studio tool
• The SELECT statement
• Filtering and Sorting Data
• Data Conversion and Formatting Functions
• Using Group Functions
• Ranking Functions
• SET Operators
• Derived Tables
This course also constitutes part 1 of 5 of the preparation for the Microsoft Certification - Querying Microsoft SQL Server 2012 (Exam 70-461).
This course leads to...
Work in the IT Industry
There are no formal entry requirements. It is anticipated that learners will be processing data in employment or freelance projects.
Apply Now »
Need more information or can’t find the course you’re looking for? We can book you in to speak with our dedicated Advice & Guidance team about your options at The City of Liverpool College. With hundreds of courses and flexible learning, we’re sure to have something to meet your needs.
You can contact us online via firstname.lastname@example.org or call us at any point on 0151 252 3000 with any queries you may have – we’re here to help.