MindTech Academy

Online course
Advanced SQL

Dive into SQL window functions, transactions and stored procedures

About the course

The Advanced SQL course includes three units of study in different areas: transactions, stored procedures, and window functions.

In the block on transactions, you'll learn about transaction isolation levels in SQL and learn how to prevent anomalies.

Stored procedures, triggers, and views allow you to automate and simplify your database operations.

SQL window functions can help you take your data analytics to the next level.

Course Program

Advanced SQL training program with short video tutorials and practice on a simulator.
Learning analytical and windowing functions, transactions and stored procedures in SQL.

  1. 1

    Transactions

    7 lessons, 19 tasks

    Learn what SQL and ACID transactions are.
    Familiarize yourself with transaction isolation levels.
    Learn how to combat the effects of lost updates, as well as messy, non-repeatable and phantom reads.

  2. 2

    Stored procedures, triggers, views

    10 lessons, 23 assignments

    Learn how to create stored procedures and functions to automate database work.
    Become familiar with methods for analyzing SQL query performance.
    Learn how to create and run triggers.
    Learn how to write submissions.

  3. 3

    SQL window functions

    19 lessons, 49 tasks

    Familiarize yourself with SQL window functions.
    Learn how to use aggregation functions with windows.
    Master segmentation with OVER and PARTITION BY.
    Learn absolute and relative ranking of data.
    Become familiar with the statistical and analytical functions of SQL.
    Learn how to use frames and spacing.

Who will benefit from this course

The course is designed for analysts, marketers, economists, database developers and programmers,
who have a good command of SQL basics, understand what JOIN, UNION and subqueries are and are ready to improve their skills.
If you are unsure of your skills, we recommend taking a course first "SQL Fundamentals." .

  • SQL для программиста

    Database developer

    Learn how to apply SQL transactions to maximize performance and reliability.

    Automate your database work with stored procedures and triggers.

    Learn how to find and optimize slow SQL queries.

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

    See for analysis.

    Learn how to use SQL window functions to analyze data.

    Learn how to combine grouping, segmentation, aggregation, and windows in a single query.

    Significantly improve your information handling skills.

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

    To the marketer

    Learn the analytical capabilities of the SQL language.

    Learn how to analyze user and product information in various combinations.

    Master cumulative counting, moving average calculation and other techniques.

What you'll learn

By completing the Advanced SQL course you will learn how to:

    Transactions and stored procedures

  • Writing transactions that execute ACID requirements.

  • Select transaction isolation levels to provide better performance .

  • Select transaction isolation levels to ensure maximum reliability .

  • Create error-resistant transactions.

  • Create stored procedures and functions.

  • Use transactions within stored procedures.

  • Create and run SQL triggers.

  • Create table views based on SQL queries.

  • Create and use variables in SQL.

  • Optimize SQL queries.

    SQL window functions

  • Utilize SQL window functions.

  • Apply window analytics along with grouping and subqueries.

  • Manage the order in which the data is processed.

  • Highlight segments with OVER и PARTITION BY .

  • Rank the data by functions ROW NUMBER , RANK и DENSE RANK .

  • Utilize SUM и COUNT with window functions.

  • Refer to past and future periods with the help of LAG и LEAD .

  • Calculate the cumulative total in SQL.

  • Scanning with ROWS BETWEEN .

  • Use frames and spacing in SQL.

Certificate

Students who learn the theory and solve all the problems - receive a certificate of completion of the Advanced 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

32 positive feedback, average rating

Рейтинг курса
  • КавычкиРечь
    I would like to thank the author for the quality material. I have taken all 3 courses on SQL and have not regretted it one bit. For symbolic, for our times, money, the author gives a good basis for learning SQL. Thanks to the courses I was able to get a job in an IT company and pass the probation period. Naturally, it is foolish to expect that after taking the course you will become a super-specialist, but I repeat, the courses provide a good basis. Before that, I took various trainings - either water or the basic knowledge that should appear from somewhere. It is absolutely necessary to pass and "Advanced SQL" (window functions are very important). "Database Design" is more for general development. The author a big plus for quick and detailed answers in chat and good luck in further development of his projects! Definitely recommend it to everyone!
  • КавычкиРечь
    A very strong addition to the main course on SQL, I highly recommend it! Without this course you will miss a lot and spend a lot more time on bits and pieces to collect information on the Internet.
  • КавычкиРечь
    For those who have already mastered the base and want to move on, this is a good reference point to generally understand what other features sql has and what it will give you as a user in your work.

    And if you're interested, you should look for resources to pump up some specific skills, for example, writing procedures. There are no very practical exercises here.

    I liked that all lessons are in short video format. You don't get tired.

    I liked the fast and competent support. I always received a detailed, "chewed up" answer to all my questions.
  • КавычкиРечь
    The price/quality ratio is excellent. The information presented in this course is a must for every middle-level programmer.
    The disadvantages are the lack of practice. But if it were available, the cost would be higher.
    I recommend it to everyone I know.

Tariffs

  • Basic

    Fundamentals of Advanced SQL

    • 50 video lessons

      Over 5 hours of video

    • Supplementary materials

      How-to guides, query diagrams

    • Access to the course forever

      You can return to the material at any time

    • Practical tasks

      No access to assignments

    • Teacher support

      No assistance is available

    • Certificate

      The document is not foreseen

    $100

    To learn the basics of advanced SQL

  • Advanced

    Practical and in-depth study of SQL

    • 80 video lessons

      Over 8 hours of video

    • Supplementary materials

      Query diagrams, checklists, how-to guides

    • Practical tasks

      200+ verified tasks

    • Certificate

      Course completion document

    • Teacher support

      No help available

    $200

    Ideal for those who want to consolidate knowledge in practice

  • Premium

    Maximum opportunities to learn advanced SQL

    • 120 video lessons

      Over 12 hours of video

    • Supplementary materials

      Tutorials, benchmark solutions, query diagrams

    • Practical tasks

      300+ tasks with automatic checking

    • Teacher support

      Answers to questions within 24 hours

    • Certificate

      Confirmation of your knowledge and skills

    $300

    Ideal for learning SQL at a professional level

Any questions?

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

    Try this. First lessons and 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 of our lessons are recorded and available online, 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 the training last?

    Some students complete the entire Advanced SQL course in a week, while others need several months.
    It all 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 .