Mastering MySQL: A Comprehensive Crash Course for Beginners || Completely in Bangla

🔍 In this video, we'll cover the fundamentals of MySQL, from installation to creating databases, tables, and executing queries. Get hands-on experience with real-world examples and practical tips that will empower you to manage and manipulate data efficiently.
📎Chapter/Bookmark: (🏁Table of Contents:)
0:07 - Introduction
1:07 - Course Plan
1:35 - Data, Information, Knowledge
3:18 - File-oriented Approach
6:10 - Introduction to Database
9:58 - Introduction to Database-Management System
13:17 - Three Levels of Abstractions
15:08 - Users of DBMS, Types of DBMS, Types of DBMS Architecture
19:05 - Relational Model, E-R Diagram
23:12 - KEYs in DBMS, Types of KEYs
26:30 - Database Language (SQL)
29:35 - MySQL Installation
38:35 - SQL Commands
42:31 - Form of Basic SQL Queries
43:52 - MySQL Datatypes
46:48 - DDL Commands (CREATE, ALTER, DROP, TRUNCATE)
1:03:03 - DML Commands (INSERT, UPDATE, DELETE)
1:05:00 - EXERCISE
1:09:57 - INSERT records into the table
1:17:17 - AUTO INCREMENT Constraint
1:20:33 - UPDATE Records
1:25:17 - DELETE Records
1:26:27 - EXERCISE 2 (Expand Customers Table)
1:27:45 - More Tables
1:31:50 - MySQL Operators
1:36:49 - DQL Commands
1:37:39 - DISTINCT Keywords
1:40:06 - WHERE Clause
1:44:45 - ORDER BY Clause
1:47:05 - Logical AND, OR, NOT
1:53:17 - Special OPERATORS (IN, BETWEEN)
1:57:32 - LIKE Keyword
1:59:57 - REGEXP Keyword
2:05:44 - LIMIT Keyword
2:08:47 - MySQL JOIN (INNER JOIN, LEFT JOIN, RIGHT JOIN)
2:24:08 - JOIN of THREE Tables
2:29:20 - MySQL Aggregate Function
2:31:57 - GROUP BY Clause
2:36:23 - MySQL VIEW
2:41:38 - Outro
***************************************************************
Download the course material from here - https://drive.google.com/file/d/1jBefxyVD4iXBnHMjsRCUqleQr-Tlun1r/view?usp=sharing
***********************************************************

🎓 Don't miss out on this opportunity to level up your MySQL skills! Hit play, follow along, and unlock the doors to a world of powerful database management. Subscribe for more tech tutorials and let's embark on this MySQL journey together! 💻🔐📊 #education #mysql #database #sql #tutorial #crashcourse #databasemanagement

Видео Mastering MySQL: A Comprehensive Crash Course for Beginners || Completely in Bangla канала Robaidul Islam