Udemy

Platform

English

Language

IT Certification

Category

The Complete Oracle SQL Course

Learn Oracle SQL: From Beginner to An Oracle Certified Associate - Helpful for Oracle Exam 1Z0-071

4.35 (219 reviews)

Students

7.5 hours

Content

Oct 2017

Last Update
Regular Price


What you will learn

Do database development

Develop codes using Oracle SQL

Understand the fundamentals of SQL (Structured Query Language)

Understand the basics of Oracle RDBMS Architecture

Learn the basics of Oracle RDBMS Architecture

Can gain considerable SQL knowledge to apply for a beginner level, SQL Developer or Database Developer Job

Understand about Oracle 12c Database

Take steps towards becoming an Oracle SQL Developer

Take steps towards becoming an Oracle DBA

Progress towards Oracle SQL Certification


Description

Quick Info:

  • Latest update: 10/23/2017
  • More than 220 Lectures
  • Very Comprehensive with extra lectures on Database Administration
  • May help in obtaining Oracle Database 12c SQL Certification.
  • With FULL Subtitles for all the video lessons

About This Course:

Welcome to the course, The Complete Oracle SQL Course.

This course introduces SQL, which is an acronym for 'Structured Query Language', to its students. This is based on Oracle's SQL implementation for Oracle Databases. The lessons are based on Oracle 12c Database and SQL Developer Tools running in Windows 10.

This course may help you in taking a step towards..

  • in becoming an 'Oracle SQL Developer'
  • in achieving 'Oracle SQL Certification'

About the Name of this Course:

When I started out to create this course, I wanted to create a Beginner Level Oracle SQL course. So I named it as 'SQL Development for Beginners'.

However as I progressed, I decided to make it much more comprehensive and cover most of the topics in the curriculum of Oracle SQL exam 1Z0-071. And so I renamed it to, The Complete Oracle SQL Course.

So, this course starts with Beginner Level lessons and progresses into next levels.

About SQL:

SQL is used to interact with Database Systems. As per ANSI (American National Standards Institute), SQL is the standard language for Relational Database Management Systems.

SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existed two decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.

About Oracle Database:

Oracle Database is one of the prominent Database Systems in the RDBMS (Relational Database Management Systems) segment. Some of the other prominent Database Systems are

  • Microsoft SQL Server
  • MySQL
  • Sybase ASE.
They also use SQL to interact with their Database Systems. While there are subtle differences between each of their SQL implementations, a SQL as a whole, is generally very standard. So a person with SQL knowledge in one platform such as Oracle, may find it easier to learn and code for other Database Systems such as Microsoft SQL or MySQL. 
The point is, once you learn SQL, then your reach into the job market is very wide.

About the Curriculum:
  • The curriculum has been carefully designed to introduce the Oracle RDBMS environment first.
  • Then it moves on to various types of SQL Statements such as DDL, DML and TCL.
  • And next, it goes to the depths of various SQL Statements, Conditions, Sorting, Functions, Grouping etc..
  • It also gives Database Administration tips, as needed.
  • It is also covers most of the topics from the Oracle SQL Certification Exam 1Z0-071

Oracle Certification:
  • Oracle awards certain certifications that are recognized globally
  • One such certification is Oracle Database 12c SQL Certified Associate
  • The exam for that certification is (currently as of May 2016), 1Z0-071.
  • The topics in this course covers most of the topics for that exam.

Oracle Certification - Declarations
  •  While this course covers most of the topics for that exam, this course is not a sole material for that exam. Additional materials such as Oracle's recommended Books may be needed.
  • This course is NOT an official course from Oracle Corporation.
  • This course has been developed individually by its author.

About the Instructor:
The instructor of this course, Mr.Sam Dhanasekaran, has more than 20 years of IT experience. It predominantly includes Database Support, IT Support and Recruiting.

About Previews:
More lessons have been opened for public previews than the required amount. Please take your time to go through all of them. This will give you an idea about the instructor's presentation style, technical knowledge etc.

Subtitles/Closed Captions:
All the video based lectures contain subtitles or closed-captions. You would be able to enable them if needed.

Screenshots

The Complete Oracle SQL Course
The Complete Oracle SQL Course
The Complete Oracle SQL Course
The Complete Oracle SQL Course

Content

Introduction

Introduction

PART I - SQL DEVELOPMENT FOR BEGINNERS

BEGINNING OF PART I

Installation

Installing Oracle 12c in Windows 10

Self Test - Oracle Installation

Using SQL Developer

Troubleshooting Connection Issues

Infrastructure Architecture

Client Server Architecture

Different types of Clients

Oracle RDBMS Architecture

Quick Overview of Oracle RDBMS Architecture

Connecting to an Oracle Database

Connecting to an Oracle Database

Demo - Connecting as SYSDBA

LAB - Connecting as SYSDBA

Stopping and Starting an Oracle Database

DEMO - Stopping an Oracle Database

LAB - Stopping an Oracle Database

DEMO - Starting an Oracle Database

LAB - Starting an Oracle Database

Table

What is a Table?

Data Types

SELECT - Basic SELECT Statement

Basics of a SELECT Statement

DESCRIBE Command - DESC

LAB - DESCRIBE or DESC Command

SELECT COUNT - Find the total number of Rows

LAB - SELECT COUNT

DBA Info - DBA_TABLESPACES

DBA_TABLESPACES

LAB - DBA_TABLESPACES

SELECT - Selecting Specific Data

Selecting Particular Columns

LAB - Selecting Particular Columns

WHERE Clause - Basics

LAB - WHERE Clause

DBA Info - Oracle Database User Architecture

Oracle Database User Architecture

Schema Vs User

How objects are stored?

Accessing the Objects

Classification of SQL Commands

Classification of SQL Commands

DML - Data Manipulation Language

DDL - Data Definition Language

DCL - Data Control Language

TCL - Transaction Control Language

Creating a Schema

Create a User

LAB - Create a User

Create a Table

LAB - Create a Table

DML - Data Manipulation Language

Basics of DML

DML - SELECT STATEMENT

DML - INSERT STATEMENT

LAB - DML - INSERT Fails. Why?

DBA Info - METADATA

DBA Info - DATA DICTIONARY

DBA Info - DEFAULT PERMANENT TABLESPACE

DML - Fixing the Failed INSERT

Demonstration of the commands to fix the INSERT

LAB - Demonstration of the commands to fix the INSERT

DML - UPDATE STATEMENT

Demo of an UPDATE STATEMENT

LAB - DML - UPDATE

DML - DELETE STATEMENT

Demo - DELETE STATEMENT

LAB - DML - DELETE

DML - MERGE STATEMENT

TCL - Transaction Control Language

TCL - Basics

Definition of a Transaction

What is a Transaction?

Demo of a Transaction

LAB - TCL - Transactions

DBA Info - Internal handling of Transaction through REDO

DBA Info - Internal handling of Transaction through UNDO

TCL - COMMIT STATEMENT

TCL - COMMIT Demo

LAB - TCL - COMMIT STATEMENT

TCL - ROLLBACK STATEMENT

LAB - ROLLBACK STATEMENT

TCL - SAVEPOINT STATEMENT

TCL - SAVEPOINT Demo

LAB - TCL - SAVEPOINT

DCL - Data Control Language

DCL - GRANT STATEMENT

DCL - SYSTEM PRIVILEGES

DCL - OBJECT PRIVILEGES

DCL - ROLE PRIVILEGES

DCL - REVOKE STATEMENT

DCL - GRANT and REVOKE - FULL DEMO

LAB - GRANT and REVOKE - FULL DEMO

DBA Info - Find the DBAs

LAB - Find the DBAs

DDL - Data Definition Language

DDL - CREATE STATEMENT

DDL - ALTER STATEMENT

DDL - DROP STATEMENT

DDL - RENAME STATEMENT

DDL - TRUNCATE STATEMENT

DDL - TRUNCATE vs DELETE

DDL - COMMENT STATEMENT

ALL THE DDL STATEMENTS - FULL DEMO

LAB - DDL STATEMENTS

Addressing the Objects

Database Design

OLTP - Online Transaction Processing System

DSS - Decision Support System

DATA MODELING - ENTITY RELATIONSHIP MODEL or ER MODEL

ER MODEL - CREATION & NORMALIZATION

ER MODEL - CONCEPTUAL MODEL

ER MODEL - LOGICAL MODEL

ER MODEL - PHYSICAL MODEL

ER MODEL vs ER DIAGRAM

ENTITY, ATTRIBUTE, TUPLE & RELATIONSHIPS

PART II - ORACLE SQL CERTIFICATION MATERIALS

Beginning of Part II

Build a SELECT Statement

Data for this Section

SELECT EVERYTHING

SELECT PARTICULAR COLUMNS

Filtering Data using WHERE Clause

JOIN Two Tables

LAB - JOIN Two Tables

Oracle Certification Exam Concepts - SELECT

PROJECTION, SELECTION & JOINING

Mandatory and Optional Clauses of a SELECT Statement

ORACLE RESERVED WORDS

CASE SENSITIVITY & TERMINATORS

LOWER and UPPER CASE in SQL Statements

LAB - LOWER and UPPER CASE in SQL Statements

SQL STATEMENT TERMINATORS

