MS2778

Ladda ner som PDF

Writing Queries Using Microsoft SQL Server Transact-SQL

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.

 This course can be paid with SA Vouchers  SA Voucher

Audience:

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Objectives:

  • Get started with databases and Transact-SQL.
  • Perform basic queries.
  • Group and summarize data.
  • Join data from multiple tables.
  • Work with subqueries.
  • Modify data.
  • Query metadata, XML, and full-text indexes.
  • Use programming objects for data retrieval.
  • Use advanced querying techniques.

Course Outline:

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

Module 2: Querying and Filtering Data 

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

Module 3: Grouping and Summarizing Data 

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

Module 4: Joining Data from Multiple Tables 

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

Module 5: Working with Subqueries 

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

Module 6: Modifying Data in Tables 

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

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

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

Module 9: Using Advanced Querying Techniques 

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

Förkunskaper

Before attending this course, students must have:

  • Knowledge of data integrity concepts.
  • Core Windows Server skills.
  • Relational database design skills.
  • Programming skills.

Kursmaterial

Microsofts officiella elektroniska kursmaterial på engelska ingår.

Utbildningen levereras i samarbete med

Kurs-ID: MS2778
Längd: 3 dagar
Kan betalas med:
TRAINING CARD

Lämna dina kontaktuppgifter om du önskar en företagsintern utbildning.