Welcome to SQL

Ditch Stackoverflow and get a comfortable grasp on the most important language in data and software engineering. Suitable for those who are brand new to SQL, or engineers who have managed to squeak by with a limited knowledge of SQL (most of us, probably). Define database table schemas, write moderately complex queries to SELECT/UPDATE/DELETE data, and perform actions like JOINs and aggregates.

What You'll Learn

  • Defining tables from scratch with proper indexes and data types
  • Internalize everyday queries to select or modify data
  • Effectively designing tables to leverage foreign key relations
  • Execute and fully understand JOINs
  • Aggregate data to extract deeper meaning from SQL tables

For those who...

  • Are new to SQL or relational databases
  • Have mediocre knowledge of SQL and could benefit from filling the gaps
  • Have PHDs in statistics but think they can get by without knowing SQL

Tags

Python Software DevOps Data Engineering Architecture Pandas Excel Data Analysis SQL Data Science REST APIs JavaScript Flask Code Snippet Corner AWS NodeJS Google Cloud Frontend MySQL Apache Data Vis BI NoSQL GraphQL Spark PostgreSQL ExpressJS ETL Pipelines Tableau PowerBI SQLAlchemy GatsbyJS Powerpivot Machine Learning Automation Big Data Atlassian Mapbox Golang Scraping JAMStack Data Warehouses Plotly Docker Concurrency Hashicorp Django ReactJS SaaS Products Frameworks Java FastAPI Terraform Microsoft

Series'

Data Analysis with Pandas 11
Build Flask Apps 11
Learning Apache Spark 6
Google Cloud Architecture 6
Mastering SQLAlchemy 4
GraphQL Tutorials 4
Welcome to SQL 4
Working with MySQL 4
Mapping Data with Mapbox 3
Web Scraping With Python 2
Python Concurrency with Asyncio 2
Getting Started with Django 2