Advanced Guide for MySQL Database
4.1 (53 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
527 students enrolled

Advanced Guide for MySQL Database

learn most popular relational database MYSQL
4.1 (53 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
527 students enrolled
Created by Inflame Tech
Last updated 2/2019
English
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 48 lectures 07:33:42
+ Course
46 lectures 07:30:29
3.2 DDL in MySQL part-2
19:25
3.3 DML in MySQL Part-1
13:32
3.4 DML in MySQL part-2
08:26
3.5 DML in MySQL part-3
09:18
3.6 LIMIT and ORDER BY in MySQL
10:36
3.7 Group By in MySqL
07:04
4.1 MySQL Aliases
11:43
4.2 Union Operator
10:52
4.3 Joins in MySQL
12:39
4.4 Constraints in MySQL- Part 1
15:30
4.5 Constraints in MySQL- Part 2
30:44
5.1 Logical and Comparison Operators
15:56
5.2 Conditions in MySQL
16:56
5.3 COMMIT, SAVEPOINT and ROLLBACK
07:21
5.4 LIKE in MySQL
16:35
5.5 RLIKE in MySQL
05:35
6.1 Views in MySQL
21:59
6.2 Subqueries
05:12
6.3 Scalar and Row Subqueries
12:01
6.4 Column and Table Subqueries
09:14
6.5 Subqueries with different Conditions
13:33
7.1 Stored Procedure in MySQL
09:22
7.2 Stored Procedure Variables
09:07
7.3 Stored Procedure Parameters
13:13
7.4 Conditions on Stored Procedures
10:42
8.1 Triggers in MySQL
03:58
8.2 Creating Triggers
12:20
8.3 Managing Triggers
03:21
8.4 Events in MySQL
03:20
8.5 Creating MySQL Events
07:51
8.6 Managing MySQL Events
08:46
9.1 Aggregate Function in MySQL
04:57
9.2 Join with Aggregate Function
03:39
9.3 String Function in MySQL
09:38
9.4 Date and Time Function
04:31
9.5 Control Flow Function
10:53

This video is about MySQL Administartion.

10.1 MySQL Administration
03:25

This video is about Create User and Change Passwords for Accounts.

10.2 Create User and Change Passwords for Accounts
09:12

This video is about Granting Privilleges to Accounts

10.3 Granting Privilleges To Accounts
08:26

This video is about MySQL Admin Commands

10.4 Revoking Privilleges From Users
04:27

This video is about More MySQL Admin Commands

10.5 More MySQL Admin Commands
06:07

This video is about is Clone Tables in MySQL.

11.1 Clone Tables in MySQL
03:42

This video is about Temporary Table in MySQl

11.2 Temporary Table in MySQL
04:52

This video is about How to Backup and Restore Database

11.3 How to Backup and Restore Databases
07:00
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