Master SQL - Basic to Advanced
Learn with Us
12 modules
English
Certificate of completion
Lifetime access
Become an SQL expert with this comprehensive course
Overview
Master SQL - Basic to Advanced is a comprehensive course designed to take you from a beginner to an expert in SQL (Structured Query Language). Whether you have no prior experience or are looking to enhance your existing SQL skills, this course covers all the fundamental concepts and advanced techniques to help you gain mastery in SQL. With hands-on exercises and real-world examples, you will learn how to efficiently use SQL to query and manipulate databases, write complex queries, optimize performance, and more.
Key Highlights
Learn SQL from scratch to advanced level
Master SQL techniques and best practices
Gain hands-on experience through real-world examples
Enhance your database management skills
Become proficient in writing complex SQL queries
What you will learn
Learning Outcome 1
Understand the fundamentals of SQL and its importance in database management.
Learning Outcome 2
Learn how to create and manage databases using SQL commands and statements.
Learning Outcome 3
Master the art of writing efficient SQL queries to retrieve, filter, and sort data.
Learning Outcome 4
Explore advanced SQL concepts such as subqueries, joins, and table expressions.
Learning Outcome 5
Optimize database performance by understanding indexing and query optimization techniques.
Learning Outcome 6
Work with complex data types, stored procedures, and triggers to automate tasks.
Modules
Chapter 1 - MYSQL Work Bench Installation
3 attachments • 39 mins
How to Install MySQL Workbench in Windows
CRUD Operations in MySQL
Primary key vs Foreign Key in MYSQL
Chapter 2 - Filtering and Sorting in SQL
8 attachments • 35 mins
FILTERING,SORTING & IMPORT CSV FILE IN MYSQL
Difference between - Limit and Offset | Between and IN
Practice Chapter 2 - Problems
Select all
Japanese City Names | Hacker Rank
Weather Observation Station 1
Employee Names
Employee Salaries
Chapter 3 - Wildcards and Case statement in SQL
6 attachments • 27 mins
Wildcards in MYSQL
Distinct and Case statement in MYSQL
Practice Chapter 3 - Problems
Weather Observation Station 3
Weather Observation Station 9
Types of Triangle
Chapter 4 - Other Important Functions in SQL
8 attachments • 33 mins
Other Functions In MYSQL | Concat, Upper, Lower, Left, Right, Round, floor and Ceil
Substr, Instr and Replace in MYSQL
Date Functions in MYSQL
Practice Chapter 4 - Problems
Weather Observation Station 6
Weather Observation Station 8
Weather Observation Station 10
Weather Observation Station 11
Chapter 5 - Aggregated Functions | Group by and Having In SQL
4 attachments • 22 mins
Aggregated functions in SQL
Group by | Having | Difference between group by and Having in mysql
Practice Chapter 5 - Problem
Weather Observation Station 4
Chapter 6 - Union and Joins in MYSQL
8 attachments • 1 hrs
Union and Union all | Difference between Union and Union all
Joins and its Types in MYSQL | Inner Join | Left Join | Right Join
Joins in SQL | Cross Join | Self Join
Practice chapter 6 - Problems
Weather Observation Station 5
Population Census | Hacker Rank | Joins
Average Population of Each Continent | Hacker rank Joins Problem Statement
The Report | Hacker Rank Problem | Joins Medium Level
Chapter 7 - Subqueries and Its Types in SQL
4 attachments • 30 mins
Single Row, Multiple Row and Column Subqueries
Correlated Subqueries and Difference between Any and All
Chapter 7 - Practice Problems
Binary Tree Nodes | Hacker Rank
Chapter 8 - Windows Function
3 attachments • 39 mins
Aggregated Windows Function
Windows Function | Ranking Windows Function
Windows Function | Value Windows Function
Chapter 9 - Stored Procedures , Function and Views
4 attachments • 5 mins
Views in Mysql
Reporting
Coming Soon
ETL Processes
Coming Soon
Database Administration
Coming Soon
Chapter 10 - Connect Database with Excel, Python and PowerBI
2 attachments • 28 mins
Connect to Database (Mysql) Using Excel
Connect Database using Python | Read Excel file in Python
Top 50 SQL Interview Questions
3 attachments • 1 hrs
Mock Interview : 15 min
Top 50 Leetcode Problems | Part 1 | SQL
Leetcode TOP 50 Problems | Part 2 | SQL
Resume Review
1 attachment
Resume Review Form
Certification
When you complete this course you receive a ‘Certificate of Completion’ signed and addressed personally by me.
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with Us
Elevate your learning experience with us, a passionate expert in Software & Technology. Immerse yourself in a diverse collection of courses, vibrant communities, insightful webinars, and premium digital products. Start your educational journey today!
Rate this Course
₹ 999.00
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
