MySQL Tutorial with Examples
UNIT - 2
Overview of MySQL and its features
History and development of MySQL
Comparison with other database management systems
Installing MySQL server and client
Configuring MySQL server settings
Setting up users and permissions
Data types supported by MySQL
Question & Answer
MySQL Introduction
Overview of MySQL and its features
History and development of MySQL
Comparison with other database management systems
Installing MySQL server and client
Configuring MySQL server settings
Setting up users and permissions
Data types supported by MySQL
Question & Answer
UNIT - 3
CREATE DATABASE
DROP DATABASE
SELECT DATABASE
DISPLAY LIST OF DATABASE
Question & Answer
Managing databases
CREATE DATABASE
DROP DATABASE
SELECT DATABASE
DISPLAY LIST OF DATABASE
Question & Answer
UNIT - 4
Display list of Tables
Creating Tables
Altering Existing Table
Delete Exiting table
Question & Answer
Working with tables
Display list of Tables
Creating Tables
Altering Existing Table
Delete Exiting table
Question & Answer
UNIT - 5
Defining constraints
Relationships between tables
Type Relationships
Question & Answer
Constraints and Relationships
Defining constraints
Relationships between tables
Type Relationships
Question & Answer
UNIT - 6
Display All data from table
Display selected Column from table
Colum aliasing
Display Distinct values
Apply limit to display data
Question & Answer
Querying data
Display All data from table
Display selected Column from table
Colum aliasing
Display Distinct values
Apply limit to display data
Question & Answer
UNIT - 7
Display the in ascending order
Display the in descending order
Question & Answer
Sorting data
Display the in ascending order
Display the in descending order
Question & Answer
UNIT - 8
using where clause to filter data
operators used in where clause
Question & Answer
Filtering data
using where clause to filter data
operators used in where clause
Question & Answer
UNIT - 11
String Functions
Numeric Functions
Date and Time Functions
Mathematical Functions
Aggregate Functions
Control Flow Functions
JSON Functions
Encryption and Hashing Functions
Bitwise Functions
Spatial Functions
Question & Answer
Functions in Mysql
String Functions
Numeric Functions
Date and Time Functions
Mathematical Functions
Aggregate Functions
Control Flow Functions
JSON Functions
Encryption and Hashing Functions
Bitwise Functions
Spatial Functions
Question & Answer