|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 - Implementing a Database - Part 3 |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
Learn To:
- Query multiple tables using Transact-SQL statements.
- Retrieve and modify data using advanced query techniques.
Content Emphasis
Skills-Based
Audience
This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first two courses in this series.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Querying Multiple Tables
Duration: 3 - 4 Hour(s)- Select the primary properties of a SELECT statement.
- Select the uses for a join.
- Perform the steps to combine tables.
- Perform the steps to combine table data.
- Select the statement that combines table data.
- Perform the steps to combine data from more than two tables.
- Select the statement that joins a table to itself.
- Identify the characteristics of the UNION operator.
- Perform the steps to create a single result set from multiple queries.
- Identify the characteristics of the SELECT INTO statement.
- Perform the steps to create a temporary table.
Unit 2: Advanced Query Techniques
Duration: 3 - 4 Hour(s)- Select the guidelines for using subqueries.
- Perform the steps to return a single value of data.
- Perform the steps to return a list of values.
- Select the characteristics of a correlated subquery.
- Sequence the steps to process a correlated subquery.
- Sequence the steps to complete a correlated subquery.
- Sequence the steps in which the SQL Server processes EXISTS and NOT EXISTS subqueries.
- Perform the steps to add rows to a table.
- Perform the steps to delete rows from a table.
- Perform the steps to remove rows based on other tables.
- Perform the steps to update rows.
- Select the benefits of cursors.
- Select the methods for requesting a cursor.
- Select the uses of Transact-SQL cursors.
- Sequence the steps of the Transact-SQL cursor procedure.
- Match the types of cursors with their descriptions.
- Match the cursor characteristic with its description.
- Match the cursor syntax with its function.
- Identify the characteristics of a local cursor.
- Match the cursor system stored procedure with its description.
- Select the use of CURSOR_STATUS function.
- Select the most commonly used global variables.
|
|
||||||||||
SQL Server 7 0 - Implementing a Database - Part 3
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
