SQL Time

SQL Time

SQL for managers

Tired of constantly pinging an analyst or developer when you need to get data for analysis? Now imagine that you can independently and as quickly as possible get the necessary information from the database for report compilation, analysis, effective communication with the client or hypothesis testing. And you don’t have to write any requirements, create tasks and wait for them to be done... SQL Time course will help you make this dream come true.

Learn more
Real

DataBase

3 expert

speakers

Middle

complexity level

Real
DataBase
3 expert
speakers
Middle
complexity level

Who needs SQL Time?

Tired of constantly pinging an analyst or developer when you need to get data for analysis? Now imagine that you can independently and as quickly as possible get the necessary information from the database for report compilation, analysis, effective communication with the client or hypothesis testing. And you don’t have to write any requirements, create tasks and wait for them to be done... SQL Time course will help you make this dream come true.

Иерархия

Those who want to learn SQL database

middle business analyst

Project Manager

future sales

Product Manager

повышение

Product Analyst

Project manager

Business Analyst

Add these skills to your resume:

  • Understanding database storage architecture and structure

  • Connecting to databases and process data

  • Working with basic select and join queries

  • Writing correct SQL queries to database

  • Combining results of multiple queries

  • Working with MySQL analytics functions

  • Integrating database data with Power BI visualizers, Tableau

  • Creating the right requirements for the developer’s data sampling

What will you learn?

What will you learn?

Add these skills to your resume:

  • Understanding database storage architecture and structure
  • Connecting to databases and process data
  • Working with basic select and join queries
  • Writing correct SQL queries to database
  • Combining results of multiple queries
  • Working with MySQL analytics functions
  • Integrating database data with Power BI visualizers, Tableau
  • Creating the right requirements for the developer’s data sampling

Course program:

Basics of working with SQL and databases

Databases for noobs. Types of databases. Necessary language theory to work with database. SQL syntax. Ways to send a query and not ruin the database. SQL operators. Subsets, tables, and SQL fields.

What problems will we solve?
✓ Lack of understanding of database storage structure
✓ Incorrect requirements for developer that slow down data processing
✓ Heavy queries that can ruin a database if you do not know the basics of SQL

Videolecture. Working with select and join queries

Work with queries and their structure. Using cluster, aggregation and filter operators. Connection types. Working with queries and sub-queries JOIN and SELECT. Studying the functions of UNION and UNION ALL.

What problems will we solve?
✓ Not knowing how to use SQL queries to get data
✓ The tables contain thousands of data that's hard to work with
✓ Unable to effectively work with data from different tables

Videolecture. SQL Analytics for Managers

Type conversion (CAST function) and statistical functions (SUM, AVG, MIN, MAX, COUNT). Date and time functions, string, window and logic functions. 15 most common functions for analytics.

What problems will we solve?
✓ Ineffective data analytics due to lack of functions knowledge
✓ Difficulties in processing data through a bundle with Excel
✓ Analysis of database data is very time-consuming

Online Q&A

Videolecture. Visualization of received data. Power BI

Integration of received data from database with Power BI. Nicely looking data visualization. Reports design.

What problems will we solve?
✓ Lack of proficiency in visualizing received data
✓ Creating very basic and uninteresting reports for stakeholders and team
✓ Visualizing data is time-consuming, incomprehensible and difficult

Online Q&A

Visualization in Excel (pre-recorded lecture)

Why you only use Excel for 10%. Formulas that will help make BA life easier. Diagrams or how to explain dependencies. Dashboard on a shoestring.

What problems will we solve?
✓ Using Excel is not at full capacity
✓ Ignorance of formulas
✓ Difficulties with visualization

Visualization in Tableau (pre-recorded lecture)

Types of visualizations: dynamics, shares, dependencies. Visualization Rules. Mistakes you can make in the tool. Overview of the tool: worksheet, dashboard, analytics.

What problems will we solve?
✓ Inability to use full functionality
✓ Difficulties with visualization
✓ Mistakes made by beginners

Спікери

Алексей Поган A

Alexey Pogan

Project Manager at HELSI

More than 16 years in IT. During this time he went from Oracle developer to Head of Project Management.

More than 16 years in IT. During this time he went from Oracle developer to Head of Project Management. Started as a database developer. He has a blog where he teaches SQL beginners.

момот O

Olga Momot

Business Analyst at Eva

More than 14 years in data analytics, the last 2 years specialized in developing reports in Power BI.

More than 14 years in data analytics, the last 2 years specialized in developing reports in Power BI. Masterfully sharpened her skills in Excel, Power BI (DAX), MySQL.

grekov D

Denis Grekov

Lead analyst at WhaleApp

More than 17 years of engineering experience, 7 years of work in IT as a Data Analyst. Uses SQL, BQ, Tableau, R, Python and can tell everything about it.

More than 17 years of engineering experience, 7 years of work in IT as a Data Analyst. Uses SQL, BQ, Tableau, R, Python and can tell everything about it. Knows everything about data analysis and processing.

What you will get

Тех.спец

Real cases and database

No examples detached from reality and simulators. Only practice that you can already add to your resume.

Новый уровень задач

Only necessary knowledge

We will not burden you with a useless theory that will never be useful to you in your work. At the course we review only actual practical cases for Managers and Business Analysts.

Нужные навыки

Practice right in class

Each session will be accompanied by practical tasks in the database to practice the obtained theory directly with the speaker and receive recommendations from him.

документация

Diving right into

You do not need to spend months studying SQL. On the course we will give only the necessary basis for your current or future work.

Сертификат

Practicing experts

Speakers of the course have extensive experience of working with SQL on real successful projects, which gives the opportunity to get actual first-hand knowledge on your particular issue.

Общение

Tips 24/7

Add you to a private chat room where you can get advice from speakers or fellow students even after completing the course, consult with the best and get an expert evaluation

We help with employment

  • Recommendations for improving your resume and portfolio
  • Assistance in creating and improving a cover letter
  • Preparing for an interview and passing test assignments
  • Personal advice on career development
  • Assistance in finding relevant vacancies
  • Internships and special offers from partner companies
  • Letter of recommendation from speakers and mentors for the best students

Still in doubt? Leave an email to get answers for all questions!

Learn how to get an additional discount. Leave a request for receiving a discount.

    kzt 16.5eur 0.0274usd 0.0274

    FAQ

    Why would I need to know that, I have a developer in my team who knows everything?

    Now your reality looks like this:

    Write a technical task for the developer – create the task on a board – wait until he gets to it – realize that you got the wrong data – write another technical task. And so on and on. 

    While it could have been like this: create a query yourself – get the data. 5 minutes task. 

    That’s why you need to know this.

    I’m a manager, I dont’ need SQL in my work. Why would your course be useful for me?

    Every other company uses databases for data storage. Sooner or later you will be faced with a project in which at least an understanding of the structure and principles of data storage in the database will be required. And the maximum – the ability to independently get the necessary data (to test the hypothesis, to prepare a report for the client, etc.). But it’ll be too late…

    There’s plenty information about SQL on internet - I’ll figure this out myself

    Do you know what kind of information you really need that will be useful in practice in future? Yes, there is a lot of information on the Internet, but all of it is: 

    • disconnected from the reality of the manager
    • scattered
    • too deep
    • incorrect at times

    In the end, you’re going to spend months learning the theory you don’t actually need, when you could have spent two weeks.

    There are many other SQL courses - why would I choose yours?

    Most of these courses look like this: theory + homework, and they also last a month or two. We suggest to study the necessary basis for comfortable work with data with the help of practical workshops in just 2 weeks. In addition, almost all courses are designed for Data or System Analysts, when we collected only the most necessary cases for Managers and Business Analysts.

    What if I’ve never studied SQL or worked with databases, will this course be the right for me?

    Yes, the course program is designed for those who want to learn from scratch the necessary SQL database for effective data management. During the course we will not only practice, but also analyze all the necessary theory.

    How are practical lessons of the course conducted?
    • The sessions are held in the format of two-hour online workshops, where speakers share their experience, show tools and answer questions.
    • From the theory we give exactly the knowledge that, first of all, the non-technical specialist needs when working with SQL.
    • We have developed all the basic skills in practical workshops to make sure that all students will leave the course with the right skills.
    Can I take only those lectures that are interesting to me, instead of buying the whole course?

    Unfortunately, this is not possible. The lectures are interconnected and the material of each lecture can refer to the knowledge gained from the previous one. In addition, the course contains homework, practice, and work with cases. Therefore, to get the maximum benefit, you need to take the lectures in the order indicated.

    Will I get a certificate?

    Yes, we will issue you a course completion certificate. It will be available online for pinning on LinkedIn.

    Also, once you complete all homework assignments and pass the exam, you can get a certificate of honor.

    Can tuition be paid in installments?

    Yes, it can be paid in installments. The conditions for splitting payments are discussed individually for each specific case.

    Still in doubt?

    Leave your E-mail to get answers for all questions!