Querying Microsoft SQL Server 2012_Parte_01

Querying Microsoft SQL Server 2012_Parte_01

1. Módulo 1: Introdução ao Microsoft SQL Server 2014

   • Lições
     • A arquitetura básica do SQL Server
     • As versões e edições do SQL Server
     • Começando com o SQL Server Management Studio
   • Laboratório: Trabalhando com ferramentas de SQL Server 2014
     • Trabalhando com o SQL Server Management Studio
     • Criando e organizando T-SQL scripts
     • Usando livros on-line

2. Módulo 2: Introdução de consulta T-SQL

   • Lições
     • Introdução de T-SQL
     • Understanding Sets
     • Understanding Predicate Logic
     • Understanding the Logical Order of Operations in SELECT statements
   • Lab : Introduction to Transact-SQL Querying
     • Executing Basic SELECT Statements
     • Executing queries which filter data using predicates
     • Executing queries which sort data using ORDER BY

3. Module 3: Writing SELECT Queries

   • Lições
     • Writing Simple SELECT Statements
     • Eliminating Duplicates with DISTINCT
     • Using Column and Table Aliases
     • Writing Simple CASE Expressions
   • Lab : Writing Basic SELECT Statements
     • Write simple SELECT Statements
     • Eliminate Duplicates Using Distinct
     • Use Table and Column Aliases
     • Use a Simple CASE Expression

4. Module 4: Querying Multiple Tables

   • Lição
     • Understanding Joins
     • Querying with Inner Joins
     • Querying with Outer Joins
     • Querying with Cross Joins and Self Joins
   • Lab : Querying Multiple Tables
     • Writing Queries That Use Inner Joins
     • Writing Queries That Use Multiple-Table Inner Join
     • Writing Queries That Use Self Joins
     • Writing Queries That Use Outer Joins
     • Writing Queries That Use Cross Joins

5. Module 5: Sorting and Filtering Data

   • Lição
     • Sorting Data
     • Filtering Data with a WHERE Clause
     • Filtering with the TOP and OFFSET-FETCH Options
     • Working with Unknown and Missing Values
   • Lab : Sorting and Filtering Data
     • Writing Queries That Filter Data Using a WHERE Clause
     • Writing Queries That Filter Data Using an ORDER BY Clause
     • Writing Queries That Filter Data Using the TOP Option
     • Writing Queries That Filter Data Using the OFFSET-FETCH Clause

6. Module 6: Working with SQL Server 2014 Data Types

   • Lição
     • Introducing SQL Server 2014 Data Types
     • Working with Character Data
     • Working with Date and Time Data
   • Lab : Working with SQL Server 2014 Data Types
     • Writing Queries That Return Date and Time Data
     • Writing Queries That Use Date and Time Functions
     • Writing Queries That Return Character Data
     • Writing Queries That Use Character Functions

7. Module 7: Using DML to Modify Data

   • Lições
     • Inserting Data
     • Modifying and Deleting Data
   • Lab : Using DML to Modify Data
     • Inserting Data
     • Updating and Deleting Data

8. Module 8: Using Built-In Functions

   • Lições
     • Writing Queries with Built-In Functions
     • Using Conversion Functions
     • Using Logical Functions
     • Using Functions to Work with NULL
   • Lab : Using Built-In Functions
     • Write queries which use conversion functions
     • Write queries which use logical functions
     • Write queries which test for nullability

9. Module 9: Grouping and Aggregating Data

   • Lições
     • Using Aggregate Functions
     • Using the GROUP BY Clause
     • Filtering Groups with HAVING
   • Lab : Grouping and Aggregating Data
     • Write queries which use the GROUP BY clause
     • Write queries which use aggregate functions
     • Write queries which use distinct aggregate functions
     • Write queries which filter groups with the HAVING clause

10. Module 10: Using Subqueries

    • Lições
      • Writing Self-Contained Subqueries
      • Writing Correlated Subqueries
      • Using the EXISTS Predicate with Subqueries
    • Lab : Using Subqueries
      • Write queries which use self-contained subqueries
      • Write queries which use scalar and multi-result subqueries
      • Write queries which use correlated subqueries and EXISTS predicate

11. Module 11: Using Table Expressions

    • Lições
      • Using Derived Tables
      • Using Common Table Expressions
      • Using Views
      • Using Inline Table-Valued Functions
    • Lab : Using Table Expressions
      • Write Queries Which Use Views
      • Write Queries Which Use Derived Tables
      • Write Queries Which Use Common Table Expressions
      • Write Queries Which Use Inline Table-Valued Functions