Overview
Accessing a relational Database requires understanding of Structured Query Language (SQL). This course introduces the student to the Oracle SQL language. This course explores the fundamentals of SQL Developer and SQL language, syntax rules and best practices. This hands-on course provides a thorough grounding in using SQL in Oracle from a developer viewpoint.
Audience
Individuals who need to learn, understand and use SQL as part of their job requirements. It is designed for developers new to Oracle SQL.
Length
3 days
Outline
In this course, participants will learn the basics of the SQL language, and explore the fundamentals of SQL Developer and SQL language, syntax rules and best practices. You will start with database rules and design and then delve into the fundamentals of database design.
Topics:
- Introduction
- Oracle database structure
- Single Table queries
- Joins
- Inner vs Outer Joins
- Sub-queries
- Functions
- Inserting data
- Updating data
- Deleting data
- Aggregate Expressions
- Summary