A QUICK RECAP

STRUCTURE OF A TABLE - DESCRIBE COMMAND

SELECT EVERYTHING - SELECT *

FIND THE TOTAL NUMBER OF ROWS - COUNT (*)

LAB - For this Entire Section

SELECT ANYTHING - Even the NON-EXISTENT DATA..!

To Quote or Not to Quote..!

DUAL has a DUMMY with an X – Wait, What?

Excuse me, Who am I and What is today's date please? - SYSDATE

LAB - For this Section

ARITHMETIC OPERATIONS

Additions and Subtractions ( + and - )

Multiplication and Division ( * and / )

Order of Precedence between Multiple Operators

Changing the Order of Precedence using Parenthesis

Arithmetic Operations on Tables

LAB - For this Section

COLUMN ALIAS AND CONCATENATION

Alias for Columns

CONCATENATION - Creating Sentences from the Data

Exception for Inner Single Quotes

Replacing the Quote Delimiters

LAB - For this Section

DISTINCT

DISTINCT - Avoiding Duplicates in the Results

LAB - For DISTINCT

SQL DEVELOPER - Exploring a Schema

Unlocking the HR Schema and Connecting

Explore a Schema using SQL Developer

LAB - For this Section

NULL VALUES

NULL Values

Retrieving NULL Values - IS NULL

Retrieving NON-NULL Values - IS NOT NULL

Arithmetic Operations on NULL Values

Concatenation on NULL Values

Substituting NULL Values in the Results

LAB - For this Section

Restricting and Sorting Data

Use the ORDER BY clause to sort SQL query results

Sorting NULL Values and Expressions

Positional and Composite Sorting

Limiting the Rows with a WHERE clause

Column based and Date based Conditions in WHERE clause

LAB - For this Section

COMPARISON OPERATORS

INEQUALITY OPERATORS - GREATER THAN & LESS THAN

COMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO

COMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO

INEQUALITY OPERATORS ON DATE VALUES

RANGE COMPARISON - BETWEEN OPERATOR

SET COMPARISON - IN OPERATOR

LAB - For this Section

PATTERN COMPARISON - LIKE OPERATOR

LIKE OPERATOR - WITH WILDCARDS % AND _ (UNDERSCORE)

LIKE OPERATOR - HANDS ON

PATTERN COMPARISON - ESCAPE CHARACTER

LAB - For this Section

BOOLEAN OR LOGICAL OPERATORS

BOOLEAN or LOGICAL OPERATORS - CONCEPTS

BOOLEAN OPERATOR - OR

BOOLEAN OPERATOR - AND

BOOLEAN OPERATOR - NOT

BOOLEAN OPERATORS - HANDS ON DEMO

LAB - BOOLEAN OPERATORS

SUBSTITUTIONS - USING AMPERSANDS

SUBSTITUTIONS - USING AMPERSANDS, DEFINING AND UNDEFINING THE VARIABLES

SUBSTITUTIONS - DOUBLE AMPERSANDS

LAB - For this Section

FUNCTIONS

FUNCTIONS - INTRODUCTION

NUMERICAL SINGLE ROW FUNCTIONS

CHARACTER BASED SINGLE ROW FUNCTIONS

LAB I - For this Section

CHARACTER FUNCTIONS WITH NUMERICAL RESULTS

DATETIME FUNCTIONS INTRODUCTION

DATE AND TIME FUNCTIONS - MORE FUNCTIONS

DATE AND TIME FUNCTIONS - TO_DATE

COMPARISON FUNCTIONS - GREATEST AND LEAST

LAB II - For this Section

AGGREGATE FUNCTIONS

AGGREGATE FUNCTIONS - GROUPS and SUBGROUPS

AGGREGATE FUNCTIONS - EXAMPLES

FILTERING AGGREGATE FUNCTIONS - HAVING CLAUSE

LAB - For this Section

CONDITIONAL FUNCTIONS

CONDITIONAL FUNCTIONS - NVL, NVL2 and NULLIF

CONDITIONAL FUNCTIONS - DECODE and CASE

LAB - For this Section

DISPLAYING DATA FROM MULTIPLE TABLES - JOINS

BASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN

BASICS OF A JOIN - AMBIGUOUS COLUMN NAMES

DEMO - CARTESIAN PRODUCT OR CROSS JOIN

DEMO - AMBIGUOUS COLUMN NAMES

EQUIJOIN - OLD METHOD

EQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE

EQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE

EQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE

NON-EQUIJOINS

OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS

DEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS

LAB - For this Section

USING SUBQUERIES TO SOLVE QUERIES

SUBQUERIES - DEFINITION AND SUBQUERY IN THE SELECT CLAUSE

