About the Course
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 CoveredIntroduction 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
Who should attendBeginners.
Pre-requisitesWindows PC, Good Internet Connectivity and Basic database knowledge
Key TakeawaysHighly interactive self paced course contents supplemented with demonstrations.
Designed and developed by Subject Matter Experts.