Complete Sql Megacourse: Beginner To Expert

Complete Sql Megacourse: Beginner To Expert
Published 5/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

Unlock the Full Potential of Data Management with the Ultimate SQL Mastery Course

What you’ll learn

Understand the fundamental concepts of SQL

The different databases commonly used in SQL, and how to choose and work with the appropriate database for your project

Overview of the history of SQL and its architecture and understand what a RDBMS is and how it works

Explore the different attributes and concepts in SQL, including data types, operators, keys, NULL values, and data integrity

SQL commands and expressions, including creating tables, dropping tables, selecting data, inserting data, updating data, and more

Understand aggregate functions, the HAVING clause, and how to use them to summarize data

Explore string and date/time functions in SQL and how to use them to manipulate data

How to use advanced SQL features such as views, indexes, and windows functions
Requirements

No previous knowledge of SQL required

A desire to learn!

A positive attitude!

Description

Overview

Section 1: Overview

Lecture 1 Introduction

Lecture 2 What is SQL

Lecture 3 What is a RDBMS

Lecture 4 What is a Table

Lecture 5 Common Rules

Lecture 6 List of Databases

Section 2: SQL Attributes and Concepts

Lecture 7 Data Types

Lecture 8 Operators in Detail

Lecture 9 Records vs. Rows

Lecture 10 Fields vs. Columns

Lecture 11 Keys

Lecture 12 SQL Constraints

Lecture 13 SQL Structure Overview

Section 3: SQL Commands and Expressions

Lecture 14 Create New Database

Lecture 15 Create Tables

Lecture 16 Insert Data

Lecture 17 The SELECT Statement

Lecture 18 The WHERE Clause

Lecture 19 Conjunctive Operators

Section 4: More with SQL

Lecture 20 Updated Queries

Lecture 21 The LIKE Clause

Lecture 22 The TOP Clause

Lecture 23 More Keys

Lecture 24 Get Unique Records

Lecture 25 Sorted Order

Lecture 26 Normal Forms

Section 5: SQL Exercises Section I

Lecture 27 Exercises Introduction

Lecture 28 Exercise Area 1-1

Lecture 29 Exercise Area 1-2

Lecture 30 Exercise Area 1-3

Lecture 31 Exercise Area 1-4

Lecture 32 Exercise Area 1-5

Lecture 33 Exercise Area 1-6

Lecture 34 Exercise Area 1-7

Lecture 35 Exercise Area 1-8

Lecture 36 Exercise Area 1-9

Lecture 37 Exercise Area 1-10

Section 6: SQL Exercises Section II

Lecture 38 Exercises Area 2-1

Lecture 39 Exercises Area 2-2

Lecture 40 Exercises Area 2-3

Lecture 41 Exercises Area 2-4

Lecture 42 Exercises Area 2-5

Lecture 43 Exercises Area 2-6

Lecture 44 Exercises Area 2-7

Lecture 45 Exercises Area 2-8

Lecture 46 Exercises Area 2-9

Lecture 47 Exercises Area 2-10

Section 7: SQL Exercises Section III

Lecture 48 Exercises Area 3-1

Lecture 49 Exercises Area 3-2

Lecture 50 Exercises Area 3-3

Lecture 51 Exercises Area 3-4

Lecture 52 Exercises Area 3-5

Lecture 53 Exercises Area 3-6

Lecture 54 Exercises Area 3-7

Lecture 55 Exercises Area 3-8

Lecture 56 Exercises Area 3-9

Lecture 57 Exercises Area 3-10

Section 8: SQL Exercises Section IV

Lecture 58 Exercises Area 4-1

Lecture 59 Exercises Area 4-2

Lecture 60 Exercises Area 4-3

Lecture 61 Exercises Area 4-4

Lecture 62 Exercises Area 4-5

Lecture 63 Exercises Area 4-6

Lecture 64 Exercises Area 4-7

Lecture 65 Exercises Area 4-8

Lecture 66 Exercises Area 4-9

Lecture 67 Exercises Area 4-10

Section 9: SQL Exercises Section V

Lecture 68 Exercises Area 5-1

Lecture 69 Exercises Area 5-2

Lecture 70 Exercises Area 5-3

Lecture 71 Exercises Area 5-4

Lecture 72 Exercises Area 5-5

Lecture 73 Exercises Area 5-6

Lecture 74 Exercises Area 5-7

Lecture 75 Exercises Area 5-8

Lecture 76 Exercises Area 5-9

Lecture 77 Exercises Area 5-10

Section 10: SQL Beginner Outro

Lecture 78 Review

Lecture 79 Outro

Section 11: Introduction to SQL Advanced

Lecture 80 Introduction

Lecture 81 Course Focus

Lecture 82 Review SQL Objects

Lecture 83 Wildcard Operators

Lecture 84 Wildcard Operators Exercises Pt. 1

Lecture 85 Wildcard Operators Exercises Pt. 2

Section 12: SQL JOIN Syntax and Practice

Lecture 86 SQL JOINS Syntax

Lecture 87 SQL JOINS Exercises Pt. 1

Lecture 88 SQL JOINS Exercises Pt. 2

Section 13: Aggregate Functions

Lecture 89 Aggregate Functions

Lecture 90 The HAVING Clause

Lecture 91 Aggregate Functions Exercises

Section 14: String and DATE/TIME Functions

Lecture 92 String Functions Area I

Lecture 93 String Functions Area II

Lecture 94 String Functions Area III

Lecture 95 String Functions Area IV

Lecture 96 DATE/TIME Functions Area I

Lecture 97 DATE/TIME Functions Area II

Lecture 98 DATE/TIME Functions Area III

Lecture 99 DATE/TIME Functions Area IV

Section 15: Advanced JOINS

Lecture 100 Advanced JOINS Syntax

Lecture 101 Advanced JOINS Exercises Pt. 1

Lecture 102 Advanced JOINS Exercises Pt. 2

Section 16: SQL Programming

Lecture 103 SQL Programming Pt. 1

Lecture 104 SQL Programming Pt. 2

Lecture 105 Stored Procedures Pt. 1

Lecture 106 Stored Procedures Pt. 2

Section 17: Introduction to Tables

Lecture 107 Tables

Lecture 108 Demonstration Exercises

Section 18: Cursors and Transactions
Lecture 109 Cursors

Lecture 110 SQL Transactions Area I
Lecture 111 SQL Transactions Area II
Lecture 112 SQL Transactions Area III
Section 19: SQL Triggers

Lecture 113 SQL Triggers Area I

Lecture 114 SQL Triggers Area II

Lecture 115 SQL Triggers Area III

Section 20: View and Subqueries

Lecture 116 Views Area I

Lecture 117 Views Area II

Lecture 118 Subqueries Area I

Lecture 119 Subqueries Area II

Lecture 120 Advanced Subqueries Area I

Lecture 121 Advanced Subqueries Area II

Section 21: Indexes and Schema Structures

Lecture 122 Indexes Area I

Lecture 123 Indexes Area II

Lecture 124 Indexes Area III

Lecture 125 Indexes Area Demo

Lecture 126 Schema Structures Area I

Lecture 127 Schema Structures Area II

Section 22: Windows Functions
Lecture 128 Windows Functions Area I
Lecture 129 Windows Functions Area II
Lecture 130 Windows Functions Area III
Lecture 131 Windows Functions Area IV
Lecture 132 Windows Functions Area V
Lecture 133 Windows Functions Area VI
Section 23: Advanced SQL Programming

Lecture 134 SQL Programming Area I

Lecture 135 SQL Programming Area II

Lecture 136 SQL Programming Area III

Lecture 137 SQL Programming Area IV

Lecture 138 SQL Programming Area V

Lecture 139 SQL Programming Area VI

Section 24: SQL Advanced Exercises Section I

Lecture 140 Exercises Area 1-1

Lecture 141 Exercises Area 1-2

Lecture 142 Exercises Area 1-3

Lecture 143 Exercises Area 1-4

Lecture 144 Exercises Area 1-5

Lecture 145 Exercises Area 1-6

Lecture 146 Exercises Area 1-7

Lecture 147 Exercises Area 1-8

Lecture 148 Exercises Area 1-9

Lecture 149 Exercises Area 1-10

Lecture 150 Exercises Area 1-11

Lecture 151 Exercises Area 1-12

Section 25: SQL Advanced Exercises Section II

Lecture 152 Exercises Area 2-1

Lecture 153 Exercises Area 2-2

Lecture 154 Exercises Area 2-3

Lecture 155 Exercises Area 2-4

Lecture 156 Exercises Area 2-5

Lecture 157 Exercises Area 2-6

Lecture 158 Exercises Area 2-7

Lecture 159 Exercises Area 2-8

Lecture 160 Exercises Area 2-9

Lecture 161 Exercises Area 2-10

Lecture 162 Exercises Area 2-11

Lecture 163 Exercises Area 2-12

Section 26: SQL Advanced Outro

Lecture 164 Review

Lecture 165 Outro

Lecture 166 Last Words

Anyone who wants to learn SQL from scratch – no prior experience required!,Professionals who want to enhance their productivity and efficiency with data management and automation,Anyone who is currently working with data and wants to expand their knowledge of SQL to optimize database performance and streamline their workflow,Students who are interested in pursuing a career in data management, business intelligence, or data analytics