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.
Objectifs :
S'inscrire à une session ou téléphoner au 05 57 19 07 60.
Writing Queries Using Microsoft® SQL
Server™ 2005 Transact-SQL
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.
• 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
Module 2: Performing Basic Queries in Microsoft SQL Server 2005
After completing this module, students will be able write basic queries.
• 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
Module 3: Grouping and Summarizing Data in Microsoft SQL Server 2005
After completing this module, students will be able to generate summary reports.
• Summarizing Data by Using Aggregate Functions
• Summarizing Grouped Data
• Ranking Grouped Data
• Creating Crosstab Queries
Lab: Grouping and Summarizing Data
• Using aggregate functions
• Summarizing grouped data
• Ranking grouped data
• Pivoting data
Module 4: Joining Data from Multiple Tables in Microsoft SQL Server 2005
After completing this module, students will be able to write
joins and combine result sets.
• Querying Multiple Tables by Using Joins
• Applying Joins for Typical Reporting Needs
• Combining and Limiting Result Sets
Lab: Joining Data from Multiple Tables
• Joining data from multiple tables
• Combining result sets from multiple queries
Module 5: Working with Subqueries in Microsoft SQL Server 2005
After completing this module, students will be able to write
subqueries.
Lessons
• Writing Basic Subqueries
• Writing Correlated Subqueries
• Comparing Subqueries with Joins and Temporary Tables
• Using Common Table Expressions
Lab: Working with Subqueries
• Performing subqueries
• Using temporary tables
• Using Common Table Expressions
Module 6: Modifying Data in Microsoft SQL Server 2005
After completing this module, students will be able to modify
data.
• Overview of Transactions
• Inserting Data into Tables
• Deleting Data from Tables
• Updating Data in Tables
Lab: Modifying Data in Tables
• Inserting data
• Deleting data
• Updating data
Module 7: Querying Metadata, XML, and Full-Text Indexes in Microsoft SQL Server 2005
After completing this module, students will be able to query
semi-structured and unstructured data.
• Querying Metadata
• Overview of XML
• Querying XML Data
• Overview of Full-Text Indexes
• Querying Full-Text Indexes Implementing Message
Transport
Lab: Querying Metadata, XML, and Full-Text Indexes
• Querying metadata
• Querying XML data
• Query Full-Text indexes
Module 8: Using Programming Objects for Data Retrieval in Microsoft SQL Server 2005
After completing this module, students will be able to use
programming objects.
• Encapsulating Expressions by Using User-Defined
Functions
• Encapsulating Queries by Using Views
• Overview of Stored Procedures
• Writing Distributed Queries
Lab: Using Programming Objects for Data Retrieval in Microsoft SQL Server
2005
• Using User-Defined Functions
• Using Views
• Querying distributed data
Module 9: Using Advanced Querying Techniques in Microsoft SQL Server 2005
After completing this module, students will be able to apply
advanced querying techniques to solve complex reporting
requirements.
• Recommendations for Querying Complex Data
• Querying Complex Table Structures
• Writing Efficient Queries
• Explain the recommendations for querying complex data.
• Using Different Techniques When Working with Complex
Queries
• Maintaining Query Files
Lab: Using Advanced Querying Techniques
• Writing efficient queries
• Solving complex reporting requirements
© 2010-2011 Formatic. Tous droits réservés