The Complete Oracle SQL Certification Course

Focused View

Job Ready Programmer

16:27:30

7 View

01 - Database Basics

001 Oracle Database Introduction & Basics of Tables.mp4

19:43

002 Creating the Workspace in Oracle.mp4

06:33

003 IMPORTANT Prepare the Sample Data.mp4

03:42

003 course-data.txt

004 Dedicated TA Support.mp4

01:39

005 Join our Online Community (Discord).html

006 How to Proceed in This Course.mp4

02:18

02 - Single Table Queries (Exercises & Solutions in the Lectures)

001 Oracle Exams and Certification Information.html

002 Code-for-Select-Clause.txt

002 Retrieving Data Using the SELECT Clause.mp4

14:42

003 Code-for-WHERE-Clause.txt

003 Using the WHERE Clause in a Query.mp4

19:37

004 Important Information from Instructor.mp4

03:35

005 Code-for-Using-Operators-in-the-WHERE-Clause.txt

005 Using Operators in the WHERE Clause.mp4

19:47

006 Some Inspiration.mp4

02:33

007 Code-for-Combining-WHERE-AND-OR-Operators.txt

007 Combining WHERE, AND & OR with Operators.mp4

19:16

008 Code-for-Query-Filtering-Continued-BETWEEN-IN-NULL.txt

008 Query Filtering Continued BETWEEN, IN and NULL.mp4

20:02

009 What Will Make you Grow as a Software Developer.mp4

03:10

010 Code-for-Query-Filtering-Conditions-Operator-Precedence.txt

010 Query Filtering Conditions & Operator Precedence.mp4

19:56

011 Code-for-Ordering-Concatenating-Aliasing-Query-Results.txt

011 Ordering, Concatenating And Aliasing Query Results.mp4

19:58

012 Assignment 1 Practice with Single Table Queries.html

03 - Single Row Functions (Exercises and Solutions In the Lectures)

001 Code-for-Single-Row-Functions-SRF-Using-the-Dual-Table.txt

001 Single Row Functions (SRF) & Using The Dual Table.mp4

19:37

002 Code-for-Using-Functions-in-WHERE-and-Character-Based-SRFs.txt

002 Using Functions in WHERE And Character Based SRFs.mp4

20:00

003 Code-for-Numeric-and-Date-Datatype-SRFs.txt

003 Numeric and Date Data type SRFs.mp4

19:53

004 Code-for-Conversion-SRFs-Date-Formatting.txt

004 Conversion SRFs and Date Formatting.mp4

19:39

005 Some More Date Functions.html

006 Code-for-Concluding-SRFs-NULL-NULLIF-Functions.txt

006 Concluding SRFs & NULL NULLIF Functions.mp4

16:18

007 Assignment 2 Practice with Single Row Functions.html

04 - Grouping Functions (Exercises and Solutions In the Lectures)

001 Code-for-Grouping-Functions-MIN-MAX-AVG-COUNT-etc.txt

001 Grouping Functions MIN, MAX, AVG, COUNT etc.mp4

19:42

002 Code-for-GROUP-BY-Clause-HAVING-CLAUSE.txt

002 GROUP BY Clause & HAVING Clause.mp4

19:59

003 Code-for-More-Practice-with-the-GROUP-BY-Clause.txt

003 More Practice With The GROUP BY Clause.mp4

12:12

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)

001 Code-for-SELECT-within-SELECT-Nested-Queries-Subqueries.txt

001 SELECT within SELECT (Subqueries).mp4

23:58

002 Code-for-Relating-Tables-together-using-JOINs.txt

002 Relating Tables Together Using JOINs.mp4

19:21

003 Code-for-JOINS-Continued-INNER-OUTER-Joins.txt

003 Joins Continued INNER & OUTER Joins.mp4

21:30

004 Career Advice.mp4

01:28

005 Code-for-More-JOINS-with-Correlated-Subqueries.txt

005 Correlated Subqueries with EXISTS & NOT EXIST operators.mp4

21:14

006 SELF JOIN.mp4

11:10

007 CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4

08:43

008 Code-for-EQUI-and-NON-EQUI-Joins.txt

008 EQUIJOIN and NON-EQUIJOINs.mp4

09:38

009 CASE Statements.mp4

08:40

009 Code-for-CASE-Statement.txt

009 Oracle-COALESCE-Function.pdf

06 - Analytical Functions using OVER and PARTITION with ORDER BY

001 OVER Clause with PARTITION BY.mp4

18:31

002 Compute Running Totals with Ordering and Partitioning.mp4

18:47

003 Unbounded Preceding Order in Over Clause.mp4

08:42

004 Slicing Windows and Filtering with Analytic Functions.mp4

05:59

005 Rank, Dense rank, Lead, and Lag Functions.mp4

15:05

006 Assignment Application of Window Functions and SELF JOIN.html

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)

001 Code-for-Creating-Your-Own-Tables-Design-Considerations.txt

001 Creating Your Own Tables & Design Considerations.mp4

21:01

002 Code-for-Inserting-Data-Into-our-Table.txt

002 Inserting Data Into Our Table.mp4

19:41

003 Code-for-Create-Table-With-Primary-Key-Constraint.txt

003 Create Table With a Primary Key Constraint.mp4

21:35

004 Code-for-Multi-Table-Insert-Using-INSERT-ALL.txt

004 INSERT ALL for Multi-table & Conditional Inserts.mp4

11:24

005 Code-for-Alter-Table-and-Modify-Column-Attributes.txt

005 Using ALTER to modify the table structure.mp4

16:34

006 Code-for-Create-Table-with-SELECT-and-UPDATE-existing-Data.txt

006 Create Table with SELECT + UPDATE Data.mp4

19:56

007 Code-for-MERGE-Statement.txt

007 MERGE Statement in Oracle.mp4

16:57

007 merge-sql-example.txt

008 Primary and Foreign Keys.html

009 Sequence Statements in Oracle.mp4

12:28

010 Code-for-Delete-Truncate-and-Drop-Commands.txt

010 DELETE, TRUNCATE, and DROP Commands.mp4

18:50

011 Code-for-Database-Indexes.txt

011 Working With Database Indexes.mp4

14:21

012 Code-for-System-Tables-Pseudo-Columns-Deleting-Duplicate-Data.txt

012 System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4

24:06

013 Code-for-Other-Objects-and-Commands-VIEWs-UNION-ALL-etc.txt

013 Views and Other Objects and Commands (Newly Added).mp4

23:33

014 SQL could be tricky, check this out!.html

015 Granting and Revoking Privileges.mp4

15:08

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071

001 OFFSET and FETCH.mp4

09:55

002 ERD Diagrams.mp4

18:34

003 Commit, Rollback, and Savepoint.mp4

14:37

004 Large Objects and Interval Data Types.mp4

17:33

004 code-for-building-lease-example.txt

005 Using Cascade Constraints and On Delete Cascade.mp4

17:56

005 code-for-cascade-constraints.txt

006 UNUSED Columns.mp4

07:37

007 External Tables.mp4

15:00

007 code-for-external-tables.txt

008 SQL Plus and Substitution Variables.mp4

32:42

09 - Exam Question Walkthrough Videos + 2 Exams

001 QA 1- DML, DDL, and Transaction Control.mp4

24:19

002 QA 2- Fetch and Substitution Variables.mp4

25:13

003 QA 3 - Conversion Functions, TO CHAR, NVL, and TO DATE.mp4

28:50

004 Practice Test 1.html

005 Practice Test 2.html

10 - APPENDIX - Installing Oracle on Windows

001 Install Oracle Database 19c in Windows.mp4

09:36

002 Install Oracle SQL Developer in Windows.mp4

13:27

11 - Course Extras!

001 Bonus Lecture.html

Description

Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!

What You'll Learn?

