Oracle SQL : Practical Examples : Go from Beginner to Master
4.3 (185 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16,491 students enrolled

Oracle SQL : Practical Examples : Go from Beginner to Master

From basics to advanced Oracle SQL : Solve critical SQL queries : SQL interview preparation : Job-ready course contents
4.3 (185 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16,491 students enrolled
Created by Prashant Munshi
Last updated 1/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 15 hours on-demand video
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • SQL over Oracle 19 C version on Oracle LiveSQL platform
  • A to Z in SQL on Oracle's latest version
  • Go from an absolute beginner to an advanced SQL developer in less than 15 hours
  • RDBMS fundamentals and explanation on various terminologies for interview preparation
  • This is a complete course which does not require the students to have local installation of Oracle yet they we use the latest version of Oracle from web
  • Structure of basic query statement - Projection, Predicate and Verb
  • Use of Logical Operators - AND, OR, IN, BETWEEN, NOT, DISTINCT, LIKE
  • Various important properties of ORDER BY clause with examples
  • Deal with NULL values - IS NULL, NVL, NVL2, COALESCE
  • All forms of Sub-queries / Nested Queries - Multi-valued, Returning NULL, Set Comparison, Correlated, EXISTS operator, ANY & ALL operators
  • All forms of JOIN operations - Inner, Equijoin, Natural, Non-equijoin, Selfjoin, Outer Join operator, OUTER JOIN clause
  • GROUP BY clause concept - Group Functions MAX, MIN, SUM, AVG, COUNT - Group function tricky queries
  • Analytical / Aggregate form of Function - ROLLUP, CUBE, RANK, DENSE_RANK, DECODE vs CASE
  • SQL General Functions - Conversion, Numeric, String, Date functions - Query examples
  • Database Transaction Concepts - DML statements and forms - Rows Locking FOR UPDATE NOWAIT clause - Transaction Consistent Read SET TRANSACTION READ ONLY
  • SQL commands DELETE vs TRUNCATE - Difference and similarities
  • CREATE TABLE from scratch and copy from existing table - ALTER TABLE - Add/drop columns - Change column datatypes/widths and limitations - RENAME columns/Table
  • Constraint Metadata - Enable / Disable Constraint - Data Validation
  • Data Integrity Concepts - Data Integrity Constraints - Column / Table level constraint definitions - Referential Integrity through FOREIGN KEY constraint
  • IMMEDIATE vs DEFERRED constraints - Transaction level constraint validation.
Course content
Expand all 56 lectures 15:06:23
+ Introduction
5 lectures 40:21

Just intro about why you should learn Oracle SQL and faculty profile

Preview 02:32

Oracle is Relational DataBase and so also the other many databases. They all share a common theoretical concepts and it is necessary that one should understand the technical terminologies involved and this lesson is dedicated to the same.

Preview 15:06

Setup the Oracle's web based LiveSQL platform and create an user account. Upload the script for creating database tables based on Scott schema of Oracle,  to be used in hands on practice.

Preview 10:15

Know about what SQL is all about and who created this language and where it is used, who should study this language.

Preview 05:30

Understand the anatomy of the basic SELECT query statement of SQL.

Preview 06:58
+ SQL Logical Operators
3 lectures 24:20

Lessons with examples about how to combine multiple conditions using AND operator in the SQL predicate clause

AND Operator
05:34

Lessons with examples about how to combine multiple conditions using OR operator in the SQL predicate clause

OR Operator
04:28

Combination of AND and OR operators is required to be handled according to the rule of precedence, which is the subject of this lesson.

Using AND & OR Together
14:18
+ SQL operators IN and BETWEEN
2 lectures 16:49

Study of IN operator to list the rows when a common expression is compared with various different values with OR, a shorthand for multiple OR for common expression.

SQL operator IN
08:04

Listing rows based on a range of values criteria. Important are the fine points of BETWEEN operator explained with examples.

SQL operator BETWEEN
08:45
+ SQL Clauses DISTINCT & ORDER BY & SET Operators
3 lectures 44:22

Use and properties of the DISTINCT clause used in SQL SELECT statement. Suppression of duplication of values in listing.

SQL clause DISTINCT
08:25

Use and properties of ORDER BY clause in SQL SELECT statement. To display the rows in ASCENDING and DESCENDING sorted order based on a column or combination of columns.

SQL clause ORDER BY
16:21

Concept of SQL SET Operators - UNION - MINUS - INTERSECTION - Explanation and use with examples - UNION & UNION ALL - UNION compatibility rules

SQL UNION - MINUS - INTERSECT operators
19:36
+ Handling of NULL values
4 lectures 35:28

Listing the rows based on NULL values in the rows by using IS NULL clause or IS NOT NULL clauses

SQL clause IS NULL and IS NOT NULL
07:18

SQL function NVL, its use, properties and case studies

SQL built in function NVL
09:15

SQL function NVL2, its use, properties and case studies

SQL built in function NVL2
09:21

SQL function COALESCE, its use, properties and case studies

SQL built in function COALESCE
09:34
+ Subquery / Nested Query Techniques
7 lectures 01:23:00

Understand the basic use of Sub-query and its need. Know basic syntax of Sub-query.

Preview 09:01

Understand about how to handle the situation when the Sub-query is supposed to return multiple values, with examples

Multi-valued Subqueries
07:42

Know about how to handle the situations when the sub-query has the possibility to return NULL values, with examples of workaround

Subquery Returning NULL
18:48

Sub-queries returning sets of values and comparison of them as a set in the predicates of SQL statements, case study.

Set Comparison Subqueries
09:39

A very special type and complex form of Sub-Query. Use and properties of Correlated Subquery with examples

Correlated Subqueries
11:35

Use of EXISTS Boolean operator for Correlated Subqueries

Subquery Operator EXISTS
11:18

Understand use & properties of ANY and ALL operators typically with Subqueries

ANY/ALL Operators
14:57
+ SQL Join Operation
5 lectures 51:27

Understand the basics of JOIN operation - EquiJoin - Joining the two relations based on equality of values in common columns.

SQL Inner Join Operation
12:29

Understand the use of Non-Equi type of join operation based on operators like between. Properties of Non-Equi joins

SQL Non-Equi Join Operation
07:45

Understand the technique of table join with itself

SELF JOIN operation
09:30

Understand about why require OUTER JOIN operation. Use of special OUTER JOIN operator provided by Oracle. Properties of OUTER JOIN operator

OUTER JOIN operation
12:55

Understand use of ANSI provided standardized OUTER JOIN clause with its various options. Advantages of using the OUTER JOIN clause as replacement of OUTER JOIN operator.

OUTER JOIN clause
08:48
+ SQL standardized built-in Group Functions
4 lectures 45:49

Understand the concept of Group Functions, different Group Functions, purpose of GROUP BY clause and HAVING clause

Preview 09:10

Actual use of Group Functions and GROUP BY clause and HAVING clause with query examples, syntax.

SQL Group Function Queries
07:57

Certain SQL Group Function based tricky queries being frequently asked in interviews, with explanation, demonstration and case studies

SQL Group Function Tricky Queries
18:43

Understand the use of two analytical extensions of GROUP BY clause to solve certain complex reporting problems of SubTotals and GranTotals in financial and other statements

ROLLUP & CUBE - SQL Group Function Analytical Extensions
09:59
+ Oracle SQL General Built-in Functions
5 lectures 02:45:26

Understand the use of some conversion functions or type casting functions TO_CHAR, TO_NUMBER

Preview 34:52

Continued study of conversion functions and some numeric built in functions with examples and problem solutions

SQL Functions Part - 2
33:10

Continued study of numeric functions and some important string functions, their way of  use and properties

SQL Functions Part - 3
32:26

Extension of study of string functions and some date functions with solutions to frequently asked tricky queries / problems in the interview

SQL Functions Part - 4
31:46

Extension of study of date functions with solutions to frequently asked tricky queries / problems in the interview

SQL Functions Part - 5
33:12
+ Transaction And DML
6 lectures 02:14:18

Conceptual explanation of the rules of database transactions, ACID Properties of transaction, Nature of database transaction

SQL Transactions Concepts
25:50

INSERT, UPDATE, DELETE statments, Syntax and Statement Form, Examples.

Preview 14:29

Isolation of transaction through locking, Optimistic and Pessimistic locking, How to request for the locks

SQL Transaction and Isolation
29:05

Understand the concept of data consistent transaction, concept of READ ONLY transaction

Concept of Consistency and Consistent Read in Database Transaction
27:06

Transaction Control Language statements consists of COMMIT, ROLLBACK and SAVEPOINT. Let us understand the proper use of these statements with examples

SQL Transaction Control Language
18:52

Similarities and Differences between DELETE, TRUNCATE and DROP TABLE commands. Answer to frequently asked question in the interview.

SQL DELETE vs TRUNCATE vs DROP
18:56
Requirements
  • No prior programming knowledge is required in any language. It is learn-by-doing hands-on course, so except UG level education in any branch there is no other requirement
Description

***SQL course which gained immediate popularity with the launch on UDEMY***

============================================================================

***Continuously being updated with new topics/videos every week***

***Added lecture SQL vs NOSQL*** > 19 Dec 2019 (under Interview Section)

***Added Interview Section*** > 15 Dec 2019

*** Added lecture Most Important SQL Queries*** > 15 Dec 2019

***Added lecture What is VIEW?*** > 15 Dec 2019

=============================================================================

You need to learn the most important and powerful language of the database world - SQL which makes your programming skills complete and enriched in just less than 20 hours of study!

If you have already wasted your time and money in hunting for a complete yet concise course in SQL through random youtube videos or offered by inexperienced people - then you are at the right place here. This course brings step-by-step lessons in its logical series of videos to help you master the art and science of SQL. Moreover there is not even a basic knowledge of programming envisaged while designing this course.

This course has been brought by an highly experienced faculty who have had 20+ years of experience in working as Oracle developer and DBA out of which 6 years onside in USA and UK. The faculty has been working in Oracle field ranging from Oracle version 6 to the latest 19C.

This course is for everybody who likes to make career in database programming, front end programming, ERP, or in general succeed as an IT professional, management people and undergraduate students of any stream. This course is covered on Oracle's LiveSQL platform available on web hence does not require any local installation of Oracle, yet the students can practice on latest version, the current is Oracle 19C. Being on web, students can learn, take notes or do practice sitting anywhere as Oracle LiveSQL is accessible on all the devices - PC, Laptops or even Mobiles.

Who this course is for:
  • Students interested in database back end programming
  • Programmers in any other front end language like Java or PHP or Python etc, must learn SQL
  • Engineering students, Computer Science students, Science / Commerce students - All pursuing UG or PG or completed with degree
  • Management people who are required to draw ad-hoc data as per requirement