Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    15 Days Of Sql: The Complete Sql Masterclass 2022

    Posted By: ELK1nG
    15 Days Of Sql: The Complete Sql Masterclass 2022

    15 Days Of Sql: The Complete Sql Masterclass 2022
    Last updated 12/2022
    MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
    Language: English | Size: 5.67 GB | Duration: 14h 9m

    Master SQL in just 15 days from Basics to Pro by working daily on real-life projects

    What you'll learn

    You will master SQL in just 15 Days in real-life projects

    Master real-life challenges and projects

    Use SQL professionally in your career

    Understand SQL for data analysis

    Write complex and advanced SQL queries

    Create & manage your own databases

    Work with 2 complex real-life databases throughout the course and learn everything you need to master SQL

    You will learn joining tables, group by, functions, conditional expressions, stored procedures, grouping sets, transactions, indexes and much more!

    Requirements

    No prior experience is needed - I will teach you everything you need to know

    Description

    Learn SQL with the world’s best SQL course in just 15 days!1 hour per day, for just 15 days and you will be fluent in SQL!That’s the only course you need to completely master SQL.You will be guided step-by-step from beginner to absolute expert in SQL.Why is this the best course you can take?The most comprehensive course that teaches you everthing from beginner to expertMuch more challenges & hands-on coding exercises than other coursesMuch more real-life advanced topics that other courses don’t coverBy the end of this guided experience you will be so fluent in SQL to get a job and work professionally and with a lot of confidence with SQL!This is the most comprehensive & most modern course you can find on SQL.Here is why:Most comprehenisve course with 14 hours video lectures and most topicsMaster SQL by working on real-life challengesLearn PostgreSQL – the most modern SQL system & easy to transfer to all other SQL dialectsWe will set up two modern databases and learn everything with realistic data, so you can do everything hands-on!Learn from a real expert - crystal clear & straight-forwardUnderstand everything step by step from the absolute basics to the advanced topicsLearn the practical to upskill your career or find a job with SQLWe cover every single important topic you will need including the advanced topics other courses do not cover!Including…GROUP BYJOINsFunctionsUNIONsData manipulation & Data DefinitionViewsWindow functionsGrouping setsRollupsTransactionsSubqueriesQuery optimizationIndexes and much more!Plus, tons of practical challenges and 2 complete course projects and much more challenges than you can find anywhere else!This course will take you all the way from beginner to being able to upskill your career and make you ready to get a job with SQL!Check out the free video previews and enroll now!See you inside the course!

    Overview

    Section 1: Day 1 - Getting started with SQL!

    Lecture 1 Why learning SQL?

    Lecture 2 What is a database?

    Lecture 3 Different dialects of SQL

    Lecture 4 Installing PostgreSQL & pgAdmin (Windows)

    Lecture 5 Installing PostgreSQL & pgAdmin (MacOS)

    Lecture 6 Setting up the database

    Lecture 7 Common problems: Set binary paths

    Lecture 8 Common problems: Slow performance

    Lecture 9 The Project

    Lecture 10 SELECT

    Lecture 11 Challenge: SELECT

    Lecture 12 Solution: SELECT

    Lecture 13 ORDER BY

    Lecture 14 Challenge: ORDER BY

    Lecture 15 Solution: ORDER BY

    Lecture 16 SELECT DISTINCT

    Lecture 17 Challenge: SELECT DISTINCT

    Lecture 18 Solution: SELECT DISTINCT

    Lecture 19 LIMIT

    Lecture 20 COUNT()

    Lecture 21 Today's challenges

    Lecture 22 Today's summary

    Section 2: Day 2 - Basics: Filtering

    Lecture 23 WHERE

    Lecture 24 Challenge: WHERE

    Lecture 25 Solution: WHERE

    Lecture 26 WHERE operators

    Lecture 27 Challenge: WHERE operators

    Lecture 28 Solution: WHERE operators

    Lecture 29 WHERE with AND/OR

    Lecture 30 Challenge: WHERE with AND/OR

    Lecture 31 Solution: WHERE with AND/OR

    Lecture 32 Quick note on time zones

    Lecture 33 BETWEEN

    Lecture 34 Challenge: BETWEEN

    Lecture 35 Solution: BETWEEN

    Lecture 36 IN

    Lecture 37 Challenge: IN

    Lecture 38 Solution: IN

    Lecture 39 LIKE

    Lecture 40 Challenge: LIKE

    Lecture 41 Solution: LIKE

    Lecture 42 Comments & Aliases

    Lecture 43 Today's summary

    Lecture 44 Today's challenges

    Section 3: Day 3 - Basics: Grouping

    Lecture 45 Today's plan

    Lecture 46 Aggregate functions

    Lecture 47 Challenge: Aggregate function

    Lecture 48 GROUP BY

    Lecture 49 Challenge: GROUP BY

    Lecture 50 Solution: GROUP BY

    Lecture 51 GROUP BY multiple columns

    Lecture 52 Challenge: GROUP BY multiple columns

    Lecture 53 Solution: GROUP BY multiple columns

    Lecture 54 HAVING

    Lecture 55 Challenge: HAVING

    Lecture 56 Solution: HAVING

    Lecture 57 Introducing the second project

    Lecture 58 Note for Mac users

    Lecture 59 Problems & solutions of setting up the database

    Lecture 60 Today's summary

    Section 4: Day 4 - Intermediate: Functions

    Lecture 61 Today's plan

    Lecture 62 LENGTH, LOWER & UPPER

    Lecture 63 Challenge: LENGTH, LOWER & UPPER

    Lecture 64 Solution: LENGTH, LOWER & UPPER

    Lecture 65 LEFT & RIGHT

    Lecture 66 Challenge: LEFT & RIGHT

    Lecture 67 Solution: LEFT & RIGHT

    Lecture 68 Concatenate

    Lecture 69 Challenge: Concatenate

    Lecture 70 Solution: Concatenate

    Lecture 71 POSITION

    Lecture 72 Challenge: POSITION

    Lecture 73 Solution: POSITION

    Lecture 74 SUBSTRING

    Lecture 75 Challenge: SUBSTRING

    Lecture 76 Solution: SUBSTRING

    Lecture 77 EXTRACT

    Lecture 78 Challenge: EXTRACT

    Lecture 79 Solution: EXTRACT

    Lecture 80 TO_CHAR

    Lecture 81 Challenge: TO_CHAR

    Lecture 82 Solution: TO_CHAR

    Lecture 83 Intervals & Timestamps

    Lecture 84 Challenge: Intervals & Timestamps

    Lecture 85 Solution: Intervals & Timestamps

    Lecture 86 Today's slides

    Section 5: Day 5 - Intermediate: Conditional Expressions

    Lecture 87 Mathematical functions and operators

    Lecture 88 Challenge: Mathematical functions and operators

    Lecture 89 Solution: Mathematical functions and operators

    Lecture 90 CASE WHEN - Theory

    Lecture 91 CASE WHEN - Hands-on

    Lecture 92 3 Challenge: CASE WHEN

    Lecture 93 Quick solutions

    Lecture 94 Solution: CASE WHEN

    Lecture 95 CASE WHEN & SUM

    Lecture 96 COALESCE

    Lecture 97 CAST

    Lecture 98 Challenge: CAST & COALESCE

    Lecture 99 Solution: CAST & COALESCE

    Lecture 100 REPLACE

    Lecture 101 Today's slides

    Section 6: Day 6 - Intermediate: Joins

    Lecture 102 What are joins?

    Lecture 103 INNER JOIN - Theory

    Lecture 104 INNER JOIN - Practice

    Lecture 105 Challenge: INNER JOIN

    Lecture 106 Solution: INNER JOIN

    Lecture 107 FULL OUTER JOIN

    Lecture 108 JOIN & WHERE

    Lecture 109 LEFT OUTER JOIN

    Lecture 110 Challenge: LEFT OUTER JOIN

    Lecture 111 Solution: LEFT OUTER JOIN

    Lecture 112 RIGHT OUTER JOIN

    Lecture 113 Challenge: Joins

    Lecture 114 Solution: Joins

    Lecture 115 Joins on multiple conditions

    Lecture 116 Solution: Joins on multiple conditions

    Lecture 117 Joining multiple tables

    Lecture 118 Joining multiple tables - Practice

    Lecture 119 Challenge: Joining multiple tables

    Lecture 120 Solution: Joining multiple tables

    Lecture 121 More challenges

    Lecture 122 Solutions

    Lecture 123 Today's slides

    Section 7: Day 7 - Advanced: UNION & Subqueries

    Lecture 124 UNION

    Lecture 125 UNION - Practice

    Lecture 126 Subqueries in WHERE

    Lecture 127 Challenge: Subqueries in WHERE

    Lecture 128 Solution: Subqueries in WHERE

    Lecture 129 More challenges: Subqueries in WHERE

    Lecture 130 Solution: More challenges

    Lecture 131 Subqueries in FROM

    Lecture 132 Challenge: Subqueries in FROM

    Lecture 133 Solution: Subqueries in FROM

    Lecture 134 Subqueries in SELECT

    Lecture 135 Challenge: Subqueries in SELECT

    Lecture 136 Solution: Subqueries in SELECT

    Lecture 137 Correlated Subqueries in WHERE

    Lecture 138 Challenge: Correlated subqueries in WHERE

    Lecture 139 Solution: Correlated subqueries in WHERE

    Lecture 140 Correlated Subquery in SELECT

    Lecture 141 More challenges: Correlated subqueres

    Lecture 142 Solution: More challenges

    Lecture 143 Today's slides

    Section 8: Day 8 - Advanced: Course project

    Lecture 144 Project Introduction

    Lecture 145 Challenges

    Lecture 146 Solutions

    Lecture 147 Solution 1

    Lecture 148 Solution 2

    Lecture 149 Solution 3

    Lecture 150 Solution 4

    Lecture 151 Solution 5

    Lecture 152 Solution 6

    Lecture 153 Solution 7

    Lecture 154 Solution 8

    Lecture 155 Solution 9

    Lecture 156 Solution 10

    Lecture 157 Solution 11

    Lecture 158 Solution 12

    Lecture 159 Solution 13

    Lecture 160 Solution 14

    Section 9: Day 9 - Advanced: Managing tables & databases

    Lecture 161 Managing databases & tables

    Lecture 162 CREATE DATABASE

    Lecture 163 Data Types

    Lecture 164 Constraints

    Lecture 165 Primary Key & Foreign Key

    Lecture 166 CREATE TABLE

    Lecture 167 INSERT

    Lecture 168 ALTER TABLE

    Lecture 169 Challenge: ALTER TABLE

    Lecture 170 Solution: ALTER TABLE

    Lecture 171 TRUNCATE & DROP TABLE

    Lecture 172 CHECK

    Lecture 173 Challenge: CHECK

    Lecture 174 Solution: CHECK

    Lecture 175 Today's slides

    Section 10: Day 10 - Advanced: Views & Data Manipulation

    Lecture 176 UPDATE

    Lecture 177 Challenge: UPDATE

    Lecture 178 Solution: UPDATE

    Lecture 179 DELETE

    Lecture 180 Challenge: DELETE

    Lecture 181 Solution: DELETE

    Lecture 182 CREATE TABLE AS

    Lecture 183 Challenge: CREATE TABLE AS

    Lecture 184 Solution: CREATE TABLE AS

    Lecture 185 CREATE VIEW

    Lecture 186 Challenge: CREATE VIEW

    Lecture 187 Solution: CREATE VIEW

    Lecture 188 CREATE MATERIALIZED VIEW

    Lecture 189 Managing views

    Lecture 190 Challenge: Managing views

    Lecture 191 Solution: Managing views

    Lecture 192 Import & Export

    Lecture 193 Today's slides

    Section 11: Day 11 - Pro: Window Functions

    Lecture 194 OVER() with PARTITION BY

    Lecture 195 Challenge: OVER() with PARTITION BY

    Lecture 196 Solution: OVER() with PARTITION BY

    Lecture 197 OVER() with ORDER BY

    Lecture 198 Challenge: OVER() with ORDER BY

    Lecture 199 Solution: OVER() with ORDER BY

    Lecture 200 RANK()

    Lecture 201 Challenge: RANK()

    Lecture 202 Solution: RANK()

    Lecture 203 FIRST_VALUE()

    Lecture 204 LEAD & LAG

    Lecture 205 Challenge: LEAD & LAG

    Lecture 206 Solution: LEAD & LAG

    Lecture 207 Today's slides

    Section 12: Day 12 - Pro: Grouping sets, rollups, self-joins

    Lecture 208 GROUPING SETS

    Lecture 209 Challenge: GROUPING SETS

    Lecture 210 Solution: GROUPING SETS

    Lecture 211 Additional challenge

    Lecture 212 Solution: Additional Challenge

    Lecture 213 ROLLUP

    Lecture 214 Challenge: ROLLUP

    Lecture 215 Solution: ROLLUP

    Lecture 216 CUBE

    Lecture 217 Challenge: CUBE

    Lecture 218 Solution: CUBE

    Lecture 219 Self joins

    Lecture 220 Challenge: Self joins

    Lecture 221 Solution: Self joins

    Lecture 222 CROSS JOIN

    Lecture 223 NATURAL JOIN

    Lecture 224 Today's slides

    Section 13: Day 13 - Pro: Course project

    Lecture 225 Project introduction

    Lecture 226 The challenges

    Lecture 227 Solutions

    Section 14: Day 14 - Pro: Stored procedures, transactions & user-defined functions

    Lecture 228 User-defined functions

    Lecture 229 User-defined functions - Example

    Lecture 230 Challenge: User-defined functions

    Lecture 231 Solution

    Lecture 232 Transactions

    Lecture 233 Challenge: Transactions

    Lecture 234 Solution: Transactions

    Lecture 235 Rollbacks

    Lecture 236 Stored procedures

    Lecture 237 Challenge: Stored procedures

    Lecture 238 Solution: Stored procedure

    Lecture 239 Today's slides

    Section 15: Day 15 - Pro: Indexes, Partitining & Query Optimization

    Lecture 240 User management

    Lecture 241 CREATE USER | ROLE

    Lecture 242 GRANT & REVOKE privileges

    Lecture 243 Privileges - Hands-on

    Lecture 244 Challenge: Privileges

    Lecture 245 Solution: Privileges

    Lecture 246 What are indexes?

    Lecture 247 B-Tree index

    Lecture 248 Bitmap index

    Lecture 249 Indexes - Guidelines

    Lecture 250 Creating indexes

    Lecture 251 Execution plan & query performance

    Lecture 252 Today's slides

    Lecture 253 Bonus

    Anyone interested in SQL or PostgreSQL,Anyone that is interested in data analysis, data science and data analytics,Anyone that wants to improve their IT skills in any profession