Udemy Business

Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Oracle SQL

Name: Oracle SQL
Rating: 4.3 (8 reviews)

Complete This Oracle SQL Course , Become Job Ready And Oracle Certified Associate (OCA)

Created byManjunath Jituri

Last updated 5/2021

English

What you'll learn

You will be able to use SQL to retrieve, filter, analyze, format and present information from Oracle databases.
You will be able to use SQL to insert, modify and delete information from Oracle databases.
You will understand SQL code written by other people and feel confident to modify it.
You will be able to apply the logic in run time depending on the work situation
You will be able to answer any SQL Interview Questions Confidently
Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!
You will learn to Install Oracle software 12c binaries and create 12c Database on windows host
Learn Single Row and Group Functions which are used mainly while developing the SQL codes

Course content

13 sections • 43 lectures • 7h 24m total length

Introduction5:12
Master the fundamentals of Oracle SQL by comparing DBMS and RDBMS, practicing select statements with from, where, group by, having, order by, and basic DDL and DML commands.
Practical21:09

Introduction Theory4:24
Master restricting data using single and multiple restrictions, operators, and literals in Oracle SQL. Then apply sorting with the order by clause, choosing ascending or descending order and handling nulls.
Single Row Restriction Practical12:37
apply single row restriction in Oracle SQL using comparison operators, in, and/or to filter employees by department, salary range, and job type, with substitution variables.
Multi Row Restriction Practical15:24
Sorting Practical8:09
Exam Preparation10:10
Explore practical Oracle SQL exam scenarios, practicing queries with select, from, where, and order by, covering ascending and descending sorting, implicit conversions, like patterns, and five percent rule examples.

DML Theory1:23
Explore data manipulation language in Oracle SQL, and learn how insert, update, and delete modify tables, while managing transactions with commit and rollback to finalize or revert changes.
DML Insert Practical13:31
Learn practical Oracle SQL inserts, including basic insert into values, column lists, insert all with conditional routing to small, medium, and big orders, and commit rollback control.
DML Update Practical6:23
DML Delete Practical11:25
Explore practical DML delete operations in oracle sql, including deleting all records, deleting with conditions, rolling back, and using merge for insert or update across source and target tables.

Constraints Theory4:25
Constraints Practical Part18:07
Create locations and workers with primary keys and a foreign key from workers to locations. Include a unique worker name and a salary check greater than 15000; emphasize constraint naming.
Constraints Practical Part223:12
Explore practical constraints in Oracle SQL, including primary keys, unique constraints, and cascade delete, with metadata access and table alterations on departments and employees.
Exam Preparation On Constraints9:59
Practice oracle sql constraints with exam-style questions on dropping and altering columns, handling primary and foreign keys, defaults, and rollback implications.

Single Row Function Introduction And Its Types2:04
Discover oracle single row functions and their types, including character functions, no functions, convergent functions, special or general functions, and conditional expressions, with practical, row-level outputs in depth.
Character Functions Practical26:33
Number Functions Practical8:47
Explore Oracle SQL number functions in this practical session, including mod for remainders, round with decimal control, truncation, and ceil/ceiling and floor operations.
Date Functions Practical11:19
Explore Oracle SQL date functions through practical examples of sysdate, next_day, last_day, and months_between. Learn to_char, add or subtract days, months, and hours for dynamic date handling.
Conversion Functions Practical22:54
Explore explicit and implicit conversion functions in Oracle SQL, converting numbers, dates, and characters to different formats with practical examples of date handling, formatting, and between usage.
General Functions and Conditional Expressions Practical15:52
Master Oracle SQL general functions and conditional expressions by applying NVL, COALESCE, and CASE to handle nulls, convert data types, and compute salaries with commissions.

