0
Views
SQL for working with data and analytics - course RUB 22,000. from HSE, training 1.5 month, date of February 27, 2023.
Miscellaneous / / December 07, 2023
In 1.5 months of training in the intensive course "SQL for working with data and analytics" you will master a powerful tool for working with data - the SQL query language. You will learn what relational databases are and learn how to create them in the PostgreSQL DBMS. You will be able to write various types of queries and use them to extract the necessary data, so that you can then use it for analysis and visualization, as well as use SQL to solve business problems
01. Intensive course: you will learn how to create a database and make queries in 6 weeks
02. Practical business tasks: you will immediately apply knowledge in practice and solve problems in your professional field
03. Face-to-face format: you can consult with the teacher and receive feedback during each lesson
Quickly turn data into information
create queries in SQL language, use SQL to find the necessary data and manage data in the PostgreSQL DBMS
Optimize process or product management
determine metrics and indicators for analyzing processes and products, analyze data and rely on the results of the analysis when making management decisions
Convincingly present the results of your work
prepare data for Excel tables and graphs and use visualization to analyze data
Ph.D., senior lecturer at the Faculty of Informatics, Mathematics and Computer Science, National Research University Higher School of Economics - Nizhny Novgorod, academic director of the educational program "Business Informatics"
Databases and their purpose for solving business problems 2 hours
The concept of a database and DBMS, application for solving analytical problems in business. Advantages of a database over heterogeneous and multi-format tables. Acquaintance with a ready-made database in the PostgreSQL DBMS. Introduction to SQL. Analysis and filtering of data when working with one table. Introduction to WHERE statements, use of mathematical functions, date and time functions, logical operators LIKE, IN, BETWEEN.
Practical lesson. Writing your first simple SQL query against a database
SQL language. Writing simple database queries. SQL queries against multiple tables, relationships between tables, aggregate functions 10 hours
Relationship between tables. The concept of primary and foreign key in relational databases. Relationships between tables. Creating SQL queries linking multiple tables. Aggregation functions GROUP BY, ORDER BY, HAVING.
Practical lesson. Creating SQL queries using various functions
Administration of PostgreSQL DBMS 6 hours
Data normalization for database design. How to move from an unstructured data set to related tables. Working with ER diagrams. Basics of PostgreSQL DBMS administration. Creating and modifying tables, filling tables with data (CREATE TABLE, DROP TABLE, etc.). Creating subqueries and temporary tables in SQL.
Practical lesson. Creating your own database in a DBMS, creating and modifying tables
Window functions and pivot tables 6 hours
Working with window functions OVER, LAG, LEAD, RANK, row_number, adding partitions. Preparing data for Excel. Prepare data for Excel pivot tables and graphs, combine data across time scales, use the CASE statement.
Practical lesson. Working with window functions, preparing data for pivot tables
SQL in solving analytical problems 14 hours
Formulation of a business problem (case analysis). Selecting tools for implementation. Drawing up a plan to solve the problem. Solution analysis. Using SQL for visualization in BI tools.
Practical lesson. Setting your own project tasks and implementing them using the tools you’ve learned
Preparation and defense of the final project
Subscribe