The Comprehensive SQL Course

The Comprehensive SQL Course

The Comprehensive SQL Course

A bootcamp designed to help you master SQL and work with databases like Oracle, MySQL and Microsoft SQL Server

Language: english

Note: 4.6/5 (321 notes) 35,218 students

Instructor(s): Malvik Vaghadia

Last update: 2021-09-18

What you’ll learn

  • Become proficient in SQL
  • Students will be able to apply SQL to real world problems
  • Boost your CV with one of the most in-demand skills in the data analysis and software development professions
  • Apply what you’ve learnt across different database management systems
  • Oracle SQL
  • MySQL
  • Microsoft SQL Server

 

Requirements

  • Absolutely no prior knowledge required

 

Description

Want to learn one of the most in-demand skills in the business and technology sector?

Then this course is for you!

SQL skills are highly marketable everywhere, especially in companies like Netflix, Facebook, Amazon, Google… the list goes on and on… The simple fact is that if you want to do any work involving data, then the chances are that you need to know SQL!

This course has been designed for:

  • Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language

  • Those with some experience looking to brush up on their SQL knowledge

No downloads or software installation required! We will be using Oracle APEX which is a web-based application – you will be set up with your own virtual database hosted on the cloud! Although we will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.

The lectures in this course are arranged into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every technical section of the course will be rounded off with quizzes / assignments and give you an opportunity to develop your practical skills.

The course will provide students with an extensive Question Bank section which is full of questions and walkthroughs designed to emulate real world scenarios and combine together all of the different SQL clauses, operations and commands taught in this course!

In this course you will learn about:

  • Data Definition Language Commands such as CREATE, DROP, TRUNCATE, ALTER and RENAME

  • Data Query Language Commands using the SELECT statement

  • Data Manipulation Commands such as INSERT, UPDATE and DELETE

  • Data Control Language Commands such as GRANT and REVOKE

  • Transaction Control Language commands such as COMMIT and ROLLBACK

  • Data Types

  • Qualifying Column Names

  • Aliasing Columns and Tables

  • Row Level Functions

  • Aggregation Functions

  • The Where Clause

  • The Group By and Having Clauses

  • The Order By Clause

  • Single Table and Multiple Table Joins

  • SET Operators

  • Subqueries

  • Database Constraints

  • Relational Databases and Data Model Design including STAR and SNOWFLAKE Schemas

  • Views

 

Who this course is for

  • Beginners looking to learn SQL
  • Individuals with prior SQL knowledge looking to refresh their SQL skills
  • Individuals looking to pursue a career in software engineering, business intelligence or data analsysis

 

Course content

  • Intoduction To The Course And Set Up
    • Course Overview
    • Quick Note Before We Begin
    • Getting Set Up On Oracle APEX
    • Installing The Countries Dataset
    • (OPTIONAL) – Manually Installing The Countries Dataset
    • Oracle APEX Overview
    • Exploring The Countries Sample Dataset
    • Important infomation relating to Oracle APEX Sample Datasets
    • What Is SQL?
    • Tables
    • Basic Database Terminology
    • Your First SQL Query
    • Quiz
  • Data Types
    • Section Overview
    • String Data Types
    • Numerical Data Types
    • Date Data Types
    • The Describe Statement
    • Simple Mathematical Operators
    • Guidance And Documentation On Data Types
    • Useful External Links On Data Types
    • Quiz
  • SQL Commands
    • Section Overview
    • The 5 Types of SQL Commands
    • Data Query Language
    • Select Distinct
    • Data Definition Language
    • Note On String and Numerical Values
    • Data Manipulation Language
    • Data Control Language
    • Transaction Control Language
    • Assignment Questions
    • Assignment Solutions Walkthrough
    • Assignment Solutions (SQL Code)
  • Qualifying Columns And Aliasing Table Names
    • Section Overview
    • Qualifying Columns
    • Aliasing Table Names
    • Qualified vs Unqualified Objects
    • Quiz
  • Operators And The Where Clause
    • Section Overview
    • Operators And The Where Clause
    • Some Examples Using The Where Clause
    • An Important Note About Case Sensitivity In SQL
    • Introduction To The Case Statement
    • Examples With The Case Statement
    • Revisiting The DML Update Command
    • Assignment Questions
    • Assignment Solutions Walkthrough
    • Assignment Solutions (SQL Code)
  • Date, String And Mathematical Functions
    • Section Overview
    • Overview Of The Employees (EMP/DEPT) Data Model
    • Installing The Employees (EMP/DEPT) Dataset
    • (OPTIONAL) – Manually Installing The Employees (EMP/DEPT) Dataset
    • The CAST Function
    • Date Values and Formatting
    • Date Functions
    • String Functions
    • Mathematical Functions
    • Useful External Links On Functions
    • Assignment Questions
    • Assignment Solutions Walkthrough
    • Assignment Solutions (SQL Code)
  • Aggregate Functions And The Group By, Having & Order By Clauses
    • Section Overview
    • Aggregate Functions
    • Count(*)
    • Aggregate Functions And The Where Clause
    • Aggregate Functions And Group By
    • Single Column Group By
    • Multi Column Group By
    • Non-Aggregated Columns
    • Group By And The Having Clause
    • Group By On Numerical Fields
    • Order By
    • Order Of Execution
    • Assignment Questions
    • Assignment Solutions Walkthrough
    • Assignment Solutions (SQL Code)
  • Joining Tables
    • Section Overview
    • Introduction to the Join Operation
    • Simple Join
    • Joining Multiple Tables
    • Joining On Multiple Columns
    • Assignment Questions
    • Assignment Solutions Walkthrough
    • Assignment Solutions (SQL Code)
  • Set Operators
    • Section Overview
    • Union / Union All
    • Intersect
    • Minus
    • Quiz
  • Query Order Of Execution And Subqueries
    • Section Overview
    • SQL Query Order Of Execution
    • Fetch, Limit And Top
    • Subqueries
    • Subqueries And Joins
    • Assignment Questions
    • Assignment Solutions Walkthrough
    • Assignment Solutions (SQL Code)
  • Relational Data Model Basics And Database Constraints
    • Section Overview
    • Relational Databases
    • Fact And Dimension Tables Revisited
    • Star And Snowflake Schemas
    • Types Of Relationships
    • Primary Key and Foreign Key Constraints
    • Other Important Constraints
    • Quiz
  • Views
    • Section Overview
    • What Are Views?
    • Creating, Replacing And Dropping Views
    • Simple And Complex Views
    • Performing DML Operations On Simple Views
    • Quiz
  • The Question Bank: Bringing It All Together
    • Section Overview
    • Overview Of The Customer Orders Data Model
    • Installing The Customer Orders Dataset
    • (OPTIONAL) – Manually Installing The Customer Orders Dataset
    • Question 1
    • Question 1 Solution Walkthrough
    • Question 1 Solution (SQL Code)
    • Question 2
    • Question 2 Solution Walkthrough
    • Question 2 Solution (SQL Code)
    • Question 3
    • Question 3 Solution Walkthrough
    • Question 3 Solution (SQL Code)
    • Question 4
    • Question 4 Solution Walkthrough
    • Question 4 Solution (SQL Code)
    • Question 5
    • Question 5 Solution Walkthrough
    • Question 5 Solution (SQL Code)
    • Question 6
    • Question 6 Solution Walkthrough
    • Question 6 Solution (SQL Code)
    • Question 7
    • Question 7 Solution Walkthrough
    • Question 7 Solution (SQL Code)
    • Question 8
    • Question 8 Solution Walkthrough
    • Question 8 Solution (SQL Code)
    • Question 9
    • Question 9 Solution Walkthrough
    • Question 9 Solution (SQL Code)
  • Other Useful Bits
    • Inserting Comments Into Your Code
  • BONUS LECTURE: Next Steps
    • Congratulations & Next Steps

 

Time remaining or 705 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate