Advanced Guide for MySQL Database

Advanced Guide for MySQL Database, available at $19.99, has an average rating of 3.3, with 48 lectures, based on 69 reviews, and has 562 subscribers.

You will learn about 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 This course is ideal for individuals who are STUDENTS or DATABASE ADMINISTRATOR or DATABASE DEVELOPER or DATABASE ENGINEER It is particularly useful for STUDENTS or DATABASE ADMINISTRATOR or DATABASE DEVELOPER or DATABASE ENGINEER.

Enroll now: Advanced Guide for MySQL Database

Summary

Title: Advanced Guide for MySQL Database

Price: $19.99

Average Rating: 3.3

Number of Lectures: 48

Number of Published Lectures: 48

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 48

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

STUDENTS

DATABASE ADMINISTRATOR

DATABASE DEVELOPER

DATABASE ENGINEER

Target Audiences

STUDENTS

DATABASE ADMINISTRATOR

DATABASE DEVELOPER

DATABASE ENGINEER

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!!

Course Curriculum

Chapter 1: Introduction to the course

Lecture 1: 1.1 Introduction to MySQL

Lecture 2: 1.2 Prerequisites

Chapter 2: Course

Lecture 1: 2.2 RDBMS and Its Terminology

Lecture 2: 3.1 DDL in MySQL part-1

Lecture 3: 3.2 DDL in MySQL part-2

Lecture 4: 3.3 DML in MySQL Part-1

Lecture 5: 3.4 DML in MySQL part-2

Lecture 6: 3.5 DML in MySQL part-3

Lecture 7: 3.6 LIMIT and ORDER BY in MySQL

Lecture 8: 3.7 Group By in MySqL

Lecture 9: 4.1 MySQL Aliases

Lecture 10: 4.2 Union Operator

Lecture 11: 4.3 Joins in MySQL

Lecture 12: 4.4 Constraints in MySQL- Part 1

Lecture 13: 4.5 Constraints in MySQL- Part 2

Lecture 14: 5.1 Logical and Comparison Operators

Lecture 15: 5.2 Conditions in MySQL

Lecture 16: 5.3 COMMIT, SAVEPOINT and ROLLBACK

Lecture 17: 5.4 LIKE in MySQL

Lecture 18: 5.5 RLIKE in MySQL

Lecture 19: 6.1 Views in MySQL

Lecture 20: 6.2 Subqueries

Lecture 21: 6.3 Scalar and Row Subqueries

Lecture 22: 6.4 Column and Table Subqueries

Lecture 23: 6.5 Subqueries with different Conditions

Lecture 24: 7.1 Stored Procedure in MySQL

Lecture 25: 7.2 Stored Procedure Variables

Lecture 26: 7.3 Stored Procedure Parameters

Lecture 27: 7.4 Conditions on Stored Procedures

Lecture 28: 8.1 Triggers in MySQL

Lecture 29: 8.2 Creating Triggers

Lecture 30: 8.3 Managing Triggers

Lecture 31: 8.4 Events in MySQL

Lecture 32: 8.5 Creating MySQL Events

Lecture 33: 8.6 Managing MySQL Events

Lecture 34: 9.1 Aggregate Function in MySQL

Lecture 35: 9.2 Join with Aggregate Function

Lecture 36: 9.3 String Function in MySQL

Lecture 37: 9.4 Date and Time Function

Lecture 38: 9.5 Control Flow Function

Lecture 39: 10.1 MySQL Administration

Lecture 40: 10.2 Create User and Change Passwords for Accounts

Lecture 41: 10.3 Granting Privilleges To Accounts

Lecture 42: 10.4 Revoking Privilleges From Users

Lecture 43: 10.5 More MySQL Admin Commands

Lecture 44: 11.1 Clone Tables in MySQL

Lecture 45: 11.2 Temporary Table in MySQL

Lecture 46: 11.3 How to Backup and Restore Databases

Instructors

Inflame Tech

Rating Distribution

1 stars: 8 votes

2 stars: 6 votes

3 stars: 16 votes

4 stars: 17 votes

5 stars: 22 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!