Comprehensive SQL Course For Data Professionals [2024]

Become a Confident SQL Developer by Developing a Real World Project using SQL and Solving 120+ SQL Coding Exercises

Created by: Ramesh Retnasamy
Senior Data Engineer/ Machine Learning Engineer

What Will I Learn?

• You will learn how to create database tables, alter an existing table and drop a table that's not required using SQL
• You will learn how to query data from a table, apply transformations using functions, filter and sort the data returned using SQL
• You will learn how to join multiple tables, summarise the data as required to produce summaries using SQL
• You will learn how to use sub queries and common table expressions to implement complex logic using SQL
• You will learn how to create and work with views to simplify complex solutions using SQL
• Using SQL, you will learn how to use window functions to carry out complex data analysis with ease
• Using SQL, you will learn how to design and implement a database for a real world project
• You will learn how to write SQL queries required to satisfy the requirements for a real world project

Requirements

• No prior SQL or programming experience necessary. I will start from the basics and also provide detailed step-by-step instructions
• No database installation required. We use the database provided by the Udemy Platform. So, any device that you are using to take the course is sufficient.

Target audience

• University students looking for a career in Information Technology
• Software Engineers working with data, i.e, Web Developers, App Developers etc
• Anyone interested in Data Engineering, Data Analysis, Data Science, Business Intelligence etc