Advanced Guide for MySQL Database

Name: Advanced Guide for MySQL Database
Rating: 3.6 (69 reviews)

learn most popular relational database MYSQL

Created byInflame Tech

Last updated 2/2019

English

What you'll learn

Introduction to MySQL
DDL
DML
LIMIT
ORDER BY
GROUP BY
ALIASES
UNION
JOINS
CONSTRAINTS
LOGICAL OPERATORS
COMPARISON OPERATOR
COMMIT, SAVEPOINT and ROLLBACK
VIEWS
SUBQUERIES
STORED PROCEDURE
TRIGGERS
EVENTS
AGGREGATE FUNCTIONS
DATE & TIME
MYSQL ADMINISTRATION
PRIVILLEGES
BACKUP

Course content

2 sections • 48 lectures • 7h 33m total length

1.1 Introduction to MySQL2:48
1.2 Prerequisites0:25

2.2 RDBMS and Its Terminology6:03
3.1 DDL in MySQL part-17:26
Explore ddl to define and modify database structures, dml to retrieve and update data, and dcl to manage permissions, with examples of create, drop, rename, and comments.
3.2 DDL in MySQL part-219:25
Explore the MySQL data definition language (DDL) by performing alter table operations to add, drop, modify columns, change data types, and rename or drop tables.
3.3 DML in MySQL Part-113:32
3.4 DML in MySQL part-28:26
3.5 DML in MySQL part-39:18
3.6 LIMIT and ORDER BY in MySQL10:36
3.7 Group By in MySqL7:04
Explore how to use group by in MySQL to aggregate data with select statements, apply aggregate functions, and filter results with conditional grouping.
4.1 MySQL Aliases11:43
4.2 Union Operator10:52
4.3 Joins in MySQL12:39
4.4 Constraints in MySQL- Part 115:30
4.5 Constraints in MySQL- Part 230:44
5.1 Logical and Comparison Operators15:56
5.2 Conditions in MySQL16:56
5.3 COMMIT, SAVEPOINT and ROLLBACK7:21
5.4 LIKE in MySQL16:35
Learn how to use the like condition in MySQL to filter data with wildcards, underscores, and escape sequences, including practical examples of matching names and patterns.
5.5 RLIKE in MySQL5:35
6.1 Views in MySQL21:59
6.2 Subqueries5:12
Discover how subqueries and inner queries work in MySQL, and learn to nest select statements to perform complex data retrieval using where clauses and multiple query strategies.
6.3 Scalar and Row Subqueries12:01
Explore scalar and row subqueries in MySQL, using where clauses to compare single values and multiple columns across tables, with practical country and population examples.
6.4 Column and Table Subqueries9:14
6.5 Subqueries with different Conditions13:33
Master subqueries with different conditions in MySQL, using not in, exists, any and all in the where clause to filter customers and orders and verify existence.
7.1 Stored Procedure in MySQL9:22
Master stored procedures in MySQL: create and invoke them with delimiters to improve performance, security, and reduce traffic between the application and data, including an example with a products table.
7.2 Stored Procedure Variables9:07
7.3 Stored Procedure Parameters13:13
7.4 Conditions on Stored Procedures10:42
Learn how to implement conditional logic inside stored procedures with if statements, else branches, expressions, loops, and delimiters.
8.1 Triggers in MySQL3:58
8.2 Creating Triggers12:20
8.3 Managing Triggers3:21
Learn to manage triggers in MySQL by listing triggers for a database or the current database and dropping a trigger by name.
8.4 Events in MySQL3:20
8.5 Creating MySQL Events7:51
8.6 Managing MySQL Events8:46
9.1 Aggregate Function in MySQL4:57
9.2 Join with Aggregate Function3:39
9.3 String Function in MySQL9:38
9.4 Date and Time Function4:31
9.5 Control Flow Function10:53
10.1 MySQL Administration3:25
This video is about MySQL Administartion.
10.2 Create User and Change Passwords for Accounts9:12
This video is about Create User and Change Passwords for Accounts.
10.3 Granting Privilleges To Accounts8:26
This video is about Granting Privilleges to Accounts
10.4 Revoking Privilleges From Users4:27
This video is about MySQL Admin Commands
10.5 More MySQL Admin Commands6:07
This video is about More MySQL Admin Commands
11.1 Clone Tables in MySQL3:42
This video is about is Clone Tables in MySQL.
11.2 Temporary Table in MySQL4:52
This video is about Temporary Table in MySQl
11.3 How to Backup and Restore Databases7:00
This video is about How to Backup and Restore Database

Requirements

BASICS OF DATABASE

Description

MySQL is an open-source relational database management system (RDBMS). MySQL is written in C and C++. Major features as available in MySQL are Cross-platform support, triggers, Query caching, Built-in Replication support and Unicode support. This course is basically designed for all the beginners and experts who want to learn Mysql. In this course we’ll learn several concepts of MySql like DDL, DML, LIMIT, ORDER BY, GROUP BY, ALIASES, UNION, JOINS IN MYSQL, CONSTRAINTS, LOGICAL OPERATORS, COMPARISON OPERATOR, COMMIT, SAVEPOINT and ROLLBACK, VIEWS AND SUBQUERIES, STORED PROCEDURE AND TRIGGERS, EVENTS IN MYSQL, AGGREGATE FUNCTIONS, DATE & TIME, MYSQL ADMINISTRATION, PRIVILLEGES IN MYSQL, BACKUP IN MYSQL, and so many other important topics of mysql. So start your journey with mysql today. Happy learning!!

Who this course is for:

STUDENTS
DATABASE ADMINISTRATOR
DATABASE DEVELOPER
DATABASE ENGINEER

Advanced Guide for MySQL Database

What you'll learn

Explore related topics

Course content

Introduction to the course2 lectures • 3min

Course46 lectures • 7hr 30min

Requirements

Description

Who this course is for: