Oracle SQL - Introduction to Oracle SQL

Course details

In this course, you will learn how to write SQL queries to access data stored in an Oracle Database schema. This SQL training course teaches you how to use SQL to manage data that is held in databases. This training course is designed for beginners who have no previous experience with SQL of any kind. Learn to manipulate data and use various types of functions for customizing data output. You will learn essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Learn to use single row functions to customize output, use conversion functions and conditional expressions.

It uses video lectures, covering database topics such as:

 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

You can go from absolute beginner to capable of writing SQL statements in a matter of hours. You will start by learning how to use SQL to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. The course then teaches you about common SQL functions, such as text manipulation, and how to group and summarize. This video tutorial also covers topics such as joining tables, data modification, and creating new tables and views. Finally, you will learn about the powerful subquery, and the main variances in SQL between database types. Once you have completed this computer based training course, you will have a fundamental knowledge of what SQL is and how you can apply it to different database types. Working files are included, allowing you to follow along with the author throughout the lessons. This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. This course will teach you the basics of the SQL language on an Oracle database.