Lösenord:


 
 

MS2778B

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

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

This training can be paid by SA-Voucher

Audience:

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

Objectives:

• 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.

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 Set

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

Fakta

Just nu finns det inga kurstillfällen. Kontakta oss för mer information.

• ›
  Spara i mina sidor

Förkunskaper

Before attending this course, students must have: •Knowledge of data integrity concepts. •Core Windows Server skills. •Relational database design skills. •Programming skills.

Kursmaterial

Microsofts officiella kursmaterial på engelska ingår.

I samarbete med:

• ›
  Skriv ut denna sida
• ›
  Tipsa en kompis

Kontakta oss
för mer information:

08 - 587 116 10 (Stockholm)
031 - 773 07 90 (Göteborg)
040-662 20 60 (Malmö)
info@informator.se