Practical Oracle SQL  Complete Course

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. 

lIFETIME ACCESS

INR 999

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 (why doesn’t it work sometim…

 

 

. 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 commands

 

 

. Oracle SEQUENCES

 

 

. UPDATE from another table, MERGE from another table

 

 

. Grants and Synonyms (why both are necessary?)

 

 

More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us