The Complete SQL For Absolute Beginners Course
What you'll learn
- Manipulate Data using SQL
- How to Create Tables
- How to Insert Data into Tables
- How to Combine Different Tables
- How to Build Tables using a practical Case Study
- Computer with at least 4 GB of RAM
- Access to the Internet
So, you've decided that you want to learn SQL or you want to get familiar with it, but don't know where to start? Or are you a data/business analyst or data scientist that wants to power up your data skills by performing queries with Structured Query Language?
Then, this course was designed just for you!
This course was designed to be your first step into the SQL programming world! We will delve deeper into the concepts of SQL queries, understand the MySQL user interface and play around with several datasets. This course contains lectures around the following groups:
Code along lectures where we will go step-by-step in each instruction, compounding our SQL knowledge.
Test your knowledge with questions and practical exercises with different levels of difficulty!
Analyze real datasets and understand the thought process from question to SQL code solution!
This course was designed to be focused on the practical side of coding in SQL - instead of teaching you every possible function out there, we'll learn all the fundamentals slowly and build our knowledge from scratch. We'll use a case study to cement every concept we will learn, so that you can have a hands-on learning process, making it easier to apply the concepts in your projects.
At the end of the course you should be able to use SQL to build and manipulate tables. Along the way we will also learn the most important SQL statements such as GROUP BY, INSERT INTO or CREATE TABLE.
Here are some examples of things you will be able to do after finishing the course:
Join different tables using SQL;
Create your own tables with the appropriate structure.
Use different data types according to their characteristics.
Create columns using data available from your existing tables.
Use subqueries, building complex instructions.
Join thousands of professionals and students in this SQL journey and discover the amazing power of this querying language.
This course will be constantly updated based on students feedback.
Who this course is for:
- Data Analysts
- Data Scientists
- Data Engineers
- Full Beginners that want to learn how to work with SQL
- Marketing, Finance and Supply Chain Professionals
- IT Professionals
Ivo Bernardo is a professional with a passion for Data Science and Analytics and is currently a Partner at DareData Engineering, a startup that implements machine learning systems all around world for companies of different sizes (from startups to large enterprises). He holds a master Degree in Statistics and Business Intelligence from New University of Lisbon and has been an instructor in several data science academies throughout the years. His main teaching passion is helping beginners or professionals from other industries taking their first leap into the Data Science and Analytics space.
Technically he has worked with Python, R, SQL and main cloud providers infrastructure. Feel free to contact him on LinkedIn or via Udemy for potential business ventures or collaborations.
Ivo Bernardo é um profissional com grande interesse por Data Science e Analytics. De momento, é Partner da DareData Engineering, uma startup que implementa sistemas de machine learning em todo o mundo para empresas de diferentes tamanhos (desde startups a grandes organizações). É mestre em Estatística e Business Intelligence pela Universidade Nova de Lisboa e participou como instructor em algumas academias data science em Portugal. A sua principal paixão enquanto instrutor é ajudar iniciantes ou profissionais de outras áreas a dar o seu primeiro passo no mundo de Data Science e Analytics.
Tecnicamente, trabalha maioritariamente com Python, R, SQL e com a infraestrutura das plataformas cloud mais relevantes do mundo. Pode contactá-lo directamente no LinkedIn ou via Udemy para potenciais colaborações ou outros assuntos relacionados com Data Science.