IT Pros, take this course if you’re already familiar with database fundamentals and working with SQL Server and you’re ready to take your skills to the next level. It can also help you prepare for Exam 70-461, a key part of the MCSA: SQL Server certification. This course offers you the chance to understand the process better and teaches you to retrieve, insert, and update your database information. You also learn about data manipulation statements and how to alter tables, and you see some practical demos.
Instructors | Tobias Ternstrom – Senior Program Manager Lead; Brian Alderman - CEO & Founder, MicroTechPoint Associated Exam | 70-461 : Querying Microsoft SQL Server 2012 Related Certification | MCSA: SQL Server Associated Course | 10774A : Querying Microsoft SQL Server 2012 (five days)
In this module you’ll get an overview of the SQL Server types of statements, other statement elements, and the basic SELECT statements.
This module describes DISTINCT, aliases, scalar functions and CASE, using JOIN and MERGE; filtering and sorting data, and NULL values.
This module introduces data types, data type usage, converting data types, and understanding SQL Server function types.
In this module you’ll learn about aggregate functions, GROUP BY and HAVING clauses, and subqueries; self-contained, correlated and EXISTS; views, and inline-table valued functions, and derived tables.
In this module you’ll find out about SET operators, Windows functions, and GROUPING sets (PIVOT, UNPIVOT, CUBE, ROLLUP).
This module covers INSERT, UPDATE, and DELETE statements, and the use of defaults, constraints, and triggers, and OUTPUT.
In this module, you’ll learn about using T-SQL programming elements, implementing error handling, and understanding and implementing transactions.
This module explains querying system catalogs and dynamic management views, creating and executing stored procedures, and improving SQL Server query performance.
Please peruse this section for additional information that supports this Jump Start event. This is an opportunity for you to dive deeper into Querying Microsoft SQL Server 2012 Databases at your own pace.
Free Microsoft Training Delivered by Experts