Speak to our team now +44 (0)1737 821590

Querying Microsoft SQL Server 2012

A 5 day
HANDS ON
training course

Querying Microsoft SQL Server 2012 training course description

This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-461. Note: This course is designed for SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Key outcomes from this course

By the end of the course delegates will be able to:
  • Describe the basic architecture and concepts of Microsoft SQL Server.
  • Write SELECT queries.
  • Query multiple tables.
  • Sort and filter data.
  • Describe the data types in SQL Server.
  • Modify data using Transact-SQL.
  • Use built-in functions.
  • Group and aggregate data.
  • Use subqueries.
  • Use table expressions.
  • Use set operators.
  • Use window ranking, offset and aggregate functions.
  • Implement pivoting and grouping sets.
  • Execute stored procedures.
  • Program with T-SQL.
  • Implement error handling.
  • Implement transactions.

Querying Microsoft SQL Server 2012 training course details

Who will benefit:
Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers.
Prerequisites:
Database fundamentals
Duration:
5 days

Training approach

This structured training course seeks to build upon workbook learning through the use of group exercises, dynamic discussion and individual tasks in order to deliver an engaging and interactive module that will ensure all candidates are able to transfer their new skills into the workplace.

Overall ratings for this course:

Course review


"Hard concepts were explained very simply."
J. S., Framestore CFC
"Excellent presentation - very good course structure."
B. M., London Internet Exchange

Querying Microsoft SQL Server 2012 training course contents

Introduction to Microsoft SQL Server
Architecture, editions, versions, SQL Server Management Studio.
Lab: SQL Server tools.

Introduction to T-SQL querying
T-SQL, sets, predicate logic. Order of operations in SELECT statements.
Lab: Transact-SQL.

Writing SELECT queries
SELECT, DISTINCT, using column and table aliases, CASE expressions.
Lab: SELECT.

Querying multiple tables
Joins, querying with inner joins, querying with outer joins, querying with cross joins and self joins.
Lab: Querying multiple tables.

Sorting and filtering data
Sorting data, filtering data with WHERE, filtering with TOP and OFFSET-FETCH, unknown and missing values.
Lab: sorting and filtering data.

Working with SQL Server data types
SQL Server data types, character data, date and time data.
Lab: SQL Server data types.

Using DML to modify data
Inserting, modifying and deleting data.
Lab: DML.

Using built-in functions
Built-in function queries, conversion functions, logical functions, NULL.
Lab: built-in functions.

Grouping and aggregating data
Aggregate functions, GROUP BY clause, filtering with HAVING.
Lab: GROUP-BY, HAVING.

Using subqueries
Self-contained and correlated subqueries, the EXISTS predicate with subqueries.
Lab: EXISTS.

Using table expressions
Derived tables, common table expressions, views, inline table-valued functions.
Lab: Views.

Using set operators
UNION, EXCEPT, INTERSECT, APPLY.
Lab: using set operators.

Window functions
Windows with OVER, window functions.
Lab: Window ranking, offset & aggregate functions.

Pivoting and grouping sets
PIVOT and UNPIVOT, working with grouping sets.
Lab: pivoting and grouping sets.

Executing stored procedures
Querying data with stored procedures, passing parameters, Dynamic SQL.
Lab : EXECUTE

Programming with T-SQL
T-SQL programming elements, controlling program flow.
Lab : programming with T-SQL

Implementing error handling
TRY/CATCH, error information.
Lab: Errors.

Implementing transactions
Transactions, the database engine, controlling transactions, isolation levels.
Lab: BEGIN, COMMIT, and ROLLBACK.

Improving query performance
Query performance factors and data. Lab: Improving query performance.

Querying SQL Server metadata
System catalog views and functions. System stored procedures, querying dynamic management objects.
Lab: Querying metadata.

Why Choose Us

SNT trainers score an average of over 90% on the three main areas of:
  • Ability to teach
  • Technical knowledge
  • Answering questions
“Excellently presented by a very knowledgeable and enthusiastic trainer.” P.D. General Dynamics

We limit our maximum class size to 8 delegates; often we have less than this. This ensures optimal interactivity between delegates and instructor.
"Excellent course. The small class size was a great benefit…" M.B. IBM

We write our own courses; courseware does not just consist of slides and our slides are diagrams not bullet point text. A typical chapter provides clearly defined objectives with a chapter overview, slides with text underneath, a quiz at the end to check the learning of the students. Hands on exercises are at the end and are used to reinforce the theory.

See Dates & Prices for this course

To enquire about this course

To reserve this course online