Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL: The Ultimate Crash Course to your Wishlist.

Add to Wishlist

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.6 (43 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,280 students enrolled
Last updated 4/2016
English
$10 $120 92% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 4 Articles
  • 13 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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.
View Curriculum
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
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 72 Lectures Collapse All 72 Lectures 07:39:36
+
What is it all about!
5 Lectures 14:19

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.
Preview 06:48

Presentation slides for the introductory lecture.

[Slides] Brief Overview
10 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.

[Document] Oracle environment preparation steps
3 pages

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.

Preview 05:30

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

Startup database and run Toad on Oracle VM
02:01
+
Day 1: The Concepts
4 Lectures 19:31

The history of database and applications on daily life.

Preview 07:28

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

Database Components
05:10

Get introduced to database tables and other important elementary concepts.

Table Components
06:53

Presentation slides for the concepts lectures.

[Slides] The Concepts
13 pages

Questions: 10

Required Time: 15 Minutes

[Riddles] Database Concepts
10 questions
+
Day 2: Retrieving Data
16 Lectures 01:38:50

Topics covered in day 2.

Day 2 Table of contents
02:00

Learn to write your first SELECT statement in few minutes.

First SQL Statement
08:58

Return only unique results from your SELECT statement using DISTINCT.

DISTINCT keyword
05:41

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

Code comments
06:16

Sort returned query results with ORDER BY clause.

ORDER BY clause
08:25

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

WHERE clause
03:18

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

Comparison operators
17:54

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

AND/OR operators
08:36

Filter set of values from returned data.

IN operator
04:32

Search inside specific text value with LIKE operator.

Preview 10:20

Append multiple strings for better representation.

Concatenation operator ||
03:15

Mathematical operators that can be used with SQL language.

Mathematical operators
03:05

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

Mathematical operators precedence
07:32

Rename your output titles for better representation of data.

Aliases
08:55

Presentation slides for retrieving data lectures.

[Slides] Retrieving Data
18 pages

Questions: 21

Required Time: 35 Minutes

[Riddles] SELECT Statement
21 questions

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.

[BrainTeasers] SQL Challenges
00:03
+
Day 3: Functions
11 Lectures 01:05:41

Topics covered in day 3.

Day 3 Table of contents
02:22

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

Preview 04:46

Learn the functions that deal with text values.

Text manipulation functions
06:58

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

Date & time manipulation functions
08:53

Use numeric functions for building complex calculation expressions.

Numeric manipulation functions
05:57

Practice those powerful functions that can produce amazing reports.

Aggregate functions
15:44

Enhance the representation of aggregate functions by grouping the results.

GROUP BY clause
07:38

Filter data returned on the level of aggregate functions.

HAVING clause
10:11

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

SELECT statement structure
03:09

Presentation slides for the functions lectures.

[Slides] Functions
14 pages

Questions: 14

Required Time: 25 Minutes

[Riddles] Functions and Grouping
14 questions

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.

[BrainTeasers] SQL Challenges
00:03
+
Day 4: Join and Subquery
15 Lectures 01:16:40

Topics covered in day 4.

Day 4 Table of contents
02:08

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

Subqueries
15:14

Understand the basics of RDBMS.

Relational tables
02:21

They are the most powerful capability in SQL language.

Introduction to joins
12:26

Associate different tables for higher data accessability.

Equijoins
10:42

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

Self joins
05:35

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

Outer joins
04:32

Get every output possible from associated tables.

Cartesian product
04:12

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

SET operators
04:15

Understand the usage of UNION operator.

UNION operator
04:45

How UNION ALL differs from UNION operator!!

UNION ALL operator
02:41

Just get the common results.

INTERSECT operator
02:42

Ignore the results coming from specific query.

MINUS operator
05:04

Presentation slides for joins and subqueries lectures.

[Slides] Join and Subquery
17 pages

Questions: 12

Required Time: 15 Minutes

[Riddles] Joins, subqueries and SET operators
12 questions

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.

[BrainTeasers] SQL Challenges
00:03
+
Day 5: Changing Reality
16 Lectures 01:08:36

Topics covered in day 5.

Day 5 Table of contents
02:29

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

Data Manipulation Language (DML) and Transactions
06:17

Add new data to your table.

INSERT statement
08:41

Change existing data in the table.

UPDATE statement
10:02

Do not want specific data!! remove it.

DELETE statement
06:49

Change the structure of your database objects.

Data Definition Language (DDL)
03:00

Trash in trash out. Do no allow this.

Constraints
02:05

Create your first table.

CREATE TABLE statement
08:24

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

CREATE TABLE as SELECT
02:10

Change your table structure.

ALTER TABLE statement
02:40

Flush everything in your table instantly.

TRUNCATE TABLE statement
02:23

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

DROP TABLE statement
02:30

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

Dealing with Views
08:21

Wrap it up.

Final words
02:42

Presentation slides for the changing reality lectures.

[Slides] Changing Reality
23 pages

Questions: 18

Required Time: 30 Minutes

[Riddles] Transactions and other parts of SQL
18 questions

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.

[BrainTeasers] SQL Challenges
00:03
+
Appendix I: Oracle DB Installation & Configuration
3 Lectures 09:59

Download database installation files from www.oracle.com

Download installation files
02:11

Steps required to install Oracle database 12c

Oracle database 12c installation
06:07

Steps required to install Oracle database client 12c

Oracle database client 12c installation
01:41
+
Appendix II: Auxiliary Documents
2 Lectures 00:00

ER diagram of HR sample schema

[ER Diagram] HR Entity Relationship Diagram
1 page

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

[Mind Maps] Course summary
7 pages
About the Instructor
4.5 Average rating
101 Reviews
3,683 Students
3 Courses
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.

Report Abuse