Oracle SQL - Step by Step SQL

Learn SQL and Become a Fee-Earning SQL Developer in 7 Weeks!

This comprehensive SQL course is designed to rapidly transform you from having zero SQL writing skills to a capable SQL developer ready to earn money. This fast, easy, and effective SQL course provides a one-stop-shop approach, covering everything you need to master SQL, from fundamental database concepts to writing powerful SQL queries for database interaction.

We’ll use a practical methodology to guide your thinking and help you construct effective SQL statements. For example, consider this common business need: a manager requests a report showing total sales volume for January, broken down by day and city. We'll walk through the thought process:

• Business Need: Generate a report with total sales volume for January, daily and by city.
• Questions to Build the SQL Query: What columns to select?
• SELECT: day, city, SUM(volume)
• Summary: SUM(volume)
• Preposition: FROM
• Table: SALES (containing sales order data)
• Filter: WHERE SALES_DATE BETWEEN '01-JAN-2015' AND '31-JAN-2015'
• Grouping: GROUP BY DAY, CITY

The corresponding SQL query is:

SELECT day, city, SUM(volume)
FROM sales
WHERE sales_date BETWEEN '01-JAN-2015' AND '31-JAN-2015'
GROUP BY day, city;

In this SQL course, you will learn:

• Relational Database Concepts: Build a strong foundation in database theory.
• Data Retrieval with SQL (SELECT): Master the art of querying data.
• Data Filtering (WHERE): Extract specific data based on business requirements.
• Table Manipulation (CREATE, ALTER): Create and modify database tables.
• SQL Joins: Combine data from multiple tables effectively.
• SQL GROUP BY & Aggregate Functions: Group data and calculate summaries.
• Data Combination (UNION, UNION ALL, INTERSECT, MINUS): Combine data from two or more tables.
• Table Constraints (CREATE, ALTER): Enforce data integrity.
• SQL Views (CREATE VIEW): Create virtual tables for simplified access.
• Database Objects (SYNONYMS, SEQUENCES): Create other essential database objects.
• User Access Control (GRANT, REVOKE): Manage user permissions.
• SQL Performance Optimization (CREATE INDEX): Improve query speed.

Course Highlights:

• New Exercises Added: (Updated 04/06/2022)
• Closed Captions/Subtitles: Included for all lectures (Updated 01/04/2016)
• Practical Project Work: Apply your SQL skills to real-world scenarios and summarize the SQL concepts learned.

Software Used:

• Oracle Database 11g
• SQL Developer

Start your journey to becoming a skilled SQL developer today!