MOC 2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This Transact-SQL training class provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
This Transact-SQL class is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
- Learn to describe the uses of and ways to execute the Transact-SQL language.
- Learn to use querying tool.
- Learn to write SELECT queries to retrieve data.
- Learn to group and summarize data by using Transact-SQL.
- Learn to join data from multiple tables.
- Learn to write queries that retrieve and modify data by using subqueries.
- Learn to modify data in tables.
- Learn to query text fields with full-text search.
- Learn to describe how to create programming objects.
- Learn to use various techniques when working with complex queries.
- 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
- Lab: Using SQL Server Management Studio and SQLCMD
- Querying and Filtering Data
- Using the SELECT Statement
- Filtering Data
- Working with NULL Values
- Formatting Result Sets
- Performance Considerations for Writing Queries
- Lab: Querying and Filtering Data
- Grouping and Summarizing Data
- Summarizing Data by Using Aggregate Functions
- Summarizing Grouped Data
- Ranking Grouped Data
- Creating Crosstab Queries
- Lab: Grouping and Summarizing Data
- Joining Data from Multiple Tables
- Querying Multiple Tables by Using Joins
- Applying Joins for Typical Reporting Needs
- Combining and Limiting Result Set
- Lab: Joining Data from Multiple Tables
- Working with Subqueries
- Writing Basic Subqueries
- Writing Correlated Subqueries
- Comparing Subqueries with Joins and Temporary Tables
- Using Common Table Expressions
- Lab: Working with Subqueries
- Modifying Data in Tables
- Inserting Data into Tables
- Deleting Data from Tables
- Updating Data in Tables
- Overview of Transactions
- Lab: Modifying Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
- Querying Metadata
- Overview of XML
- Querying XML Data
- Overview of Full-Text Indexes
- Querying Full-Text Indexes
- Lab: Querying Metadata, XML, and Full-Text Indexes
- Using Programming Objects for Data Retrieval
- Overview of Views
- Overview of User-Defined Functions
- Overview of Stored Procedures
- Overview of Triggers
- Writing Distributed Queries
- Lab: Using Programming Objects for Data Retrieval
- Using Advanced Querying Techniques
- Considerations for Querying Data
- Working with Data Types
- Cursors and Set-Based Queries
- Dynamic SQL
- Maintaining Query Files
- Lab: Using Advanced Querying Techniques
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this SQL Server class:
Preparing for Class
- Knowledge of data integrity concepts.
- Core Windows Server skills.
- Relational database design skills.
- Programming skills.