Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Complete Oracle SQL Masterclass: Go from zero to Hero

Name: Complete Oracle SQL Masterclass: Go from zero to Hero
Rating: 4.2 (56 reviews)

Learn SQL by example, Connect to MySQL with Python 3, Learn queries essential to Data Science

Created byAshwin Pajankar • 85,000+ Students Worldwide

Last updated 6/2022

English

English [Auto],

What you'll learn

Write basic and advanced SQL Queries for any Relational Database Management System
Learn DDL and DML commands
Learn Joins and Subqueries
Use SQL in Python 3 programs
Work with Oracle SQL Developer
Learn to export your data

Course content

22 sections • 183 lectures • 19h 46m total length

Course Objectives and Expected Audience6:28
Explore the course objectives and origins to help learners become comfortable with SQL and relational database management systems, while preparing them for interviews and opportunities across developers, testers, and managers.
Course Contents Walkthrough6:32
Please do leave your valuable feedback for the course0:59
Introduction to Relational DBMS and SQL33:19
Explore how data moves from flat files, csv, and spreadsheets into relational database management systems, and how sql provides the interface to query tables of rows and columns.
Installation of Oracle XE10:54
Installation of SQL Developer7:21
Web Resources for Software installation0:04
Why Oracle11:14
Why Oracle : Web URLs0:01
Types of SQL Queries7:24
A quick look at SQL in action16:55
Explore sql in action with an in-browser database, running simple select and count queries, filtering by country, and restoring data without software installation.

Getting started with Oracle and SQL Developer26:50
CODE: Getting started with Oracle and SQL Developer0:02
Download the PDF for URLs to Online Resources and SQL Queries.
Selection, Projection, Operators, and Operator Precedence18:42
CODE: Selection, Projection, Operators, and Operator Precedence0:02
Download the PDF for URLs to Online Resources and SQL Queries.
NULL Values and Column Aliases12:34
CODE: NULL Values and Column Aliases0:02
Concatenation, Literal Character Strings, and DISTINCT16:14
Master the concatenation operator and distinct keyword in Oracle SQL by concatenating character strings and numeric values, handling literal strings, and removing duplicates with practical examples.
CODE: Concatenation, Literal Character Strings, and DISTINCT0:02

WHERE Clause and Comparison Conditions13:16
CODE: WHERE Clause and Comparison Conditions0:02
BETWEEN and IN11:28
Explore how to use between and in operators in Oracle SQL to filter numeric ranges (salary), select by specific values, and search data like last names in the where clause.
CODE: BETWEEN and IN0:02
LIKE and IS NULL18:58
CODE: LIKE and IS NULL0:02
Logical Operations8:13
Explore how to filter data with logical operators in Oracle SQL, using and, or, and not in where clauses, combining salary thresholds with pattern matching like 'S%'.
CODE: Logical Operations0:02
Sorting11:01
Learn to sort data with the order by clause in Oracle SQL, using ascending and descending orders, sorting by columns and aliases, and handling nulls.
CODE: Sorting0:02
Dates9:44
Explore working with dates in Oracle SQL by using the date data type, date literals, and comparison operators to filter employees by hire dates, including between and like.
CODE: Dates0:02

Functions in SQL - Single Row and Multiple Row (Group)5:30
Dual Table5:18
Case Manipulation Functions5:59
CODE: Case Manipulation Functions0:04
Character Manipulation Functions13:57
CODE: Character Manipulation Functions0:04
Number Functions11:09
CODE: Number Functions0:04
Conversion Functions15:16
CODE: Conversion Functions0:04
Working with dates13:29
Master date handling in Oracle SQL by adding days and hours, subtracting values. Explore months between, add months, next day, last day, truncate, and round for payroll and accounting.
CODE: Working with dates0:04
NVL, NVL2, NULLIF, COALESCE13:15
CODE: NVL, NVL2, NULLIF, COALESCE0:04
CASE and DECODE20:26
CODE: CASE and DECODE0:04
Nesting of Single Row Functions5:17

Cross Join and Cartesian Product6:53
CODE: Cross Join and Cartesian Product0:04
NATURAL JOIN and INNER JOIN14:51
Explore natural join and inner join concepts in Oracle SQL, compare their behaviors, and learn to use on and using clauses, aliases, and common columns to join departments and locations.
CODE: NATURAL JOIN and INNER JOIN0:04
OUTER JOINS15:19
CODE: OUTER JOINS0:04
Additional Conditions in Joins and Joining multiple tables11:45
Explore joining multiple tables in Oracle SQL, convert cartesian products into meaningful results with proper join conditions, and use where clauses for adding multiple criteria across employees, departments, and locations.
CODE: Additional Conditions in Joins and Joining multiple tables0:04
Self Join6:50
CODE: Self Join0:04
Non-equijoins8:55
Explore non-equijoins in Oracle SQL by joining on non-equality conditions, using salaries from the jobs table to filter employees by salary ranges and roles such as programmer.
CODE: Non-equiJoins0:04

Basics of Sessions and Transactions13:13
Explore how sessions arise from connections and enable user interactions with the database. Learn that transactions are the unit of work behind inserts, updates, and deletes.
INSERT Statement18:45
CODE: INSERT Statement0:04
UPDATE Statement22:06
CODE: UPDATE Statement0:04
DELETE Statements9:53
CODE: DELETE Statement0:04
Theory - Locking and Deadlocks7:22
Locking and Deadlock Demonstration11:04
CODE- Deadlock in Oracle0:03

DDLs and CREATE TABLE7:30
CODE: DDLs and CREATE TABLE0:04
ALTER TABLE4:33
Explore how to modify tables with alter table by adding and dropping columns. Use describe commands to view the updated table structure.
CODE: ALTER TABLE0:04
Data Dictionary13:48
CODE: Data Dictionary0:04
RENAME and TRUNCATE7:11
CODE: RENAME and TRUNCATE0:04
DROP TABLE4:44
Demonstrate dropping a table in Oracle SQL, permanently removing the table and its structure from a schema, with rollback limitations, production environment caution, and the need to obtain proper permissions.
CODE: DROP TABLE0:04
Commonly used Oracle Data types10:42
Explore the most common Oracle data types, including variable length character data (char, varchar), unicode storage, numeric with precision and scale, and date types, plus the royalty pseudo column.
CODE- Commonly used Oracle Data Types0:03

Constraints and Primary Key- Theory Lecture7:29
Gain understanding of constraints and the primary key, including why a primary key must be unique and not null, with real-world examples of unique identifiers in databases.
Data Dictionary for Constraints4:55
CODE- Data Dictionary for Constraints0:04
PRIMARY KEY14:38
CODE: PRIMARY KEY0:04
UNIQUE18:26
CODE: UNIQUE0:04
FOREIGN KEY - Theory6:11
Explore referential integrity with a foreign key from employees to departments, enforcing valid department references, and preventing orphan records, while using joins and handling nulls and delete options.
Foreign Key - Practice21:03
CODE: FOREIGN KEY - Practice0:04
NOT NULL7:22
CODE: NOT NULL0:04
CHECK6:43
CODE: CHECK0:04
DISABLE and DROP Constraint6:22
CODE: DISABLE and DROP Constraint0:04

Requirements

A computer with Microsoft Windows and Internet Connection
Willingness and enthusiasm to learn, drive to take your career to the next level

Description

Become an expert in SQL and learn one of employer's most requested skills of 21st Century! SQL is used in many job roles including Database Administration, Data Science, Performance Engineering, and Web Development. A person with expert level knowledge of SQL can earn minimum $100000 (That's five zeroes after 5) per year.

This is the most comprehensive, yet straight-forward course for the Structured Query Language (SQL) on Udemy! Whether you have never used databases before, already know basics of SQL, or want to learn about the advanced features of SQL, this course is for you! In this course I will teach you SQL with Oracle.

With over 180 lectures and more than 20 hours of video this comprehensive course leaves no stone unturned to make you an expert in the SQL.

This course will teach you SQL in a very practical manner, with every lecture comes a full SQL programming video and a corresponding PDF that has SQL code! Learn in whatever manner is the best for you!

We will start by helping you get Oracle XE and SQL Developer installed on your Windows computer.

We cover a wide variety of topics, including:

Basics of RDBMS and SQL
Getting Started with SQL
Installation of Oracle and SQL Developer
The WHERE Clause
Single ROW Functions
Group Functions
Joining data from multiple tables
DML Statements and Transactions
DDLs, Tables, and Data Dictionary
Constraints
Views
Synonyms and Indexes
Set Operations
Sequences
Schemas, Roles, and User Access Control
Advanced Topics in Oracle SQL
Python 3 and SQL
Additional Resources and Tools
MySQL
RDBMS and SQL for Data Science
Bonus Section

You will get lifetime access to over 180 lectures plus corresponding SQL code PDFs for the lectures!

So what are you waiting for? Learn SQL in a way that will advance your career and increase your knowledge, all in a fun and practical way!

Who this course is for:

Programmers and Developers
Testers and QAs
Data Scientists and Engineers
Database Administrators
Analysts
Managers and Sales People
People preparing for Oracle and other database related certifications
Anyone who genuinely wants to learn SQL

Complete Oracle SQL Masterclass: Go from zero to Hero

What you'll learn

Explore related topics

Course content

Introduction11 lectures • 1hr 41min

Getting Started with Oracle SQL8 lectures • 1hr 14min

The WHERE Clause12 lectures • 1hr 13min

Single Row Functions17 lectures • 1hr 50min

Group Functions6 lectures • 51min

Joining data from multiple tables12 lectures • 1hr 5min

DML Statements and Transactions10 lectures • 1hr 23min

DDL, Tables, and Data Dictionary12 lectures • 49min

Constraints16 lectures • 1hr 34min

VIEWS4 lectures • 31min

Requirements

Description

Who this course is for: