Database Training
MySQL & Live Project Training at Arraysoft
MySQL is the most popular Open Source Relational SQL Database Management System. SQL (Structured Query Language) is the standard language for relational database management systems per ANSI. Our course covers everything from basics to live project development.
MySQL Core Topics
- Introduction to SQL — Connecting, Selecting Database
- Inserting, Updating, Deleting Records
- WHERE, ORDER BY, AND, OR Conditions
- Sub Queries, Joins, Table Aliases, Outer Joins
- UNION, UNION ALL & UNION Rules
- Checking for NULL, Ascending & Descending Sorts
MySQL Programming & Live Project
- MySQL Functions — Alphabetically & By Category
- Primary Keys, Unique Constraints, Indexes
- Grant/Revoke Privileges, Change Passwords
- Create Functions, Procedures, Triggers, Cursors
- LOOP, IF-THEN-ELSE, AUTO_INCREMENT
- Live Project — Create complete project based on MySQL