SUBQUERY - IN THE WHERE CLAUSE

SUBQUERY - IN THE FROM CLAUSE

SUBQUERY - IN DMLs - IN INSERT UPDATE DELETE

LAB - For this Section

USING THE SET OPERATORS

UNION - COMBINING ROWS FROM TWO QUERIES WITHOUT DUPLICATES

UNION ALL - COMBINING ROWS FROM TWO QUERIES WITH DUPLICATES

INTERSECT - FETCHING THE COMMON ROWS FROM THE RESULTS

MINUS - FIRST RESULT SET MINUS SECOND RESULT SET

LAB - For this Section

MANIPULATING DATA

INSERT - VARIOUS METHODS OF INSERTING DATA

UPDATE - VARIOUS METHODS OF UPDATING DATA

DELETE - VARIOUS METHODS OF DELETING DATA

LAB - For this Section

CONSTRAINTS

NULL - DEFAULT

NOT NULL CONSTRAINT

UNIQUE CONSTRAINT

PRIMARY KEY CONSTRAINT

FOREIGN KEY CONSTRAINTS

LAB - For this Section

ADDITIONAL KNOWLEDGE BASE - DATABASE OBJECTS, DBA ARTICLES, SCRIPTS etc

INDEXES

CONCLUSION

CONCLUSION - THANK YOU


Reviews

S
Stephanie10 November 2020

The presentation hung a few times during the training; therefore, a few classes were hard to watch. Otherwise, it went pretty well.

M
Murugesh29 February 2020

At the first i was not able to pickup the topics very clearly, but after the examples given in this topics were very helpful to go through the course and now its very easy to understand the statements and commands. yeah the above statement was already present so i don't need to draft because, what exactly i wanted to say was already drafter. so yes the above statement is absolutely true. please make the video for advance sql as well.

G
Gourav12 December 2018

Course is extremely good for a beginner. Though I know all of these but since I was out of touch from technical things from a long time, I still enjoyed and I appreciate Sam to prepare this beautiful course.

S
Sebastiaan6 October 2018

So far I have completed 14% of the course so, there is a lot left but I really enjoy the in-depth explanations. The spoken speed is excellent, not to fast so you are able to follow the content. I can really recommend this course! Very happy student :-)

N
Norman12 July 2018

The course is good but no chapter on self joins. I have contacted the instructor who has not responded. I can accept the missing chapter but no response I think is poor

M
Matthew27 June 2018

This course is great for students. the videos are not very long and direct and to the point. for someone who speaks English as a second language, Sam was understandable and clear. I recommend this course for those new to Oracle. Matt

S
Shyam21 June 2018

Till now the trainer looks highly experienced. He is covering details which is helpful in professional word.

T
Tyti10 June 2018

I already take this class when I was in the university but Sam went a little more in depth about the materials. This course was very useful, it helped me to recycle my knowledge and learn new concept that I did not know. The explanation's video are great and easy to follow.

R
Rodney19 May 2018

I really enjoyed this course. I found it concise and perfect for beginners or for those wanting a refresher course.

S
Soyinka8 August 2017

Learnt so new things that I didn't know about. It was quite a learning and I believe it will help in my exam. Thanks.

R
Ricky6 August 2017

Very easy to understand, and loved that each topic is bite-sized, makes it very easy to pickup whenever I have time throughout the day.

M
Michael26 July 2017

For students who know nothing about SQL or relational databases, this course will serve as a basic (but not "complete") introduction. The content is decent, but could be presented more effectively. A large percent of the lectures are less than a minute, with many around 20 seconds in length. I feel it would be better if the brief lectures were either combined or covered topics in more depth. The demo lectures and section labs add little to no value to the course. They are the exact same SQL statements that were shown in previous lectures and require no thinking or problem solving skills to complete. They could be modified to show different variations or examples of a topic, or presented as a problem for the students to solve with the information they were just shown. There are no questions or quizzes that can be used to evaluate how well a student is learning the material. I do not believe it is a good value at full price, but if purchased during a sale or with a discount, it could be a good introduction to Oracle/SQL for a total beginner.

M
Maud22 July 2017

I'm currently taking this class in school ,and I didn't learn half of what I learned from this course .He breaks it down to its simplest form.

C
Clarence11 July 2017

Super informative, I'm sure there is plenty more. For the express purposes of familiarizing yourself with the entire process from A to Z. It makes you want more. Its the perfect foundation to build on. Thanks for taking the time to put this together.

E
ELVIS13 January 2017

great quality, only felt some more explanation is required when checking the installations using the command window


748408

Udemy ID

2/1/2016

Course created date

6/3/2021

Course Indexed date
Bot
Course Submitted by