Description: SQL Server 2016 offers various database programmable objects, such as stored procedures and functions, used to enhance and increase your database performance as well as ease administrative workload. This course will demonstrate how to implement various database programmability objects, as well as how to work with temporal and non-relational data in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 01:57
Description: Set operators in SQL Server 2016 are used to compare rows between input sets. This course covers the UNION, INTERSECT, and EXCEPT set operators, as well as the APPLY operator, which is used to evaluate rows in one input set against the expression defining the second input set. This course also introduces the basic components of common table expressions. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 01:35
Description: Subqueries in SQL Server 2016 are nested SELECT statements used to created more effective queries in T-SQL. This course will introduce subqueries and correlated subqueries, and cover the EXISTS predicate, a mechanism used in SQL Server 2016 to check whether any results will be returned from a specific query. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 01:36
Description: Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. This course will cover various types of aggregate functions such as SUM, MIN, MAX, AVG, and COUNT, as well as the GROUP BY clause, which is used to arrange your data into subsets before summarizing it. Lastly, this course will demonstrate how to change a table-valued expression into another table using the PIVOT and UNPIVOT operators. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 02:20
Description: SQL Server 2016 offers various built-in functions that provide data type conversion, comparison, and NULL handling. This course covers the various types of built-in functions, as well as demonstrates how to write queries using built-in functions. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 01:36
Description: SQL Server 2016 offers various clauses that work in conjunction with SELECT statements. These clauses, which include ORDER BY, TOP, OFFSET, and FETCH, determine how the results of a particular query are presented. In addition to clauses, the data manipulation language (DML) will be introduced in this course. The DML contains additional commands to modify data within rows and tables in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 02:21
Description: SELECT statements in SQL Server 2016 are used to query tables and views. Further, you can manipulate data using SELECT statements to customize the returned results. This course focuses on the fundamentals of using SELECT statements, including how to use aliases and case expressions, as well as the DISTINCT clause. Lastly, this course covers how to query multiple tables using joins. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 02:14
Description: SQL Server 2016 delivers many new features and enhancements. This course provides an overview of the SQL Server 2016 architecture, as well as the functions and capabilities available in each edition. The fundamentals of T-SQL querying is covered in this course, as well as topics such as sets and predicate logic. This course is one of a series of SkillSoft courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Target Audience: Database administrators, database developers, and BI professionals
Duration: 02:09