The Complete Oracle SQL Certification Course

Description

In this course, you will learn:

• Become Job Ready to Start Contributing as a Database Developer Day 1
• Program in the SQL Language to Solve a Variety of Database Problems
• Code along with me to PRACTICE and IMPLEMENT everything you learn
• Become a SQL Ninja and Understand How the Oracle Database Works
• MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam
• Obtain the Skills that are Necessary to Land a Job as a SQL Developer
• Have the Ability to Solve any SQL Problem

Syllabus:

• Database Basics
• Single Table Queries (Exercises & Solutions in the Lectures)
• Single Row Functions (Exercises and Solutions In the Lectures)
• Grouping Functions (Exercises and Solutions In the Lectures)
• Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)
• Analytical Functions using OVER and PARTITION with ORDER BY
• Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)