Oracle SQL A Complete Developer Guide (2023)

Oracle SQL – A Complete Developers Guide (2023), available at $84.99, has an average rating of 4.5, with 114 lectures, 20 quizzes, based on 121 reviews, and has 485 subscribers.

You will learn about Comprehensive course in SQL as per 100% Oracle University syllabus + Bonus 1 topics Learn SQL and get a job as Database Developer Well structured program to learn quickly learn and apply on projects from day 1 Instructor is having real time IT experience in SQL 19 Years!! Course will help to clear Oracle SQL Certification (1Z0-071) 100+ 1Z0-071 certification questions Oracle holds 46% share in commercial market space. So learn SQL with the best Database- Oracle ! Learn SQL using Oracle Platform and can apply on any RDBMS like MySQL, Sybase, MS SQL Server etc. Covered concepts from 11g to 21c Multitenant Architecture with 21c Installation + PDB + Local & Common user creation. All scripts files are attached (50 downladable resource) Wants to be an Expert SQL developer! This course is ideal for individuals who are Who wants to start a career as Database Developer or Developers preparing for Oracle SQL certification (1Z0-071) or ETL developers who wants to improve query writing skills It is particularly useful for Who wants to start a career as Database Developer or Developers preparing for Oracle SQL certification (1Z0-071) or ETL developers who wants to improve query writing skills.

Enroll now: Oracle SQL – A Complete Developers Guide (2023)

Summary

Title: Oracle SQL – A Complete Developers Guide (2023)

Price: $84.99

Average Rating: 4.5

Number of Lectures: 114

Number of Quizzes: 20

Number of Published Lectures: 87

Number of Published Quizzes: 19

Number of Curriculum Items: 134

Number of Published Curriculum Objects: 106

Original Price: ?4,499

Quality Status: approved

Status: Live

What You Will Learn

Comprehensive course in SQL as per 100% Oracle University syllabus + Bonus 1 topics

Learn SQL and get a job as Database Developer

Well structured program to learn quickly learn and apply on projects from day 1

Instructor is having real time IT experience in SQL 19 Years!!

Course will help to clear Oracle SQL Certification (1Z0-071)

100+ 1Z0-071 certification questions

Oracle holds 46% share in commercial market space. So learn SQL with the best Database- Oracle !

Learn SQL using Oracle Platform and can apply on any RDBMS like MySQL, Sybase, MS SQL Server etc.

Covered concepts from 11g to 21c

Multitenant Architecture with 21c Installation + PDB + Local & Common user creation.

All scripts files are attached (50 downladable resource)

Wants to be an Expert SQL developer!

Who Should Attend

Who wants to start a career as Database Developer

Developers preparing for Oracle SQL certification (1Z0-071)

ETL developers who wants to improve query writing skills

Target Audiences

Who wants to start a career as Database Developer

Developers preparing for Oracle SQL certification (1Z0-071)

ETL developers who wants to improve query writing skills

Change History:

Features added / updated.                                                  

+ Created the course on 07/16/2020.

+ Added 18C XE installation Guide (Lecture: 5 Resource) on 01/07/2021.

+ Added Multitenant Architecture + 21C XE installation + PDB, local & common user creation on 02/06/2023.

+ Bonus lecture: Lecture: 85, 86 & 87

+ Added 10 code challenges 03/12/2023.

ORACLE UNIVERSITY COURSE (1Z0-071)

Relational Database concepts

Explaining the theoretical and physical aspects of a relational database

Relating clauses in SQL Select Statement to Components of an ERD

Explaining the relationship between a database and SQL

Restricting and Sorting Data

Applying Rules of precedence for operators in an expression

Limiting Rows Returned in a SQL Statement

Using Substitution Variables

Using the DEFINE and VERIFY commands.

Sorting Data

Using Conversion Functions and Conditional Expressions

Applying the NVL, NULLIF, and COALESCE functions to data.

Understanding implicit and explicit data type conversion

Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Nesting multiple functions

Displaying Data from Multiple Tables

Using Self-joins

Using Various Types of Joins

Using Non equijoins

Using OUTER joins

Understanding and Using Cartesian Products

Using SET Operators

Matching the SELECT statements.

Using the ORDER BY clause in set operations

Using The INTERSECT operator.

Using The MINUS operator

Using The UNION and UNION ALL operators

Managing Indexes Synonyms and Sequences

Managing Indexes

Managing Synonyms

Managing Sequences

Managing Views

Managing Views

Managing Objects with Data Dictionary Views

Using data dictionary views

Retrieving Data using the SQL SELECT Statement

Using Column aliases

Using The SQL SELECT statement.

Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

Using Arithmetic expressions and NULL values in the SELECT statement.

Using Single-Row Functions to Customize Output

Manipulating strings with character functions in SQL SELECT and WERE clauses.

Performing arithmetic with date data

Manipulating numbers with the ROUND, TRUNC and MOD functions

Manipulating dates with the date function

Reporting Aggregated Data Using Group Functions

Restricting Group Results

Creating Groups of Data

Using Group Functions

Using Subqueries to Solve Queries

Using Single Row Subqueries

Using Multiple Row Subqueries

Update and delete rows using correlated subqueries.

Managing Tables using DML statements

Managing Database Transactions

Controlling transactions

Perform Insert, Update and Delete operations.

Performing multi table Inserts

Performing Merge statements

Use DDL to manage tables and their relationships.

Describing and Working with Tables

Describing and Working with Columns and Data Types

Creating tables

Dropping columns and setting column UNUSED

Truncating tables

Creating and using Temporary Tables

Creating and using external tables

Managing Constraints

Controlling User Access

Differentiating system privileges from object privileges

Granting privileges on tables

Distinguishing between granting privileges and roles

Managing Data in Different Time Zones

Working with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP

Working with INTERVAL data types

This course designed to learn Oracle SQL step by step and master it.

Database Developer are mostly sought and highly paid job (60,000 – 100,000$ per year).

You can learn SQL and clear Oracle certification 1Z0-071 (OCA- Oracle Certified Associate), It will give boast to your career as a Pro-SQL Programmer.

1Z0-071 question after each topic will help you to clear the certification.

It is also much easier to master the language as there is no prerequisite to learn SQL.

I have around 19 years of real time IT experience as an Architect in Database related technologies. This course is prepared based steps by step approach with real time coding standards and best practices in the industry, what I have learned in my career.

It will definitely helpful all the aspirant who wants to join IT industry as database developer.

The Trainer is an Architect with over 19+ years of experience, he has spent 15+ years working with SQL

An Oracle Certified Professions (OCP)

Oracle Technology Network (OTN) Points:12,975 Level:Master

Be a Pro- Oracle SQL Developer | Clear Oracle Certified Associate Exam | A Complete SQL Bootcamp!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to RDBMS

Chapter 2: Introduction to SQL

Lecture 1: Relationship between a database and SQL

Lecture 2: SQL Select Statement to Components of an ERD

Chapter 3: Environment Setup

Lecture 1: Versions of Oracle, Live Oracle cloud account creation, demo data setup

Lecture 2: Oracle 11g- XE installation

Lecture 3: Work is SQL*PLUS and SQL Developer

Chapter 4: Basic SQL

Lecture 1: Schema, Alias, Prefix, what is *

Lecture 2: How to restrict data using WHERE clause, Data sorting by ORDER BY clause

Lecture 3: Substitution variables – VERIFY, DEFINE , UNDEFINE

Lecture 4: Row Limiting Clause for Top-N Queries – 12C

Lecture 5: Code Challenge – 01

Lecture 6: Solution Code Challenge – 01

Lecture 7: Code Challenge – 02

Lecture 8: Solution Code Challenge – 02

Lecture 9: Code Challenge – 03

Lecture 10: Solution Code Challenge – 03

Chapter 5: Operators

Lecture 1: Unary and Binary Operators

Lecture 2: Comparison Operator (=,<>,>,<,<=,>=, BETWEEN, NOT IN, IN ,IS NULL, IS NOT NULL)

Lecture 3: Comparison Operator ( Wildcard Search LIKE, NOT LIKE)

