Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle SQL: The Ultimate Crash Course

Name: Oracle SQL: The Ultimate Crash Course
Rating: 4.4 (75 reviews)

[5 DAYS COURSE] Kick Start SQL Development Career Employing 25,000 Hours Worth of Intensive Database Experience

Created byBrainiwi Education

Last updated 2/2021

English

What you'll learn

NO Database Installation Required
6 Months of High Quality Preparation
Kick Start SQL Developer Career
Work as SQL Developer Freelancer
Write Complex SQL Statements
Work With Oracle Databases

Course content

8 sections • 72 lectures • 7h 39m total length

Brief Overview6: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.
[Slides] Brief Overview10:00
Presentation slides for the introductory lecture.
[Document] Oracle environment preparation steps3:00
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 using the following links:
Official Website: www.virtualbox.org

*Update February 2021*
Prepare Oracle VM5: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.
Startup database and run Toad on Oracle VM2:01
Startup the Oracle database BRAINIWIPDB using startup DB script then open Toad application and connect to the HR sample schema

Day 2 Table of contents2:00
Topics covered in day 2.
First SQL Statement8:58
Learn to write your first SELECT statement in few minutes.
DISTINCT keyword5:41
Return only unique results from your SELECT statement using DISTINCT.
Code comments6:16
Make your code more readable and communicate with other developers with universal code commenting guidelines.
ORDER BY clause8:25
Sort returned query results with ORDER BY clause.
WHERE clause3:18
Filter records to get only required data by adding a WHERE condition to your query.
Comparison operators17:54
Use comparison operators to compare different values and tune SELECT conditions.
AND/OR operators8:36
Extend WHERE conditions and make them more complex and more powerful.
IN operator4:32
Filter set of values from returned data.
LIKE operator10:20
Search inside specific text value with LIKE operator.
Concatenation operator ||3:15
Append multiple strings for better representation.
Mathematical operators3:05
Mathematical operators that can be used with SQL language.
Mathematical operators precedence7:32
Mathematical operators do not execute without a sequence. They execute as per the precedence rules.
Aliases8:55
Rename your output titles for better representation of data.
[Slides] Retrieving Data18:00
Presentation slides for retrieving data lectures.
[Riddles] SELECT Statement
[BrainTeasers] SQL Challenges0:03
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.

Day 3 Table of contents2:22
Topics covered in day 3.
Functions and DUMMY table4:46
Get introduced to functions and understand why DUMMY tables are used.
Text manipulation functions6:58
Learn the functions that deal with text values.
Date & time manipulation functions8:53
Know the functions that can be used with date and time datatypes.
Numeric manipulation functions5:57
Use numeric functions for building complex calculation expressions.
Aggregate functions15:44
Practice those powerful functions that can produce amazing reports.
GROUP BY clause7:38
Enhance the representation of aggregate functions by grouping the results.
HAVING clause10:11
Filter data returned on the level of aggregate functions.
SELECT statement structure3:09
Revisiting previous clauses and get the full picture of their sequence and neccessity.
[Slides] Functions14:00
Presentation slides for the functions lectures.
[Riddles] Functions and Grouping
[BrainTeasers] SQL Challenges0:03
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.

Day 4 Table of contents2:08
Topics covered in day 4.
Subqueries15:14
How powerful they are!! Try subqueries anywhere in your query.
Relational tables2:21
Understand the basics of RDBMS.
Introduction to joins12:26
They are the most powerful capability in SQL language.
Equijoins10:42
Associate different tables for higher data accessability.
Self joins5:35
Join different instances of the same table to get deeper level of details.
Outer joins4:32
Can not find specific data from your query!!! Try outer joins.
Cartesian product4:12
Get every output possible from associated tables.
SET operators4:15
Not satisfied with joins and subqueries!!! Go for even a higher level of connectivity.
UNION operator4:45
Understand the usage of UNION operator.
UNION ALL operator2:41
How UNION ALL differs from UNION operator!!
INTERSECT operator2:42
Just get the common results.
MINUS operator5:04
Ignore the results coming from specific query.
[Slides] Join and Subquery17:00
Presentation slides for joins and subqueries lectures.
[Riddles] Joins, subqueries and SET operators
[BrainTeasers] SQL Challenges0:03
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.

Day 5 Table of contents2:29
Topics covered in day 5.
Data Manipulation Language (DML) and Transactions6:17
SELECT is not the only thing out there. Understand how transactions form during database interactions.
INSERT statement8:41
Add new data to your table.
UPDATE statement10:02
Change existing data in the table.
DELETE statement6:49
Do not want specific data!! remove it.
Data Definition Language (DDL)3:00
Change the structure of your database objects.
Constraints2:05
Trash in trash out. Do no allow this.
CREATE TABLE statement8:24
Create your first table.
CREATE TABLE as SELECT2:10
Want to copy another table with its data!!! Try this one.
ALTER TABLE statement2:40
Change your table structure.
TRUNCATE TABLE statement2:23
Flush everything in your table instantly.
DROP TABLE statement2:30
Your table is of no use!!! Drop it.
Dealing with Views8:21
The use of views is inevitable. What are they!!!
Final words2:42
Wrap it up.
[Slides] Changing Reality23:00
Presentation slides for the changing reality lectures.
[Riddles] Transactions and other parts of SQL
[BrainTeasers] SQL Challenges0:03
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.

Requirements

FREE Oracle Virtual Machine Database Image
NO Prior Database / SQL Experience Required

Description

*** Highest Rated Course in SQL Category ***

IMPORTANT NOTE: VM download URLs can be found in pdf file in under Section 1 Lecture 3. Please let us know immediately if you are experiencing issues downloading or preparing Oracle VM.

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 practising 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, enrol 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:

Preconfigured Oracle database 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 practising SQL
Oracle database installation documentation
Presentation lectures in downloadable PDF format
ER Diagram of Oracle database 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 this course is for:

Students / Grads Planning to Start Their Career in Databases
ICT Professionals Seeking Quick Start Course in SQL Within Few Hours
Web Developers Who Use Databases in Their Websites
Data Analysts Need to Add SQL to Their Skill Set
Trainers Interested in Adding SQL Programming to Their Course Catalog
Oracle Functional Consultants Who Want Quick Introduction to SQL
Database / System Administrators

Oracle SQL: The Ultimate Crash Course

What you'll learn

Explore related topics

Course content

What is it all about!5 lectures • 27min

Day 1: The Concepts4 lectures • 33min

Day 2: Retrieving Data16 lectures • 1hr 57min

Day 3: Functions11 lectures • 1hr 20min

Day 4: Join and Subquery15 lectures • 1hr 34min

Day 5: Changing Reality16 lectures • 1hr 32min

Appendix I: Oracle DB Installation & Configuration3 lectures • 10min

Appendix II: Auxiliary Documents2 lectures • 8min

Requirements

Description

Who this course is for: