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.