MySQL
19 videos • 22,561 views • by CodeStudio
1
MySQL Tutorial 01: What is Database | What is DBMS & RDBMS | What is SQL | Installing MySQL
CodeStudio
Download
2
MySQL Tutorial 02: MySQL Workbench & Command Line Client | Create Database, table & inserting record
CodeStudio
Download
3
MySQL Tutorial 03: Import SQL File | Select Command | SQL Data Types | Where Clause (Filter data)
CodeStudio
Download
4
MySQL Tutorial 04: Order By Clause | Distinct Clause
CodeStudio
Download
5
MySQL Tutorial 05: OPERATORS - AND | OR | NOT | IN
CodeStudio
Download
6
MySQL Tutorial 06: DDL COMMANDS CREATE | ALTER | DROP | TRUNCATE | RENAME
CodeStudio
Download
7
MySQL Tutorial 07: MySQL String Functions (Lower, Upper, Ltrim, Rtrim, Concat, Instr, Substring etc)
CodeStudio
Download
8
MySQL Tutorial 08: Numeric Functions, Aggregate Functions, Date/Time Functions
CodeStudio
Download
9
MySQL Tutorial 09: GROUP BY CLAUSE | WHERE CLAUSE | HAVING CLAUSE | ORDER BY CLAUSE
CodeStudio
Download
10
MySQL Tutorial 10: SET OPERATORS | UNION & UNION ALL | INTERSECT | EXCEPT (MINUS)
CodeStudio
Download
11
MySQL Tutorial 11: JOINS | INNER JOIN | LEFT JOIN | RIGHT JOIN | CROSS JOIN | FULL JOIN
CodeStudio
Download
12
MySQL Tutorial 12: SUB QUERIES
CodeStudio
Download
13
MySQL Tutorial 13: CONSTRAINTS - NOT NULL | UNIQUE | PRIMARY KEY | FOREIGN KEY | CHECK | DEFAULT
CodeStudio
Download
14
MySQL Tutorial 14: AUTO INCREMENT | LIMIT
CodeStudio
Download
15
MySQL Tutorial 15: VIEWS | INDEX
CodeStudio
Download
16
MySQL Tutorial 16: TCL COMMANDS | COMMIT | ROLLBACK | AUTOCOMMIT
CodeStudio
Download
17
MySQL Tutorial 17 : JAVA DATABASE CONNECTIVITY(JDBC) WITH MYSQL
CodeStudio
Download
18
MySQL Tutorial 18: OPEN DATABASE CONNECTIVITY(ODBC) WITH MYSQL
CodeStudio
Download
19
MySQL Tutorial 19:Working with MySQL Command Line Interfaces| MySQL Shell |MySQL Command Line Client
CodeStudio
Download