Audience
IT Professionals, IT generalists, and Information Workers who want to learn about writing queries for Microsoft SQL Server 2005. Candidates should have at least 3 years experience working in the IT field-typically in the area of databases. No experience with SQL Server is necessary.
Skills Gained
After completing this course, students will be able to:
- 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.
Prerequisites
This course requires that students meet the following prerequisites:
- An understanding of basic relational database concepts, including:
- Logical database design.
- Physical database design.
- How data is stored in tables (rows and columns).
- Data integrity concepts.
Examinations
This course will help the student prepare for the following Microsoft Certified Professional exam:
- Exam Exam 70-431: TS: Microsoft SQL Server 2005-Implementation and Maintenance. :
Course Outline
Module 1: Getting Started with Databases and Transact-SQL in Microsoft SQL Server 2005
After completing this module, students will be able to describe the basics of the Transact-SQL language.
Lessons
- Overview of SQL Server 2005
- Overview of SQL Server Databases
- Overview of the SQL Language
- Syntax Elements of T-SQL
- Working with T-SQL Scripts
Using T-SQL Querying Tools
Lab: Getting Started with Databases and T-SQL
Using SQL Server Management Studio
After completing this module, students will be able to:
- Describe the architecture and components of SQL Server 2005.
- Describe the structure of a SQL Server database.
- Explain the basics of the SQL language.
- Describe the syntax elements of T-SQL.
- Explain how to manage T-SQL scripts.
Use T-SQL querying tools to query SQL Server 2005 databases.
Module 2: Performing Basic Queries in Microsoft SQL Server 2005
After completing this module, students will be able write basic queries.
Lessons
- Using the SELECT Statement
- Filtering Data
- Working with NULL Values
- Formatting Result Sets
Performance Considerations for Writing Queries
Lab: Performing Basic Queries
Retrieving data from tables
Formatting the result set
Using efficient search arguments
After completing this module, students will be able to:
- Retrieve data by using the SELECT statement.
- Filter data by using different search conditions.
- Explain how to work with NULL values.
- Format result sets.
Describe the performance considerations that affect data retrieval.
Module 3: Grouping and Summarizing Data in Microsoft SQL Server 2005
