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

Benefit 1

Intensive training of the most required skills in the Analytics sector, provided by attentive experienced industry practitioners.

Benefit 2

Hands-on, practical experience of applying the skills in different business scenarios.

Benefit 3

Well-rounded customer services plus complemetary career development consultancy.

Benefit 4

Pairview Practitioner Certificate: Querying Microsoft SQL Server 2012.
Enrol Today

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.”
Anonymous, Course Feedback Form

Related Courses

Developing Queries with Microsoft
SQL Server 2012
Management Information Reporting

Course Content

  1. Introduction to Microsoft SQL Server 2012
  2. Introduction to T-SQL Querying
  3. Writing SELECT Queries
  4. Querying Multiple Tables
  5. Sorting and Filtering Data
  6. Working with SQL Server Data Types
  7. Using DML to Modify Data
  8. Using Built-In Functions
  9. Grouping and Aggregating Data
  10. Using Subqueries
  11. Using Table Expressions
  12. Using Set Operators
  13. Using Window Ranking, Offset and Aggregate Functions
  14. Pivoting and Grouping Sets
  15. Executing Stored Procedures
  16. Programming T-SQL
  17. Implementing Transactions
  18. Improving Query Performance

Who Should Attend

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.

Course Fee

£1,485 per person, ex VAT