Advanced Guide for MySQL Database
4.4 (25 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
205 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Guide for MySQL Database to your Wishlist.

Add to Wishlist

Advanced Guide for MySQL Database

learn most popular relational database MYSQL
4.4 (25 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
205 students enrolled
Created by Inflame Tech
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • STUDENTS
  • DATABASE ADMINISTRATOR
  • DATABASE DEVELOPER
  • DATABASE ENGINEER
Students Who Viewed This Course Also Viewed
Curriculum For This Course
48 Lectures
07:33:42
+
Introduction to the course
2 Lectures 03:13
+
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

10.1 MySQL Administration
03:25

10.2 Create User and Change Passwords for Accounts
09:12

10.3 Granting Privilleges To Accounts
08:26

10.4 Revoking Privilleges From Users
04:27

10.5 More MySQL Admin Commands
06:07

11.1 Clone Tables in MySQL
03:42

11.2 Temporary Table in MySQL
04:52

11.3 How to Backup and Restore Databases
07:00
About the Instructor
Inflame Tech
3.7 Average rating
102 Reviews
995 Students
7 Courses

InflameTech is serving in the field of technology with a mission of Igniting knowledge over the world. Inflametech is advancing its steps towards a single goal which aims at providing knowledge to all , and in the easiest possible way. We, at Inflametech believe in the fact that everyone deserves the right to learn and gather their bit of required knowledge.

Get the best of Technology with us, and find your bit of knowledge on virtually anything.