MySQL·Beginner
MySQL
The world's most popular open-source database.
Install, query and administer MySQL for real-world apps.
4 weeks
251 lessons
1 examples
Certificate on completion
// preview.mysql
mysql
CREATE TABLE users (
id INT PRIMARY KEY AUTO_INCREMENT,
email VARCHAR(120) UNIQUE
);# curriculum
0 / 251 lessons·0% complete
01What is MySQL?02History of MySQL03Features of MySQL04Advantages of MySQL05Applications of MySQL06MySQL vs SQL07DBMS vs RDBMS08MySQL Architecture09Client-Server Model10Open Source Databases11What is a Database?12Tables, Rows & Columns13Records & Fields14Keys in Database15Relationships16ER Diagram Basics17Relational Database Concepts18Database Design Principles19Installing MySQL Server20Installing MySQL Workbench21MySQL Shell22Setting Environment Variables23Creating First Database24Connecting to MySQL Server25Starting & Stopping MySQL Service26MySQL Syntax27SQL Statements28Comments in MySQL29MySQL Data Types Overview30Naming Conventions31Case Sensitivity32Numeric Data Types33INT34BIGINT35FLOAT36DOUBLE37DECIMAL38String Data Types39CHAR40VARCHAR41TEXT42ENUM43Date & Time Types44DATE45TIME46DATETIME47TIMESTAMP48YEAR49Boolean & Binary Types50BOOLEAN51BLOB52CREATE DATABASE53SHOW DATABASES54USE DATABASE55ALTER DATABASE56DROP DATABASE57CREATE TABLE58SHOW TABLES59DESCRIBE TABLE60ALTER TABLE61DROP TABLE62RENAME TABLE63TRUNCATE TABLE64PRIMARY KEY (MySQL)65FOREIGN KEY (MySQL)66UNIQUE (MySQL)67NOT NULL (MySQL)68CHECK (MySQL)69DEFAULT (MySQL)70AUTO_INCREMENT71INSERT INTO (MySQL)72Insert Multiple Records73SELECT Statement (MySQL)74SELECT DISTINCT75SELECT with Conditions76UPDATE Statement (MySQL)77Updating Multiple Columns78DELETE Statement (MySQL)79DELETE with Conditions80WHERE Clause (MySQL)81AND Operator (MySQL)82OR Operator (MySQL)83NOT Operator (MySQL)84BETWEEN Operator (MySQL)85IN Operator (MySQL)86LIKE Operator (MySQL)87Wildcards (MySQL)88IS NULL (MySQL)89EXISTS Operator (MySQL)90ORDER BY (MySQL)91ASC & DESC92LIMIT Clause93OFFSET Clause94Arithmetic Operators95Comparison Operators96Logical Operators97Bitwise Operators98String Functions99CONCAT() (MySQL)100LENGTH() (MySQL)101UPPER() (MySQL)102LOWER() (MySQL)103SUBSTRING() (MySQL)104REPLACE() (MySQL)105TRIM() (MySQL)106Numeric Functions107ROUND() (MySQL)108CEIL() (MySQL)109FLOOR() (MySQL)110ABS() (MySQL)111RAND() (MySQL)112Date Functions113NOW() (MySQL)114CURDATE() (MySQL)115DATE_ADD() (MySQL)116DATE_SUB() (MySQL)117DATEDIFF() (MySQL)118Aggregate Functions119COUNT() (MySQL)120SUM() (MySQL)121AVG() (MySQL)122MIN() (MySQL)123MAX() (MySQL)124GROUP BY (MySQL)125HAVING Clause (MySQL)126Aggregate Filtering (MySQL)127INNER JOIN (MySQL)128LEFT JOIN (MySQL)129RIGHT JOIN (MySQL)130CROSS JOIN (MySQL)131SELF JOIN (MySQL)132Multiple Table Joins133Single Row Subquery134Multiple Row Subquery135Nested Subqueries136Correlated Subqueries137UNION (MySQL)138UNION ALL (MySQL)139CREATE VIEW (MySQL)140ALTER VIEW (MySQL)141DROP VIEW (MySQL)142Advantages of Views143What is an Index? (MySQL)144CREATE INDEX (MySQL)145UNIQUE INDEX (MySQL)146DROP INDEX (MySQL)147Composite Indexes (MySQL)148Index Optimization (MySQL)149What are Stored Procedures? (MySQL)150CREATE PROCEDURE (MySQL)151Parameters in Procedures (MySQL)152Calling Procedures (MySQL)153Procedure Variables (MySQL)154CREATE FUNCTION (MySQL)155User Defined Functions156Scalar Functions157BEFORE INSERT Trigger158AFTER INSERT Trigger159BEFORE UPDATE Trigger160AFTER UPDATE Trigger161DELETE Triggers162ACID Properties (MySQL)163COMMIT (MySQL)164ROLLBACK (MySQL)165SAVEPOINT (MySQL)166Transaction Management167What is a Cursor? (MySQL)168Cursor Operations (MySQL)169Cursor Examples (MySQL)170Creating Users171Managing Passwords172GRANT Permissions173REVOKE Permissions174User Roles175SQL Injection Prevention1761NF (MySQL)1772NF (MySQL)1783NF (MySQL)179BCNF (MySQL)180Functional Dependency181Common Table Expressions (CTE) (MySQL)182Recursive Queries (MySQL)183Window Functions (MySQL)184Ranking Functions (MySQL)185Partitioning (MySQL)186Temporary Tables (MySQL)187Dynamic SQL (MySQL)188Query Optimization (MySQL)189Explain Statement190Index Tuning (MySQL)191Query Caching (MySQL)192Performance Monitoring (MySQL)193Slow Query Optimization194mysqldump195Database Export (MySQL)196Database Import (MySQL)197Backup Strategies198Restore Database (MySQL)199InnoDB200MyISAM201InnoDB vs MyISAM202MEMORY Engine203Choosing Storage Engine204Master-Slave Replication205Replication Setup206Replication Monitoring207MySQL with PHP208MySQL with Python209MySQL with Node.js210MySQL with Java211MySQL with C#212Database Modeling213ER Diagram (Workbench)214Query Editor (Workbench)215Data Export/Import (Workbench)216User Management (Workbench)217Project — Student Management System218Project — Library Management System219Project — Ecommerce Database220Project — Banking System221Project — Hospital Management System222Project — CRM Database223Project — Inventory Management System224Frequently Asked Questions225Query Challenges (MySQL)226Scenario-Based Problems227Optimization Questions228Database Design Questions229Mini Project — Login System Database230Mini Project — Attendance Management231Mini Project — Online Shopping Database232Mini Project — Blogging Database233Mini Project — Food Delivery Database234Advanced Project — ERP Database System235Advanced Project — Real Estate CRM Database236Advanced Project — Subscription Billing System237Advanced Project — AI Analytics Database238Advanced Project — Social Media Database239Clean Query Writing (MySQL)240Naming Conventions (MySQL)241Database Security (MySQL)242Query Optimization (MySQL)243Backup Best Practices244Scalable Database Design245Capstone — Full Database Design (MySQL)246Capstone — Schema Planning (MySQL)247Capstone — Query Optimization (MySQL)248Capstone — Security Implementation (MySQL)249Capstone — Reports & Analytics (MySQL)250Capstone — Backup & Recovery (MySQL)251Capstone — Deployment & Maintenance (MySQL)
enroll.now()
Free
Full access. No credit card.
✓ Lifetime access
✓ Code along with projects
✓ Community support 24/7