SQL

with Martin Ganchev and Vladimir Saev
4.8/5
(3125)

Equipping you with the essential data science skills to effectively manage relational databases by extracting, transforming, and loading your data.

12 hours 121 lessons
Start course
121 High Quality Lessons
95 Practical Tasks
12 Hours of Content
Certificate of Achievement

Course Overview

SQL is one of the fundamental programming languages you need to learn to work with databases. When you are a data scientist in a company and you need data to perform your analysis, you usually have two options: extract it on your own or contact the IT team. Of course, the ability to extract your own data is an extremely valuable skill to have. In this course, we will teach you everything you need to know in terms of database management and creating SQL queries.

Topics covered

ProgrammingRelational DatabasesSQLTheory

What You'll Learn

SQL is a must if you are expected to work with databases. This course is the ultimate guide, teaching you everything you need to know in terms of database management and creating SQL queries.

Understand relational database management systems 
Study the components of SQL 
Store, retrieve, and manipulate data from relational databases 
Know how to set up a connection between Workbench and the server 
Create databases and work with them 
Apply the best SQL practices 

Curriculum

Student feedback

4.8/5

3125 ratings
5 stars
2720 (87%)
4 stars
352 (11%)
3 stars
43 (1%)
2 stars
4 (0%)
1 star
6 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Sort
  • Newest
  • Oldest
18.11.2023
i'd prefer learning while doing, but in this course, 1st all the explanations are done then doing. most of the time i forgot what the theory was. and there is this section for all the technical terms and jargons used in the industry, i understand it's important but for me personally it is making things complex. i start to not understand what i already knew. like when you guys explained about the "technical" names used in the industry for columns and rows, instead of saying column is called this and row is called that, you guys made some technical explanation which i think was unnecessary and made it more complex. what i think would be best practice is explaining things while doing actual coding including all the jargons and or multiple name for the same thing. otherwise the course is good. thanks
27.11.2022
I like the course and I am definitely learning SQL. I just wish the assignments at the end were handled better. Downloading a zip, unzipping, and loading the code to "check" my code is cumbersome and (at least in my case) unnecessary. Either display a code I can copy and paste (perhaps make it initially hidden with a button to unhide) or, preferably, show me the expected output from SQL so I can check my output and troubleshoot before peeking at the code.
28.06.2023
Been a great SQL course with lots of repetition. I'd say 99,999% of people won't learn by just watching the syntax. There was a real-ish relational database that was used throughout the course which gave the perfect opportunity to play around with the new concepts. I recommend people writing all the queries by hand themselves, it really solidifies the learnt concepts and prepares you better for exercises and practice exams.
11.05.2023
The information is layed out a little weird but its all very useful. The only thing that is a Con for this program is the slides, they are not concise and have a lot of duplicate information. I had to skip the majority of them because they just seem useless when there is so much irrelevant slides inbetween. Other than that, the information is clear & the practice assignments inbetween lectures is very helpful.
19.07.2022
The course is very clear and strikes a good balance between theory and applications. The exercises follow the lessons closely and are clearly stated. However I think the course could benefit from more exercises, perhaps at the end of a section, like "general" exercises, where we can put into practice several techniques as one as opposed on focusing on the ones we just learned on the preceding video.
  • 1
  • 2
  • 3
  • ...
  • 53
  • ...
  • 105
Martin Ganchev

“SQL can be crucial for data analytics and business intelligence. I created this comprehensive, practical course that follows best teaching practices. My aim is to introduce you to topics not covered in other SQL courses and show you how to work with a real-life database.”

Martin Ganchev

Worked at the European Commission

SQL

with Martin Ganchev and Vladimir Saev

Start Course