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

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
29 BECOME A SQL QUERY WIZARD!
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)