‘The Ultimate Oracle SQL Course: SQL Made Practical’ is a hands-on practical training program designed to help students learn Oracle SQL. The course covers Oracle Database 11g, 12c, 18c, and 19c. They are popular relational database management systems.
Unlike other Udemy SQL courses, this course focuses on how to write code, read, filter and sort data from a database and use various Oracle SQL functions. By the end of the course, students will be able to write basic to intermediate-level SQL queries. The course is usually available for INR 2,799 on Udemy but students can click on the link and get ‘The Ultimate Oracle SQL Course: SQL Made Practical’ for INR 449.
Who all can opt for this course?
- Aspiring database developers looking to upskill with fundamental SQL knowledge in order to advance in their careers.
- College/University students who need to learn SQL to pass their database-related course exams.
- Anyone who has basic SQL knowledge but is willing to master SQL language.
- This course is not for those who are seeking a theoretical course.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 449 ( |
| Duration | 13 hours |
| Rating | 4.6/5 |
| Student Enrollment | 17,493 students |
| Instructor | Carlos from Standout-Dev Academy https://www.linkedin.com/in/carlosdlg/ |
| Topics Covered | Basic database & SQL, filter & sorting results in SQL, SELECT statement, operators, subqueries, etc. |
| Course Level | Beginner |
| Total Student Reviews | 3,644 |
Learning Outcomes
- Access, filter, analyse, format, and present data from Oracle databases using Oracle SQL.
- Add, change, and remove data from Oracle databases using SQL.
- Edit Oracle SQL code that has been developed by others with confidence.
- Create the SQL code required to address the most typical issues seen in both practical work settings and academic exams.
- This course does not cover PL/SQL.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | Course Introduction (19 minutes) | Welcome to the Course and Curriculum Overview |
| Use Udemy’s Features Wisely! | ||
| Let’s run some SQL code right away! | ||
| How to take Full Advantage of the Course | ||
| 2. | Environment Setup (54 minutes) | Introduction |
| How to take the course without installing any program | ||
| Setting Up and using Apex to take the course on the browser | ||
| Using Live SQL to take the course on the browser | ||
| Downloading and installing Oracle Database Express Edition 18c | ||
| Taking the Course on a Mac or Windows “Home” Computer | ||
| Downloading and installing Oracle SQL Developer | ||
| Oracle SQL Developer Basics | ||
| 3. | Basic Database and SQL Concepts (29 minutes) | Introduction |
| Basic Database Concepts | ||
| What is SQL? | ||
| Basic Oracle Database Concepts and Architecture | ||
| The Multitenant Architecture | ||
| Basic Oracle Database Peculiarities | ||
| Section Recap (BC) | ||
| 4. | Retrieving information from the Database using SQL (The SELECT statement) (29 minutes) | Introduction to retrieving information from an Oracle database. |
| Creating the first Test Tables | ||
| Basic Oracle Datatypes | ||
| The SELECT Statement in its Simplest Form | ||
| Practice Challenge: Basic SELECT Statement | ||
| Column and Table Aliases in Oracle | ||
| Section Quiz (RIFD) | ||
| Solution to the practice challenges in this section (RIFD) | ||
| Section Recap (RIFD) | ||
| 5. | Filtering and Sorting Results in SQL (01 hour 11 minutes) | Introduction to filtering and sorting results from Oracle SQL queries. |
| Filtering Results (Introducing the WHERE Clause) | ||
| Practice Challenge: Filtering Results | ||
| More complex WHERE Conditions | ||
| Practice Challenge: More complex WHERE Conditions | ||
| Solution to the More Complex Conditions Challenge | ||
| Filtering Duplicate Rows (DISTINCT Clause) | ||
| Ordering the Results (ORDER BY Clause) Part 1 | ||
| Ordering the Results (ORDER BY Clause) Part 2 | ||
| Understanding and Handling NULLs | ||
| Practice Challenge: Understanding and Handling NULLs | ||
| Understanding and Handling NULLs Part 2 | ||
| NULL-handling Functions in Oracle SQL | ||
| Practice Challenge: NULL-handling Functions in Oracle SQL | ||
| NULL-handling Functions in Oracle SQL Part 2 | ||
| Practice Challenge: NULL-handling Functions in Oracle SQL Part 2 | ||
| Section Quiz (FSR) | ||
| Solution to the practice challenges in this section (FSR) | ||
| Section Recap (FSR) | ||
| 6. | Operators used in SQL (39 minutes) | Introduction to the use of Operators in Oracle SQL. |
| Comparison Operators (=,<,>,ANY,ALL) | ||
| SQL Operators (LIKE, IN, BETWEEN, IS NULL) | ||
| Practice Challenge: SQL Operators | ||
| Logical Operators (AND, OR, NOT) | ||
| Practice Challenge: Logical Operators | ||
| Substitution Variables | ||
| Practice Challenge: Substitution Variables | ||
| Section Quiz (O) | ||
| Solution to the practice challenges in this section (O) | ||
| Section Recap (O) | ||
| 7. | Group Operations in SQL (27 minutes) | Introduction to Group Operations in Oracle SQL. |
| Aggregate Functions (MIN, MAX, SUM, COUNT, AVG) | ||
| Practice Challenge: Aggregate Functions | ||
| Grouping Rows (The GROUP BY Clause) | ||
| Practice Challenge: Grouping Rows | ||
| Filtering Group Results (HAVING Clause) | ||
| Practice Challenge: Filtering Group Results | ||
| Section Quiz (GO) | ||
| Solution to the practice challenges in this section (GO) | ||
| Section Recap (GO) | ||
| 8. | Subqueries in SQL (01 hour 04 minutes) | Introduction to Subqueries in Oracle SQL. |
| Understanding Subqueries | ||
| Practice Challenge: Subqueries | ||
| Common Questions About Subqueries | ||
| Inline Views | ||
| Practice Challenge: Inline Views | ||
| Subquery Factoring (The WITH Clause) | ||
| Practice Challenge: Subquery Factoring | ||
| Top-N Queries (And Intro to ANALYTIC Functions) | ||
| Practice Challenge: Top-N Queries | ||
| The Row Limiting Clause | ||
| Practice Challenge: The Row Limiting Clause | ||
| Section Quiz (S) | ||
| Solution to the practice challenges in this section (S) | ||
| Section Recap (S) | ||
| 9. | Single Row SQL Functions (01 hour 46 minutes) | Introduction to Single Row Functions in Oracle SQL. |
| What is a Function? | ||
| Text Functions | ||
| Practice Challenge: Text Functions | ||
| Numeric Functions | ||
| Practice Challenge: Numeric Functions | ||
| Date Functions | ||
| Practice Challenge: Date Functions | ||
| Conversion Functions Part 1 | ||
| Conversion Functions Part 2 | ||
| Practice Challenge: Conversion Functions | ||
| Implicit Conversions Are Evil! | ||
| The DECODE Function and CASE Expressions | ||
| Practice Challenge: The DECODE Function and CASE Expressions | ||
| Date Arithmetic | ||
| Practice Challenge: Date Arithmetic | ||
| Section Quiz (F) | ||
| Solution to the practice challenges in this section (F) | ||
| Section Recap (F) | ||
| 10. | Transposing Rows into Columns and Columns into Rows with SQL (29 minutes) | Introduction |
| Solving the Problem with the Traditional Method | ||
| Pivot | ||
| Practice Challenge: Pivot | ||
| Unpivot | ||
| Practice Challenge: Unpivot | ||
| Section Quiz (TRC) | ||
| Solution to the practice challenges in this section (TRC) | ||
| Section Recap (TRC) | ||
| 11. | Analytic Functions in Oracle SQL (01 hour 25 minutes) | Introduction to the Analytic Functions Section |
| Analytic Functions Explained | ||
| The Partition Clause | ||
| Practice Challenge: The Partition Clause | ||
| The Analytic Order By Clause | ||
| The Windowing Clause | ||
| Practice Challenge: The Windowing Clause | ||
| Solution to the Windowing Clause Practice Challenge | ||
| Analytic COUNT, SUM, MIN and MAX | ||
| Practice Challenge: Common Analytic Functions | ||
| Ranking Functions | ||
| Practice Challenge: Ranking Functions | ||
| The LISTAGG Function | ||
| Practice Challenge: The LISTAGG Function | ||
| The LAG and LEAD Functions | ||
| Practice Challenge: The LAG and LEAD Functions | ||
| The FIRST and LAST Functions | ||
| Practice Challenge: The FIRST and LAST Functions | ||
| The FIRST_VALUE and LAST_VALUE Functions | ||
| Practice Challenge: The FIRST_VALUE and LAST_VALUE Functions | ||
| Section Quiz (AF) | ||
| Solution to the practice challenges in this section (AF) | ||
| Section Recap (AF) | ||
| 12. | Set Operators in SQL (26 minutes) | Introduction to Set Operators in Oracle SQL. |
| The UNION and UNION ALL Operators | ||
| Practice Challenge: The UNION and UNION ALL Operators | ||
| The INTERSECT Operator | ||
| Practice Challenge: The INTERSECT Operator | ||
| The MINUS Operator | ||
| Practice Challenge: The MINUS Operator | ||
| Combining Set Operators in the Same Query | ||
| Practice Challenge: Combining Set Operators in the Same Query | ||
| Section Quiz (SO) | ||
| Solution to the practice challenges in this section (SE) | ||
| Section Recap (SO) | ||
| 13. | Selecting Data from More than one Table with SQL (01 hour 00 minutes) | Introduction to SQL Joins. |
| Practice Challenge: Introduction to SQL Joins | ||
| Table Joins Explained | ||
| A more Complex Test Schema | ||
| Practice Challenge: Querying a more Complex Test Schema | ||
| Inner Joins | ||
| Practice Challenge: Inner Joins | ||
| Other Types of Joins (Equijoins, Non Equijoins, Self, Cross and Outer Joins) | ||
| Practice Challenge: Other Types of Joins | ||
| Outer Joins in Detail | ||
| Section Quiz (SDMT) | ||
| Solution to the practice challenges in this section (SDMT) | ||
| Section Recap (SDMT) | ||
| 14. | Hierarchical Queries in Oracle SQL (50 minutes) | Introduction |
| What is a Hierarchical Query? | ||
| The Hierarchical Query Clause | ||
| Practice Challenge: The Hierarchical Query Clause | ||
| Hierarchical Pseudo-Columns | ||
| Practice Challenge: Hierarchical Pseudo-Columns | ||
| Other Hierarchical Operators and Functions | ||
| Practice Challenge: Hierarchical Operators and Functions | ||
| Understanding The Execution of Hierarchical Queries | ||
| Practice Challenge: Understanding The Execution of Hierarchical Queries | ||
| Sorting The Results of Hierarchical Queries | ||
| Practice Challenge: Sorting The Results of Hierarchical Queries | ||
| Section Quiz (HQ) | ||
| Solution to the practice challenges in this section (HQ) | ||
| Section Recap (HQ) | ||
| 15. | Additional Practice (08 minutes) | SELECT statement extended practice |
| 16. | Changing the Contents of Database Tables with SQL (01 hour 24 minutes) | Introduction to Data Modification |
| Database Transactions | ||
| The INSERT Statement | ||
| Practice Challenge: The INSERT Statement | ||
| The UPDATE Statement | ||
| Practice Challenge: The UPDATE Statement | ||
| The DELETE Statement | ||
| Practice Challenge: The DELETE Statement | ||
| The MERGE Statement (Part 1) | ||
| The MERGE Statement (Part 2) | ||
| Practice Challenge: The MERGE Statement | ||
| Section Quiz (CCDT) | ||
| Solution to the practice challenges in this section (CCDT) | ||
| Section Recap (CCDT) | ||
| 17. | Data Definition Language (DDL) in SQL (01 hour 44 minutes) | Introduction to DDL in the Oracle database. |
| Creating, and Dropping Tables | ||
| Practice Challenge: Creating, and Dropping Tables | ||
| Changing the Definition of Tables | ||
| Practice Challenge: Changing the Definition of Tables | ||
| Adding, Dropping and Disabling Constraints | ||
| Practice Challenge: Constraints | ||
| Sequences | ||
| Practice Challenge: Sequences | ||
| Indexes (Part 1) | ||
| Indexes (Part 2) | ||
| Practice Challenge: Indexes | ||
| Views (Part 1) | ||
| Practice Challenge: Views 1 | ||
| Views (Part 2) | ||
| Practice Challenge: Views 2 | ||
| Section Quiz (DDL) | ||
| Solution to the practice challenges in this section (DDL) | ||
| Section Recap (DDL) | ||
| 18. | Controlling User Access – Data Control Language (DCL) (01 hour 10 minutes) | Introduction (CUA) |
| User Accounts Basics | ||
| Practice Challenge: User Accounts | ||
| User Privileges Part 1 | ||
| User Privileges Part 2 | ||
| Practice Challenge: User Privileges | ||
| User Roles | ||
| Practice Challenge: User Roles | ||
| Related Data Dictionary Views | ||
| Synonyms | ||
| Practice Challenge: Synonyms | ||
| Solution to the practice challenges in this section (CUA) | ||
| Section Recap (CUA) | ||
| 19. | Extras (11 minutes) | Solutions to the Extended Practice Problems (Section 15) |
| 20. | Conclusion (02 minutes) | Bonus |
| Conclusion |
Resources Required
- There is no prerequisite. Oracle SQL will be taught to students from scratch.
- Students should have a computer with Windows or Linux, where they can install and run applications.
Featured Review
Choppa Sairajesh (4/5): All the topics are explained briefly. It is an excellent course for beginners.
Pros
- Karunakaran K.S. (5/5): This course is a wonderful course for whom want to learn SQL from basics.
- George Vrettos (5/5): The instructor types as he speaks instead of just presenting code which I find the best way to of showcasing code.
- Thiru Ck (5/5): Practice makes the man perfect is the motto of this course.
- Vara Prasad Reddy Durgampudi (5/5): Yeah it matches my need and it’s awesome to be here.
Cons
- Vladislav T. (3/5): I think the DDL topics should be showed first, then, DML with deep dive into SELECT statement, and then Analytic functions as it is the most difficult topic of all course. Also the course could be more interactive and fun to do.
- Adi M. (3/5): Seems like it will be. There is too much conceptual theory at the very beginning. It would be better to get people going with sql in browser within 15 minutes or so. Then, once people get a chance to achieve something, drop in some more complex ideas about architecture and the db download locally.
- Udemy User (1.5/5): Practice questions solutions should be provided with detailed analysis.
About the Author
The instructor of this course is Carlos from Standout-Dev Academy. He is Software Development Director & Chief Educator. With a 4.6 instructor rating and 8,971 reviews on Udemy, he offers 2 courses and has taught 88,904 students so far.
- Carlos is the founder of the Standout Dev Academy. He is an accomplished systems engineer with a strong enthusiasm for software development and technology in general.
- He has more than 20 years of experience developing enterprise software and has worked with a variety of database management systems, which have enabled him to fully grasp the SQL language and its most well-known vendor-specific implementations.
- His main area of expertise is Oracle, having worked with Oracle databases on a daily basis for the past 18 years.
- His love for software development and entrepreneurial spirit also led him into the mobile industry, where he has created applications in his own time for a number of mobile platforms.
- He often blogs and contributes to the Oracle database community.
- Throughout the years, he has established a reputation as an authority in a variety of online forums and IT knowledge-sharing websites.
- He joined Udemy because he likes teaching and imparting his expertise and experience, in addition to software development.
Comparison Table
| Parameters | The Ultimate Oracle SQL Course: SQL Made Practical | The Complete Oracle SQL Certification Course | The Complete Oracle SQL Bootcamp (2023) |
|---|---|---|---|
| Offers | INR 449 ( | INR 449 ( | INR 449 ( |
| Duration | 13 hours | 16.5 hours | 38.5 hours |
| Rating | 4.6/5 | 4.6 /5 | 4.6 /5 |
| Student Enrollments | 17,486 | 158,793 | 69,311 |
| Instructors | Carlos from Standout-Dev Academy | Imtiaz Ahmad | Oracle Master Training | 200,000+ Students Worldwide |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this