SQL for working with data and analytics: online

Miscellaneous / by admin / December 09, 2023

click fraud protection

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 online course: you will learn how to create databases and make queries in 6 weeks
02. Lots of practice: you will immediately put your knowledge into practice and begin solving problems in your professional field
03. Individual approach: consultations with the teacher and feedback in 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

instagram viewer

Convincingly present the results of your work
prepare data for Excel tables and graphs and use visualization to analyze data

Requirements for the level of training
You can start training from scratch, without experience in data analysis

Features of training
Online classes on Mondays and Thursdays from 18.10 to 21.00

Teacher of the course “Simulation modeling for analysis and optimization of business processes.” Associate Professor at the Faculty of Informatics, Mathematics and Computer Science at the Higher School of Economics in Nizhny Novgorod, Candidate of Computer Science. Expert in the field of business informatics, academic director of the educational program "Business Informatics" at the Higher School of Economics - Nizhny Novgorod. Best teacher at the National Research University Higher School of Economics in 2018, 2019, 2020, 2021 and 2022.

Databases and their purpose for solving business problems 4 hours + independent work

You will learn how modern DBMSs differ from spreadsheets, what are the advantages of relational databases and learn how to work with them.

Concepts of databases and their management systems, application for solving analytical problems in business;
Advantages of databases compared to heterogeneous and multi-format tables;
Introduction to the PostgreSQL DBMS;
Analysis and filtering 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. Simple queries 4 hours + independent work

Review the purpose, syntax, and semantics, that is, the rules and basic constructs of Structured Query Language.

Relationships between tables. The concept of primary and foreign key in relational databases;
Creating SQL queries linking multiple tables. Aggregation functions GROUP BY, ORDER BY, HAVING.

Practical lesson. Creating SQL queries using various functions.

SQL queries against multiple tables, relationships between tables 4 hours + independent work

Learn multi-table queries and be able to join tables in different ways to streamline your workflows.

Queries with keywords 4 hours + independent work

Understand how to work with commands and structured queries using keywords to manage tables, process and retrieve the information you need.

Aggregate functions 4 hours + independent work

Consider Structured Query Language aggregation procedures and learn how to calculate result values and reduce a long set of rows to a single total.

Administration of PostgreSQL DBMS 4 hours + independent work

Expand your knowledge of the purpose of an open source relational database management system. In practice, you will understand how to use the program and manage information in databases.

Data normalization for database design. Moving from an unstructured data set to linked tables. Working with ER diagrams;
Basics of PostgreSQL DBMS administration. Creation and modification of tables (CREATE TABLE, DROP TABLE, etc.). Subqueries and temporary tables in SQL.

Practical lesson. Creating your own database in a DBMS and modifying tables.

Window functions and pivot tables 8 hours + independent work

Explore categories of commands and declarative statements that can be used to make edits to tables and much more.

Working with window functions OVER, LAG, LEAD, RANK, row_number, adding partitions;
Preparing data for Excel. Pivot tables and graphs. Combining data across time scales. CASE statement.

Practical lesson. Working with window functions, preparing data for pivot tables.

Stored components in BI tools 4 hours + independent work

Formulation of a business problem (case);
Selecting tools for implementation. Drawing up a plan to solve the problem. Solution analysis;
Visualization by Business intelligence resources.

Practical lesson. Setting your own project tasks and implementing them using the tools you have learned.

Final project 4 hours + consultations

Prepare and defend your own final project.

Tags cloud

Miscellaneous

Rating

Views

Comments