Microsoft SQL Server 2008: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Course 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

Microsoft are a leading software company, this SQL Server course will improve your career prospects and enhance your professional life.

Related Courses

• Microsoft SQL Server 2008 New Features: Hands-On
• Microsoft SQL Server 2008 Comprehensive Introduction: Hands-On
• Microsoft SQL Server 2008: Database Administration
• Microsoft SQL Server 2008 Training Course UK: Comprehensive DBA & Programming Upgrade
• Microsoft SQL Server 2008 Analysis & Integration Services (SSAS & SSIS) - (Business Intelligence, BI, Data Warehouse, Mining)
• Microsoft SQL Server 2008 Reporting Services (SSRS) - (Business Intelligence, BI)
• Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 - (Microsoft, BI, SSRS, SSAS, SSIS, Data Warehouse, Mining)
• Microsoft SQL Server 2008: Maintaining a Microsoft SQL Server 2008 Database
• Microsoft SQL Server 2008 Reporting Services: Hands-On
• Microsoft SQL Server 2008: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Examinations

• Microsoft® >>

• MCITP Microsoft Certified IT Professional >>
• MCSE Microsoft Certified Systems Engineer >>

• Microsoft SQL Server >>
• Microsoft Certified IT Professional: Applications for Microsoft Dynamics CRM 4.0 >>
• Microsoft Certified IT Professional: Installation and Deployment for Microsoft Dynamics CRM 4.0 >>
• MCSE on Windows Server 2003 >>

• Exam 70-432 MCITP: Database Administrator 2008 >>
• Exam 70-433 MCITP: Database Developer 2008 >>
• Exam 70-432 Microsoft SQL Server 2008 - Implementation and Maintenance >>
• Exam 70-432 Microsoft SQL Server 2008, Implementation and Maintenance >>
• Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance >>

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