Developing Queries for Microsoft SQL Server 2012
This course provides you with the technical skills needed to write basic Transact-SQL queries for
Microsoft SQL Server 2012.
Course Duration: 3 days (full-time)
You will learn to…
Describe the basic architecture and concepts of Microsoft SQL Server 2012.
Understand the similarities and differences between Transact-SQL and other computer languages
Describe the use of data types in SQL Server
Modify data using Transact-SQL
About this course
This course provides you with the technical skills needed to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines including Database Administration, Database Development and Business Intelligence. This course can help you prepare for Microsoft exam 70-461.
4 Benefits of booking this course with us

Course Dates and Location
- This course takes place every month.
- Main locations: Southampton and London.
- Please contact us for more details of dates/location.
Testimonials
“The course facilitator is professional and the material was well prepared, my expectation and objectives were met.”
Related Courses
Developing Queries with Microsoft
SQL Server 2012
Management Information Reporting
Course Content
- Introduction to Microsoft SQL Server 2012
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Window Ranking, Offset and Aggregate Functions
- Pivoting and Grouping Sets
- Executing Stored Procedures
- Programming T-SQL
- Implementing Transactions
- Improving Query Performance
This course is intended for Data Analyst, Marketing Insight Analyst and Customer Insight Analyst, who are responsible for managing and providing actionable solutions to customer management.
£1,485 per person, ex VAT