# 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.

**Online Courses**

**[SQL for Data Science by Coursera](<https://www.coursera.org/learn/sql-for-data-science>)**  
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](<https://www.datacamp.com/tracks/sql-fundamentals>)**  
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](<https://www.udemy.com/course/the-complete-sql-bootcamp/?couponCode=ST19MT60324>)**  
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](<https://practicum.yandex.kz/sql-data-analyst/?utm_source=google&utm_medium=cpc&utm_campaign=Gog_Net_KZ_SQL_Perf-max_460&utm_content=nt_x%3Apl_%3Acid_21105588122%3Agid_%3Akw_%3Atid_%3Acrid_%3Aadp_%3Ad_c%3Adm_%3Alim_%3Alpm_1009806&utm_term=&gad_source=1&gclid=CjwKCAjwmYCzBhA6EiwAxFwfgJjOdrHf0BW_3d5xSapEMir81hpVGlRGsS1jlt2ZykI8YvQKmwS64RoCWtEQAvD_BwE>)**  
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](<https://www.edx.org/learn/sql/harvard-university-cs50-s-introduction-to-databases-with-sql?index=product&queryID=3e613ca373e8ccd6354735a7ed6b3003&position=1&results_level=first-level-results&term=Introduction+to+Databases&objectID=course-3e45c431-10df-423e-9f03-fb98b713cd4a&campaign=CS50%27s+Introduction+to+Databases+with+SQL&source=edX&product_category=course&placement_url=https%3A%2F%2Fwww.edx.org%2Fsearch>)**  
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](<https://www.codecademy.com/learn/learn-sql>)**  
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](<https://www.andpop.ru/courses/db_books/Forta.pdf>)**  
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](<http://www.r-5.org/files/books/computers/languages/sql/mysql/Alan_Beaulieu-Learning_SQL-RU.pdf>)**  
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](<https://books.4nmv.ru/books/sql_sbornik_retseptov_fail_pdf_626980.pdf>)**  
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](<https://docshare.tips/sqlperformanceexplaineden_584cbc7cb6d87f4e378b4f3f.html>)**  
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](<https://vk.com/doc288422991_512489075?hash=g5uB9xM4LlZPCDPfojNkYgVVxfasngZ3bZtMEdCZ4PT&dl=cWazNpD3gCYhJLoReX0kYRoDzZnI207wR7xvO67ekpg>)**  
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](<https://www.youtube.com/@techTFQ/videos>)**  
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](<https://www.youtube.com/@AlexTheAnalyst>)**  
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**](<https://youtube.com/playlist?list=PLEiEAq2VkUUKL3yPbn8yWnatjUg0P0I-Z&si=JAroiRbX_RYSAzch>)  

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.
