Complete Sql Databases Bootcamp Zero To Mastery

Tags: SQL

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

Last updated 2022-01-10 | 4.6

- Become an expert in SQL and Database Concepts
- Understand SQL vs NoSQL
- MongoDB vs MySQL vs PostgreSQL
- Add SQL
- PostgreSQL
- MySQL
- Redis
- Database Management/Design to your resume

What you'll learn

Become an expert in SQL and Database Concepts

Understand SQL vs NoSQL

MongoDB vs MySQL vs PostgreSQL

Add SQL

PostgreSQL

MySQL

Redis

Database Management/Design to your resume

Learn to perform efficient and performant SQL queries using best practices

Learn how Machine Learning

Data Science and Data Engineers use Big Data and databases

Apply for SQL developer

Database Administrator

Business Analyst

Backend Developer and Business Intelligence roles

Use the right SQL features to work with data efficiently and solve database problems

Database best practices to design and manage your company data

Learn to make business and market decisions based on user data

Learn how to scale databases by using things like Sharding

Replication

etc...

Create your own databases while using SQL to interact with the data

Use real-world data to generate insights and reports using SQL

Tons of exercises to practice what you learn and test your knowledge

Help Sales/Marketing/Product managers make better decisions based on data analysis

Advanced SQL topics like indexes

aggregates

caching to make your database queries efficient

Learn how databases are used in Web & Mobile Applications

Machine Learning and other fields

Learn how to handle user passwords and keep data safe

Work with SQL across multiple tables and multiple databases

Learn to use Redis for fast memory storage

Master SQL joins

* Requirements

* No prior tech experience is required. We will start from absolute zero!
* You can use ANY operating system with this course: Windows
* macOS
* Linux. All users are all welcome!
* Get ready to do tons of exercises and learn to love Databases and SQL!

Description

Become an expert in SQL and Database Concepts
Understand SQL vs NoSQL, MongoDB vs MySQL vs PostgreSQL
Add SQL, PostgreSQL, MySQL, Redis, Database Management/Design to your resume
Learn to perform efficient and performant SQL queries using best practices
Learn how Machine Learning, Data Science and Data Engineers use Big Data and databases
Apply for SQL developer, Database Administrator, Business Analyst, Backend Developer and Business Intelligence roles
Use the right SQL features to work with data efficiently and solve database problems
Database best practices to design and manage your company data
Learn to make business and market decisions based on user data
Learn how to scale databases by using things like Sharding, Replication, etc...
Create your own databases while using SQL to interact with the data
Use real-world data to generate insights and reports using SQL
Tons of exercises to practice what you learn and test your knowledge
Help Sales/Marketing/Product managers make better decisions based on data analysis
Advanced SQL topics like indexes, aggregates, caching to make your database queries efficient
Learn how databases are used in Web & Mobile Applications, Machine Learning and other fields
Learn how to handle user passwords and keep data safe
Work with SQL across multiple tables and multiple databases
Learn to use Redis for fast memory storage
Master SQL joins

Course content

15 sections • 280 lectures

Introduction 5 lectures

Course Outline Preview 07:51

Join Our Online Classroom! Preview 01:15

Exercise: Meet The Community Preview 01:26

The Big Data Breach At Keiko Corp Preview 02:23

Monthly Coding Challenges, Free Resources and Guides Preview 00:40

History And Story Of Data 8 lectures

What Is a Database? Preview 05:57

I Didn't Learn Anything, Try Again... Preview 06:35

Database Management System (DBMS) Preview 07:44

Exercise: Building Amazon Preview 05:34

Exercise: Building Amazon 2 Preview 05:28

5 Types Of Databases Preview 05:37

Exercise: What Is A Database? Preview 01:11

Section Review Preview 01:29

Databases + SQL Fundamentals 25 lectures

SQL Playground Preview 01:54

What Is SQL? Preview 02:17

What Is A Query? Preview 06:27

Exercise: Setting Up Your First Database Preview 00:31

Imperative vs Declarative Preview 03:24

History of SQL Preview 02:21

Optional: History of SQL Deep Dive Preview 00:10

Exercises: The Select Statement Preview 00:12

SQL Standards Preview 04:25

What Is A Database? Revisited Preview 05:36

Database Oriented Approach Preview 06:51

Exercise: SQL Starter Quiz Preview 00:08

Database Models Preview 01:21

Hierarchical And Networking Model Preview 08:03

Relational Model Preview 07:17

DBMS Revisited Preview 13:56

It's funny how the 12 Rules of Codd are actually 13 because it starts counting at 0, this is a classic computer science thing to do! Reason being is one of the types of data we use to store lists starts counting at zero!

Relational Model Revisited Preview 01:06

Tables Preview 03:45

Columns Preview 04:07

Rows Preview 02:27

Primary And Foreign Keys Preview 05:03

OLTP vs OLAP Preview 03:16

Exercise: OLTP vs OLAP Preview 03:20

Exercise: Relational Model Quiz Preview 00:13

Endorsements On LinkedIN Preview 00:39

Environment Setup 12 lectures

Why PostgreSQL Preview 01:52

Environment Tooling Preview 03:10

Having Trouble Registering A Serial Key For ValentinaDB? Preview 00:19

SQL Tooling Alternatives Preview 02:16

Command Line 101 Preview 05:21

Getting Help With The Setup Preview 00:26

WINDOWS Setup Preview 04:52

Optional: Setting Up Windows For Command Line Preview 04:27

MAC Setup Preview 06:30

MAC Commandline tools Preview 00:46

LINUX Setup Preview 05:36

Importing The Databases Preview 06:03

SQL Deep Dive 55 lectures

Query Along Preview 00:13

Starting With Query Preview 05:14

Exercise: Simple Queries Preview 10:10

Renaming Columns Preview 03:19

Concat Function Preview 04:51

In this video we'll learn all about the CONCAT function and how we can make our data look prettier when querying. Often you can have 20 or 30 columns in a table and even when you select only the columns you want to see it can be hard to look at.

Luckily SQL has our back! With CONCAT you can format the return of your columns temporarily, we aren't actually changing any data, but we're just sprucing it up to look nice when the query returns us our data.

It's a temporary "view" on that data, which means you arre telling SQL how you want something to look only for that query, not permanently.