For any database: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, Teradata, Google BigQuery, Spark SQL, Snowflake, etc.
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!
Write SELECT queries for relational databases.
Use SQL for data analysis
Avoid common errors
6 Lectures
3 Lectures
9 Lectures
5 Lectures
8 Lectures
15 Lectures
5 Lectures
7 Lectures
7 Lectures
2 Lectures
1 Lectures
*** For English, please scroll down ***Всем привет! :)На основной работе я занимаюсь построением аналитических решений для крупнейших Заказчиков как в России, так и за рубежом. Эти решения требуют обработки больших объёмов данных - это озёра данных (Data Lake) и хранилища данных (Data Warehouse), информацию из которых нужно обрабатывать, в том числе с помощью SQL и Python. Опыт работы более...
Very good explanations and easy to follow.
This course helped me a lot in my first SQL test in my university. Got good grades. 85 marks. UDEMY is cheap and way better than my university instructors. But still why we need universities then? Cause of social orthodox rules of valuing university degrees more in job markets more than skills. So for now both UDEMY and UH.
na
the "teacher" takes his time not only to explain the content but add additional reasons or "why" some of the coding are being used
Great course. The concepts are explained well and the practical exercises enhanced my learning. I'm very happy I chose this course to learn SQL. Thanks Vlad.
Good Technique
I enjoyed the practical nature, quizzes and exercises with solutions
Oui , largement satisfait.
I just cant stand the voice and English pronunciation of the reader.
Your email address will not be published. Required fields are marked *
Vladimirs B.
Very BEST!!!