Complete Oracle SQL Masterclass- Go from zero to Hero

Complete Oracle SQL Masterclass: Go from zero to Hero, available at $54.99, has an average rating of 3.85, with 183 lectures, based on 53 reviews, and has 1736 subscribers.

You will learn about 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 This course is ideal for individuals who are Programmers and Developers or Testers and QAs or Data Scientists and Engineers or Database Administrators or Analysts or Managers and Sales People or People preparing for Oracle and other database related certifications or Anyone who genuinely wants to learn SQL It is particularly useful for Programmers and Developers or Testers and QAs or Data Scientists and Engineers or Database Administrators or Analysts or Managers and Sales People or People preparing for Oracle and other database related certifications or Anyone who genuinely wants to learn SQL.

Enroll now: Complete Oracle SQL Masterclass: Go from zero to Hero

Summary

Title: Complete Oracle SQL Masterclass: Go from zero to Hero

Price: $54.99

Average Rating: 3.85

Number of Lectures: 183

Number of Published Lectures: 183

Number of Curriculum Items: 183

Number of Published Curriculum Objects: 183

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Objectives and Expected Audience

Lecture 2: Course Contents Walkthrough

Lecture 3: Please do leave your valuable feedback for the course

Lecture 4: Introduction to Relational DBMS and SQL

Lecture 5: Installation of Oracle XE

Lecture 6: Installation of SQL Developer

Lecture 7: Web Resources for Software installation

Lecture 8: Why Oracle

Lecture 9: Why Oracle : Web URLs

Lecture 10: Types of SQL Queries

Lecture 11: A quick look at SQL in action

Chapter 2: Getting Started with Oracle SQL

Lecture 1: Getting started with Oracle and SQL Developer

Lecture 2: CODE: Getting started with Oracle and SQL Developer

Lecture 3: Selection, Projection, Operators, and Operator Precedence

Lecture 4: CODE: Selection, Projection, Operators, and Operator Precedence

Lecture 5: NULL Values and Column Aliases

Lecture 6: CODE: NULL Values and Column Aliases

Lecture 7: Concatenation, Literal Character Strings, and DISTINCT

Lecture 8: CODE: Concatenation, Literal Character Strings, and DISTINCT

Chapter 3: The WHERE Clause

Lecture 1: WHERE Clause and Comparison Conditions

Lecture 2: CODE: WHERE Clause and Comparison Conditions

Lecture 3: BETWEEN and IN

Lecture 4: CODE: BETWEEN and IN

Lecture 5: LIKE and IS NULL

Lecture 6: CODE: LIKE and IS NULL

Lecture 7: Logical Operations

Lecture 8: CODE: Logical Operations

Lecture 9: Sorting

Lecture 10: CODE: Sorting

Lecture 11: Dates

Lecture 12: CODE: Dates

Chapter 4: Single Row Functions

Lecture 1: Functions in SQL – Single Row and Multiple Row (Group)

Lecture 2: Dual Table

Lecture 3: Case Manipulation Functions

Lecture 4: CODE: Case Manipulation Functions

Lecture 5: Character Manipulation Functions

Lecture 6: CODE: Character Manipulation Functions

Lecture 7: Number Functions

Lecture 8: CODE: Number Functions

Lecture 9: Conversion Functions

Lecture 10: CODE: Conversion Functions

Lecture 11: Working with dates

Lecture 12: CODE: Working with dates

Lecture 13: NVL, NVL2, NULLIF, COALESCE

Lecture 14: CODE: NVL, NVL2, NULLIF, COALESCE

Lecture 15: CASE and DECODE

Lecture 16: CODE: CASE and DECODE

Lecture 17: Nesting of Single Row Functions

Chapter 5: Group Functions

Lecture 1: Group Functions

Lecture 2: CODE: Group Functions

Lecture 3: GROUP BY

Lecture 4: CODE: GROUP BY

Lecture 5: HAVING Clause

Lecture 6: CODE: HAVING Clause

Chapter 6: Joining data from multiple tables

Lecture 1: Cross Join and Cartesian Product

Lecture 2: CODE: Cross Join and Cartesian Product

Lecture 3: NATURAL JOIN and INNER JOIN

Lecture 4: CODE: NATURAL JOIN and INNER JOIN

Lecture 5: OUTER JOINS

Lecture 6: CODE: OUTER JOINS

Lecture 7: Additional Conditions in Joins and Joining multiple tables

Lecture 8: CODE: Additional Conditions in Joins and Joining multiple tables

Lecture 9: Self Join

Lecture 10: CODE: Self Join

Lecture 11: Non-equijoins

Lecture 12: CODE: Non-equiJoins

Chapter 7: DML Statements and Transactions

Lecture 1: Basics of Sessions and Transactions

Lecture 2: INSERT Statement

Lecture 3: CODE: INSERT Statement

Lecture 4: UPDATE Statement

Lecture 5: CODE: UPDATE Statement

Lecture 6: DELETE Statements

Lecture 7: CODE: DELETE Statement

Lecture 8: Theory – Locking and Deadlocks

Lecture 9: Locking and Deadlock Demonstration

Lecture 10: CODE- Deadlock in Oracle

Chapter 8: DDL, Tables, and Data Dictionary

Lecture 1: DDLs and CREATE TABLE

Lecture 2: CODE: DDLs and CREATE TABLE

Lecture 3: ALTER TABLE

Lecture 4: CODE: ALTER TABLE

Lecture 5: Data Dictionary

Lecture 6: CODE: Data Dictionary

Lecture 7: RENAME and TRUNCATE

Lecture 8: CODE: RENAME and TRUNCATE

Lecture 9: DROP TABLE

Lecture 10: CODE: DROP TABLE

Lecture 11: Commonly used Oracle Data types

Lecture 12: CODE- Commonly used Oracle Data Types

Chapter 9: Constraints

Lecture 1: Constraints and Primary Key- Theory Lecture

Lecture 2: Data Dictionary for Constraints

Lecture 3: CODE- Data Dictionary for Constraints

Instructors

Ashwin Pajankar ? 85,000+ Students Worldwide
Instructor | Programmer | Maker | Author | Youtuber

Rating Distribution

1 stars: 1 votes

2 stars: 2 votes

3 stars: 11 votes

4 stars: 25 votes

5 stars: 14 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!