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.

Topics Covered

  • 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

Audience:

     Anyone retrieving data from an Oracle database using SQL

Prerequisites:

     An understanding of relational database design concepts.

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.

Furnished Materials:

  • Student Manual

Recommended Follow-On Course

Length:

  • 3 Days

Price:

  • $1485

Training Dates:

Sign Up