|
Course Name
|
SQL Basic Skills
|
|
Audience
|
Application developers who want to gain knowledge of how to use query languages to retrieve and manipulate data in databases.
|
|
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 concepts and features of the database systems, particularly those of a relational database system.
|
|
Course Duration
|
4.1 hours
|
|
Course Objectives
|
The SQL Basic Skills WBT is the first course in the SQL Programming curriculum that consists of two courses. This course acquaints students with SQL and discusses the techniques used for normalizing a database. It also describes various commands and clauses used to query and manipulate a database. After completing this course, the student will be able to:
- Define a relational database
- List the normalization techniques used by a database
- Retrieve rows and columns from a table
- Manipulate query results using operators and functions
- Use clauses and operators to restrict query results
- Organize query results
- Classify different types of joins
- Perform multiple queries using set operators
- Build subqueries
|
|
Course Outline
|
- SQL Concepts
- Overview of Relational Databases
- Introduction to SQL
- Quiz
- Performing Basic Queries
- Creating Simple Queries
- Restricting Query Results
- Manipulating Query Results
- Formatting Query Results
- Quiz
- Performing Complex Queries
- Using Joins and Set Operators
- Building Subqueries
- Quiz
|
