Advanced Guide for MySQL Database

learn most popular relational database MYSQL

3.40 (68 reviews)

Udemy

platform

English

language

Databases

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

Why take this course?

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

Reviews

Sumbal

January 20, 2021

This course has basic knowledge of database. I didn't find any advanced level learning in this course.

Ramesh

January 5, 2021

I would like to learn some of the advanced concepts and in depth understanding of MySql, not just basic syntax stuff.

Vasyl

March 18, 2020

This course is not for advanced users but for the beginners. The lector uses quite silly examples and sometimes they could be even deceiving (for example, joining 2 tables by columns order ID and postcode). The quality of videos is also quite low (in the video about VIEWs even the stream is freezing and you cannot see what happens).

Rohan

December 18, 2019

Demonstration after every lesson. You can't ask for better. I regret not finding this course a long time ago. I regret not finding this course a long time ago.

Joel

November 10, 2019

The course has enough examples stuffed alongwith every concept, necessary to learn mysql. In my opinion, The title shouldve been 'mysql crash course'. Anyways, it was a good course. Thank you.

Frank

September 1, 2017

The voice recording seems to be from a micrphone too far away from the speaker. Pronunciation is hard to understand: Indian accent. Charts begin with no titles so the speaker is talking with a blank white screen.

Francisco

August 16, 2017

Esta bien el curso para conocer y tener conocimientos básicos pero siendo un curso de pago no lo recomendaría

Geraint

July 5, 2017

Covers MySQL very thoroughly. Could do with editing the videos to remove the sections where he is writing code, especially when he has mistakes and is going back through to fix them. He also spends time reading out long queries that he is writing on the screen. Other than that - a good course

Yeva

May 7, 2017

Heavy accent, sometimes hard to understand, uses tables that were not previously created in examples, and speaks about functions that were not discussed previously ex:concat.

Bruce

March 3, 2017

I like the content and material. Material is well organised. I also like support , I got prompt reply for any query.