|
|||||||
|
|
|
|||||
|
|
|||||||
|
|||||||
|
|
|
|||||
|
|
|||||||
|
|
|
|
Querying SQL Server 2000 Transact-SQL – 2071
- Introduction to Transact-SQL - Using Transact-SQL Querying Tools, describes several querying tools available in Microsoft SQL Server™ and how to use them to execute Transact-SQL scripts. At the end of this module, you will be able to describe the primary Transact-SQL querying tools in SQL Server and execute Transact-SQL scripts in various ways.
- Retrieving Data, covers the SELECT statement in detail, using many examples to demonstrate how to sort data, eliminate duplicates, and change the format of a result set. At the end of this module, you will be able to use the SELECT statement to retrieve data.
- Grouping and Summarizing Data, discusses using aggregate functions to group data, and explains how to generate summary reports and list values in a result set. At the end of this module, you will be able to generate and group summary data for a table. - Joining Multiple Tables, provides information on querying multiple tables by using different types of joins, combining result sets by using the UNION operator, and creating tables by using the SELECT INTO statement. At the end of this module, you will be able to combine data and multiple result sets.
- Working with Subqueries, presents advanced query techniques, including nested and correlated subqueries, and explains when and how to use them to break down and perform complex quieries. At the end of this module, you will be able to write queries that use single-value, multiple-value, and correlated subqueries to restrict result sets and combine multiple processing steps into one SELECT statement. - Modifying Data, explains how transactions work and discusses how to write INSERT, DELETE, and UPDATE statements to modify data in tables. At the end of this module, you will be able to modify data in tables in various ways.
- Introduction to Programming Objects, discusses how to create programming objects that enable the user to look at and manipulate data while hiding the complexity of the underlying database structure. At the end of this module, you will be able to display the text of a programming object and describe the concept and advantage of using views, stored procedures, triggers, and user-defined functions. Total hour is : 20 hours
|
|
|
Send mail to: alostaz_co@gawab.com
with questions or comments about this web site.
|
