Course Content

Introduction to MySQL

How to use LearnVern

MySQL Environment Setup

What is Data

What is Database

What is DBMS (Database Management System)

Introduction to SQL and its Query Types

MySQL - Numeric Datatypes

MySQL Constraints

MySQL - Create, Drop and Show Database

MySQL - Create Table Statement

MySQL - Insert and Select Statement With Like Clause

MySQL - Arithmetic and Logical Operators

MySQL - IN and NOT IN Clauses

MySQL - NULL and NOT NULL Clauses

MySQL - ORDER BY and LIMIT Clauses

MySQL - AS, CONCAT, DISTINCT, GROUP BY and HAVING Clauses with Aggregate Functions

MySQL - Update and Delete Statements

MySQL - Alter Table Statement

MySQL - Rename, Truncate and DROP Statements

MySQL - Foreign Key

MySQL - Joins

MySQL - View

MySQL - Function

MySQL - Stored Procedure

MySQL - Trigger

Database Normalization

Assignment : MySQL Database Management System

MySQL Interview Question Part 1

MySQL Interview Question Part 2

MySQL Interview Question Part 3

Course Summary

Quiz : MySQL Database Management System

MySQL Environment Setup

MySQL Database Management System Getting Started

Enroll Now For Free

Discussion

Course Content

Introduction to MySQL

How to use LearnVern

MySQL Environment Setup

What is Data

What is Database

What is DBMS (Database Management System)

Introduction to SQL and its Query Types

MySQL - Numeric Datatypes

MySQL Constraints

MySQL - Create, Drop and Show Database

MySQL - Create Table Statement

MySQL - Insert and Select Statement With Like Clause

MySQL - Arithmetic and Logical Operators

MySQL - IN and NOT IN Clauses

MySQL - NULL and NOT NULL Clauses

MySQL - ORDER BY and LIMIT Clauses

MySQL - AS, CONCAT, DISTINCT, GROUP BY and HAVING Clauses with Aggregate Functions

MySQL - Update and Delete Statements

MySQL - Alter Table Statement

MySQL - Rename, Truncate and DROP Statements

MySQL - Foreign Key

MySQL - Joins

MySQL - View

MySQL - Function

MySQL - Stored Procedure

MySQL - Trigger

Database Normalization

Assignment : MySQL Database Management System

MySQL Interview Question Part 1

MySQL Interview Question Part 2

MySQL Interview Question Part 3

Course Summary

FAQs

Right-click the My Computer icon on the Windows desktop and select Properties. Then, from the System Properties menu that displays, go to the Advanced tab and click the Environment Variables button. Select Path from the System Variables menu, then click the Edit button. The dialogue box to Edit System Variables should appear.

The path to mysql is automatically added to environment variables if you install MySQL correctly. To check this, open a command prompt and type path. You can launch mysql executable files from any command prompt location if you find mysql path in it.

Recommended Courses

PHP Course For Beginners

Students Enrolled : 28057

4.2

(243)

हिन्दी

Core PHP course will teach you to the Basics of PHP wit...

Enroll For Free

Core Java Course

Students Enrolled : 55595

4.2

(676)

हिन्दी

Java Course has been designed to teach you the concepts...

Enroll For Free

Advanced PHP with MVC Programming with Practicals

Students Enrolled : 31836

4.4

(494)

हिन्दी

Build your own website and get jobs like Web Designer a...

Enroll For Free

Java Programming Advance Course

Students Enrolled : 62273

4.2

(756)

हिन्दी

This Advance Java Course includes Everything you need t...

Enroll For Free

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image

App QR Code Image

Code Scan or Download the app

Google Play Store

598K+ Downloads

App Download Section Circle 1

4.57 Avg. Ratings

App Download Section Circle 2

15K+ Reviews

App Download Section Circle 3

Learn anywhere on the go
Get regular updates about your enrolled or new courses
Share content with your friends
Evaluate your progress through practice tests
No internet connection needed
Enroll for the webinar and join at the time of the webinar from anywhere