Oracle SQL - A Comprehensive Training on Oracle SQL

Course details

This course will teach you the SQL language on an Oracle database. This introductory course teaches you how to work with data in your Oracle Database using Oracle's proprietary SQL language. It starts with the basic overview of what SQL is all about and then covers basic queries and common things you might be expected to do on a job. We then proceed to learn complex queries and data management such as inserting/updating/deleting data. It uses video lectures, covering database topics such as:

 Setting up your Oracle environment

 Basic terminology

 Reading data using a SELECT statement

 What can be done using a SELECT statement

 Functions

 Data types

 Joins, set operators, subqueries

 Inserting, updating and deleting data

 Creating tables

By learning this course you will be conceptual ready for developing DB objects. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables