MySQL from basic to advance : Level Up Masterclass

Name: MySQL from basic to advance : Level Up Masterclass
Rating: 4.1 (44 reviews)

Become MySQL Master by creating complex queries and databases with simple examples.

Created byAtchyut Kumar, Edufulness EFN

Last updated 6/2024

English

What you'll learn

Learn SQL basics from scratch.
Understand SELECT clause never like before.
Create WHERE clause conditions for complex queries.
Group similar data using GROUP BY clause like master.
Filter the groups with HAVING clause while jagging.
Join the tables in simple manner for big data table which have lakhs of records.
Create the Subqueries confidently where you can rule your environment.

Course content

10 sections • 44 lectures • 6h 23m total length

SELECT statement structure and evaluation order.9:56
SELECT clause Syntax and examples.7:38
Master the select clause syntax, including choosing all or specific columns and the mandatory from clause from the table, as shown with 14 rows across 8 columns.
DISTINCT keyword in SELECT clause.5:04
WHERE clause : Introduction.10:36
WHERE clause : Operators - AND, OR, NOT.17:45

ORDER BY clause.7:56
Master the order by clause to sort query results in ascending or descending order. Apply it to single or multiple columns, using asc or desc for precise output.
GROUP BY clause.11:48
Group by clause organizes records into value-based groups, then apply aggregate functions like count, sum, average, min, and max to compute department totals and salaries, including multi-column groupings.
HAVING clause.5:17
LIMIT clause6:49

Introduction5:00
NOT NULL Constraint.5:19
UNIQUE Constraint.8:43
Explore how the unique constraint prevents duplicate values in a column, supports multi-column constraints, and permits nulls, with hands-on examples on a student table.
CHECK Constraint.11:54
Explore check constraints that validate column values with a condition, add constraints to tables, manage existing data, and respond to violations and automatic constraint naming.
DEFAULT Constraint.6:04
Explore the default constraint in MySQL, which assigns a default value when a column is not specified, preventing nulls and guiding inserts through practical table creation and examples.
PRIMARY KEY Constraint.10:13
AUTO_INCREMENT Constraint.12:57
Learn how the auto_increment constraint automatically generates unique keys for new records, with primary key requirements, syntax, and hands-on examples of inserts and adjusting the maximum value.
ENUM Constraint.11:10

Query 1, 2, 39:57
Query 44:23
Query 55:23
Query 65:23
Query 84:23
Develop practical skills to filter employees who died in the year 1993 using SQL, employing between date ranges and year-based formats to fetch matching records.
Query 94:09
Master how to filter employees who joined in August 1998 using between date ranges, select all details, and extract the month to enable flexible month-based queries.
Query 104:55

Requirements

Willing learn.

Description

Course Description: This course provides a comprehensive introduction to the language of relational databases: Structured Query Language (SQL). Topics covered include: Entity-Relationship modeling, the Relational Model, the SQL language: data retrieval statements, data manipulation and data definition statements. All interactive reading problems involve the use of "live" SQL. Homework will be done using databases running in MySQL which students install on their machines. Students develop a real-world database project using MySQL during the course.

Prerequisites: This course is designed database developers or students who desire a basic to advance level of proficiency with the Structured Query Language (SQL). Prerequisite: Basic computer literacy including.

Justification: This course will provide a solid preparation in SQL in the Computer Science and Informatics majors who plan to take database or data science courses. A knowledge of this material is also an important skill for anyone planning to do software engineering and development. It is also a service course for students outside of the CS major who work with or plan to work with relational databases and data science such as students studying social science, business, biological and physical sciences, among others.

Course Objectives:

Learn structured query language (SQL) to an intermediate/advanced level.
Be able to write data retrieval queries and evaluate the result set.
Be able to write SQL statements that edit existing data.
Be able to write SQL statements that create database objects.
Understand the structure and design of relational databases.
Understand the importance and major issues of database security and the maintenance of data integrity.

Who this course is for:

Academic Students
Job Seekers
Database Developers.
Certification.

MySQL from basic to advance : Level Up Masterclass

What you'll learn

Explore related topics

Course content

Clauses in MySQL5 lectures • 51min

Data Manupulation Laungage Commands (DML)3 lectures • 25min

Data Definition Language Commands (DDL) in MySQL.3 lectures • 35min

Aggregate Functions1 lecture • 12min

ORDER BY, GROUP BY, HAVING, LIMIT clause.4 lectures • 32min

Conditions4 lectures • 29min

Constraints :8 lectures • 1hr 11min

Control Flow Functions.4 lectures • 25min

Joins : Exclusive5 lectures • 1hr 5min

Intermediate Queries7 lectures • 39min

Requirements

Description

Who this course is for: