The Complete Oracle SQL Certification Course

The Complete Oracle SQL Certification Course
The Complete Oracle SQL Certification Course

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 10 Hours | 1.53 GB
eLearning | Skill level: All Levels

Don’t just learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!

Get ready to acquire some seriously marketable programming skills! You can’t consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company’s biggest asset is their data. All databases require the language SQL to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 – $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we’re going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you’ve completed the course (in 2 months), you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in just 1 month of study and practice.

What you’ll learn

  • Become Job Ready to Start Contributing as Database Developer Day 1
  • Pass the Oracle SQL Fundamentals Examinations
  • Program in the SQL Language to solve a variety of Database Problems
  • Be a SQL Ninja and understand how the Oracle Database Works
+ Table of Contents

Database Basics
1 Oracle Database Introduction & Basics of Tables
2 Setting Up the SQL Development Environment (Mac & Windows)
3 IMPORTANT Prepare the Data in the Database

Single Table Queries (Exercises & Solutions in the Lectures)
4 Oracle Exams and Certification Information
5 Retrieving Data Using the SELECT Clause
6 Using the WHERE Clause in a Query
7 Using Operators in the WHERE Clause
8 Combining WHERE, AND & OR with Operators
9 Query Filtering Continued BETWEEN, IN and NULL
10 Query Filtering Conditions & Operator Precedence
11 Ordering, Concatenating & Aliasing Query Results

Single Row Functions (Exercises and Solutions In the Lectures)
12 Single Row Functions (SRF) & Using The Dual Table
13 Using Functions in WHERE And Character Based SRFs
14 Numeric and Date Data type SRFs
15 Conversion SRFs & Date Formatting
16 Some More Date Functions
17 Concluding SRFs & NULL NULLIF Functions

Grouping Functions (Exercises and Solutions In the Lectures)
18 Grouping Functions MIN, MAX, AVG, COUNT etc.
19 GROUP BY Clause & HAVING Clause
20 More Practice With The GROUP BY Clause

Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)
21 SELECT within SELECT (Subqueries)
22 Relating Tables Together Using JOINs
23 Joins Continued INNER & OUTER Joins
24 Correlated Subqueries with EXISTS & NOT EXIST operators

Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)
25 Creating Your Own Tables & Design Considerations
26 Views and Other Objects and Commands (Newly Added)
27 SQL could be tricky, check this out!
28 Granting and Revoking Privileges
30 Bonus Lecture Lifetime Access to All My Courses
31 Inserting Data Into Our Table
32 Create Table With a Primary Key Constraint
33 Using ALTER to modify the table structure
34 Create Table with SELECT + UPDATE Data
35 Primary and Foreign Keys
36 DELETE, TRUNCATE, and DROP Commands
37 Working With Database Indexes
38 System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)