Módulos do Curso

• Modulo 1

  Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008

  • »Overview of SQL Server 2008
  • »Overview of SQL Server Databases
  • »Overview and Syntax Elements of T-SQL
  • »Working with T-SQL Scripts
  • »Using T-SQL Querying Tools

   
• Modulo 2

  Module 2: Querying and Filtering Data

  • »Using the SELECT Statement
  • »Filtering Data
  • »Working with NULL Values
  • »Formatting Result Sets
  • »Performance Considerations for Writing Queries

   
• Modulo 3

  Module 3: Grouping and Summarizing Data

  • »Summarizing Data by Using Aggregate Functions
  • »Summarizing Grouped Data
  • »Ranking Grouped Data
  • »Creating Crosstab Queries

   
• Modulo 4

  Module 4: Joining Data from Multiple Tables

  • »Querying Multiple Tables by Using Joins
  • »Applying Joins for Typical Reporting Needs
  • »Combining and Limiting Result Set

   
• Modulo 5

  Module 5: Working with Subqueries

  • »Writing Basic Subqueries
  • »Writing Correlated Subqueries
  • »Comparing Subqueries with Joins and Temporary Tables
  • »Using Common Table Expressions

   
• Modulo 6

  Module 6: Modifying Data in Tables

  • »Inserting Data into Tables
  • »Deleting Data from Tables
  • »Updating Data in Tables
  • »Overview of Transactions

   
• Modulo 7

  Module 7: Querying Metadata, XML, and Full-Text Indexes

  • »Querying Metadata
  • »Overview of XML
  • »Querying XML Data
  • »Overview of Full-Text Indexes
  • »Querying Full-Text Indexes

   
• Modulo 8

  Module 8: Using Programming Objects for Data Retrieval

  • »Overview of Views
  • »Overview of User-Defined Functions
  • »Overview of Stored Procedures
  • »Overview of Triggers
  • »Writing Distributed Queries

   
• Modulo 9

  Module 9: Using Advanced Querying Techniques

  • »Considerations for Querying Data
  • »Working with Data Types
  • »Cursors and Set-Based Queries
  • »Dynamic SQL
  • »Maintaining Query Files