|
Provided by: 123-CBT Computer Based Training Oracle9i SQL Basic SELECT Statements |
 |
Training
Provided by 123-CBT Computer Based Training
This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database.
o Match the structural elements of a relational database table with their descriptions.
o Sequence the phases of the system development life cycle.
o Match the types of SQL statements with their descriptions.
o Match the capabilities of SQL SELECT statements with their functions.
o Identify the guidelines for constructing basic SQL SELECT statement.
o Write a query that restricts rows returned by using the WHERE clause.
o Write a WHERE clause to accommodate different datatypes.
o Use comparison operators with the WHERE clause.
o Identify the different categories of datatypes.
o Match the character datatypes with their descriptions.
o Identify the features of the NUMBER datatype.
o Identify the components of the relational model.
o Match the structural elements of a relational database table with their descriptions.
o Sequence the phases of the system development life cycle.
o Identify the three components of an entity relationship model.
o Match the entity relationship model components with their conventions.
o Match the components of Oracle9i with their functions.
o Identify the tools and languages used to communicate with the Oracle server.
o Match the services provided by Oracle9iAS with their functions.
o Match the tools in Oracle9iDS with their functions.
o Identify the features of Oracle9i.
o Identify the features of Oracle9i Database.
o Match the components of Oracle Internet Platform with their features.
o Identify the benefits of the Entity Relationship (ER) model.
Unit 2: Writing Basic SQL Statements 1 - 2 hours
o Match the capabilities of SQL SELECT st
Learn To:
o Identify the components of the relational model.o Match the structural elements of a relational database table with their descriptions.
o Sequence the phases of the system development life cycle.
o Match the types of SQL statements with their descriptions.
o Match the capabilities of SQL SELECT statements with their functions.
o Identify the guidelines for constructing basic SQL SELECT statement.
o Write a query that restricts rows returned by using the WHERE clause.
o Write a WHERE clause to accommodate different datatypes.
o Use comparison operators with the WHERE clause.
o Identify the different categories of datatypes.
o Match the character datatypes with their descriptions.
o Identify the features of the NUMBER datatype.
Audience
The target audience for this course includes database administrators and application developers. This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007.Deployment Options
Internet / Intranet, Download, LAN, WorkstationAccreditation
NASBA credits: 4 CPE CreditsLanguage Options
American English, Brazilian Portuguese, SpanishTotal Learning Time
6 to 8 hours61130 Objectives
Unit 1: Relational Database Concepts 1 - 2 hourso Identify the components of the relational model.
o Match the structural elements of a relational database table with their descriptions.
o Sequence the phases of the system development life cycle.
o Identify the three components of an entity relationship model.
o Match the entity relationship model components with their conventions.
o Match the components of Oracle9i with their functions.
o Identify the tools and languages used to communicate with the Oracle server.
o Match the services provided by Oracle9iAS with their functions.
o Match the tools in Oracle9iDS with their functions.
o Identify the features of Oracle9i.
o Identify the features of Oracle9i Database.
o Match the components of Oracle Internet Platform with their features.
o Identify the benefits of the Entity Relationship (ER) model.
Unit 2: Writing Basic SQL Statements 1 - 2 hours
o Match the capabilities of SQL SELECT st
|
|
||||||||||
Oracle9i SQL Basic SELECT Statements
--
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
-...
