Oracle SQL: The Ultimate Crash Course

Become an SQL Developer earning $70 - $100K by receiving 20,000 hours of database experience in one course
4.7 (36 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,217 students enrolled
$19
$120
84% off
Take This Course
  • Lectures 72
  • Length 7.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

Want a better lifestyle? Looking for a salary boost working as an Oracle SQL developer? Maybe seeking a career change for greater flexibility? Or feeling the freedom of earning money independently as a freelancer developer working under your own rules?

Whatever motivates you to become a professional SQL developer, you’re in the right place.

Oracle SQL ultimate crash course is the most cost-effective and career enhancing course you’ll ever find on the web. It’s the place where you can become an Oracle SQL developer from absolute zero in just 5 days and make dependable income.

Not only that but you will get unlimited access to a preconfigured Oracle database instance that have everything you need to start practicing immediately without delays.

Oracle is #1 database product in the world while SQL is simple, power and working under ANSI standards which means it can be used almost with any other database product. This powerful blend grants you a prestigious position and allows you to work with the world’s largest corporations.

Oracle SQL ultimate crash course will not only tech you how to code in SQL language but to understand the thinking process and the mindset of the developer. On the other hand, the riddles and BrainTeasers will complement your learning experience and transform you to a pro developer smoothly and surely.

You don’t have to believe what I’m saying, enroll and try yourself and you have 30 days money back guarantee if you don’t like what you have.


All what you’ll get here have unlimited access:

  • Pre-configured Oracle database 12c VM image
  • 59 lectures in widescreen HD quality, total of 7.5 hours
  • 75 quizzes [Riddles] for better material absorption
  • 58 Real-life scenarios [BrainTeasers] for practicing SQL
  • Oracle database 12c installation documentation
  • Presentation lectures in downloadable PDF format
  • ER Diagram of Oracle database 12c sample schema
  • [Mind Maps] contains illustrative summary of course contents

DO NOT waste your time and hard-earned money buying books, expensive courses or free videos on the internet. With Oracle SQL ultimate crash course you will get everything you need in one place conveniently accessible from anywhere.

You won’t be alone!!

I’ll be your senior developer who will help you all the way to get the best out of this course and to enhance the learning experience to become a complete workshop. You may seek for help at anytime through email, Udemy platform, Facebook, Twitter or Google+ and your right is to receive a quality and friendly assistance till you are satisfied with the results.

Join us and get Oracle VM, BrainTeasers and mind maps worth $279 exclusively for FREE

Forget about your age or knowledge level, just bring your laptop and let’s do this together. There is no reason to wait without taking action to change your life. Take this course and invest in the right place.

Here comes the best part:

  • NO previous experience required
  • NO Oracle setup required
  • NO additional materials needed

Anyone who ……. should take this course.

  • Want to apply for Oracle SQL Developer job
  • Desire to work as a freelancer developer
  • Want to start teaching SQL language
  • Want to use SQL in other applications like web development

Do something today that your future self will thank you for.

What are the requirements?

  • NO previous database, SQL or programming required to become an SQL Developer using this course.
  • NO Oracle setup required to start practicing this course! Ready-made virtual machine image was prepared specially for this course.
  • Download and configure "Oracle VM VirtualBox" software! Will be covered under "The Concepts".
  • Special package worth $279 is provided absolutely for FREE

What am I going to get from this course?

  • Apply for an SQL Developer full-time job.
  • Work as SQL Developer freelancer.
  • Teach Oracle SQL to other students.
  • Write complex SQL statements.
  • Configure PC/Laptop with Oracle database.

What is the target audience?

  • Anyone want to become a SQL Developer in few days without prior experience.
  • Anyone want to teach Oracle SQL course as a freelancer or full-time trainer.
  • Anyone who want to use SQL with other applications like web development
  • Fresh graduates who want to start their career as SQL Developers.
  • IT professionals who want to learn SQL language and concepts of databases in least possible time.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: What is it all about!
06:48

In this lecture:

  • Know your coach.
  • Advantages of learning SQL language.
  • Why choosing Oracle as a database product.
  • Other available databases in the market.
  • Database configuration structure.
  • Why this course is different!!!
  • How to benefit from this course.
10 pages

Presentation slides for the introductory lecture.

3 pages

Document contains the steps for preparing Oracle VM as well as the installation steps for Oracle database including the required configurations.

================================== IMPORTANT NOTE ==================================

You may now download VirtualBox software and Oracle Database VM from the following links;

Oracle VirtualBox URLs: 

  • Google Drive: https://goo.gl/m2uew9 
  • MEGA: https://goo.gl/9pnX6e 

Oracle Database 12c VM URLs: 

  • Google Drive: https://goo.gl/R61kg9 
  • MEGA: https://goo.gl/ZdXthm


Note: Links here are the most recent, please use those links if you experience issues using links attached in the document.

05:30

Install VirtualBox downloaded from Brainiwi google drive or from www.virtualbox.com and mount the VM image contains preconfigured Oracle database 12c downloaded from Brainiwi google drive.

02:01

Startup the Oracle database BRAINIWIPDB using startup DB script then open Toad application and connect to the HR sample schema

Section 2: Day 1: The Concepts
07:28

The history of database and applications on daily life.

05:10

Definition of database components and how they relate to one another.

06:53

Get introduced to database tables and other important elementary concepts.

13 pages

Presentation slides for the concepts lectures.

10 questions

Questions: 10

Required Time: 15 Minutes

Section 3: Day 2: Retrieving Data
02:00

Topics covered in day 2.

08:58

Learn to write your first SELECT statement in few minutes.

05:41

Return only unique results from your SELECT statement using DISTINCT.

06:16

Make your code more readable and communicate with other developers with universal code commenting guidelines.

08:25

Sort returned query results with ORDER BY clause.

03:18

Filter records to get only required data by adding a WHERE condition to your query.

17:54

Use comparison operators to compare different values and tune SELECT conditions.

08:36

Extend WHERE conditions and make them more complex and more powerful.

04:32

Filter set of values from returned data.

10:20

Search inside specific text value with LIKE operator.

03:15

Append multiple strings for better representation.

03:05

Mathematical operators that can be used with SQL language.

07:32

Mathematical operators do not execute without a sequence. They execute as per the precedence rules.

08:55

Rename your output titles for better representation of data.

18 pages

Presentation slides for retrieving data lectures.

21 questions

Questions: 21

Required Time: 35 Minutes

Article

Real life requirements to build SQL statements. Brain Teasers provide the correct way of thinking and breakdown of the process to effectively build the required SQL statement.

Section 4: Day 3: Functions
02:22

Topics covered in day 3.

04:46

Get introduced to functions and understand why DUMMY tables are used.

06:58

Learn the functions that deal with text values.

08:53

Know the functions that can be used with date and time datatypes.

05:57

Use numeric functions for building complex calculation expressions.

15:44

Practice those powerful functions that can produce amazing reports.

07:38

Enhance the representation of aggregate functions by grouping the results.

10:11

Filter data returned on the level of aggregate functions.

03:09

Revisiting previous clauses and get the full picture of their sequence and neccessity.

14 pages

Presentation slides for the functions lectures.

14 questions

Questions: 14

Required Time: 25 Minutes

Article

Real life requirements to functions with SQL statements. Brain Teasers provide the correct way of thinking and breakdown of the process to effectively build the required SQL statement.

Section 5: Day 4: Join and Subquery
02:08

Topics covered in day 4.

15:14

How powerful they are!! Try subqueries anywhere in your query.

02:21

Understand the basics of RDBMS.

12:26

They are the most powerful capability in SQL language.

10:42

Associate different tables for higher data accessability.

05:35

Join different instances of the same table to get deeper level of details.

04:32

Can not find specific data from your query!!! Try outer joins.

04:12

Get every output possible from associated tables.

04:15

Not satisfied with joins and subqueries!!! Go for even a higher level of connectivity.

04:45

Understand the usage of UNION operator.

02:41

How UNION ALL differs from UNION operator!!

02:42

Just get the common results.

05:04

Ignore the results coming from specific query.

17 pages

Presentation slides for joins and subqueries lectures.

12 questions

Questions: 12

Required Time: 15 Minutes

Article

Real life requirements to build joins and subqueries and understand the differences and applications of both. Brain Teasers provide the correct way of thinking and breakdown of the process to effectively build the required SQL statement.

Section 6: Day 5: Changing Reality
02:29

Topics covered in day 5.

06:17

SELECT is not the only thing out there. Understand how transactions form during database interactions.

08:41

Add new data to your table.

10:02

Change existing data in the table.

06:49

Do not want specific data!! remove it.

03:00

Change the structure of your database objects.

02:05

Trash in trash out. Do no allow this.

08:24

Create your first table.

02:10

Want to copy another table with its data!!! Try this one.

02:40

Change your table structure.

02:23

Flush everything in your table instantly.

02:30

Your table is of no use!!! Drop it.

08:21

The use of views is inevitable. What are they!!!

02:42

Wrap it up.

23 pages

Presentation slides for the changing reality lectures.

18 questions

Questions: 18

Required Time: 30 Minutes

Article

Real life requirements to the structure of database objects. Brain Teasers provide the correct way of thinking and breakdown of the process to effectively build the required SQL statement.

Section 7: Appendix I: Oracle DB Installation & Configuration
02:11

Download database installation files from www.oracle.com

06:07

Steps required to install Oracle database 12c

01:41

Steps required to install Oracle database client 12c

Section 8: Appendix II: Auxiliary Documents
1 page

ER diagram of HR sample schema

7 pages

Summary of course in the form of easy to understand mind maps for better acquisition of the material.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Brainiwi Education, Training Excellency

Imagine being able to learn a new skill or gain insight into a new language without having to leave the comfort of your own home! With Brainiwi’s online courses, this is now possible.

Online education courses are a part of a rapidly growing industry that promotes faster and more efficient learning. We at Brainiwi strive to provide our constantly expanding customer base with premium quality educational material that will help them develop their skill set and personal qualities, and advance in their career, regardless of the field.

Distance learning offers distinct advantages to thousands of students around the world. Apart from being flexible and easily adjusted to your daily schedule, Brainiwi online courses are based on extensive research and specifically developed for your individual level. Interesting in learning Arabic or taking up SQL language? You can get these (and many more!) educational courses directly from Brainiwi website. We devote a large portion of our time to research each and every content for our constantly growing number of courses in depth, to ensure that our material is not only correct, but also relevant to your field and up-to-date with the most recent advances. This means that with Brainiwi courses, you can easily expand your horizons, gain insights into various languages or fields, and quickly pick up important business skills, such as programming!

Launched in October 2015, we at Brainiwi already have more than 1500 satisfied students, learning from our material. We’re currently launching two types of educational courses: free and paid, targeted at developing different skill sets and suitable for various audiences. All of our online classes are currently hosted on the Udemy platform. The founders behind Brainiwi are a husband and a wife duo, each with more than 11 years of experience in IT consulting, human resources and education. They feel extremely passionate about helping others develop their abilities and skills, both in their professional and personal life, and providing them with well-researched online content that will aid their further career advancement. Their vision is to share their passion for knowledge with students from all parts of the globe, and turn Brainiwi into an influencer and a major player in the world of online learning.

Ready to start learning?
Take This Course