Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Oracle SQL

The Complete Oracle SQL Certification Course

Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!
Bestseller
Rating: 4.6 out of 54.6 (25,096 ratings)
96,076 students
Created by Imtiaz Ahmad
Last updated 11/2020
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Course content

10 sections • 69 lectures • 16h 31m total length

  • Oracle Database Introduction & Basics of Tables
    Preview19:43
  • Creating the Workspace in Oracle
    Preview06:33
  • IMPORTANT: Prepare the Sample Data
    03:42
  • How to Proceed in This Course
    02:18

  • Oracle Exams and Certification Information
    00:27
  • Retrieving Data Using the SELECT Clause
    14:42
  • Using the WHERE Clause in a Query
    19:37
  • Using Operators in the WHERE Clause
    19:47
  • Some Inspiration
    02:33
  • Combining WHERE, AND & OR with Operators
    19:16
  • Query Filtering Continued BETWEEN, IN and NULL
    Preview20:02
  • What Will Make you Grow as a Software Developer
    03:10
  • Query Filtering Conditions & Operator Precedence
    19:56
  • Ordering, Concatenating & Aliasing Query Results
    20:00
  • Assignment 1: Practice with Single Table Queries
    02:27

  • Single Row Functions (SRF) & Using The Dual Table
    19:37
  • Using Functions in WHERE And Character Based SRFs
    20:00
  • Numeric and Date Data type SRFs
    19:53
  • Conversion SRFs and Date Formatting
    19:39
  • Some More Date Functions
    00:26
  • Concluding SRFs & NULL / NULLIF Functions
    16:18
  • Assignment 2: Practice with Single Row Functions
    03:05

  • Grouping Functions MIN, MAX, AVG, COUNT etc.
    19:42
  • GROUP BY Clause & HAVING Clause
    19:59
  • More Practice With The GROUP BY Clause
    12:12

  • SELECT within SELECT (Subqueries)
    23:58
  • Relating Tables Together Using JOINs
    19:21
  • Joins Continued INNER & OUTER Joins
    21:30
  • Career Advice
    01:28
  • Correlated Subqueries with EXISTS & NOT EXIST operators
    21:14
  • SELF JOIN
    11:10
  • CROSS JOIN, NATURAL JOIN and the USING CLAUSE
    08:43
  • EQUIJOIN and NON-EQUIJOINs
    09:38
  • CASE Statements
    08:40

  • OVER Clause with PARTITION BY
    18:31
  • Compute Running Totals with Ordering and Partitioning
    18:47
  • Unbounded Preceding Order in Over Clause
    08:42
  • Slicing Windows and Filtering with Analytic Functions
    05:59
  • Rank, Dense_rank, Lead, and Lag Functions
    15:05

  • Creating Your Own Tables & Design Considerations
    21:01
  • Inserting Data Into Our Table
    19:41
  • Create Table With a Primary Key Constraint
    21:35
  • INSERT ALL for Multi-table & Conditional Inserts
    11:24
  • Using ALTER to modify the table structure
    16:34
  • Create Table with SELECT + UPDATE Data
    19:56
  • MERGE Statement in Oracle
    16:57
  • Primary and Foreign Keys
    00:52
  • Sequence Statements
    12:27
  • DELETE, TRUNCATE, and DROP Commands
    18:50
  • Working With Database Indexes
    14:21
  • System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
    24:06
  • Views and Other Objects and Commands (Newly Added)
    23:33
  • SQL could be tricky, check this out!
    00:44
  • Granting and Revoking Privileges
    15:08
  • BECOME A SQL QUERY WIZARD!
    00:18
  • Bonus Lecture: Lifetime Access to All My Courses
    00:24

  • OFFSET and FETCH
    09:55
  • Preview18:34
  • Commit, Rollback, and Savepoint
    14:36
  • Large Objects and Interval Data Types
    17:33
  • Using Cascade Constraints and On Delete Cascade
    17:56
  • UNUSED Columns
    07:36
  • External Tables
    14:59
  • SQL Plus and Substitution Variables
    32:42

  • QA 1- DML, DDL, and Transaction Control
    24:19
  • QA 2- Fetch and Substitution Variables
    25:13
  • QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL
    28:50
  • Practice Test 1
    20 questions
  • Practice Test 2
    25 questions

  • Install Oracle Database 19c in Windows
    09:36
  • Install Oracle SQL Developer in Windows
    13:27

Requirements

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

Description

LAST UPDATED: November 2020

(Source Code Included for 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!

Featured review

Pratiksha deshmukh
Pratiksha deshmukh
17 courses
2 reviews
Rating: 4.5 out of 510 months ago
Hi im assistant professor, dbms is very easy subject as SQL is easy query language compared to other programming languages. So we think that we know it, but after studying this video, making things i forgot n some little stuff is new for me Explanation is in very simple language and amazing, i will definitely recommend this course to my students as well as who want to learn sql programming in detail. Thankyou for this amazing videos.

Instructor

Imtiaz Ahmad
Senior Software Engineer & Trainer @ Job Ready Programmer
Imtiaz Ahmad
  • 4.6 Instructor Rating
  • 67,650 Reviews
  • 263,628 Students
  • 12 Courses

Imtiaz is an award winning Udemy instructor who is highly experienced in big data technologies and enterprise software architectures. Imtiaz has spent a considerable amount of time building financial software on Wall St. and worked with companies like S&P, Goldman Sachs, AOL and JP Morgan along with helping various startups solve mission critical software problems. In his 13+ years of experience, Imtiaz has also taught software development in programming languages like Java, C++, Python, PL/SQL, Ruby and Javascript. He's the founder of Job Ready Programmer - an online programming school that prepares students of all backgrounds to become professional job-ready software developers through real-world programming courses.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.