Comprehensive SQL Course For Data Professionals [NEW]

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

What you'll 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.

Description
Welcome! I am looking forward to helping you to become proficient in SQL, one of the fundamental skills required to become a data professional. SQL is one of the important skill required to become data engineer, data analyst, data scientist, web developer, application developer etc. So, if you aspire to be a competent data professional, this is course is for you! Course Approach:This is a comprehensive hands-on course with 120+ SQL coding exercises and a Real World Project of building a database for one of the popular sporting tournaments, and writing all the SQL statements required for the tournament website. I have combined my experience working with SQL in the industry for 25 years with teaching on Udemy for 160,000 students to create this comprehensive curriculum. Throughout the course, I provide guidance on using best practices for writing SQL statements and also take you through real world examples. I value your time as much as I do mine. So, I have designed this SQL course to be fast-paced and to the point. Also, the course has been taught with simple English and no jargons. I start the course from basics and progress to complex topics, and by the end of the course you will be proficient in SQL. Comprehensive Curriculum:Beginner Level Topic:Introduction to Databases and SQLBasics of SQL statementsQuerying DataFiltering DataIntermediate Level Topic:Simple SQL functionsDate FunctionsConditional Expressions & FunctionsAggregate FunctionsGrouping DataSQL JoinsSQL ConstraintsPrimary & Foreign Keys and RelationshipsAdvanced Level Topic:Database Design & Entity Relationship DiagramsSubqueriesCommon Table Expressions (CTEs)ViewsWindow/ Analytical FunctionsProject:Requirements gathering & Database DesignWriting SQL Queries for a WebsiteANSI SQL:This course follows the ANSI standard for SQL. So, once you complete the course, you will be able to with with SQL on all major databases such as MySQL, PostgreSQL, SQLite, Oracle, SQL Server etc, and also with any big data and parallel processing engines such as Spark SQL, Hive SQL, Snowflake, Google BigQuery, Azure Synapse etc. Course Outcome:Once you have completed the course including all the SQL coding exercises and the project, I genuinely believe that you will be in a position to start working in a real world data project using SQL.Student Feedback:Here are some of the reviews from existing students which may help you make the decision, but also please feel free to go through the reviews from others at the bottom of this page!  Ayantika N [5*] - This is my first-hand experience with SQL. I thoroughly enjoyed the course, especially being a student with no background in computer language. I found the course well-thought out and beneficial for me. The hands-on examples are really well explained. I look forward to coming back to your courses in future as well. Kudos to you!! :)Mayank S [5*] -  A very comprehensive course which starts with the basics then slowly moves on to intermediate and advanced concepts. The best part is the practice exercises to solidify one's understanding. Easy to follow along.Ritesh T [5*] -  I have purchased all his courses. The best part of him is that, he explains the concepts + the use cases where it would be used. Just like his databricks, azure df, azure synapse courses, the theories are there as well as the  scenarios where such concepts could / would / should be used. There are times when a student like me who is working on live projects could use a particular concept, and bingo, his lectures come life saving.

Who this course is for:
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