J. S., Framestore CFC
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.
Writing SELECT queries
SELECT, DISTINCT, using column and table aliases, CASE expressions.
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.
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.
Self-contained and correlated subqueries, the EXISTS predicate with subqueries.
Using table expressions
Derived tables, common table expressions, views, inline table-valued functions.
Using set operators
UNION, EXCEPT, INTERSECT, APPLY.
Lab: using set operators.
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.
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
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.