Querying Microsoft SQL Server 2012/2014 - MOC 20461
Course Description
This 5-day instructor led course (MOC 20461) provides participants with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.
Note: This course is designed for participants who are interested in learning 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.
5 days
Contact us for pricing
Prerequisites
This course requires that you meet the following prerequisites:- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Introduction to Microsoft SQL Server 2014
The Basic Architecture of SQL ServerSQL Server Editions and Versions
Getting Started with SQL Server Management Studio
Introduction to T-SQL Querying
Introducing T-SQLUnderstanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Writing SELECT Queries
Writing Simple SELECT StatementsEliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
Querying Multiple Tables
Understanding JoinsQuerying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Sorting and Filtering Data
Sorting DataFiltering Data with a WHERE Clause
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown and Missing Values
Working with SQL Server 2014 Data Types
Introducing SQL Server 2014 Data TypesWorking with Character Data
Working with Date and Time Data
Using DML to Modify Data
Inserting DataModifying and Deleting Data
Using Built-In Functions
Writing Queries with Built-In FunctionsUsing Conversion Functions
Using Logical Functions
Using Functions to Work with NULL
Grouping and Aggregating Data
Using Aggregate FunctionsUsing the GROUP BY Clause
Filtering Groups with HAVING
Using Subqueries
Writing Self-Contained SubqueriesWriting Correlated Subqueries
Using the EXISTS Predicate with Subqueries
Using Table Expressions
Using Derived TablesUsing Common Table Expressions
Using Views
Using Inline Table-Valued Functions
Using Set Operators
Writing Queries with the UNION OperatorUsing EXCEPT and INTERSECT
Using APPLY
Using Window Ranking, Offset, and Aggregate Functions
Creating Windows with OVERExploring Window Functions
Pivoting and Grouping Sets
Writing Queries with PIVOT and UNPIVOTWorking with Grouping Sets
Executing Stored Procedures
Querying Data with Stored ProceduresPassing Parameters to Stored Procedures
Creating Simple Stored Procedures
Working with Dynamic SQL
Programming with T-SQL
T-SQL Programming ElementsControlling Program Flow
Implementing Error Handling
Using TRY / CATCH BlocksWorking with Error Information
Implementing Transactions
Transactions and the Database EngineControlling Transactions
Isolation Levels
Business IntelligenceMicrosoft SQLMicrosoft SQL ServerMicrosoft SQL Server 2012MS SQL Server 2012SQL 2012SQL Server 2014Microsoft SQL Server 2016MOCMicrosoft Official Curriculum20641MOC 20461