Writing Queries Using Microsoft SQL Server 2008 Transact-SQL هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Course Outline

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

2 - Querying and Filtering Data

• Using the SELECT Statement
• Filtering Data
• Working with NULL Values
• Formatting Result Sets
• Performance Considerations for Writing Queries

3 - Grouping and Summarizing Data

• Summarizing Data by Using Aggregate Functions
• Summarizing Grouped Data
• Ranking Grouped Data
• Creating Crosstab Queries

4 - Joining Data from Multiple Tables

• Querying Multiple Tables by Using Joins
• Applying Joins for Typical Reporting Needs
• Combining and Limiting Result Set

5 - Working with Subqueries

• Writing Basic Subqueries
• Writing Correlated Subqueries
• Comparing Subqueries with Joins and Temporary Tables
• Using Common Table Expressions

6 - Modifying Data in Tables

• Inserting Data into Tables
• Deleting Data from Tables
• Updating Data in Tables
• Overview of Transactions

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

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

9 - Using Advanced Querying Techniques

• Considerations for Querying Data
• Working with Data Types
• Cursors and Set-Based Queries
• Dynamic SQL
• Maintaining Query Files

Target Audience: This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.