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 CBT
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 SQL

Advanced SQL : SQL Expert Certification Preparation Course

Complete Your Oracle SQL Knowledge From Intermediate to Advanced Level and Become a Database SQL Expert in Oracle!
Bestseller
Rating: 4.3 out of 54.3 (1,920 ratings)
22,164 students
Created by Oracle Master Training • 80,000+ Students Worldwide, Code Star Academy
Last updated 2/2021
English
English, Indonesian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • All the advanced subjects that you need for SQL Expert Certification
  • Learn Advanced SQL Query with Hundreds of Examples!
  • Write, Read, Analyze Any Advanced SQL Codes Easily
  • Over 125+ Lectures, 12+ Hours On-Demand Content
  • Learn Advanced SQL Functions in Oracle
  • Get a Better Job and Income!
  • Analytical SQL Functions in Oracle
  • Regular Expressions
  • Introducing Database Objects
  • Creating and Using Indexes
  • Creating and Using Views
  • Creating and Using Synonyms
  • Creating and Using Sequences
  • Data Dictionary Views
  • Using Advanced Subqueries
  • Generating (Dynamic) SQL Scripts
  • Advanced Data Manipulations
  • Advanced Aggregation Techniques
  • Windowing functions for working with ordered data sets
  • Lifetime Support from the Authors
  • Working Materials
  • Weekly Quizzes & Assessments
Curated for the Udemy for Business collection

Course content

19 sections • 138 lectures • 13h 5m total length

  • Preview01:23
  • UDEMY 101: How to Use Udemy? +Some Useful Tips
    05:01

  • Preview03:02
  • Which Option to Choose to Have a Database?
    09:07
  • Option 1: Having the Database with the Oracle Virtual Box
    16:29
  • Option 1: How to Install the Virtual Box on Mac OS X?
    01:36
  • Preview03:13
  • Preview18:18
  • Option 2: Unlocking the HR Schema
    07:34
  • Option 2: Configuring and Using the SQL Developer
    22:14
  • Option 3: Using Oracle Live SQL
    07:40
  • Option 3: About Oracle Live SQL Restrictions
    00:20
  • The Sample (HR) Schema Used in This Course
    07:23

  • Introducing Database Objects and Reaching Another User's Objects
    09:37
  • Reaching Another User's Objects
    06:20
  • The Working Document
    00:16
  • Don't Forget to Leave a Rating!
    00:19
  • Code Samples
    09:46
  • Quiz 1
    5 questions

  • What Are Data Dictionary Views?
    01:15
  • What Is There In Data Dictionary Views?
    01:12
  • Dictionary Table
    03:18
  • Differences Between USER, ALL, DBA, V$ Prefixes
    01:30
  • USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views
    09:13
  • USER_TABLES View
    05:11
  • USER_TAB_COLUMNS View
    05:04
  • User Constraints View
    09:47
  • USER_CONS_COLUMNS View
    05:28
  • USER_TAB_COMMENTS & USER_COL_COMMENTS Views
    03:42
  • Quiz 2
    10 questions

  • What is a Sequence and Why is It Used For?
    01:27
  • Creating Sequences
    06:42
  • Modifying Sequences
    02:47
  • Dropping Sequences
    01:23
  • Preview09:08
  • Using Sequences As a Default Value
    04:30
  • Sequence Caching
    02:28
  • User Sequences
    02:29
  • Quiz 3
    8 questions

  • What Is a Synonym and Why Is It Used For?
    02:32
  • Creating & Dropping Synonyms
    07:03
  • Using Synonyms
    02:34
  • Analyzing USER_SYNONYMS
    03:43
  • Quiz 4
    5 questions

  • What is an Index and Why is It Used For?
    02:43
  • Types of Indexes
    02:32
  • Preview08:02
  • Creating Index on Table Creation
    07:43
  • Function Based Indexes
    04:52
  • Multiple Indexes With Same Columns
    09:04
  • Dropping Indexes
    02:51
  • USER_INDEXES and USER_IND_COLUMNS Views
    04:03
  • Quiz 5
    10 questions

  • What is a View and Why Is It Used For?
    03:04
  • Types Of Views
    01:58
  • Creating Simple Views
    12:25
  • Creating Complex Views
    04:35
  • Modifying Views
    03:37
  • Analyzing User Views
    03:20
  • Performing DML Operations with Views
    06:52
  • Using WITH CHECK OPTION Clause
    11:06
  • Preventing DML Operations on A View
    02:22
  • Dropping Views
    02:14
  • Quiz 6
    8 questions

  • What is a Materialized View and Why is it Used For?
    05:12
  • Creating Materialized Views Part 1
    06:32
  • Creating Materialized Views Part 2
    04:54
  • Complex Materialized Views
    03:49
  • Types of Refreshing Materialized Views
    10:02
  • Refreshing Materialized Views Manually
    10:39
  • Preview01:48
  • Quiz 7
    7 questions

  • Using Subqueries as a Source
    05:56
  • Scalar Subqueries
    09:11
  • Multiple Column Subqueries
    07:21
  • Correlated Subqueries
    04:18
  • EXISTS Operator
    05:16
  • NOT EXISTS Operator
    04:56
  • Using WITH Clause
    06:31
  • Using Recursive WITH Clause
    05:33
  • Inserting Data By Using a Subquery as a Target
    07:06
  • Manipulating Data by Using "WITH CHECK OPTION" Keyword
    06:24
  • Correlated Update
    06:15
  • Correlated Delete
    02:33
  • Quiz 8
    7 questions

