datacamp.com
Unknown
DataCamp is an online learning platform for data science that offers interactive, hands-on courses and career tracks in SQL, Python, R, and related data analytics topics. It provides bite-sized lessons, coding challenges, real-world projects, and certificates to track progress.
More resources on Database Fundamentals
SQLZoo
Free interactive SQL learning platform
DB-Fundamentals
Interactive SQL and database tutorials
Use The Index, Luke
Free guide to SQL performance and indexing fundamentals
SQL Tutorial - Full Database Course for Beginners
freeCodeCamp.org 4-hour SQL course covering fundamentals
Databases and SQL for Data Science with Python
Working knowledge of SQL (or Structured Query Language) is a must for data professionals like Data Scientists, Data Analysts and Data Engineers. Much of the world's data resides in databases. SQL is a powerful language used for communicating with and extracting data from databases. In this course you will learn SQL inside out- from the very basics of Select statements to advanced concepts like JOINs. You will: -write foundational SQL statements like: SELECT, INSERT, UPDATE, and DELETE -filter result sets, use WHERE, COUNT, DISTINCT, and LIMIT clauses -differentiate between DML & DDL -CREATE, ALTER, DROP and load tables -use string patterns and ranges; ORDER and GROUP result sets, and built-in database functions -build sub-queries and query data from multiple tables -access databases as a data scientist using Jupyter notebooks with SQL and Python -work with advanced concepts like Stored Procedures, Views, ACID Transactions, Inner & Outer JOINs through hands-on labs and projects You will practice building SQL queries, work with real databases on the Cloud, and use real data science tools. In the final project you’ll analyze multiple real-world datasets to demonstrate your skills.
Database Systems: The Complete Book
Database Systems: The Complete Book - A book resource