0
Views
Advanced SQL - course RUB 2,920. from Shultais education, training 36 lessons, Date November 28, 2023.
Miscellaneous / / November 30, 2023
The advanced SQL course includes three training blocks in different directions: transactions, stored procedures and window functions. In the section on transactions, you will become familiar with transaction isolation levels in SQL and learn how to prevent anomalies. Stored procedures, triggers, and views will allow you to automate and simplify your work with your database. SQL window functions help you take your data analytics to the next level.
WHO IS THIS COURSE SUITABLE FOR?
The course is intended for analysts, marketers, economists, database developers and programmers, who have a good command of the basics of SQL, understand what JOIN, UNION and subqueries are and are ready to improve skills. If you are not confident in your skills, we recommend taking the SQL Fundamentals course first.
DATABASE DEVELOPER
Learn to use SQL transactions for maximum performance and reliability.
Automate work with the database using stored procedures and triggers.
Learn how to find and optimize slow SQL queries.
ANALYTICS
Learn to use SQL window functions to analyze data.
Learn how to combine grouping, segmentation, aggregation, and windows in one query.
Significantly improve your information processing skills.
MARKETOLIST
Learn the analytical capabilities of the SQL language.
You will learn how to analyze information on users and products in various combinations.
Learn how to calculate cumulative values, calculate moving averages, and other techniques.
1. Transactions 7 lessons, 19 tasks
Learn what SQL and ACID transactions are.
Become familiar with transaction isolation levels.
Learn to combat the effects of lost update as well as dirty, non-repeated and phantom reads.
2. Stored procedures, triggers, views 10 lessons, 23 tasks
Learn to create stored procedures and functions to automate work with databases.
Get acquainted with methods for analyzing the performance of SQL queries.
Learn how to create and launch triggers.
Learn to write submissions.
3. SQL Window Functions 19 lessons, 49 tasks
Learn about SQL window functions.
Learn to use aggregation functions with windows.
Master segmentation using OVER and PARTITION BY.
Learn absolute and relative ranking of data.
Become familiar with SQL statistical and analytical functions.
Learn how to use frames and spacing.
Subscribe
YOU MIGHT ALSO LIKE
