SQL-100-Queries-Solutions
Instructor
Abhijit
- Description
- Curriculum
- Reviews
MySQL
-
1
Installation MySQLHow to Install MySQL:
-
2
Start MySQL and ses Database & Tables
In this lesson, we know the following topics: mysql -- version, mysql - u root -p, Show databases; create database sdb; Use sdb; Select database(); Show tables; Exit or Quit
-
3
DDL(Data Definition Language) Commands.
DDL
Data Definition Language
CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE VIEW, ALTER VIEW, DROP VIEW, TRUNCATE, RENAME
-
4
DML(Data Manipulation Language) Commands.
DML(Data Menipulation Language) Commands:
DML
Data Manipulation Language
INSERT, UPDATE, DELETE, SELECT, GROUP BY, HAVING, WHERE, LIKE, IN, NOT IN, JOIN( INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN), SET (UNION, UNION ALL, INTERSECTION, EXCEPT).
-
5
DCL(Data Control Language) Commands
DCL
Data Control Language
GRANT, REVOKE
Please, login to leave a review
Google 
Facebook