SQL: a collection of online courses, books, and video resources
SQL, or Structured Query Language, is a standard language for working with relational databases. It is used in a wide range of fields, from web development and data analysis to database administration. Here is a curated selection of online courses, books, and video resources to help you learn SQL or enhance your skills.
Author - Mansur Ismagulov
The Tech AI
Get the key points in seconds - a short summary from The Tech AI.
The text lists online SQL courses from Coursera, DataCamp, Udemy, Yandex Practicum, Harvard University, and Code Academy, along with their durations (from 5 hours to 4 months) and costs (free or around 33,565 tenge). It also includes books: "SQL in 10 Minutes" by Ben Forta, "Learning SQL" by Alan Beaulieu, "SQL Cookbook" by Anthony Molinaro, "SQL Performance Explained" by Markus Winand, and "SQL Antipatterns" by Bill Karwin. YouTube channels techTFQ, Alex The Analyst, and Simplilearn are mentioned for learning basic and advanced SQL topics.
Online Courses
SQL for Data Science by Coursera
This course provides a comprehensive introduction to SQL for data analysts. It is specifically designed for those who want to use SQL in the context of data analysis and learn to create queries to extract information from databases.
Duration: 2 weeks
Cost: Free
SQL Fundamentals by DataCamp
You will learn the SQL basics needed to enhance your data skills. Through practical exercises, you will get familiar with the fundamentals of SQL.
Duration: 3 weeks
Cost: Free
The Complete SQL Bootcamp by Udemy
This course aims to make you a complete SQL specialist. It covers SQL basics and moves on to more complex concepts such as table joins and window functions.
Duration: 1 week
Cost: ≈ 33,565 KZT
"SQL for Data Work and Analytics" by Yandex Practicum
During the course, you will learn to find and filter data using SQL queries and calculate product metrics to compare goods and services.
Duration: 4 months
Cost: Free
Introduction to Databases by Harvard University
This course provides a comprehensive introduction to databases and SQL. You will learn about basic database concepts and how to write SQL queries to extract and manipulate data.
Duration: 7 weeks
Cost: Free
Learn SQL by Codecademy
In this SQL course, you will learn how to manage large datasets and analyze real-world data using the standard data management language.
Duration: 5 hours
Cost: Free
Books
SQL in 10 Minutes, Sams Teach Yourself, Ben Forta
This book provides a fast and effective way to learn SQL. It covers SQL basics as well as more advanced topics such as joins and data aggregation.
Learning SQL, Alan Beaulieu
This book is suitable for both beginners and more experienced SQL users. It contains clear explanations of core SQL concepts and offers many practical examples.
SQL Cookbook, Anthony Molinaro
This book is a collection of recipes and code examples for solving various tasks using SQL. The book will help you expand your SQL knowledge and learn to apply it effectively in real-world projects.
SQL Performance Explained, Markus Winand
The book explores various aspects of SQL query and database performance. It covers topics such as indexes, query optimization, and choosing the right data structures to improve the performance of SQL applications.
SQL Antipatterns: Avoiding the Pitfalls of Database Programming, Bill Karwin
This book discusses common mistakes and antipatterns that can arise when developing SQL applications. It offers practical advice on how to prevent and resolve them.
YouTube Channels
techTFQ
On this channel, Tofiq teaches the basics of SQL and databases in the field of data analysis and Data Science in the simplest possible way. You will also find videos where he answers interview questions.
Alex The Analyst
The Alex The Analyst YouTube channel offers high-quality and accessible video tutorials on data analytics, including work with SQL, Excel, and Power BI. Alex shares his professional experience and practical tips, helping viewers improve their skills and develop in the field of data analytics.
Simplilearn
This SQL playlist covers all the important SQL concepts and commands that will help you master SQL. From these videos, you will learn everything from SQL basics to advanced levels.
The Tech on Telegram Follow The Tech on Telegram
Keep up with the latest technology and startup news.