Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
3 Days
This three-day instructor-led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008
Facilities
Location
Start date
Start date
About this course
Before attending this course, students must have: Knowledge of data integrity concepts Core Windows Server Skills Relational database design skills Programming Skills
Reviews
Course programme
Overview
This three-day instructor-led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008
Examination information
Prerequisites
Before attending this course, students must have:
Knowledge of data integrity concepts
Core Windows Server Skills
Relational database design skills
Programming Skills
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 Sets
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
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL