DBA: Introduction to SQL Ed 2

  • Course level: All Levels
  • Total Enrolled 0
  • Last Update February 26, 2021


This Introduction to SQL training takes to the basic concepts of relational databases and SQL programming language. Through this training you will gain the essential SQL skills to write queries against single and multiple tables and can manipulate data in tables and create database objects.

Topics for this course

73 Lessons


Overview of Oracle Database 12c and Related Products00:00:00
Introduction to SQL and its development environments
Course Objectives, Course Agenda and Appendixes Used in this Course
The Human Resource (HR) Schema
Overview of relational database management concepts and terminologies
What is Oracle SQL Developer?
Tables used in the Course
Starting SQL*Plus from Oracle SQL Developer

Working with Oracle Cloud Exadata Express Cloud Service

Retrieving Data using the SQL SELECT Statement

Restricting and Sorting Data

Using Single-Row Functions to Customize Output

Using Conversion Functions and Conditional Expressions

Using Subqueries to Solve Queries

Using the SET Operators

Managing Tables using DML statements

Introduction to Data Definition Language

Introduction to Data Dictionary Views

Creating Sequences, Synonyms, Indexes

Creating Views

Managing Schema Objects

Retrieving Data by Using Subqueries

Manipulating Data by Using Subqueries

Controlling User Access

Manipulating Data

Managing Data in Different Time Zones