SQL: Fundamentals and Practical Skills

  • Home
  • SQL: Fundamentals and Practical Skills
Shape Image One

SQL: Fundamentals and Practical Skills

About Course

In this course you will see that almost anyone can learn SQL to the level of complex queries. And the training itself can be understandable even for a beginner.

By increasing the level of complexity, we will solve dozens of problems. Before you know it, we will move on to building complex SQL queries.

The main goal of the course is to talk about complex things simply.

There are 3 more important advantages:

✔️ At the end of each lesson there will be a video analysis of SQL problems with solutions.

If you cannot solve the problem, watch the video analysis and try to solve the problem again. This will help avoid learning gaps.

✔️ Balance of theory and practice.

After each video lesson, you will be given tasks on the topic being discussed. Also, practical tasks will be proposed based on the results of several lessons that are logically connected. And finally, 20 SQL problems await you to test your mastery of the entire course. This way you will solve several problems on each topic and better understand the material.

Show More

What Will You Learn?

  • work with popular databases: MS SQL Server, Oracle, PostgreSQL, MySQL, СlickHouse, etc.
  • solve 90% of SQL problems given during interviews
  • write complex SQL queries
  • understand and edit someone else's SQL code

Course Content

Installing software and familiarizing yourself with database tables

  • Software installation
  • Parameters for connecting to the database
  • Checking installation and connection
  • Table elements
  • Introduction to the database
  • Tasks
  • Advice

Lesson 2. Filtering WHERE rows. Regular expressions LIKE. AND and OR

Lesson 3. Sorting ORDER BY strings

Lesson 4. Aggregating functions: COUNT, SUM, MIN, MAX, AVG. Aliases

Lesson 5. Grouping GROUP BY and HAVING lines. Generating reports

Practice based on the results of the first 5 lessons

Lesson 11. CASE expression

Lesson 12. Popular functions for working with strings

Practical tasks to reinforce course material

Student Ratings & Reviews

No Review Yet
No Review Yet