Collection 2778: Writing Queries Using Microsoft® SQL Server? 2005 Transact-SQL£189.99
Description
With this collection of nine 2-hour courses, you will write Transact-SQL (T-SQL) queries by using Microsoft SQL Server 2005.
This collection also helps prepare you for certification exam 70-431.
Audience: IT Pro
Available Offline: Yes
Subscription: 12 months
This 18-hour, 9-course online collection is comprised of a rich multimedia experience coupled with comprehensive technical labs.
This collection introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources.
This collection is intended for IT Professionals who must access and manipulate data in SQL Server 2005 databases and other data sources.
After completing this collection, you 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.
To get the most out of this collection, you should:
• Be familiar with a programming or scripting language.
• Understand relational databases and the concept of data normalization
This collection also helps prepare you for certification exam 70-431.
This offer includes the following:
E-Learning
Course 4326: Getting Started with Databases and Transact-SQL in Microsoft® SQL ServerTM 2005
Course 4327: Performing Basic Queries in Microsoft® SQL ServerTM 2005
Course 4328: Grouping and Summarizing Data in Microsoft® SQL ServerTM 2005
Course 4329: Joining Data from Multiple Tables in Microsoft® SQL ServerTM 2005
Course 4330: Working with Subqueries in Microsoft® SQL ServerTM 2005
Course 4331: Modifying Data in Microsoft® SQL ServerTM 2005
Course 4332: Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL ServerTM 2005
Course 4333: Using Programming Objects for Data Retrieval in Microsoft® SQL ServerTM 2005
Course 4334: Using Advanced Querying Techniques in Microsoft® SQL ServerTM 2005
Course Objectives
With this collection of nine 2-hour courses, you will write Transact-SQL (T-SQL) queries by using Microsoft SQL Server 2005.
This collection also helps prepare you for certification exam 70-431.
Audience: IT Pro
Available Offline: Yes
Subscription: 12 months
This 18-hour, 9-course online collection is comprised of a rich multimedia experience coupled with comprehensive technical labs.
This collection introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources.
This collection is intended for IT Professionals who must access and manipulate data in SQL Server 2005 databases and other data sources.
After completing this collection, you 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.
To get the most out of this collection, you should:
• Be familiar with a programming or scripting language.
• Understand relational databases and the concept of data normalization
This collection also helps prepare you for certification exam 70-431.
This offer includes the following:
E-Learning
Course 4326: Getting Started with Databases and Transact-SQL in Microsoft® SQL ServerTM 2005
Course 4327: Performing Basic Queries in Microsoft® SQL ServerTM 2005
Course 4328: Grouping and Summarizing Data in Microsoft® SQL ServerTM 2005
Course 4329: Joining Data from Multiple Tables in Microsoft® SQL ServerTM 2005
Course 4330: Working with Subqueries in Microsoft® SQL ServerTM 2005
Course 4331: Modifying Data in Microsoft® SQL ServerTM 2005
Course 4332: Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL ServerTM 2005
Course 4333: Using Programming Objects for Data Retrieval in Microsoft® SQL ServerTM 2005
Course 4334: Using Advanced Querying Techniques in Microsoft® SQL ServerTM 2005
Technical Requirements
With this collection of nine 2-hour courses, you will write Transact-SQL (T-SQL) queries by using Microsoft SQL Server 2005.
This collection also helps prepare you for certification exam 70-431.
Audience: IT Pro
Available Offline: Yes
Subscription: 12 months
This 18-hour, 9-course online collection is comprised of a rich multimedia experience coupled with comprehensive technical labs.
This collection introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources.
This collection is intended for IT Professionals who must access and manipulate data in SQL Server 2005 databases and other data sources.
After completing this collection, you 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.
To get the most out of this collection, you should:
• Be familiar with a programming or scripting language.
• Understand relational databases and the concept of data normalization
This collection also helps prepare you for certification exam 70-431.
This offer includes the following:
E-Learning
Course 4326: Getting Started with Databases and Transact-SQL in Microsoft® SQL ServerTM 2005
Course 4327: Performing Basic Queries in Microsoft® SQL ServerTM 2005
Course 4328: Grouping and Summarizing Data in Microsoft® SQL ServerTM 2005
Course 4329: Joining Data from Multiple Tables in Microsoft® SQL ServerTM 2005
Course 4330: Working with Subqueries in Microsoft® SQL ServerTM 2005
Course 4331: Modifying Data in Microsoft® SQL ServerTM 2005
Course 4332: Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL ServerTM 2005
Course 4333: Using Programming Objects for Data Retrieval in Microsoft® SQL ServerTM 2005
Course 4334: Using Advanced Querying Techniques in Microsoft® SQL ServerTM 2005
Accessibility Requirements
With this collection of nine 2-hour courses, you will write Transact-SQL (T-SQL) queries by using Microsoft SQL Server 2005.
This collection also helps prepare you for certification exam 70-431.
Audience: IT Pro
Available Offline: Yes
Subscription: 12 months
This 18-hour, 9-course online collection is comprised of a rich multimedia experience coupled with comprehensive technical labs.
This collection introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources.
This collection is intended for IT Professionals who must access and manipulate data in SQL Server 2005 databases and other data sources.
After completing this collection, you 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.
To get the most out of this collection, you should:
• Be familiar with a programming or scripting language.
• Understand relational databases and the concept of data normalization
This collection also helps prepare you for certification exam 70-431.
This offer includes the following:
E-Learning
Course 4326: Getting Started with Databases and Transact-SQL in Microsoft® SQL ServerTM 2005
Course 4327: Performing Basic Queries in Microsoft® SQL ServerTM 2005
Course 4328: Grouping and Summarizing Data in Microsoft® SQL ServerTM 2005
Course 4329: Joining Data from Multiple Tables in Microsoft® SQL ServerTM 2005
Course 4330: Working with Subqueries in Microsoft® SQL ServerTM 2005
Course 4331: Modifying Data in Microsoft® SQL ServerTM 2005
Course 4332: Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL ServerTM 2005
Course 4333: Using Programming Objects for Data Retrieval in Microsoft® SQL ServerTM 2005
Course 4334: Using Advanced Querying Techniques in Microsoft® SQL ServerTM 2005
You may also be interested in...
Clinic 6258: New Features Of Microsoft SQL Server 2008 Reporting Services£19.99
Clinic 6448: Understanding the Differences Between Microsoft® SQL Server 2005 Standard and Enterprise Editions£19.99
Course 2936: Installing and Securing Microsoft® SQL Server? 2005£89.99
