 |
|
|
|
Price: $49
|
 |
|
Course Name
|
SQL Advanced Skills
|
|
Audience
|
Application developers who want to implement a database solution using SQL.
|
|
Course Requirements
|
You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above.
Plug-in Requirements
ØMacromedia Shockwave plug-in for Windows for IE/NN
ØMacromedia Flash plug-in for Windows for IE/NN
Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.
|
|
Pre-requisites
|
Before taking this course, the user should be familiar with the features of database systems, particularly those of a relational database system, and should be able to perform queries on databases.
|
|
Course Duration
|
4.3 hours
|
|
Course Objectives
|
The SQL Advanced Skills WBT is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. Users will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions. After completing this course, the user will be able to:
- Define a relational database
- Insert new records in an existing table
- Insert records from another table
- Update and delete data from a table
- Create and modify tables
- Create and manipulate indexes
- Create views, cursors, and stored procedures
- Create and implement triggers
- Perform transactions
|
|
Course Outline
|
- Working with Existing Tables
- Adding Data to a Table
- Modifying Existing Data
- Quiz
- Creating and Modifying Tables
- Creating Tables
- Working with Indexes
- Working with Views
- Quiz
- Using Advanced Features of SQL
- Working with Cursors
- Using Stored Procedures
- Using Triggers
- Managing Transactions
- Quiz
|
|
|
