The Sql Primer Masterclass

Description

Price: 5.00 USD | Size: 3.00 GB | Duration : 8.30+  Hours

BRAND: Expert TRAINING | ENGLISH | INSTANT DOWNLOAD

The Sql Primer Masterclass

Modules

01 – Course Introduction

02 – Setting up Resources

03 – Basic SQL

04 – Bigquery Intro Walkthrough

05 – Basic SQL Structure

06 – Query Syntax

07 – Order of True SQL Statements

08 – Schema Data Types

09 – Important SQL Commands

10 – Data Definition Language DDL

11 – Data Manipulation Language DML

12 – DDL DML Exercises

13 – AGGREGATE Functions

14 – STRING Functions

15 – SQL Operators

16 – SUBQUERIES CTEs

17 – JOINs

18 – Nested Repeated Structures

19 – WINDOW Analytics Functions

20 – Templated SQL

21 – dbt Data Build Tool

22 – SQL Best Practices

23 – UseCase 1 Airbnb

24 – Wrap Up

Pdfs