Just launched with all modern SQL and Databases (PostgreSQL, MySQL, + more) features for 2021! Join a live online community of over 400,000+ students and a course taught by industry experts that have actually worked both in Silicon Valley and Toronto managing databases. This is one of the most in demand tech skills in the world right now with SQL being used for many years to come (it has been around since the 1970s and going stronger than ever)!
Using the latest best practices in SQL, Database Management and Database Design, this course is focused on efficiency. Never spend time on confusing, out of date, incomplete tutorials anymore. Graduates of Andrei’s courses are now working at Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, + other top tech companies.
We guarantee you this is the most comprehensive online resource on Databases like PostgreSQL and MySQL. This project and exercise based course will introduce you to all of the modern toolchain of an SQL developer or anyone using a database in the workplace (Product Manager, Business Analyst/Intelligence, Data Analyst, Data Scientists, Machine Learning Engineer, Web Developer, Mobile Developer + any role requiring insights from data). Along the way, we will learn practical and real world skills that will get you hired.
The curriculum is going to be very hands on as we walk you from start to finish of working with databases and SQL, all the way into learning how to scale databases, how to manage them, and even bonus material on working with Big Data, Caching using Redis, and connecting PostgreSQL to a Node.js server. We even talk about pros and cons of choosing an SQL Database vs NoSQL like MongoDB. We will start from the very beginning by teaching you SQL and Database Fundamentals and then going into advanced topics so you can make good decisions and work with any data that your company has no matter how complex!
The topics covered are:
– NoSQL (MongoDB) vs PostgreSQL, MySQL vs NewSQL
– SQL Theory And Concepts
– The Relational Model
– SQL Basics
– SQL Functions
– Data Modification Language / DML
– Data Query Language / DQL
– SQL Filtering / WHERE Statement
– 3 Valued Logic
– SQL JOINS
– Window Functions
– Date Filtering and Timestamps
– SQL Aggregate Functions
– SQL Operator Precedense
– SQL ORDER BY
– SQL GROUP BY
– SQL Top Down Design
– SQL Bottom Up Design
– SQL Entity Relationship Diagram
– SQL Normalization
– Database Types
Do enroll in AWS course