disciop.blogg.se

Writing Queries that use Multiple-Table Inner Joins.

Querying with Cross Joins and Self Joins.This module describes how to write queries that combine data from multiple sources in Microsoft SQL Server. This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table. Executing Queries That Sort Data Using ORDER BY. Executing Queries that Filter Data using Predicates. Understanding the Logical Order of Operations in SELECT statements.Describe the logical order of operations in SELECT statements. Describe the use of predicate logic in SQL Server. This module describes the elements of T-SQL and their role in writing queries. Module 2: Introduction to T-SQL Querying.

Working with SQL Server Management Studio.