MindTech Academy

Online course
SQL Fundamentals

SQL training from zero to complex
analytical queries for 3 months
Best online course
according to EdCrunch Award

  • Flexible schedule

    You choose your own day, place and time of SQL training. All you need to get started is a computer and internet access.

    You can take breaks if you're on vacation or have a work emergency. Learn at your own pace, no deadlines or dropouts.

  • Real business challenges

    SQL Training on real business problems from banking and finance, Online trading, insurance, CRM-systems and Internet portals.

    By the end of the SQL course, you'll be fluent in extracting data and making analytical queries. Help your business or accelerate your career.

  • Teacher support

    Personalized feedback within 24 hours . The tutor or tutors will answer all your questions in detail and help you with assignments.

  • Balance of theory and practice

    The course consists of short, but detailed online SQL video tutorials with reinforcing assignments. No water, no boring lectures or long webinars, just useful concentrated content.

    The tasks are performed on a special SQL simulator which not only checks the query but also gives hints.

Course Program

A rich program with short video lessons and lots of practice.
SQL Training from scratch on the example of MySQL - one of the most popular databases.

  1. 1

    Simple SQL queries

    9 lessons, 26 tasks

    Become familiar with the SQL language and write your first database queries.
    Learn how to filter and sort data.
    Master the LIMIT, FETCH, OFFSET, and TOP constructs.
    Learn how to install MySQL and connect to the database.
    Learn how the client interacts with the server.

  2. 2

    Adding, modifying, deleting

    3 lessons, 20 tasks

    Learn how to add new records to tables, as well as change and delete existing data.

  3. 3

    Creating tables

    10 lessons, 37 tasks

    Learn how to create tables from scratch to meet business requirements.
    Learn how to choose the best data types for columns.
    Familiarize yourself with NULL and TRUE, as well as inserting default values.

  4. 4

    Indices

    4 lessons, 20 tasks

    Learn what a primary key and AUTO_INCREMENT are.
    Learn how to create common indexes to speed up SELECT queries. Familiarize yourself with unique indexes for data control.

  5. 5

    Changing tables

    3 lessons, 13 tasks

    Learn how to modify the structure of tables: add new ones
    and delete irrelevant columns.
    Learn how to change data types in existing fields.

  6. 6

    Text Search

    2 lessons, 12 tasks

    Learn how to search for textual data using a template.
    Familiarize yourself with full-text search to find relevant data.

  7. 7

    Auxiliary functions

    4 lessons, 23 assignments

    Learn how to modify text data.
    Become familiar with mathematical functions.
    Learn how to convert the date and time into a usable form.
    Practice filtering information with features.

  8. 8

    Data grouping

    3 lessons, 17 tasks

    Learn how to group and aggregate data based on different criteria.
    Build the first summary reports.
    Learn how to count quantities and sums, as well as average, minimum, and lowest values.
    Master a new way of filtering information - HAVING.

  9. 9

    Multi-table queries

    13 lessons, 76 tasks

    Learn how to merge data from multiple tables.
    Familiarize yourself with the concept of links and relationships between tables.
    Learn what a foreign key is and how to ensure data integrity.
    Master the JOIN and UNION constructs.

  10. 10

    Nested queries

    6 lessons, 17 tasks

    Learn how to use nested queries to sample data.
    Familiarize yourself with the operators EXISTS, IN, ANY, ALL.
    Learn how to use nested queries to insert data.

What you'll learn

After taking the SQL Fundamentals course, you will learn how to:

  • Install MySQL server on your computer, start the DBMS, and connect to it using a client program.
  • Create databases and tables from scratch to suit business requirements.
  • Extract information from databases using SQL queries.
  • Use SQL to analyze data.
  • Process and modify source information for convenient output.
  • Perform arithmetic operations, format a date, bring text to the desired form.
  • Search for information using full-text search tools.
  • Modify and add new data to tables.
  • Select optimal data types.
  • Create unique and compound indexes.
  • Utilize WHERE и HAVING to filter the data.
  • Aggregate data using GROUP BY .
  • Calculate the average, minimum and maximum values.
  • Group data by categories and dates, generate summary reports.
  • Retrieve data from multiple linked tables using JOIN .
  • Merge multiple tables using UNION .
  • Create nested SQL queries.

Duration of SQL training

38 hours

Average duration of training

3 months if you're practicing 30 minutes a day .
In 30 minutes you can watch 1-2 SQL lessons and solve 5-6 assignments.
Great if you don't have a lot of free time.
Minimum time to complete the SQL course 6 days .
If you have a lot of free time and high motivation.

Who will benefit from this course

Online SQL course is suitable for beginner developers, marketers, analysts.
The program is designed for a wide audience and requires no prior skills.

  • SQL для web-разработчика

    Web developer

    Learn how to write effective SQL queries as well as design robust databases.
    Good websites without databases don't work.

  • SQL для маркетолога

    To the marketer

    Learn how to extract data for reports without the help of developers. Be able to analyze user behavior and marketing metrics.

  • SQL для аналитика

    See for analysis.

    Learn to get information directly from databases without programmers. Master the tools of data processing and analysis.

Why learn SQL