Become Job Ready to Start Contributing as a Database Developer Day 1
Program in the SQL Language to Solve a Variety of Database Problems
Code along with me to PRACTICE and IMPLEMENT everything you learn
Become a SQL Ninja and Understand How the Oracle Database Works
MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam
Obtain the Skills that are Necessary to Land a Job as a SQL Developer
Have the Ability to Solve any SQL Problem

Who is this for?

Anyone willing to get into the software development career

Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer

Anyone willing to work hard in mastering the SQL language

Anyone who is interested in passing the Oracle 1Z0-071 exam!

What You Need to Know?

Absolutely no programming experience is required to master the content in this course

More details

Description
LASTÂ UPDATED:Â JuneÂ 2023
(Added a Comprehensive Assignment on Analyzing Sales data)
(Source Code Included for ALL Lectures)
Get ready to acquire some seriously marketable programming skills! You can't consider yourself a complete end to end developer until you can code inÂ SQL. Today, data has become the hottest topic in technology and a company's biggest asset is their data. All databases require the languageÂ SQLÂ to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 - $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we're going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you've completed the course (in 2 months), you can call your self anÂ OracleÂ SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in justÂ 1 month of studyÂ and practice.
All exercises and solutions are in the lectures. In severalÂ lectures IÂ ask students to pause the video and complete the assignment before resuming to watch my solution. MAKEÂ SUREÂ YOUÂ WORKÂ OUTÂ THEÂ PROBLEMSÂ ONÂ YOURÂ OWNÂ BEFOREÂ MOVINGÂ ONÂ TOÂ MYÂ SOLUTION!!

With over 62,000 enrolled students and a 4.5 star-rating, this is a Udemy best-selling course.

Do you have no prior experience in SQL development? This course is perfect for you. Don't take it from me, take it from actual students that took this course:
"I am a beginner and the way this course starts is perfect for the person who has no introduction of SQL or Oracle."

Do you have prior experience, but need a refresher or to fine-tune your skills? This is the course for you. Again, I'll let my students do the talking:
"I had a good base of knowledge from my last employment. This course is constantly proving useful to supercharge my actual knowledge base. Very good one!"

Have you taken a SQL course before, but felt confused on certain topics or not completely satisfied in your abilities? A lot of my students had shared similar concerns:
"I had previously taken a college course about databases and SQL, but these ten hours of content were more clear and useful than the course and textbook."

Topics covered in this course :
Basics of Tables
SELECT and WHERE Clause
WHERE, AND & OR with Operators
BETWEEN, IN and NULL
Single Table Queries
Single Row Functions
Grouping Functions
GROUPÂ BY and HAVINGÂ Clause
Joins
Inner and Outer Joins
EXISTS & NOT EXIST Operators
Creating Your Own Tables
Using ALTER
Creating Tables with SELECT & UPDATE Data
DELETE, TRUNCATE, and DROP Commands
System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
Views and Other Objects and Commands (Newly Added)
Who this course is for:
Anyone willing to get into the software development career
Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer
Anyone willing to work hard in mastering the SQL language
Anyone who is interested in passing the Oracle 1Z0-071 exam!

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Job Ready Programmer

Instructor's Courses

You can’t learn programming from reading books or online fill-in-the-blank type tutorials. Especially the online tutorials with browser based exercises where you code directly in your browser. The problem with that approach is that it doesn’t provide practical experience. It provides an illusion of learning something as it tugs you along to complete an assignment that’s more of a fill-in-the-blank type problem. A student feels like they’ve learned something but that knowledge does not stick. Unfortunately that experience will not help in an interview nor an actual project. Valuable time ends up going to complete waste. At JRP (JobReadyProgrammer), we don’t follow hype. We do what works! We take a traditional route to teaching how to code advancing slowly & patiently in the lectures often repeating key concepts in multiple different ways to help students really solidify the knowledge and mold their foundation to discover how to code properly and then boy do we test the skills! Students are put right in the middle of a practical real-world programming assignment to apply everything they've learned. So enough of those “key in the next few commands to fill in the puzzle and we’ll advance you” kind of tutorials. Here you’ll need to roll up your sleeves and get to work on solving practical programming assignments.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.