Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 53 Minute(s)
Language
English
Taught by
Skill Tree
Rating
Course Overview
Learn how to communicate with oracle databases using Toad for Oracle . Learn how to create,read,update and delete data.
What is this course about?
This course teaches how to use SOL to communicate with Oracle database using Toad for Oracle editor.
What Kind of Course material is included?
All the contents are video based there are 38 video lectures that includes :
- Database Concepts
- SQL Sub Languages (DDL,DML)
- Data Types and Constraints(Varchar2,Number,Date,NOT Null,Primary Key)
- Reading ,Limiting and Sorting Data
- Table Joins (Extract data from several tables)
- Aliases
- Functions (Character,Group).
How Long is this course?
The course is approximately four hours long and is structured in a logical easy to follow functional way .
Why take this course?
Taking this course will give you a well sort after skill that will last many years. Databases are vital and to have the skill to talk to them is invaluable.
Course Content
- 7 section(s)
- 56 lecture(s)
- Section 1 Introduction and Lab Setup
- Section 2 SQL Sub Languages
- Section 3 Reading Data
- Section 4 Table Joins
- Section 5 Functions
- Section 6 Analytic Functions
- Section 7 Conclusion
What You’ll Learn
- Write SQL Queries on Oracle Databases
- Create,read,update and delete data from a database.
- Connect to Oracle databases using TOAD
- Execute SQL Queries in TOAD Editor
- Extract data from multiple tables using SQL
Skills covered in this course
Reviews
-
AAditya Kumar276734
experience was to good!!
-
VVivek Kumar Tiwari
It was very effective
-
AAkshaya R
this course gives a perfect overview and explanations for SQL using the ORACLE database
-
MMonica Venkatesh
I really learned my things in this class
