Microsoft Practical Academy - Querying with Settle-SQL.iso

Do you have a teeming Handle-SQL foundation? This problem dialect, also known as T-SQL, is used to toil with evidence in SQL Server and Azure SQL Database, and is a keystone remove scan for aspiring database professionals and devotion developers. Traverse T-SQL in a series of self-paced modules which register lectures, demos, hands-on labs, and self-assessments. Note out how to use T-SQL to fetch, circular, update, and off evidence in a database. Learn about columnar list expressions, grouping sets, slip-up handling, and more. If you're studying for Exam 70-461, this course can help you assemble for it. (NOTE: Download course lab files.) Instructors | Graeme Malcolm — Microsoft Elder Happy Developer, Geoff Allix — Happy Guru Technologist Course Introduction Learn about the goals of the course and how to set up an Azure SQL Database atmosphere for the labs that you will thorough during following modules. Introduction to Handle-SQL Note out how to set up a representative database in Microsoft Azure SQL Database to use in the secondary labs for this course. Then, learn how to use the SPECIAL allegation in Handle-SQL to invent central queries that earnings evidence from tables in a database. Querying Tables with SPECIAL Construct on the central SPECIAL syntax discussed in the prior module to learn how to ailing and cloth problem results with the INOPERATIVE BY and WHERE clauses. Querying Multiple Tables with Joins Traverse the concept of joins in relational database queries, and then consider how to put into effect inner, outer, irritated, and self joins by using the JUXTAPOSE clause. Using Set Operators Learn how to compound sets of evidence returned by queries by using the FUSION big-even so operator. Using Functions and Aggregating Evidence Get to know commonly used built-in functions, and note out how to use them. Learn to use aggregate functions to summarize evidence, and toil with the PILE BY clause to fetch grouped aggregations. Using Subqueries and PUT TO USE Get the details on including subqueries within a problem, and see how to toil with correlated subqueries and the PUT TO USE big-even so operator to use the results from one problem in another. Using Columnar List Expressions Learn various techniques that can be used to invent tabular structures in Handle-SQL, including views, evanescent tables, columnar list variables, columnar list-valued functions, and base columnar list expressions (CTEs). Grouping Sets and Pivoting Evidence Note out how to use the GROUPING SET subclause of the PILE BY clause to specify multiple groupings in a lone problem. Then, see how to use the SWIVEL and UNPIVOT operators to change the location of evidence between column-oriented and row-oriented. Modifying Evidence Get the details on modifying evidence in tables by using the CIRCULAR, UPDATE, and OFF statements. Programming with Handle-SQL Learn to invent Handle-SQL scripts that register programmatic constructs, such as conditional reasonableness and loops. Slip-Up Handling and Transactions Note out how to invent Handle-SQL lex scripta «statute law» that includes slip-up handling. Learn about the concept of a matter and how to put into effect crystal-clear transactions in Handle-SQL lex scripta «statute law». Recommended Resources & Next Steps Take this break to learn more about Handle-SQL, at your own figure. Learn 00 | Course Introduction 01 | Introduction to Handle-SQL 02 | Querying Tables with SPECIAL 03 | Querying Multiple Tables with Joins 04 | Using Set Operators 05 | Using Functions and Aggregating Evidence 06 | Using Subqueries and PUT TO USE 07 | Using Columnar List Expressions 08 | Grouping Sets and Pivoting Evidence 09 | Modifying Evidence 10 | Programming with Handle-SQL 11 | Slip-Up Handling and Transactions Recommended Resources & Next Steps Prerequisites None Even So requirements, modules, assessments and points for this course: 7 hours* 13 modules 11 assessment *Excluding labs, adeptness checks and assessments