SQL.md

SQL Resources

SQL Tutorials and Reference

• SQLZoo - "SQLZoo includes tutorials and reference to support people learning SQL."
• SQLBolt - Introduction to SQL - "a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser."
• SQLTutorial.org - "This SQL tutorial helps you get started with SQL quickly and effectively through many practical examples."
• SQL Tutorial on W3Schools - "Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems." W3Schools' content, in general, is absolutely great!
• w3resource SQL Tutorial
  • MySQL Tutorials
• PostgreSQL Tutorials
• SQLite Tutorials
• SQL Tutorial - Tutorials Point

Videos

• "Learn Basic SQL in 10 Minutes" - "This video uses a visual approach to teach the basic SQL commands."
• "Learn SQL In 60 Minutes" - "In this video we will cover everything you need to know about SQL in only 60 minutes. We will cover what SQL is, why SQL is important, what SQL is used for, the syntax of SQL, and multiple examples of SQL. SQL is the standard language for interacting with and manipulating data in a relational database system, and is one of the most important concepts you can learn in programming. It allows you to create, read, update, and delete data which is something nearly every application will need to do."
• "SQL Tutorial - Full Database Course for Beginners" - "In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. "
• SQL Tutorial for Beginners - "SQL Tutorial for Beginners - Learn complete SQL from basics to advance in one video."

SQL Cheat Sheet

• SQL Cheat Sheet (from SQLTutorial.org)
• SQL Cheat Sheet (from www.databasestar.com/)
• SQL Cheat (from hackr.io)
• Quick SQL Cheatsheet
• SQL Cheatsheet

Practice SQL - SQL Exercises

• SQL Exercises - w3schools
• SQL Exercises - w3resource
  • MySQL Exercises
  • SQLite Exercises
  • PostgreSQL Exercises
• 50 SQL Query Questions and Answers for Practice
• SQL Exercises – Complex Queries

SQL Interview Questions

• Top SQL Interview Questions One Should Know Beforehand
• 25 SQL Performance Interview Questions and Answers
• Top 30 PL SQL Interview Questions and Answers for Freshers
• SQL Interview Questions and Answers for Freshers

Learn SQL - SQL Courses

• Codecademy's SQL Courses:
  • Learn SQL
  • SQL: Table Transformation (requires a paid Pro subscription)
  • SQL: Analyzing Business Metrics (requires a paid Pro subscription)
• Learn SQL - Kaggle's online SQL course
• SQL for Data Science - a Coursera course (could be taken/audited for free, you can pay for a certificate of completion)
• ntro to SQL: Querying and Managing Data - Khan Academy SQL course
• SQL Courses
• SQL Resources
• "Effectively Master SQL for Data Science with any of these courses" - a list of recommended courses for learning SQL.

SQL with Python

• Python MySQL tutorial
• SQL Interface within JupyterLab
• Greg Reda - Translating SQL to pandas. And back. - video from PyData
• GitHub Repo associated with the talk
• First Steps to Transition from SQL to Pandas | Katarzyna Rachuta @ PyBay2018 -
• Comaparison between Pandas and SQL - from the Pandas documentation
• "How to rewrite your SQL queries in Pandas, and more"