Requirements

  • Need to know SQL in basic level
  • SQL Developer
  • Oracle Database Software

Description

"One", "Enough", "Ultimate" Course to make you an "SQL Expert!".

Advance Your SQL Knowledge and Get Better Income From Your Job, like $100k.

Get Oracle's SQL Expert Certification.

Oracle has two Certification Exams for SQL;

The first one (SQL Fundamentals) covers the basic subjects (All of these subjects are covered in my first course.)

The second one (SQL Expert) covers more advanced subjects including the basic ones. (All the advanced subjects (and more) for this exam are covered in this course.)

All the subjects are explained in detail, and exampled as many as I can do with Oracle's HR schema. You can check the subjects from Oracle's related pages.

Now, you are looking at a course that will make you pass this exam.

  • You can ask any questions about this course from discussion board.

  • Your questions will be answered as soon as possible.

You can check my website for more details.

What are you going to learn from this course? 

  • Introducing Database Objects

  • Data Dictionary Views

  • Creating, Using and Managing Sequences

  • Creating, Using and Analyzing Synonyms

  • Understanding and Using Indexes

  • Managing Views

  • Materialized Views

  • Creating and Using Advanced Subqueries

  • Advanced Data Manipulation

  • Controlling Schema Objects)

  • Administering User Privileges and Roles

  • Hierarchical Queries (Tree Structure)

  • Writing Advanced Scripts

  • Generating Dynamic SQL Scripts

  • Analytical SQL Functions

  • Regular Expressions

  • And much more beyond these... (+Quizzes, +Bonus Lectures, +New Updates)...

More?

  • Hundreds of Examples

  • Professional Course Design,

  • Well-organised Content

  • In-Depth Subjects (All subjects are explained with all details)

  • Lifetime Author Support.

Who this course is for:

  • This SQL Course is meant for who already know SQL in basic level and want to improve it to Advance.
  • It is not for newbies. Newbies can take my beginner courses by checking the Intructor Page

Featured review

Seng Kong
Seng Kong
18 courses
7 reviews
Rating: 5.0 out of 5a year ago
This is my third course with Mr Omer. As usual, despite the thick accent in the lectures and occasional grammatical errors (that sometimes cause confusions) in the teaching materials, Mr Omer is very knowledgeable about SQL and going through his course will definitely make you a better SQL user. I recommend this course for anyone who needs a SQL refresher. Looking forward to the next course with Mr Omer.

Instructors

Oracle Master Training • 80,000+ Students Worldwide
Oracle Architect & Best Selling Instructor
Oracle Master Training • 80,000+ Students Worldwide
  • 4.5 Instructor Rating
  • 16,598 Reviews
  • 84,439 Students
  • 7 Courses

I have been working for more than 20+ years on software development on many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 15+ years on SQL & PL/SQL programming using many different Oracle Technologies. And also I'm a software development manager for more than 15 years.

Currently, I work as a Project Manager on a huge database which has more than 20 million active-users, and at the same time, teaching SQL & PL/SQL and many programming languages such as Python, C, Java, PHP programming, etc.

Code Star Academy
Software Training Center | Over 80.000+ Successful Students
Code Star Academy
  • 4.5 Instructor Rating
  • 16,614 Reviews
  • 84,439 Students
  • 7 Courses

Hi, welcome to our courses.

'Code Star' Academy is a platform and community that teaches SQL & PL/SQL Development, SQL Tuning, Python Programming, Web Development and many Computer Science related topics. 

Through a passion for tech and what it means to be a Computer Scientist and Developer, Code Star Academy creates great courses, blog posts and videos to instruct, inspire and spread these topics across a large spectrum.

Our Mission, give others the opportunity to be part of an amazing field whilst teaching them the skills that will allow them to do so.

Our expertise areas are mainly:

★ Programming Languages (Python, SQL, PL&SQL, PHP, Java, etc.)

★ Database Development

★ Data Science

★ Big Data

★ Cloud Computing

★ Data Mining

★ Data Visualization

★ Data Security

★ Computer Security               

✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯

► Time is so precious so every second costs you money ($$$)

☞ Don't postpone your dreams ☜

✔ Enroll to our courses right now!

✔ Success is your destiny and we are waiting for you!

✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯

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