Complete SQL and Databases Bootcamp

سرفصل های دوره

Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL + more. With Exercises!

1 - Introduction

1 -Course Outline

2 -Join Our Online Classroom!

3 -The Big Data Breach At Keiko Corp

3 - Exercise Meet Your Classmates & Instructor.html

4 -ZTM Resources

5 - Monthly Coding Challenges, Free Resources and Guides.html

2 - History And Story Of Data

1 -What Is a Database

2 -I Didnt Learn Anything, Try Again

3 -Database Management System (DBMS)

4 -Exercise Building Amazon

5 -Exercise Building Amazon 2

6 -5 Types Of Databases

7 -Exercise What Is A Database

8 -Section Review

3 - Databases + SQL Fundamentals

1 -SQL Playground

2 -What Is SQL

3 -What Is A Query

4 -Imperative vs Declarative

4 - Exercise Setting Up Your First Database.html

5 -History of SQL

6 -SQL Standards

6 - Exercises The Select Statement.html

6 - Optional History of SQL Deep Dive.html

7 -What Is A Database Revisited

8 -Database Oriented Approach

9 -Database Models

9 - Exercise SQL Starter Quiz.html

10 -Hierarchical And Networking Model

11 -Relational Model

12 -DBMS Revisited

13 -Relational Model Revisited

14 -Tables

15 -Columns

16 -Rows

17 -Primary And Foreign Keys

18 -OLTP vs OLAP

19 -Exercise OLTP vs OLAP

20 - Endorsements On LinkedIN.html

20 - Exercise Relational Model Quiz.html

4 - Environment Setup

1 -Why PostgreSQL

2 -Environment Tooling

3 -Command Line 101

3 - Having Trouble Registering A Serial Key For ValentinaDB.html

3 - SQL Tooling Alternatives.html

4 -WINDOWS Setup

4 - Getting Help With The Setup.html

5 -Optional Setting Up Windows For Command Line

6 -MAC Setup

7 -LINUX Setup

7 - MAC Commandline tools.html

8 -Data.zip

8 -Importing The Databases

9 -Exercise Imposter Syndrome

5 - SQL Deep Dive

1 -Starting With Query

1 - Query Along.html

2 -Exercise Simple Queries

3 -Changing Column Names in a SELECT Query

4 -Concat Function

5 -What Is A Function In SQL

6 -Aggregate Functions

7 -Commenting Your Queries

7 - Exercise Aggregate Functions.html

8 -Common SELECT Mistakes

9 -Filtering Data

10 -AND and OR

11 -Exercise Filtering Data

12 -The NOT Keyword

13 -Comparison Operators

13 - Exercise The Where Clause.html

14 -Logical Operators

14 - Exercise Comparison Operators.html

15 -Operator Precedence

16 -Operator Precedence 2

17 -Checking For NULL Values

17 - Exercise Operator Precedence.html

17 - Operator Precedence Extra.html

18 -IS Keyword

19 -NULL Coalescing

20 -3 Valued Logic

20 - Exercise Null Value Coalescing.html

21 -BETWEEN + AND

21 - Exercise 3 Valued Logic.html

22 -IN Keyword

22 - Exercise BETWEEN + AND.html

23 -LIKE

23 - Exercise IN Keyword.html

24 -Dates And Timezones

24 - Exercise Like Keyword.html

25 -Setting Up Timezones

26 -How Do We Format Date And Time

27 -Timestamps

28 -Date Functions

29 -Date Difference And Casting

30 -Age Calculation

31 -Extracting Information

32 -Intervals

33 -DISTINCT

33 - Exercise Date and Timestamp.html

34 -Sorting Data

34 - Exercise Distinct Keyword.html

35 -Multi Table SELECT

35 - Exercise Sorting Data.html

36 -Inner Join

37 -Self Join

38 -Outer Join

39 -Less Common Joins

40 -USING Keyword

40 - Inner-Join Exercises.html

6 - Advanced SQL

1 -GROUP BY

2 -HAVING Keyword

2 - Group By Exercises.html

3 -Ordering Grouped Data

3 - Having Exercises.html

4 -Group By Mental Model

5 -Grouping Sets

6 -Rollup

7 -Window What

8 -Looking Through The Window

9 -PARTITION BY

10 -Order By Acting Strange

11 -Using Framing In Window Function

12 -Solving For Current Salary

13 -FIRST VALUE

14 -LAST VALUE

15 -SUM

16 -ROW NUMBER

17 -Conditional Statements

17 - Window Function Exercises.html

18 -NULLIF

18 - Conditional Statement Exercise.html

19 -Views...What Are They Good For

19 - NULLIF Exercise.html

20 -View Syntax

21 -Using Views

22 -Indexes

22 - Views Exercises.html

23 -Index Types

24 -Index Algorithms

25 -What Are Subqueries

25 - Quick Note On Index Algorithms.html

26 -Subqueries vs Joins

27 -Subquery Guidelines As Types

28 -Using Subqueries

29 -Getting The Latest Salaries

29 - Quick Note Titles For Employees.html

30 -Subquery Operators

31 - Subquery Exercises.html

7 - Database Management

1 -Time To Create Some Stuff!

1 - Before We Get Started.html

2 -Types Of Databases In A RDBMS

3 -Default PostgreSQL Database

4 -Template Databases

5 -Creating A Database

6 -Database Organization

7 -Roles In Postgres

8 -Role Attributes And Creation

9 -Creating Users And Configuring Login

10 -Privileges

11 -Granting Privileges and Role Management

12 -Best Practices For Role Management

13 -Data Types & Boolean Type

14 -Storing Text

15 -Storing Numbers

16 -Storing Arrays

17 -Data Models And Naming Conventions

18 -CREATE TABLE

19 -Column Constraints

19 - Extra information on CREATE TABLE.html

20 -Table Constraints

21 -UUID Explained

21 - Regexes!.html

22 -Custom Data Types And Domains

23 -Creating The Tables For ZTM

24 -Adding Students And Teachers

24 - Extra information on ALTER TABLE.html

25 -Creating A Course

26 -Adding Feedback To A Course

27 -A Tale Of 2 Feedbacks

28 -Backups And Why They Are Important

28 - SQL Exercises.html

28 - SQL Quiz.html

29 -Backing Up In Postgres

30 -Restoring A Database

31 -Transactions

8 - Solving The Mystery

1 -Clue #1 and #2

2 -Clue #3

2 -data.zip

2 -movr employees.zip

2 -schema.zip

2 - Getting ready to solve the Mystery!.html

3 -Solution Solving The First Clues

3 - Exercise Solving The First Clues.html

4 -Clue #4

5 -Solution Clue #4

5 - Exercise Clue #4.html

6 -Clue #5 and #6

7 -Solution Clue #5 and #6

7 - Exercise Clue #5 and #6.html

8 -Solving The Mystery

9 - Database Design

1 -System Design And SDLC

2 -SDLC Phases

3 -System Design Deep Dive

4 -Top-Down vs Bottom-Up

5 -DRIVEME Academy

6 -Top Down Design

7 -ER Model

8 -Step 1 Determining Entities

9 -Tooling For Diagramming

10 -DRIVEME Academy Entities

11 -Step 2 Attributes

12 -Relational Model Extended

13 -Relational Schema And Instance

14 -Super Key and Candidate Key

15 -Primary Key and Foreign Key

16 -Compound Composite And Surrogate Key

17 -DRIVEME Attributes

18 -Step 3 Relationships

19 -DRIVEME Relationships

20 -Step 4 Solving Many To Many

21 -Step 5 Subject Areas

22 -DRIVEME Subject Areas

23 -Exercise Painting Reservations

24 -Exercise Movie Theatre

25 -Bottom Up Design

26 -Anomalies

27 -Normalization

28 -Functional Dependencies

29 -Functional Dependencies 2

30 -The Normal Forms

31 -Going from 0NF to 1NF

32 -Going from 1NF to 2NF

33 -Going from 2NF to 3NF

34 -Boyce-Codd Normal Form

35 -Why 4NF And 5NF Are Not Useful

36 - Exercise Database Design Quiz.html

10 - Database Landscape, Performance and Security

1 -Brunos Request

2 -Scalability

3 -Sharding

4 -Replication

5 -Backups

6 -Distributed vs Centralized Databases

7 -Database Security

8 -Optional All About Injections Attacks

8 - Exercise SQL Injection.html

9 -Optional Storing Passwords

10 -Relational vs NoSQL, PostgreSQL vs MongoDB Databases

10 - Optional How To Store Passwords.html

11 -Future Of Relational Databases

12 -Elasticsearch

13 -S3 Object Storage

14 -Top Databases To Use

11 - Where To Go From Here

1 -Thank You

2 - Become An Alumni.html

2 - Coding Challenges.html

2 - Learning Guideline.html

2 - LinkedIn Endorsements.html

12 - Extras Data Engineering (And the role of Machine Learning)

1 -Big Data + Analytics

2 -Reviewing How We Got Here

2 - Quick Note Upcoming Videos.html

3 -Data Engineering Introduction

4 -What Is Data

5 -What Is A Data Engineer

6 -What Is A Data Engineer 2

7 -What Is A Data Engineer 3

8 -What Is A Data Engineer 4

9 -Types Of Databases

10 -Hadoop, HDFS and MapReduce

11 -Apache Spark and Apache Flink

12 -Kafka and Stream Processing

13 - Extras Redis

1 -What Is Caching

1 - Quick Note Upcoming Videos.html

2 -Introducing Redis

3 -Installing Redis

3 - Redis Version Updates and Playground.html

4 -Redis Commands

4 - Resources Installing Redis.html

5 -Redis Data Types

6 -Redis Hashes

7 -Redis Lists

8 -Redis Sets and Sorted Sets

9 -Section Summary

14 - Extra Bits Databases In A Web App (with Node.js)

1 -Setting Up Your Database

1 - Quick Note Upcoming Videos.html

2 -Connecting To The Database

3 -Registering A User Part 1

15 - BONUS SECTION

1 - Special Bonus Lecture.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy