At the end of this course, you will get the knowledge of... How to write SQL queries to access data stored in an Oracle Database schema. 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

Topics Covered

Introduction to SQL DURATION – 25 Minutes Writing Basic SQL SELECT Statements DURATION – 30 Minutes Restricting and Sorting Data DURATION – 45 Minutes Single Row Functions DURATION – 110 Minutes Aggregating Data Using Group Functions DURATION – 30 Minutes Constraints DURATION – 45 Minutes Displaying Data from Multiple Tables – 60 Minutes Sub-Queries DURATION – 30 Minutes Producing Readable Output with SQL*Plus – 60 Minutes Manipulating Data DURATION – 75 Minutes Creating and Managing Tables DURATION – 60 Minutes