The Comprehensive SQL Course

A bootcamp designed to help you master SQL and work with databases like Oracle, MySQL and Microsoft SQL Server
The Comprehensive SQL Course
File Size :
1.76 GB
Total length :
6h 28m

Category

Instructor

Malvik Vaghadia

Language

Last update

9/2022

Ratings

4.5/5

The Comprehensive SQL Course

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

The Comprehensive SQL Course

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 perfect 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 languageThose with some experience looking to brush up on their SQL knowledgeNo 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 RENAMEData Query Language Commands using the SELECT statementData Manipulation Commands such as INSERT, UPDATE and DELETEData Control Language Commands such as GRANT and REVOKETransaction Control Language commands such as COMMIT and ROLLBACKData TypesQualifying Column NamesAliasing Columns and TablesRow Level FunctionsAggregation FunctionsThe Where ClauseThe Group By and Having ClausesThe Order By ClauseSingle Table and Multiple Table JoinsSET OperatorsSubqueriesDatabase ConstraintsRelational Databases and Data Model Design including STAR and SNOWFLAKE SchemasViews

Overview

Section 1: Intoduction To The Course And Set Up

Lecture 1 Course Overview

Lecture 2 Quick Note Before We Begin

Lecture 3 Getting Set Up On Oracle APEX

Lecture 4 Installing The Countries Dataset

Lecture 5 (OPTIONAL) – Manually Installing The Countries Dataset

Lecture 6 Oracle APEX Overview

Lecture 7 Exploring The Countries Sample Dataset

Lecture 8 Important infomation relating to Oracle APEX Sample Datasets

Lecture 9 What Is SQL?

Lecture 10 Tables

Lecture 11 Basic Database Terminology

Lecture 12 Your First SQL Query

Section 2: Data Types

Lecture 13 Section Overview

Lecture 14 String Data Types

Lecture 15 Numerical Data Types

Lecture 16 Date Data Types

Lecture 17 The Describe Statement

Lecture 18 Simple Mathematical Operators

Lecture 19 Guidance And Documentation On Data Types

Lecture 20 Useful External Links On Data Types

Section 3: SQL Commands

Lecture 21 Section Overview

Lecture 22 The 5 Types of SQL Commands

Lecture 23 Data Query Language

Lecture 24 Select Distinct

Lecture 25 Data Definition Language

Lecture 26 Note On String and Numerical Values

Lecture 27 Data Manipulation Language

Lecture 28 Data Control Language

Lecture 29 Transaction Control Language

Lecture 30 Assignment Questions

Lecture 31 Assignment Solutions Walkthrough

Lecture 32 Assignment Solutions (SQL Code)

Section 4: Qualifying Columns And Aliasing Table Names

Lecture 33 Section Overview

Lecture 34 Qualifying Columns

Lecture 35 Aliasing Table Names

Lecture 36 Qualified vs Unqualified Objects

Section 5: Operators And The Where Clause

Lecture 37 Section Overview

Lecture 38 Operators And The Where Clause

Lecture 39 Some Examples Using The Where Clause

Lecture 40 An Important Note About Case Sensitivity In SQL

Lecture 41 Introduction To The Case Statement

Lecture 42 Examples With The Case Statement

Lecture 43 Revisiting The DML Update Command

Lecture 44 Assignment Questions

Lecture 45 Assignment Solutions Walkthrough

Lecture 46 Assignment Solutions (SQL Code)

Section 6: Date, String And Mathematical Functions

Lecture 47 Section Overview

Lecture 48 Overview Of The Employees (EMP/DEPT) Data Model

Lecture 49 Installing The Employees (EMP/DEPT) Dataset

Lecture 50 (OPTIONAL) – Manually Installing The Employees (EMP/DEPT) Dataset

Lecture 51 The CAST Function

Lecture 52 Date Values and Formatting

Lecture 53 Date Functions

Lecture 54 String Functions

Lecture 55 Mathematical Functions

Lecture 56 Useful External Links On Functions

Lecture 57 Assignment Questions

Lecture 58 Assignment Solutions Walkthrough

Lecture 59 Assignment Solutions (SQL Code)