Joins Introduction and Its Types3:33
Learn to master Oracle SQL joins, including inner, outer, and cross joins, with equal joins using on, using, and natural join; cover left and right outer joins and syntax styles.
ER Diagram of SCOTT and HR Schema4:43
Explore the ER diagram of the SCOTT and HR schema, identify common columns and references, and understand inner, left outer, and full outer joins.
Inner Equi Join Practical (Join on, Join using and Natural Join methods)15:32
Non Equi Join And Self Join (Join on Method)10:54
Outer Join (Left/Right/Full Outer Join) and Cross Join13:42
Exam Preparation On Joins6:45
Explore practical joins, including inner, left outer, right outer, full outer, and natural joins, with cartesian product examples from employees and managers to prep for the exam.

Subquery Introduction and Its types2:40
Explore subqueries in oracle sql, including inner and outer queries, non-correlated and correlated types, and single-row versus multi-row subqueries using operators and table references.
Non-correlated Subquery (Single/Multi Row Subquery) Practical12:52
Practice non-correlated and single/multi-row subqueries in Oracle SQL, using real-world examples to fetch jobs, compare salaries with all/any, and identify max salaries by department.
Correlated Subquery and Analytical Function12:15
Exam Preparation On Subqueries3:56
Explore subqueries in Oracle SQL through exam-style questions on update with subqueries, execution rules, and the truth of statements about comparing columns, cross-table data access, and subquery levels.

Requirements

You need a PC to do a lab setup
No programming experience is required
You should have a real desire to learn, and time to watch the lectures and practice the concepts as suggested by the instructor.
Downloading oracle database and this will be covered in details on Windows OS.
No need for any prerequisite database skills, this course designed from Zero to certified level.

Description

We all know that , SQL is more powerful and widely used language for data work.

All the dynamic websites existing on the internet are database driven. Dynamic sites like online banking, social media sites, railway reservation, e-commerce

are connected to database. If database is there then SQL will definitely come into the picture.

Almost all of the biggest names in tech use SQL. Uber, Netflix - the list goes on. Even within the companies like Facebook, Google, Amazon , which have built

their own high performance database systems and data teams use SQL to query and perform analysis.

You might be knowing that , SQL is most demanding for Data Analyst role, Data Scientist and Data Engineer role.

What are you going to learn from this course?

SQL Introduction And Basic Select Statements

Restricting And Sorting Data

Creating/Altering/Dropping/Renaming/Truncating Tables Using DDL Commands

Accessing Database Tables by Insert/Update/Delete DML Commands

Creating Constraints On Column To Avoid Unwanted Entry Of Data Into Table And To Maintain Parent-Child Relationship Between The Tables

Single Row Functions And Multi Row Functions

Fetching Data From Multiple Tables Using Joins

Using Subqueries

Using Set Operators To Combine Data From Multiple Queries

Using Other Schema Objects

Creating GTT - Global Temporary Tables

Using LISTAGG Function

Grant/Revoke of System And Object privileges

Creating Roles , Granting Privileges To Roles And Granting Roles to Users

More?

Hundreds of Examples

Professional Course Design,

Well-organized Content

In-Depth Subjects (All subjects are explained with all details)

Lifetime Author Support.

Who this course is for:

Beginners who want to step into SQL development career
Anyone dreaming to get a well-paid SQL Development Job
Anyone planning to Pass the Oracle 1Z0-071 (OCA) exam

Oracle SQL

What you'll learn

Explore related topics

Course content

Chapter 1: Retrieving Data Using the SQL SELECT Statement2 lectures • 26min

Environment Setup For Windows Machine1 lecture • 9min

Chapter 2 : Restricting And Sorting Data5 lectures • 51min

Chapter 3 : Using DDL Statements to Create and Manage Tables2 lectures • 19min

Chapter 4 : Data Manipulation Language (DML)4 lectures • 33min

Chapter 5 : Constraints4 lectures • 46min

Chapter 6 : Using Single-Row Functions to Customize Output6 lectures • 1hr 27min

Chapter 7 : Reporting Aggregated Data Using the Group Functions3 lectures • 24min

Chapter 8 : Displaying Data from Multiple Tables Using Joins6 lectures • 55min

Chapter 9 : Using Subqueries to Solve Queries4 lectures • 32min

Requirements

Description

Who this course is for: