Hackers and Slackers
Hackers and Slackers

Hackers and Slackers

  • About
  • Series
  • Join
  • Donate
  • Log in
  • Subscribe
  • Python
  • Software
  • DevOps
  • Architecture
  • Data Engineering
  • Pandas
  • Data Analysis
  • SQL
  • Data Science
  • REST APIs
  • JavaScript
  • Flask
  • AWS
  • NodeJS
  • Google Cloud
  • Apache
  • Frontend
  • MySQL
  • Data Vis
  • NoSQL

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

Newsletter

Create an account to receive occasional updates and interact with the community.

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
Hackers and Slackers

Community of hackers obsessed with data science, data engineering, and analysis. Openly pushing a pro-robot agenda.

Navigation

    • About
    • Series
    • Join
    • Donate

Series'

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

Authors

  • Todd Birchard
  • Matthew Alhonte
  • Max Mileaf
  • Ryan Rosado
  • Graham Beckley
  • David Aquino
  • Paul Armstrong
  • Dylan Castillo
©2023 Hackers and Slackers, All Rights Reserved.