Section 7: Aggregate Functions And The Group By, Having & Order By Clauses

Lecture 60 Section Overview

Lecture 61 Aggregate Functions

Lecture 62 Count(*)

Lecture 63 Aggregate Functions And The Where Clause

Lecture 64 Aggregate Functions And Group By

Lecture 65 Single Column Group By

Lecture 66 Multi Column Group By

Lecture 67 Non-Aggregated Columns

Lecture 68 Group By And The Having Clause

Lecture 69 Group By On Numerical Fields

Lecture 70 Order By

Lecture 71 Order Of Execution

Lecture 72 Assignment Questions

Lecture 73 Assignment Solutions Walkthrough

Lecture 74 Assignment Solutions (SQL Code)

Section 8: Joining Tables

Lecture 75 Section Overview

Lecture 76 Introduction to the Join Operation

Lecture 77 Simple Join

Lecture 78 Joining Multiple Tables

Lecture 79 Joining On Multiple Columns

Lecture 80 Assignment Questions

Lecture 81 Assignment Solutions Walkthrough

Lecture 82 Assignment Solutions (SQL Code)

Section 9: Set Operators

Lecture 83 Section Overview

Lecture 84 Union / Union All

Lecture 85 Intersect

Lecture 86 Minus

Section 10: Query Order Of Execution And Subqueries

Lecture 87 Section Overview

Lecture 88 SQL Query Order Of Execution

Lecture 89 Fetch, Limit And Top

Lecture 90 Subqueries

Lecture 91 Subqueries And Joins

Lecture 92 Assignment Questions

Lecture 93 Assignment Solutions Walkthrough

Lecture 94 Assignment Solutions (SQL Code)

Section 11: Relational Data Model Basics And Database Constraints

Lecture 95 Section Overview

Lecture 96 Relational Databases

Lecture 97 Fact And Dimension Tables Revisited

Lecture 98 Star And Snowflake Schemas

Lecture 99 Types Of Relationships

Lecture 100 Primary Key and Foreign Key Constraints

Lecture 101 Other Important Constraints

Section 12: Views

Lecture 102 Section Overview

Lecture 103 What Are Views?

Lecture 104 Creating, Replacing And Dropping Views

Lecture 105 Simple And Complex Views

Lecture 106 Performing DML Operations On Simple Views

Section 13: The Question Bank: Bringing It All Together

Lecture 107 Section Overview

Lecture 108 Overview Of The Customer Orders Data Model

Lecture 109 Installing The Customer Orders Dataset

Lecture 110 (OPTIONAL) – Manually Installing The Customer Orders Dataset

Lecture 111 Question 1

Lecture 112 Question 1 Solution Walkthrough

Lecture 113 Question 1 Solution (SQL Code)

Lecture 114 Question 2

Lecture 115 Question 2 Solution Walkthrough

Lecture 116 Question 2 Solution (SQL Code)

Lecture 117 Question 3

Lecture 118 Question 3 Solution Walkthrough

Lecture 119 Question 3 Solution (SQL Code)

Lecture 120 Question 4

Lecture 121 Question 4 Solution Walkthrough

Lecture 122 Question 4 Solution (SQL Code)

Lecture 123 Question 5

Lecture 124 Question 5 Solution Walkthrough

Lecture 125 Question 5 Solution (SQL Code)

Lecture 126 Question 6

Lecture 127 Question 6 Solution Walkthrough

Lecture 128 Question 6 Solution (SQL Code)

Lecture 129 Question 7

Lecture 130 Question 7 Solution Walkthrough

Lecture 131 Question 7 Solution (SQL Code)

Lecture 132 Question 8

Lecture 133 Question 8 Solution Walkthrough

Lecture 134 Question 8 Solution (SQL Code)

Lecture 135 Question 9

Lecture 136 Question 9 Solution Walkthrough

Lecture 137 Question 9 Solution (SQL Code)

Section 14: Other Useful Bits

Lecture 138 Inserting Comments Into Your Code

Section 15: BONUS LECTURE: Next Steps

Lecture 139 Congratulations & Next Steps

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 Information:

Udemy | English | 6h 28m | 1.76 GB
Created by: Malvik Vaghadia

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top