SQL is a language for programs to communicate with databases.
The ability to write SQL queries is one of the key skills of modern programmers, as well as analysts, product analysts and internet marketers.

  • 99 %

    IT companies use
    databases in their work

  • 55 %

    vacancies for the position
    of a programmer requires knowledge of SQL

  • 83 %

    vacancies for the position
    backend programmer
    require proficiency in SQL*

Every serious interview or test assignment contains questions about databases and SQL.
Learning SQL greatly increases the chance of getting a job.

Награда Edcrunch Award 2019

Winner of the V International Competition
educational projects EdCrunch Award 2019 .

First place among more than 70 participants from all over Russia in the nomination "The best online course posted on an educational platform".

Certificate

Students who learn the theory and complete all assignments - receive a certificate of completion of the online SQL course.

You can add the certificate to your resume or send the link to your employer.

A certificate is a validation of your skills and knowledge.

Feedback from students

253 positive feedback, average rating

Рейтинг курса
  • КавычкиРечь
    It so happened that I learned the basics of SQL on my own, immediately applying them in my work. But, as it often happens, my working queries were limited to specific tasks, I didn't need to know or use a lot of things. If I encountered any complexity, I googled (that's how I learned nested queries in general and, for example, regular expressions), and my knowledge was very fragmentary and superficial. I realized that it would be necessary to organize them somehow, besides, the possibility of getting an offer as a middle business analyst loomed, so I bought all three courses here. Before the interview I watched some lessons here and got a general idea about window functions and database design - I got the interview and got the job. Now I'm happy to go through the whole course, all the tasks in sequence so that all the knowledge is organized.

    This course (both basic and advanced) provides excellent knowledge for both juniors and middles, and you will get the rest by practicing on the job.

    Special thanks to Nikita for his responsiveness, patience, for never ignoring questions but answering promptly. I really hope there will be a course on Python for analytics, there are many different ones, but I am so used to you that I would be happy to continue learning here.
  • КавычкиРечь
    Great course, tons of practice, great videos with no water!
    Very satisfied!
  • КавычкиРечь
    The theory/practice ratio is perfect. I memorized most of the syntax already at the "muscle memory" level!

    I use this course as a supplement to the Yandex.Praktikum course "Data Analyst". Looking at the list of upcoming tasks in the "Practicum" section on SQL, I realize that I will feel confident.

    I originally took it on the recommendation of a friend who had already traveled this road. I have not regretted it for a second.
  • КавычкиРечь
    Yay! I took the SQL Fundamentals course. Thanks to Nikita Shultais for the opportunity to get quality knowledge in the areas of interest. This is the second course from MindTech Academy that I have taken. I would like to note the large volume of topics studied, high quality of teaching, timely help from the site support service and a sufficient number of tasks. I do not want to stop at what I have achieved and am now starting to study an advanced course in SQL.

Tariffs

  • Basic

    Self-study of SQL basics

    • 50 video lessons

      Over 5 hours of video

    • Supplementary materials

      Guides and tables

    • Access to the course forever

      Return to the materials at any time

    • Practical tasks

      No access to assignments

    • Teacher support

      The questions are not addressed

    • Certificate

      No confirmation of course completion

    $100

    For self-study of SQL basics

  • Advanced

    Practice and testing of knowledge

    • 80 video lessons

      Over 8 hours of video

    • Supplementary materials

      Tutorials, tables, example queries

    • Practical tasks

      200+ assignments with a check

    • Certificate

      Course completion document

    • Teacher support

      No help available

    $200

    Ideal for consolidating knowledge through practice

  • Premium

    Maximum opportunities for deep learning of SQL

    • 120 video lessons

      Over 12 hours of video

    • Supplementary materials

      Database diagrams, sample queries, checklists

    • Practical tasks

      300+ assignments with automatic checking

    • Teacher support

      Assistance in resolving issues within 24 hours

    • Certificate

      A document proving your skills

    $300

    For those who want to learn SQL on a professional level

Any questions?

  • 1. Will your training program be right for me?

    We teach SQL from scratch, and the language itself is designed for a wide range of users, so the training program can cope with both technically savvy students and humanities with minimal experience.

    Either way - give it a try. First 9 lessons and 26 assignments available free of charge after you sign up.
    This is enough to appreciate the presentation and complexity of the materials.

  • 2. How, when and at what time will I study?

    All lessons are available Online in a recorded format so learning can begin at any time .
    There are also no restrictions on the time of passing, you can safely go on vacation, and then continue the classes without problems.

  • 3. How long does SQL training last?

    Some students complete the entire SQL course in a month, others need a year, the record is 6 days.

    On average, it takes 32 hours or 2.5 months to learn, but the final result depends on your goals, initial training, and the time you are willing to spend studying.

  • 4. What if I have difficulties during the training?

    Under each lesson and assignment there is a support forum where students can communicate with the teacher and each other.
    If you have any questions, feel free to ask them through the forum and you will be will definitely help .

    Help usually comes within 24 hours .

  • 5. Can I switch from Basic to Premium?

    Yes, you can upgrade to Premium at any time and get access to all tasks and support.

  • 6. What if I use Microsoft SQL, Oracle or PostgreSQL?

    We use MySQL in the course, but 90% of the syntax constructs will work in other databases as well.

    The main differences concern data types and a set of functions for processing text and dates. But even using MySQL, when selecting functions, we recommend to refer to the official documentation in these matters.

    About 40% of our apprentices use Microsoft SQL Server and Oracle at work.