Bangla MySQL database & SQL tutorial for beginner to Intermediate 2023
🔴 In this video, I will start from the basics of MySQL and take you to the intermediate level with theoretical and practical explanations.
⭐️ Video Contents ⭐️
⌨️ (00:00:00) Intro
⌨️ (00:02:13) Prerequisite
⌨️ (00:03:05) Introduction to the database
⌨️ (00:12:45) Types of database
⌨️ (00:18:26) Types of Key
⌨️ (00:26:18) DBMS
⌨️ (00:31:53) RDBMS
⌨️ (00:34:32) Relations
⌨️ (00:40:08) Sorting & Indexing
⌨️ (00:47:15) Security
⌨️ (00:53:40) Query Language
⌨️ (00:59:21) SQL
⌨️ (01:05:01) Setup XAMPP
⌨️ (01:07:52) SHOW, CREATE AND DROP DATABASE
⌨️ (01:13:30) Data Types
⌨️ (01:17:37) CREATE, RENAME, DROP TABLE
⌨️ (01:27:10) INSERT records
⌨️ (01:40:22) SELECT records
⌨️ (01:46:12) DISTINCT, LIMIT
⌨️ (01:51:01) Sorting
⌨️ (01:56:50) Arithmetic Operators
⌨️ (01:58:58) WHERE clause
⌨️ (02:04:54) Relational Operators
⌨️ (02:07:26) Logical Operators – AND, OR
⌨️ (02:14:28) Logical Operators – IN, NOT IN
⌨️ (02:19:03) Logical Operators – LIKE
⌨️ (02:24:04) Custom name
⌨️ (02:25:38) Constraint and AUTO_INCREMENT
⌨️ (02:36:05) UPDATE records
⌨️ (02:41:08) DELETE records
⌨️ (02:45:02) UPPER & LOWER
⌨️ (02:48:54) Functions
⌨️ (02:57:26) Aggregate functions
⌨️ (03:04:52) subquery
⌨️ (03:10:28) ALTER statement
⌨️ (03:18:01) UPDATE statement
⌨️ (03:20:09) GROUP BY CLAUSE
⌨️ (03:25:11) TRUNCATE TABLE
⌨️ (03:27:48) Joining tables
⌨️ (03:38:07) JOIN CLAUSE
⌨️ (03:44:27) INNER JOIN
⌨️ (03:49:28) LEFT & RIGHT JOIN
⌨️ (03:53:32) UNION, UNION ALL
⌨️ (03:58:17) VIEW
⌨️ (04:07:40) Date & Time
⌨️ (04:17:00) outro
🔴 Subscribe for more videos: https://www.youtube.com/channel/UCEXwc6mNh7Lakj6lX-7a2Mg
✅ website: https://www.studywithanis.com
✅ Facebook: https://www.facebook.com/anisul2010s
✅ Facebook page: https://www.facebook.com/studywithanis/
✅ LinkedIn: https://www.linkedin.com/in/anisul2020/
✅ GitHub: https://github.com/anisul-Islam
🛑 Web development? Checkout following playlists :
👉 Full-stack web development Series: https://www.youtube.com/playlist?list=PLgH5QX0i9K3p06YY1fyReA2UK8mh_zsiY
🛑 Programming languages? Check out the following playlists:
👉 C programming: https://youtube.com/playlist?list=PLgH5QX0i9K3pCMBZcul1fta6UivHDbXvz
👉 C Pattern Printing: https://youtube.com/playlist?list=PLgH5QX0i9K3oTxQhx2kejYmQn6qtRULCD
👉 C++ : https://youtube.com/playlist?list=PLgH5QX0i9K3q0ZKeXtF–CZ0PdH1sSbYL
👉 Python: https://youtube.com/playlist?list=PLgH5QX0i9K3rz5XqMsTk41_j15_6682BN
👉 Java: https://youtube.com/playlist?list=PLgH5QX0i9K3oAZUB2QXR-dZac0c9HNyRa
👉 Java swing: https://youtube.com/playlist?list=PLgH5QX0i9K3rAHKr6IteF5kdgN6BorH9l
🛑 Android development? Check out the following playlists:
👉 Android development series: https://youtube.com/playlist?list=PLgH5QX0i9K3p9xzYLFGdfYliIRBLVDRV5
🛑 HSC Students? Are you worried about ICT? I have created 377 videos for you. check out the following playlists-
👉 ICT (HSC) Series- https://youtube.com/playlist?list=PLgH5QX0i9K3o8Y-CKhmyodbfHAc9VSVOv
🛑 CSE Students? Checkout following playlists :
👉 Discrete Math Series: https://youtube.com/playlist?list=PLgH5QX0i9K3rYy9DVhk28m8enSo8xxiZ3
👉 Theory of Computation (TOC): https://www.youtube.com/playlist?list=PLgH5QX0i9K3qw5pu16QgnKNj91Rnjoyd0
👉 Compiler: https://www.youtube.com/playlist?list=PLgH5QX0i9K3oWTwTgILA7v9oysoDgkJDg
👉 Operating System: https://www.youtube.com/playlist?list=PLgH5QX0i9K3r_SuT0AnOEoElfQQPgkBIq
👉 AI Bangla: https://www.youtube.com/playlist?list=PLgH5QX0i9K3oFAaeJxjDWA8kEbMutzV6V
👉 AI (English): https://www.youtube.com/playlist?list=PLgH5QX0i9K3rRVV7oeML93OVAxqQ-CvzV
👉 Numerical Method: https://www.youtube.com/playlist?list=PLgH5QX0i9K3oKFrSOo4Kwns1-vTZmKQ7z
👉 Networking: https://www.youtube.com/playlist?list=PLgH5QX0i9K3p5OI88r3ob-otmKqIm_DbS
🛑 MS Office? Trying to learn MS office to improve your skill? Checkout following playlists :
👉 MS Word: https://www.youtube.com/playlist?list=PLgH5QX0i9K3p21lsneT3cW4CJL4Bd1lJ2
👉 MS Excel: https://www.youtube.com/playlist?list=PLgH5QX0i9K3ohKCQMR7aopneByGX05iSK
👉 MS PowerPoint (Sylheti): https://www.youtube.com/playlist?list=PLgH5QX0i9K3pBnrckqfJ2zn7FL6Q_LNcm
🛑 Replying to your comments: https://www.youtube.com/playlist?list=PLgH5QX0i9K3rOy_3R7lYlN92BggSpbWTY
🛑 Finland Vlogs: https://www.youtube.com/playlist?list=PLgH5QX0i9K3rjV_UPr7SieC8ptWFsaA-i
🛑 Travel Vlogs: https://www.youtube.com/playlist?list=PLgH5QX0i9K3oePPOV7DXBAfZcOSZ9GIrh
#database #anisul_islam #databse_bangla_tutorial #web_development #bangla_web_development #sqlite #javaprogramming #sql #bangla_tutorial #android #databse_anisul_islam
Comments are closed.