SQL for data analysis - free course from Skillbox, training, Date: November 29, 2023.
Miscellaneous / / December 05, 2023
Marketers
You will learn to analyze customer data without the help of developers and analysts and be able to make the right marketing decisions.
Analysts
You'll learn the ins and outs of different databases, learn how to query, be able to work on complex problems, and become a more valuable employee.
Managers and business owners
You will learn to obtain data from databases, analyze it and use it to make decisions about the future of the product.
Data Analysis and SQL
Learn how SQL is used to solve analytical problems. You will make your first queries in a test environment with the SELECT statement.
SELECT statement - selecting columns
Learn to select columns from a table and perform calculations in them.
SELECT Statement - Row Filtering
Learn about SQL filters, learn how to combine filters for numeric and string fields.
Sorting and functions for working with strings
Learn to sort data and use mathematical functions, functions for working with strings and dates.
Functions for working with date and time. Part 1
Learn how to work with system date and time. Learn the parts and formats of dates and times. Learn to perform date and time operations in queries.
Functions for working with date and time. Part 2
Learn to work with equality conditions for date and time fields. You can convert strings to date and time. Learn to create date and time type values.
Aggregate functions and grouping
Learn to use aggregate functions and group data.
Merging data from different tables
Master nested queries, the JOIN operator, learn about the features of joining tables, study the NULL value and joining using UNION.
Modifying tables
Learn how to create tables, load data into them, and modify them.
Window functions
Master window functions: OVER, LAG, LEAD, RANK, row_number, learn how to add partitions.
Preparing data for Excel
Learn to prepare data for Excel pivot tables and graphs, combine data across a time scale, and use the CASE statement.
Graduate work. Preparing data for analysis
It will be necessary, according to the customer’s instructions, to create the necessary queries using filtering, grouping, merging data and various functions, unload data from the database and prepare it for analysis in Excel.
S
Shooricon
28.12.2022 G.
Great platform for learning
Advantages: Clear video lessons, free pace of learning, ability to buy in installments. Disadvantages: Not found. Took a SQL course for data analysis. Before starting, I already had some idea of SQL, so everything was extremely clear, but I think even without any basic knowledge, the course is easy to learn, because the video lessons are clear, and the curators answer all your questions and are quite fast. Kr...
P
PopovaYuO
24.09.2022 G.
Great platform to learn
Advantages: Convenient platform, useful up-to-date knowledge, unlimited time. Disadvantages: None At work, there was a need to understand and write in SQL, and since Skillbox was recommended to me more than once by friends, I didn’t even bother looking for a course on other platforms. My choice fell on the course "SQL for Data Analysis". It is convenient that it is possible to pay for the course in installments, since the price is not...
S
Svet0406-01
08.08.2022 G.
Productive, useful, quality training
Advantages: Documentation package, high level of teaching. Disadvantages: none found. Completed the SQL data analysis course. Received significant advancement in my specialty. The course is interesting and productive. The quality of teaching is high. A large package of documentation is purchased. The ability to quickly receive online consultations from a teacher helps to get out of difficult...
Agent Boy
13.01.2023 G.
I decided to change the type of activity and the start was successful
Advantages: 1. The training system is built competently 2. Opportunity to hear feedback 3. Diploma project 4. General chats with curators and students. Disadvantages: I didn’t notice any, but I will note that when purchasing a course, you cannot make a tax deduction for it. I purchased it in the fall. course from Skillbox "SQL for data analysis" because I have long been thinking about how to start smoothly learning analytics and far...
The course examines the possibilities of using MS Excel for statistical data processing, hypothesis testing, and time series analysis. The training is aimed primarily at familiarization with the basic statistical techniques, their step-by-step practical application and interpretation of the results obtained, and not on memorizing formulas or definitions. Participants will receive tasks to complete independently and formulate conclusions on the results achieved.
4
11 900 ₽