Topics

206

Introduction to Databases 1 What is a Database? 2 Types of Databases 3 Relational Database Concepts 4 What is MySQL? 5 SQL vs MySQL 6 Install MySQL Server 7 Install MySQL Workbench 8 Practice Assignment: Introduction to Databases 9 Assignment Solution: Introduction to Databases

Database Languages in SQL 1 Introduction to MySQL Databases 2 SQL and MySQL 3 DDL - Data Definition Language 4 DML - Data Manipulation Language 5 DCL Commands 6 Structured Query Language (SQL) 7 Assignment Solution: Database Languages in SQL 8 Practice Assignment: Database Languages in SQL 9 Relational database concepts 10 TCL Commands

Create Database in MySQL 1 What is character set for the database? 2 How to create database in MySQL 3 How to rename database in MySQL 4 How to delete database in MySQL 5 Create Table in MySQL 6 utf8mb4_unicode_ci 7 MySQL collation 8 What is Storage Engine in MySQL 9 User Interface of phpMyAdmin - MYSQL 10 User Interface phpMyAdmin - Database - MYSQL 11 Practice Assignment: Create Database in MySQL 12 Assignment Solution: Create Database in MySQL

Working with Tables 1 Create table 2 Alter Table 3 Rename Table 4 Drop Table 5 Truncate Table 6 Table Relationships 7 Practice Assignment: Working with Tables 8 Assignment Solution: Working with Tables

Database Modeling & ER Diagrams 1 ER Diagram Basics in MySQL 2 Entities in MySQL 3 Attributes in MySQL 4 Relationships in MySQL 5 Cardinality in MySQL 6 Designing Databases from Requirements 7 Practice Assignment: Database Modeling and ER Diagrams 8 Assignment Solution: Database Modeling and ER Diagrams

Join in MySQL 1 What are Joins in MySQL? 2 INNER JOIN in MySQL 3 LEFT JOIN in MySQL 4 RIGHT JOIN in MySQL 5 CROSS JOIN in MySQL 6 SELF JOIN in MySQL 7 Practice Assignment: Joins in MySQL 8 Assignment Solution: Joins in MySQL

MySQL Data Types 1 Numeric Data Types in mySQL 2 String Data Types in mySQL 3 Date and Time Data Types in mySQL 4 Boolean Data Type in mySQL 5 ENUM and SET in mySQL 6 Practice Assignment: MySQL Data Types 7 Assignment Solution: MySQL Data Types

CRUD Operations in MySQL 1 INSERT Statement in MySQL 2 SELECT Statement in MySQL 3 UPDATE Statement in MySQL 4 DELETE Statement in MySQL 5 Practice Assignment: CRUD Operations in MySQL 6 Assignment Solution: CRUD Operations in MySQL

Filtering Data in MySQL 1 WHERE Clause in MySQL 2 AND Operator in MySQL 3 OR Operator in MySQL 4 NOT Operator in MySQL 5 IN Operator in MySQL 6 BETWEEN Operator in MySQL 7 LIKE Operator in MySQL 8 Wildcards in MySQL 9 Practice Assignment: Filtering Data in MySQL 10 Assignment Solution: Filtering Data in MySQL

Sorting and Limiting in MySQL 1 ORDER BY in MySQL 2 LIMIT in MySQL 3 DISTINCT in MySQL 4 Practice Assignment: Sorting and Limiting in MySQL 5 Assignment Solution: Sorting and Limiting in MySQL

MySQL Functions 1 String Functions in MySQL 2 Numeric Functions in MySQL 3 Date Functions in MySQL 4 Conversion Functions in MySQL 5 Conditional Functions in MySQL 6 Practice Assignment: MySQL Functions 7 Assignment Solution: MySQL Functions

Aggregate Functions in MySQL 1 Aggregation functions - MySQL 2 COUNT() in MySQL 3 SUM() in MySQL 4 AVG() in MySQL 5 MAX() in MySQL 6 MIN() in MySQL 7 GROUP BY in MySQL 8 HAVING in MySQL 9 Practice Assignment: Aggregate Functions in MySQL 10 Assignment Solution: Aggregate Functions in MySQL

Constraints in MySQL 1 PRIMARY KEY in MySQL 2 FOREIGN KEY in MySQL 3 UNIQUE in MySQL 4 NOT NULL in MySQL 5 DEFAULT in MySQL 6 CHECK Constraint in MySQL 7 Data Constraints and Integrity - MySQL 8 Practice Assignment: Constraints in MySQL 9 Assignment Solution: Constraints in MySQL

