Virtual Instructor-Led Training
3 Days (24 Hours)Oracle Database SQL Workshop I Ed 2 covers introductory SQL skills for querying and managing data within Oracle databases.
Course Objectives
- Identify the major components of Oracle Database
- Retrieve row and column data from tables with the SELECT statement
- Create reports of sorted and restricted data
- Employ SQL functions to generate and retrieve customized data
- Run complex queries to retrieve data from multiple tables
Upcoming Schedules
Course Prerequisites
Required
- Familiarity with data processing concepts and techniques
- Familiarity with programming languages
Course Outline
Introduction
- Course Objectives, Course Agenda and Appendixes Used in this Course
- Overview of Oracle Database 12c and Related Products
- Overview of relational database management concepts and terminologies
- Introduction to SQL and its development environments
- What is Oracle SQL Developer?
- Starting SQL*Plus from Oracle SQL Developer
- The Human Resource(HR) Schema
- Tables used in the Course
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language