Online SQL courses for analysts - course RUB 18,100. from the International School of Professions, training 5 weeks, Date November 30, 2023.

Hello everyone :-)My name is Stanislav. Currently I live in the Tula region. I have several higher educations. Main - MSTU im. Bauman with a specialization in Computer Science and Control Systems. Second - Economic - Finance and credit. Third - Management of organizations. I have been working in IT for over 15 years. I started as a system administrator, system engineer. Worked in various large and international organizations, such as RAO UES, Yandex, Microsoft. Worked in different positions and directions. Completed projects of varying complexity. In recent years, my development vector has shifted from system administration to the implementation of web projects: I am involved in their creation and promotion. And of course, you have to use programming using Python, C#, JS, as well as SQL, CSS, HTML. At the moment, your favorite language is Python. I really love sharing knowledge and my experience. I have been teaching for the last 7 years. And I'm very glad that I became part of OTUS :-) Teacher

1. Getting started with databases

Explore

1.Analyst tools
2.SQL query language
3.Development environments
4.Principles of creating a database
5.Database management system (DBMS)
6. Data analytics methods

Master it

• SQL
• Database
• DBMS
• Workbench

On practice

• Everyone will create their own database under the guidance of a teacher.
• Install and master the Workbench interface.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

2. Basic SQL Query Syntax

Explore

1.SQL query statements SELECT ALL/DISTINCT, FROM
2.Auxiliary operators: WHERE, GROUP BY, HEAVING
3.Sorting data
4.Assigning nicknames
5. Regular expressions
6. Comparison predicate using various functions: (LIKE, BETWEEN, IN, NOT IN)
7.Total values ​​(sum, min, max, count)

Master it

• Operator options
• Grouping data
• CASE expressions
• Aliases

On practice

• We make queries using learned operators.
• Sorting database information.
• Assign aliases to variables.
• We perform basic queries.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

3. Multi-table queries and SQL subqueries

Explore

1. Join types of multi-table queries (LEFT/RIGHT/INNER/FULL JOIN)
2.Vertical connection operations (UNION/UNION ALL)
3.Using operators with subqueries
4.Rules for using subqueries
5.Get data summaries
6.Output of data from several tables

Master it

• Joining tables
• Scalar queries
• Data sampling
• Summaries

On practice

• We solve problems with multi-table queries under the guidance of a teacher.
• We practice the acquired skills on our own database.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

4. SQL queries for working with tables

Explore

1.SQL queries to add/remove data
2.Converting columns in a table
3. DDL language operators
4.Changing the structure of an existing table

Master it

• DDL
• SQL queries
• Converting tables
• ALTER TABLE

On practice

• Let's work on problems using VIEW structures.
• Let's complete tasks on using operators.
• Let's study data types CHAR & VARCHAR, NUMBER & DEC, DATE.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

5. Data Analytics

Explore

1.SQL Analytical Functions
2.LAG/LEAD
3.Query function in GoogleSheet
4. Data ranking
5.Query in building analytical tools for business

Master it

• RANK
• DANGE_RANK
• GoogleSheet: Query
• FIRST/LAST

On practice

• We will test new functions on our database.
• Let's learn how to run queries using the Query function in GoogleSheet.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

6. Working with Google BigQuery

Explore

1.Google BigQuery tasks
2. Analysis of the Google BigQuery interface
3. Data sampling
4.Creating reports based on samples
5.Collection, processing and presentation of information

Master it

• Google BigQuery
• Making report
• Data sample preparation
• Google Analytics 4

On practice

• We analyze data using Google BigQuery.
• Learning to write reports.
• We make selections using SQL queries.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

7. Cohort analysis

Explore

1.What is cohort analysis and where to use it
2.Requirements for cohort analysis
3.How to use the obtained data for further work
4.Analysis of user group behavior

Master it

• Cohort analysis
• Analytics KPIs
• Efficiency 
• Advertising payback

On practice

• Learn to determine the effectiveness of your marketing decisions.
• We create our own sample using cohort analysis.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

8. Preparation for the project

Explore

1.Selecting a DB topic, discussion with the teacher
2. Finalization of already created databases during the training process
3.Development and setting of necessary tasks (marketer/analyst/developer)

Master it

• Concept
• Tools
• Analysis
• Setting goals

On practice

• Let's start developing our own project for the portfolio.
• Let's decide on a topic and divide it into tasks.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

9. Project work

Explore

1.Creating a case
2. Hypothesis testing
3.Work on mistakes
4.Answers to questions

Master it

• Case
• Hypotheses
• Processing requests
• Debugging

On practice

• We will work out the details of the project and learn to see and correct errors in our own work.
• We will prepare the project for presentation.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

10. Project protection

Explore

1.Project presentation
2. Development prospects
3.Design of the finished case
4.Start a career in analytics
5. Opportunities for growth in the profession

Master it

• Self-presentation
• Working with feedback
• Case in portfolio
• SQL for Analysts

On practice

• You will present your first project to the group, learn to work with feedback and understand how to develop in the analytical profession.
The teacher will evaluate the result of the assignment and discuss it with you in detail.