Subqueries in MySQL 1 Introduction to Subqueries in MySQL 2 Single Row Subquery in MySQL 3 Multiple Row Subquery in MySQL 4 Correlated Subquery in MySQL 5 Practice Assignment: Subqueries in MySQL 6 Assignment Solution: Subqueries in MySQL

Views in MySQL 1 What is a View in MySQL? 2 Create View in MySQL 3 Update View in MySQL 4 Drop View in MySQL 5 Practice Assignment: Views in MySQL 6 Assignment Solution: Views in MySQL

Indexes in MySQL 1 What is an Index in MySQL? 2 Create Index in MySQL? 3 Composite Index in MySQL? 4 Unique Index in MySQL? 5 Index Performance in MySQL? 6 Practice Assignment: Indexes in MySQL 7 Assignment Solution: Indexes in MySQL

Transactions in MySQL 1 Transactions and ACID properties - MySQL 2 COMMIT in MySQL 3 ROLLBACK in MySQL 4 SAVEPOINT in MySQL 5 Practice Assignment: Transactions in MySQL 6 Assignment Solution: Transactions in MySQL

Stored Procedures & Functions in MySQL 1 PL/SQL vs MySQL Stored Programs: Why PL/SQL Is Not Used in My 2 Stored Procedures in MySQL 3 Parameters in MySQL 4 Variables in MySQL Stored Programs 5 IF, ELSEIF, ELSE Statements in MySQL 6 CASE Statement in MySQL 7 Loops in MySQL Stored Programs 8 Error Handling using DECLARE HANDLER 9 Cursors in MySQL 10 Stored Functions in MySQL 11 Real Examples in MySQL 12 Practice Assignment: Stored Procedures and Functions in MySQL 13 Assignment Solution: Stored Procedures and Functions in MySQL

Triggers in MySQL 1 Stored functions and triggers - MySQL 2 Introduction to Triggers in MySQL 3 BEFORE INSERT Trigger in MySQL 4 AFTER INSERT Trigger in MySQL 5 UPDATE Trigger in MySQL 6 DELETE Trigger in MySQL 7 Practice Assignment: Triggers in MySQL 8 Assignment Solution: Triggers in MySQL

JSON in MySQL 1 JSON Data Type 2 JSON Functions 3 Real API Storage Examples 4 Practice Assignment: JSON in MySQL 5 Assignment Solution: JSON in MySQL

User Management & Security in MySQL 1 Create User in MySQL 2 Grant Privileges in MySQL 3 Revoke Privileges in MySQL 4 Best Security Practices in MySQL 5 Practice Assignment: User Management and Security in MySQL 6 Assignment Solution: User Management and Security in MySQL

MySQL Performance Optimization 1 Query Optimization in MySQL 2 EXPLAIN Statement in MySQL 3 Slow Queries in MySQL 4 Index Optimization in MySQL 5 Common Performance Mistakes in MySQL 6 Practice Assignment: MySQL Performance Optimization 7 Assignment Solution: MySQL Performance Optimization

Database Design Fundamentals 1 What is Database Design? 2 Introduction to Database Normalization (1NF, 2NF, 3NF) 3 Entity Relationship Concepts 4 Database Normalization (1NF) 5 Database Normalization (2NF) 6 Database Normalization (3NF) 7 Boyce-Codd Normal Form (BCNF) 8 Denormalization concepts 9 Designing Production Databases 10 Practice Assignment: Database Design Fundamentals 11 Assignment Solution: Database Design Fundamentals

Advanced Joins & Query Writing 1 Multiple Table Joins 2 Join Optimization 3 Complex Reporting Queries 4 Real Business Scenarios 5 Practice Assignment: Advanced Joins and Query Writing 6 Assignment Solution: Advanced Joins and Query Writing

Real-World Projects in MySQL 1 Project 1: Student Management System using MySQL 2 Project 2: E-Commerce Database using MySQL 3 Project 3: Library Management System using MySQL 4 Final Project Assignment: Real-World MySQL Projects 5 Project Solution Guide: Real-World MySQL Projects

Advanced MySQL & Career Preparation (MySQL Bonus Topic) 1 MySQL Interview Questions 2 Common MySQL Errors 3 Database Design Best Practices 4 MySQL Backup & Restore 5 Import and Export Data in MySQL 6 MySQL with PHP 7 MySQL with Python 8 MySQL with Laravel 9 MySQL in Real Production Systems 10 Practice Assignment: Advanced MySQL and Career Preparation 11 Assignment Solution: Advanced MySQL and Career Preparation

No topics found for your search.

Table of Contents

Boyce-Codd Normal Form (BCNF) Explained: An In-Depth Guide to Database Normalization

Rumman Ansari July 19, 2024 6,974 views Subject Details

🔒 Please log in to unlock this course.