| Oracle SQL Fundamentals |
| |
| This hands-on course provides the basic knowledge and skills necessary to code SQL statements. Students will receive a hands-on introduction to SQL basics and SQL*Plus. The course also includes some relational database management system (RDBMS) concepts and terminology. |
|
| Covered Topics: |
- Database Management System Overview
- What is a database?
- Types of DBMSs
- What is a Data Model?
- Reading an Entity Relationship Diagram
- Relational Database Management System Overview
- What is a RDBMS?
- What is SQL? SQL*Plus? PL/SQL?
- Difference between DDL, DML and DCL statements
- SELECT statement and mandatory clauses
- WHERE and ORDER BY clauses
- Single row functions
- Group functions
- GROUP BY and HAVING clauses
- Joining data from multiple tables
- Subqueries and set operators
- SQL*Plus Reporting
- Data Manipulation Language (DML) statements
- Transaction control
|
| Prerequisites: |
- An understanding of relational database design concepts.
|
| Audience: |
| Anyone retrieving data from an Oracle database using SQL |
|
| |
| Course Benefits: |
| Students will understand relational database terminology, understand and code Oracle SQL statements and format reports using SQL*Plus statements. They will also be able to perform data maintenance using the insert, update and delete statements. |
| Materials Furnished: |
|
| Recommended Follow-On Course: |
- Oracle 9i Advanced SQL
- Oracle 9i PL/SQL Fundamentals
- Oracle 9i Performance Tuning for Developers
|
|
|
|
|
|