SQL Essentials: The Beginner's Guide to SQL Language
What you'll learn
- Write SELECT queries for relational databases.
- Use SQL for data analysis
- Avoid common errors
- Be comfortable putting SQL on your resume
- Write complex SQL queries, getting data from multiple tables
- Aggregate data using GROUP BY
- Lead your way in the database world
- Enhance your SQL skills, filling any gaps you might have
Requirements
- No prior knowledge/experience is required. Only your desire to learn.
- A PC/Laptop for lab exercises: Windows or MacOS
- No licenses: all the software we use is free
Description
The course has everything you need to start writing your own SQL queries.
Why learn SQL? Short answer is - if you know SQL well, you'll always be able to find a job! That's because it is used in a variety of different job roles:
- Data Analysts
- Data Scientists, Data Engineers
- Database / Datawarehouse Developers and Designers
- Software Quality Assurance Engineers
- And more!
The SQL language seems simple - and that's true. However, some topics can cause mistakes - things like NULL values, duplicate rows and missing rows, etc. This course covers the frequent mistakes, and how to avoid them.
You will learn SQL syntax applicable to most relational databases. In the practice exercises you will use PostgreSQL, but the knowledge is easily transferable to other databases: PostgreSQL, Oracle, Microsoft SQL Server, MySQL, Teradata and so on. The standard SQL is the same in all ANSI-compliant SQL databases.
Why this course? Because it was made based on the author's experience from the industry - so the course focuses on the topics and features that are really used on a day-to-day basis for data analysis.
Features:
- High-quality video lectures
- English subtitles (closed captions) hand-made for you (NOT auto-generated)
- Practice tests
- Practice exercises to test and enhance your knowledge (with explained solutions)
- And more!
I'll be happy to see you inside the course. Check out the free preview videos for more information!
Who this course is for:
- Data Analysts
- Data Scientists
- Data Engineers
- Database / Datawarehouse Developers and Designers
- Software Quality Engineers
Instructor
- 4.7 Instructor Rating
- 3,760 Reviews
- 21,670 Students
- 5 Courses
*** For English, please scroll down ***
Всем привет! :)
На основной работе я занимаюсь построением аналитических решений для крупнейших Заказчиков как в России, так и за рубежом. Эти решения требуют обработки больших объёмов данных - это озёра данных (Data Lake) и хранилища данных (Data Warehouse), информацию из которых нужно обрабатывать, в том числе с помощью SQL и Python. Опыт работы более 18 лет.
Также я периодически провожу обучающие курсы (тренинги) для программистов по базам данных и другим темам. Это формат обучения "в учебном классе" для Заказчиков.
В качестве хобби занимаюсь разработкой под iOS и Web.
Высшее техническое и высшее экономическое образование.
Добро пожаловать на мои авторские курсы.:)
ENGLISH
Hello, Everyone! :)
My primary job is all about large scale data analytics. More than 18 years of experience working with enterprise data warehouses and data lakes, processing data using various tools, including SQL and Python.
I also teach various in-class trainings for Customers.
As a hobby, I do programming for iOS and Web.
I have a Masters degree in Mathematics / Computer Science, and a Masters degree in Economics.
I welcome you to my courses.:)