2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
- Course Categorization:
- Microsoft,
- Databases,
- Course Provider:
- New Horizons Computer Learning Centers
- Learning Method:
- Classroom Learning
Lesson 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
Lesson 2: Querying and Filtering Data
- Using the SELECT Statement
- Filtering Data
- Working with NULL Values
- Formatting Result Sets
- Performance Considerations for Writing Queries
Lesson 3: Grouping and Summarizing Data
- Summarizing Data by Using Aggregate Functions
- Summarizing Grouped Data
- Ranking Grouped Data
- Creating Crosstab Queries
Lesson 4: Joining Data from Multiple Tables
- Querying Multiple Tables by Using Joins
- Applying Joins for Typical Reporting Needs
- Combining and Limiting Result Set
Lesson 5: Working with Subqueries
- Writing Basic Subqueries
- Writing Correlated Subqueries
- Comparing Subqueries with Joins and Temporary Tables
- Using Common Table Expressions
Lesson 6: Modifying Data in Tables
- Inserting Data into Tables
- Deleting Data from Tables
- Updating Data in Tables
- Overview of Transactions
Lesson 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
Lesson 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
Lesson 9: Using Advanced Querying Techniques
- Considerations for Querying Data
- Working with Data Types
- Cursors and Set-Based Queries
- Dynamic SQL
- Maintaining Query Files
- Chattanooga, TN - April 25, 2012
- Pittston, PA - April 30, 2012
- Anaheim, CA - May 2, 2012
- West Valley City, UT - May 2, 2012
- Washington, DC - May 7, 2012
- Bethlehem, PA - May 9, 2012
- Tampa, FL - May 14, 2012
- Charleston, SC - May 14, 2012
- Columbia, SC - May 14, 2012
- Greenville, SC - May 14, 2012
- Charleston, WV - May 14, 2012
- Nashville, TN - May 29, 2012
- Las Vegas, NV - May 29, 2012
- Sacramento, CA - May 29, 2012
- Reno, NV - May 29, 2012
- Carmel, IN - May 29, 2012
- Orlando, FL - May 30, 2012
- Urbandale, IA - June 4, 2012
- Atlanta, GA - June 6, 2012
- Richmond, VA - June 6, 2012
- Mechanicsburg, PA - June 6, 2012
- Charleston, SC - June 20, 2012
- Columbia, SC - June 20, 2012
- Greenville, SC - June 20, 2012
- Charleston, WV - June 20, 2012
- Anaheim, CA - June 25, 2012
- Jacksonville, FL - July 2, 2012
- Mechanicsburg, PA - July 11, 2012
- Urbandale, IA - July 11, 2012
- Burbank, CA - July 16, 2012
People Also Registered For
SQL Querying - Level 1 Fundamentals of Querying
In this course, students will compose SQL queries to retrieve desired information from a database.
SQL Querying - Level 2 Advanced Querying
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
Related Courses
10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2
This course focuses on the new features SQL Server 2008 R2 for BI specialists.
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008
This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
2778 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.
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
This course teaches how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use...
6231 Maintaining a Microsoft SQL Server 2008 R2 Database
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...
6232 Implementing a Microsoft SQL Server 2008 R2 Database
This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best...
6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis...
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...
