0
Views
Basics of SQL for data analysis - free course from Skypro, training 2 months, Date November 29, 2023.
Miscellaneous / / December 02, 2023
You will develop your data skills and take your first step in a sought-after profession.
You will learn how to analyze data yourself and be able to make more accurate, effective decisions.
Learn to extract information from databases and deeply analyze user behavior.
Learn the nuances of working with databases and help businesses make effective data-driven decisions.
You will learn how to improve a website or application through competent work with databases.
You participate in webinars, live 60-minute video lessons, and complete an assignment after each lesson. Lessons can be reviewed at any convenient time.
From the beginning of the course, you will solve problems close to analyst work tasks in the popular Jupyter Notebook interpreter. This is a real development environment that you can use for your own work tasks.
You analyze real problems in team master classes under the guidance of an expert. Share your experience, receive support and useful connections in a professional environment.
Author and teacher of the SQL course
Lead Product Analyst at Skyeng.
Developed a system to combat fraudulent transactions in the Ukrainian Alfa-Bank. Together with Spanish colleagues, he advised Big 4 banks: analyzed millions of transactions and proposed solutions to save millions of dollars. Analyzed and forecast key business indicators for Skyeng top management.
Product analyst at Skyeng. Mentor for the course. 2.5 years in analytics and 2.5 years in SQL.
Together with the team, he launched a premium product and helped speed up the selection of teachers at Skyeng. Improved the algorithm for recognizing visa hotel reservations in Ostrovok.ru. Reduced type II errors by 69%. “I will help a novice analyst quickly master SQL and become a great specialist. SQL is to an analyst as air is to a person. It makes it easier to dig into the data, look for insights, test hypotheses and make recommendations to the business.”
Data engineer at Skyeng. Author and teacher of the course. Uses SQL in work for more than 8 years.
Works in a team of data engineers at Skyeng. Developed reporting for a TOP-10 bank. Was an MS SQL developer at one of the leading mobile trade automation companies in the CIS. Worked with AWS Redshift, Microsoft SQL Server, Oracle, PostgreSQL, MySQL, DB2 and other databases.
Module 1
Working with native data
Basic queries
Learn to select and filter data using SELECT, FROM, WHERE statements. Learn how to sort data and use conditions.
Homework
Generation of new features and data cleaning
You will understand how to work with the CASE statement. Learn how to create new features and filter by them.
Homework: prepare a data sample for training a recommendation model for an online store.
Test work for the module: upload data for the marketing department under certain conditions.
Module 2
Data Conversion
Aggregate functions
Learn to aggregate data, group it by fields, find the sum, find the minimum, maximum, number of unique elements and average.
Homework
Joining tables
You will learn how to combine tables, study the methods and be able to choose the right one for your task.
Homework
Subqueries and WITH
Understand how to do nested queries and create temporary tables to store intermediate data. Master the WITH constructs and learn how to use it to write complex queries.
Homework
Window functions
Learn the functions OVER, LAG, LEAD, RANK, ROW_NUMBER. Learn to calculate indicators for different groups of objects: deviation from the average for the group and as a whole, the serial number of customer transactions, moving average.
Homework
Master class: conducting analytical research and solving a business problem using SQL
You will be immersed in a real-life data analyst task and help a business solve a problem. Under the guidance of a mentor, you will analyze data from different tables, first cleaning them and creating new features.
Homework
Module 3
Database Administration Basics
Creating, changing, deleting data in a table. Creating indexes. Temporary tables
Learn to create, modify, delete data in tables and the tables themselves using the CREATE, UPDATE, INSERT, DELETE, DROP commands.
You will understand how to create temporary tables and use them in queries.
Homework
Optimization Basics
Systematize your knowledge of writing queries.
Learn how to write queries and learn how to choose a method for the task.
Homework
Course work
Analytical project in SQL
Educational project
A project to analyze content quality metrics and student learning outcomes on an online school dataset for 2021.
Your own project
Choose for yourself.
Subscribe
YOU MIGHT ALSO LIKE