Lecture 4: Logical operators (NOT, AND , OR)

Lecture 5: Arithmetic operators (+ Addition , – Minus , * Multiplication , / Division )

Lecture 6: Arithmetic operators Precedence

Lecture 7: Character operators ( || )

Lecture 8: Set operators ( UNION, UNION ALL, INTERSECT, INTERSECT ALL, MINUS )

Lecture 9: Code Challenge – 04

Lecture 10: Solution Code Challenge – 04

Lecture 11: Code Challenge – 05

Lecture 12: Solution Code Challenge – 05

Chapter 6: Oracle Built-in Single row functions

Lecture 1: Numeric Function (ABS, FLOOR, CEIL, MOD, POWER, SIGN, TRUNC_ROUND, WIDTH_BUCKET)

Lecture 2: Character Function (CONCAT, REPLACE, SUBSTR, INSTR, UPPER, LOWER, LAPD, RPAD)

Lecture 3: Date Functions (SYSDATE, LAST_DAY, ROUND, TRUNC, ADD_MONTHS, MONTHS_BETWEEN)

Lecture 4: Conversion Function (TO_DATE, TO_CHAR, TO_TIMESTAMP, TO_NUMBER)

Lecture 5: Nesting Functions

Lecture 6: NULL Functions (NVL, NVL2, COALESCE, NULLIF)

Lecture 7: Code Challenge – 06

Lecture 8: Solution Code Challenge – 06

Chapter 7: Oracle Built-Group function or Aggregate functions

Lecture 1: Group or Aggregate Function (MAX, MIN, AVG, COUNT, SUM)

Lecture 2: Rows to Columns & vice-versa – PIVOT, UNPIVOT

Lecture 3: Analytical Functions -1 (ROW_NUMBER, RANK, DENSE_RANK, FIRST, LAST, LISTAGG)

Lecture 4: Analytical Functions -2 (LEAD, LAG)

Lecture 5: Code Challenge – 07

Lecture 6: Solution Code Challenge – 07

Lecture 7: Code Challenge – 08

Lecture 8: Solution Code Challenge – 08

Chapter 8: Hierarchical queries

Lecture 1: Hierarchical queries Functions (CONNECT BY PRIOR, LEVEL, SYS_CONNECT_BY_PATH)

Lecture 2: Hierarchical queries writing

Lecture 3: Code Challenge – 09

Lecture 4: Solution Code Challenge – 09

Chapter 9: Query Types

Lecture 1: Subquery, Co-related Sub query, Inline Views

Lecture 2: Co-related Subquery with EXISTS clause

Lecture 3: Update and Delete using Co-related Subquery

Lecture 4: Code Challenge – 10

Lecture 5: Solution Code Challenge – 10

Chapter 10: CASE Statement

Lecture 1: CASE Statement

Lecture 2: DECODE

Chapter 11: Displaying Data from Multiple Tables

Lecture 1: Outer joins (Left, Right, Full)

Lecture 2: Self-joins , Equijoin, Non equijoins, Outer joins

Chapter 12: Table

Lecture 1: Table Creation, Data Types

Lecture 2: Data dictionary and comments on columns and Table

Lecture 3: Temporary Tables

Lecture 4: External Table

Chapter 13: SQL Command

Lecture 1: DDL – CREATE, ALTER, MODIFY ,TRUNCATE ,Make Column UNUSED and Drop UNUSED column

Lecture 2: DML – Insert, Update, Delete, Merge

Lecture 3: DML – Multiple Insert

Lecture 4: DCL- GRANT and REVOKE

Lecture 5: Transaction – COMMIT, ROLLBACK , SAVE POINT

Chapter 14: Constraints

Lecture 1: Constraints (NOT NULL, PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK)

Chapter 15: Indexes

Lecture 1: B-Tree (Balanced Tree)

Lecture 2: Bitmap Index

Lecture 3: Function based index

Chapter 16: Other Objects

Lecture 1: Sequence

Lecture 2: Synonyms

Instructors

Global Trainers
Technical Architect

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 8 votes

4 stars: 24 votes

5 stars: 87 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!