Practical Oracle SQL  Complete Course

  • Duration – 20 hour

 

Relational databases have spread across the software world. Learning SQL means you know how to access them. This skill enables you to stay competitive.

The course teaches you Oracle SQL. But, SQL is a standard that is used for other relational databases also. So, you can re-use the SQL learning (not 100% though) for other DBs as well with some tweaks specific to those DBs. 

ALL SQL/MYSQL COURSES BUNDLE

$40

Practical Oracle SQL Complete Course

Section : Welcome to the world of SQL

 

. Introduction

Section : Oracle SQL: Getting Started

 

. What is data?

. Why do we need a database and SQL?

. Install Oracle

. Install SQL developer

. Connect to DB (Why do we need Hostname, Port, SID), Users, Schemas

 

Section : Oracle SQL: Creating, Altering and Dropping the table

. Data Model for the videos

. Create table statement

. What are Data Types? (Why does Oracle expect us to provide it?)

. Create Table, Alter table, Drop Table in action

 

Section : Oracle SQL: Inserting into a table, Commit and Rollback

 

. Insert, commit and rollback (with a visual representation)

 

Section : Oracle SQL: Read data from table

 

. SELECT statement

. SELECT with WHERE clause, AND condition, OR condition (Truth Tables)

. ORDER BY clause

 

Section : Oracle SQL: Read data from table (continued..) – More

 

. LIKE (with variants), NOT LIKE, IN,NOT IN

. Relational operators, Arithmetic operators, Concatenation

. NULL Values (Scenarios where you have to be careful)

 

Section : Oracle SQL: Updates, Deletes and Truncates

 

. Update statement, Delete vs Truncate

 

Section : Oracle SQL: Pseudocolumns and Functions

 

. DUAL table (what’s the need?), Rownum 

. Functions – Lower(), Upper(), length() – empty string?,substr(), INSTR(), trim()

. Functions – nvl(), round(), floor(), to_date()/ to_char() -datatype, to_numb…

Section : Oracle SQL: Aggregate Functions

 

. (), max(), sum(), avg(), count(), common mistake with count(*)

. Group by on single/multiple columns, Having clause vs whereclause

 

Section : Oracle SQL: Joins

 

. Join  tables, Inner Join (old vs new), Left Join, Right Join, Full outer join

. Joins across multiple tables

 

Section : Oracle SQL: Views, Subqueries

 

. Views, Inline views, With clause, Subqueries

. EXISTS (vs join), NOT EXISTS, IN, NOT IN revisited

 

Section : Oracle SQL: Scalar Subqueries, UNIONs, INTERSECT

 

. Scalar Subqueries

. Union, Union All, Intersect, us

 

Section : Oracle SQL: Indexes and Constraints

 

. Indexes (Are indexes always good?

. NOT null, Unique/Primary Key constraints, Index+constraint vs Just Co…

. Check conditions, Foreign Key Constraints (& types)

 

Section : Oracle SQL: Other interesting concepts

 

. Create table as (potential use case), Insert into command

. Oracle SEQUENCES

. UPDATE from another table, MERGE from another table

. Grants and Synonyms (why both are necessary?)

 

 

Complete End to End Job Oriented Courses.

Best self paced courses created by industry experts & 24/7 support.

Knowasap Features 

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

Human Resources

Get connected to more than 50000+ recruiters helping you with job opening and yes they are key decision makers.

Resume and LinkedIn Profile Makeover

Our experts will make your resume professionally with key makeovers, Also changing your linkedIn profile according to your skill set and high ranking keywords.

Interview Questions Blueprint

Did you know interviewer decides you will get "HIRED OR NOT" in first 3 minutes. Well dont worry we will provide you exact blueprint about how to "Introduce yourself" and other personality based interview questions which gives you the result you wanted for sure. Its a proven formula our premium students are using it and got hired.

Recent Students got hired after learning from our courses

What People Are Saying

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us