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

What is Data

MySQL Database Management System Getting Started

Enroll Now For Free

Discussion

View Resources

View Resources

learn_vern
products_master

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

For subsequent statements, the USE statement instructs MySQL to use the named database as the default (current) database. This statement necessitates the database or an object within it having some level of privilege.

In MySQL there are Two main data types:

string.
date and time.

Each column, local variable, expression, and parameter in SQL Server has a corresponding data type. A data type is an attribute that describes the sort of data that an object can carry, such as integers, characters, money, dates and times, binary strings, and so on.

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