Name: SQL Programming Complete Bundle
Price: 85 USD
Rating: 5 (65 reviews)

This course offers an all-inclusive guide to mastering SQL, covering everything from basic queries to advanced database management techniques. Participants will learn how to create, manage, and manipulate databases using SQL commands like SELECT, JOIN, INSERT, and UPDATE. The course also dives into more complex topics such as stored procedures, triggers, views, and query optimization for enhanced performance. Designed for both beginners and experienced professionals, this bundle provides practical, hands-on experience with real-world scenarios. By the end of the course, learners will have the expertise to handle complex data queries, manage relational databases, and improve data-driven decision-making.

Who is this course for?

By taking this SQL Programming Complete Bundle, you’re able to open yourself to new opportunities within the database management and data analytics career path. Such careers may include:

SQL Developer (£30,000 to £55,000)
Database Administrator (£35,000 to £60,000)
Data Analyst (£25,000 to £50,000)

Course Introduction
	Introduction	00:04:00
	Course Curriculum Overview	00:05:00
	Overview of Databases	00:10:00
SQL Environment Setup
	MySQL Installation	00:16:00
	MySQL Workbench Installation	00:09:00
	Connecting to MySQL using Console	00:09:00
SQL Statement Basics
	Overview of Challenges	00:04:00
	SQL Statement Basic	00:16:00
	SELECT Statement	00:09:00
	SELECT DISTINCT	00:05:00
	Column AS Statement	00:12:00
	COUNT built-in Method usage	00:11:00
	SELECT WHERE Clause – Part One	00:05:00
	SELECT WHERE Clause – Part Two	00:11:00
	SQL Statement Basic	00:16:00
	SQL Limit Clause Statement	00:09:00
	SQL Using BETWEEN with Same Column Data	00:11:00
	How to Apply IN Operator	00:11:00
	Wildcard Characters with LIKE and ILIKE	00:11:00
GROUP BY Statements
	Overview of GROUP BY	00:06:00
	Aggregation function SUM()	00:09:00
	Aggregation MIN() and MAX()	00:05:00
	GROUP BY – One	00:09:00
	GROUP BY – Two	00:12:00
	HAVING Clause	00:05:00
JOINS
	Overview of JOINS	00:04:00
	Introduction to JOINS	00:04:00
	AS Statement table	00:03:00
	INNER Joins	00:14:00
	FULL Outer Join	00:11:00
	LEFT Outer JOIN	00:08:00
	RIGHT JOIN	00:08:00
	Union	00:07:00
Advanced SQL Commands / Statements
	Timestamps	00:12:00
	EXTRACT from timestamp	00:10:00
	Mathematical Functions	00:12:00
	String Functions	00:22:00
	SUBQUERY	00:13:00
Creating Database and Tables
	Basic of Database and Tables	00:06:00
	DataTypes	00:10:00
	Primarykey and Foreignkey	00:06:00
	Create Table in SQL Script	00:13:00
	Insert	00:11:00
	Update	00:07:00
	Delete	00:04:00
	Alter Table	00:09:00
	Drop Table	00:05:00
	NOT NULL Constraint	00:08:00
	UNIQUE Constraint	00:09:00
Databases and Tables
	Creating a Database backup	00:12:00
	10a Overview of Databases and Tables	00:05:00
	10c Restoring a Database	00:07:00
Final Exam
	Final Exam – SQL Programming Complete Bundle	00:25:00

Log in to your account

Sign up and start learning

SQL Programming Complete Bundle

Course Curriculum