The purchase of this item grants unlimited use for the named user to these modules for up to 60 days.
Audience
Instructors and students taking the Oracle SQL courses of versions 10g or 11g
Objectives - Module 1
This mini-lesson introduces you to the subject of database technologies. Among the questions to which you will find answers in this course are:
• What is a database model?
• Which database products are based upon which models?
• What current database technologies should I focus on?
• What is the role of a database within an organization's IT architecture?
• What should I learn next?
Objectives - Module 2
This mini-lesson introduces you to the subject of relational database concepts. These are among the topics you will learn and the questions to which you will find answers:
• What is the role of a table in a relational database?
• How are columns used as part of the logical design of a database?
• What types of relationships exist within a database, and how are they used?
• Review what you have learned and test your knowledge by means of a quiz
How to use e-Learning Modules?
These modules may be used (1) as part of a distance learning presentation, or (2) as a blended-learning solution, or (3) to enhance instructor-led training.
(1) Enhanced Instructor-Led Training Integrate our e-Learning modules into your instructor-led presentations and improve the learning experience for your students. Distinguish your instructor-led courses from the traditional training model.
(2) Distance Learning Use low-cost web-based services to deliver distance-learning training sessions. Eliminate travel expense while retaining the best elements of live training. The finest print courseware guides combined with on-line interactive e-Learning modules makes distance-learning more effective than ever.
(3) Blended-learning There is no substitute for a subject matter expert serving as an instructor and trainer. But with our e-Learning solutions, you may develop a blended-learning solution: our interactive e-Learning modules together with your instructor presentations. Consider some possibilities:
• Pre-course preparations – Deploy selected e-Learning modules before the live course. Minimize the time spent in formal training sessions with the instructor.
• Post-course assessment – Use the built-in quiz modules to assess the success of the training sessions.
• Long-term review – Deploy e-Learning after the course as long-term reference and refresher for the students.
• In-class supplemental – Utilize other modules within the actual presentation, supplementing the standard e-Learning content provided with customized instructor-led content focused on the audience and organization you are training.
Module 1 Contents - About Database Technologies (18 minutes)
Database Models
• DBMS Data Model
• Legacy Data Models
• Current Data Models
The Relational Model
• RDBMS-based applications
• Relational Database Language SQL
Module 2 Contents - Introduction to Database Technologies (30 minutes)
Tables
• Identifying the Tables
• Table Objects
• Naming the Tables
• Tables Terminology
• Columns Within the Table Structure
• About Rows
• Using Tables
• Accessing Table Data
Columns • About Column Data Types • List Column Details • Common Data Types • Foreign Key & Primary Key Columns • Using the Key Columns
