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 Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-14 13:27:51
30-Day Money-Back Guarantee
Development Database Design & Development Oracle SQL

The Complete Oracle SQL Bootcamp (2021)

Become an In-demand SQL Professional & Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!
Bestseller
Rating: 4.5 out of 54.5 (5,613 ratings)
24,913 students
Created by Oracle Master Training • 80,000+ Students Worldwide, Code Star Academy
Last updated 2/2021
English
English [Auto], Italian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!
  • Be Able to Answer any SQL Interview Questions Confidently!
  • Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
  • Learn Oracle SQL by Professionally Designed Content Step by Step!
  • Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!
  • Solve any SQL-related Problems by Yourself Creating Analytical Solutions!
  • Test Your SQL Skills with Hundreds of Hands-on Examples, Quizzes, Challenges!
  • Lifetime Support from the Instructors. Get a Well-Organized Recap Document!
Curated for the Udemy for Business collection

Course content

19 sections • 151 lectures • 23h 7m total length

  • What is a Database?
    Preview07:44
  • Preview07:00
  • What is a Table?
    Preview03:40
  • UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
    05:01
  • Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples)
    00:34
  • What is a Relational Database (RDBMS)?
    07:52
  • Entity Relationship Logic in Databases
    03:46
  • What is Pluggable Database?
    03:13
  • Introduction to Database Objects
    13:26
  • The Sample (HR) Schema Used in This Course
    07:23
  • Preview05:02
  • Section 1 : Quiz
    10 questions

  • Preview03:02
  • Which Option to Choose to Have a Database?
    09:18
  • 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:41
  • Option 2: Downloading And Installing Oracle Database
    18: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: Warning About Oracle Live SQL Limitations
    00:33
  • SQL Statements Used in This Course
    05:29
  • The Working Document
    00:16
  • Don't Forget to Leave a Rating!
    00:13

  • Oracle Data Types
    06:54
  • What is a NULL Value?
    05:10
  • DESCRIBE Command
    04:25
  • INFORMATION Command
    08:13
  • SQL Statement Basics
    13:56
  • Oracle Error Messages
    06:51
  • Using SELECT Statements
    06:00
  • CODE: Using SELECT Statements
    00:05
  • Using Column Aliases
    07:26
  • CODE: Using Column Aliases
    00:10
  • Quote (Q) Operator
    08:53
  • Preview07:42
  • Concatenation Operators
    07:46
  • Arithmetic Expressions and NULL Values
    10:05
  • Section 2 : Quiz
    4 questions

  • Using WHERE Clause
    04:41
  • Comparison Operators
    06:33
  • BETWEEN … AND Operator
    05:48
  • IN Operator
    11:10
  • LIKE Operator
    11:21
  • IS NULL Operator
    05:21
  • Logical Operators (AND, OR, NOT)
    14:23
  • Rules of Precedence
    10:41
  • Preview12 pages
  • Section 3 : Quiz
    10 questions

  • ORDER BY Clause
    15:12
  • ASC and DESC Operators
    09:55
  • NULLS FIRST and NULLS LAST Operators
    04:24
  • ROWNUM & ROWID in SQL
    12:48
  • Oracle FETCH Clause
    13:02
  • Section 4 : Quiz
    5 questions

  • What is a Substitution Variable?
    15:50
  • Double Ampersand (&&) and DEFINE & UNDEFINE Commands
    18:52
  • ACCEPT and PROMPT Commands
    08:17
  • SET VERIFY ON / SET VERIFY OFF Commands
    08:07

  • Single Row Functions
    12:33
  • Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios
    15:12
  • Character Functions - Character Manipulation Functios (Part 1)
    14:27
  • Character Functions - Character Manipulation Functions Part 2 (INSTR Function)
    11:06
  • Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)
    20:15
  • Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)
    11:37
  • Numeric Functions
    16:32
  • Nested Functions
    15:24
  • Date Values & Date Formats in Oracle
    22:33
  • Date Functions & Arithmetic Operations on Dates
    16:43
  • Date Manipulation Functions in SQL
    19:20
  • Section 5 : Quiz
    5 questions

  • Conversion Functions
    10:23
  • TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)
    17:28
  • TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)
    16:17
  • Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions
    19:46
  • Section 6 : Quiz
    6 questions

  • Oracle Conditional Expressions: CASE Expressions
    22:23
  • Oracle Conditional Expressions: DECODE Function
    09:21
  • Section 7 : Quiz
    5 questions

  • Preview07:41
  • AVG Function
    09:31
  • COUNT Function
    06:06
  • MAX Function
    04:35
  • MIN Function
    04:16
  • SUM Function
    03:40
  • LISTAGG Function
    09:56
  • Overview Of Group Functions
    03:48
  • Section 8 : Quiz
    5 questions

Requirements

  • Nothing more than a working computer; all PC, Mac or Linux, etc. users are all welcome.
  • No previous programming experience is required!
  • No paid tools are required!

Description

★ Last Course Updates:

✔ (Feb, 2021): 3-Real SQL(200+ High-Quality Questions) Certification Exam Samples are added!

✔ (Jan, 2021): New Lectures and Quiz Questions are added!

✔ (Dec, 2020): English Closed-Captions are added!

Important Notice: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL.

Are you a student ready to learn SQL for your lessons?

Do you want to get a better job?

Are you bored with watching a lot of stuff, but could not learn anything?

Do you think you know SQL, but you cannot write SQL codes?

Are you looking for a really professional course?

Then this is the course you are looking for.

You have come to the right place!

In this course, all the subjects are explained in a professional order.

   If you are new to SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects.

   After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now.

   Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

So come on, what are you waiting for?

Get this course, and go get a better job!


✅ Benefits of Taking This SQL Course:

Knowing SQL can get you a better job or improve the one you have and it can earn you $80-100k+ in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, this is why it's so popular and backed by Oracle.

This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL codes easily and thinking analytically against the problem in your company.


✅ Student Reviews Prove This Course's Worth:

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high-quality audio/video.

Check out all of the great reviews in the review section ... a lot of happy students :-)


✅ Important Notice:

Knowing SQL is "mandatory" for any IT Professionals and having good SQL knowledge will be a "GREAT PLUS" for you!

If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you!

So let’s do this! I'll see you in the first lecture!

Who this course is for:

  • Anyone willing to step into the software development career!
  • Anyone dreaming to get a well-paid SQL Development Job!
  • Anyone planning to Pass the Oracle 1Z0-071 (OCA) exam!
  • Anyone who wants to Become an in-demand SQL Professional!

Featured review

Marlo Celestri
Marlo Celestri
46 courses
7 reviews
Rating: 4.5 out of 5a year ago
I can't explain how happy I am that I took this course. There is a good belance between explanation and demonstration. I think that's the perfect key to learn. I don't have to read my SQL school book anymore, Thanks :)

Instructors

Oracle Master Training • 80,000+ Students Worldwide
Oracle Architect & Best Selling Instructor
Oracle Master Training • 80,000+ Students Worldwide
  • 4.4 Instructor Rating
  • 16,554 Reviews
  • 84,164 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.4 Instructor Rating
  • 16,554 Reviews
  • 84,164 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.