# MySQL Course

> Learn MySQL from scratch! This beginner-friendly MySQL Expert Course covers SQL essentials for working with databases. For any query give we call on: +91-8287540705.

- Institute: Next-G Classes, Plot No 4, Kh. No. 59/13, First Floor, Pal Colony, Rithala, Near Rithala Metro Station, Delhi - 110085
- Web page: https://nextgclasses.com/advance-mysql-course
- Duration: Regular 45 Days · Fastrack 25 Days · Crash 15 Days
- Mode: Classroom and Live Online · Certificate · Live projects · Placement assistance
- Enquire: +91-7503301775, +91-8287540705 · nextgclasses@gmail.com

## Syllabus

##### **OURSE CONTENTS OF MYSQL DATABASEDATABASE BASICS**

- What is Database

- Need of Database

- Tables

- primary key

- foreign key

- data types

**NORMALIZATION IN DATABASE**

- What is Normalization

- Need of Database Normalization

- 1nf

- 2nf

- 3nf

- bcnf

**PHP WITH MYSQL**

- mysqli vs mysqli

- Connect to database

- create database

- drop database

- select database

- create table

- insert data into table

- update data

- select data

- delete data

**FILTERING DATA IN MYSQL**

- where

- and

- or

- between

- in

- like

- limit

- is null

**MYSQL JOINS**

- mysql join

- inner join

- left join

- right join

- cross join

- self join

**MYSQL GOUPING DATA**

- Group By

- Having

- RollUp

**MYSQL TRANSACTION**

- MySql Transaction

- MySql Table Locking

**MYSQL IMPORT & EXPORT**

- Import CSV to MySql

- Export Mysql to CSV