Description
What you’ll learn
-
You will learn how to create database tables, alter an existing table and drop a table that’s not required
-
You will learn how to query data from a table, apply transformations using functions, filter and sort the data returned
-
You will learn how to join multiple tables, summarise the data as required to produce summaries
-
You will learn how to use sub queries and common table expressions to implement complex logic
-
You will learn how to create and work with views to simplify complex solutions
-
You will learn how to use window functions to carry out complex data analysis with ease
-
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
Welcome!
I am looking forward to helping you with learning SQL, one of the fundamental skills required to become a data professional. SQL is one of the important skill required to become data engineers, data analysts, data scientists, web developers, application developer etc.
This is a hand-on course with 120+ coding exercises and a real world project of building a database for one of the popular sporting tournaments, Indian Premier League and writing all the SQL statements required for the scorecard of the tournament website.
No downloads or database installations required. I teach the course using the Udemy coding exercises platform which comes with a database installed for you! You just need a web browser with any device (i.e., iPad, tablet, laptop) to practice SQL!
Once you have completed the course including all the coding exercises and the project, I strongly believe that you will be in a position to start working in a real world data project using SQL.
I value your time as much as I do mine. So, I have designed this 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 by the end of the course you will be proficient in SQL.
Currently this course teaches you the following
-
Basics of SQL statements
-
Querying Data
-
Filtering Data
-
Simple SQL functions
-
Date Functions
-
Conditional Expressions & Functions
-
Aggregate Functions
-
Grouping Data
-
Joins
-
SQL Constraints
-
Primary & Foreign Keys and Relationships
-
Database Design & Entity Relationship Diagrams
-
Subqueries
-
Common Table Expressions (CTEs)
-
Views
-
Window/ Analytical Functions
-
Working with a Real World Project
This course assumes no prior knowledge of SQL or any programming language. Once you complete the course, I genuinely believe that you will be in a position to confidently work in a real time project using SQL!
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
Course content
- Beginner – Course Introduction3 lectures • 8min
- Beginner – Course Introduction
- Beginner – Overviews3 lectures • 16min
- Beginner – Overviews
- Beginner – Introduction to SQL Statements11 lectures • 44min
- Beginner – Introduction to SQL Statements
- Beginner – Querying Data9 lectures • 43min
- Beginner – Querying Data
- Beginner – Filtering Data13 lectures • 55min
- Beginner – Filtering Data
- Intermediate – Simple SQL Functions7 lectures • 1hr 2min
- Intermediate – Simple SQL Functions
- Intermediate – Conditional Functions & Expressions8 lectures • 1hr
- Intermediate – Conditional Functions & Expressions
- Intermediate – Date Functions5 lectures • 30min
- Intermediate – Date Functions
- Intermediate – Aggregate Functions10 lectures • 1hr 8min
- Intermediate – Aggregate Functions
- Intermediate – SQL Joins11 lectures • 1hr 18min
- Intermediate – SQL Joins
Reviews
There are no reviews yet.