|
Provided by: 123-CBT Computer Based Training Oracle9i SQL Basic SELECT Statements |
 |
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.
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, Workstation
Accreditation NASBA credits: 4 CPE Credits
Language Options American English, Brazilian Portuguese, Spanish
Total Learning Time 6 to 8 hours
61130 Objectives Unit 1: Relational Database Concepts 1 - 2 hours
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, Workstation
Accreditation NASBA credits: 4 CPE Credits
Language Options American English, Brazilian Portuguese, Spanish
Total Learning Time 6 to 8 hours
61130 Objectives Unit 1: Relational Database Concepts 1 - 2 hours
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
|
|
||||||||
Training
Provided by 123-CBT Computer Based Training
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
-...
