- Have any question?
- 📲 0197-2719550
- ✉️ support@msbacademy.com
Ultimate SQL Bootcamp: Enter The World Of Data Science
আপনি যদি Data Science নিয়ে আগ্রহী হয়ে থাকেন এবং SQL Developer, Database Administrator, Business Analyst & Intelligence হিসেবে নিজেকে প্রতিষ্ঠিত করতে চাইলে এই কোর্সটি করে ফেলুন। কোর্সটি ভালোভাবে কমপ্লিট করলে আপনি চাকরীর বাজারে এবং ফ্রীলান্সিং সেক্টরে সবার থেকে বহুগুণ এগিয়ে থাকবেন ইনশাআল্লাহ।
Course Content
Total learning: 167 lessons
Road to Database, SQL and MySQL
SQL Philosophy
Fundamentals of Database Terminology
Install MySQL and Getting Acquainted with the Interface
Practically Learn SQL with Confidence
- Creating a Database – Part 15.1
- Creating a Database – Part 1 (Exercise)5.2
- Creating a Database – Part 25.3
- Creating a Database – Part 2 (Exercise)5.4
- Introduction to Data Types5.5
- String Data Types5.6
- Integers5.7
- Fixed and Floating-Point Data Types5.8
- Other Useful Data Types5.9
- Creating a Table5.10
- Creating a Table (Exercise)5.11
- Using Databases and Tables5.12
- Using Databases and Tables (Exercise)5.13
- Additional Notes on Using Table5.14
- Additional Notes on Using Tables (Exercise)5.15
-
Understanding MySQL Constraints
- Primary Key Constraint6.1
- PRIMARY KEY Constraint (Exercise)6.2
- Foreign Key Constraint6.3
- FOREIGN KEY Constraint (Exercise)6.4
- Unique Constraint6.5
- UNIQUE KEY Constraint (Exercise)6.6
- Default Constraint6.7
- DEFAULT Constraint (Exercise)6.8
- NOT NULL Constraint6.9
- NOT NULL Constraint (Exercise)6.10
-
How Professionals Deal with Codes
Loading The 'Employees' Database
SQL Select Statement (Very Important)
- SELECT….FORM…..9.1
- SELECT – FROM (Exercise)9.2
- WHERE9.3
- WHERE (Exercise)9.4
- AND9.5
- AND (Exercise)9.6
- OR9.7
- OR (Exercise)9.8
- Operation Precedence9.9
- Operator precedence (Exercise)9.10
- IN – NOT IN9.11
- IN – NOT IN (Exercise)9.12
- LIKE – NOT LIKE9.13
- LIKE – NOT LIKE (Exercise)9.14
- Wildcard Characters9.15
- Wildcard Characters (Exercise)9.16
- BETWEEN….. AND9.17
- BETWEEN – AND (Exercise)9.18
- IS NOT NULL – IS NULL9.19
- IS NOT NULL – IS NULL (Exercise)9.20
- Other Comparison Operations9.21
- Other comparison operators (Exercise)9.22
- SELECT DISTINCT9.23
- SELECT DISTINCT (Exercise)9.24
- Introduction to Aggregate Function9.25
- Introduction to Aggregate Functions (Exercise)9.26
- ORDER BY9.27
- ORDER BY (Exercise)9.28
- GROUP BY9.29
- Using Aliases9.30
- Using Aliases (AS) (Exercise)9.31
- HAVING9.32
- HAVING (Exercise)9.33
- WHERE vs HAVING9.34
- WHERE vs HAVING (Exercise)9.35
- LIMIT9.36
- LIMIT (Exercise)9.37
-
SQL INSERT Statement
SQL UPDATE Statement
SQL DELETE Statement
SQL Aggregate Functions
Deep Dive into SQL Joins
- Introduction to JOINs14.1
- Introduction to JOINs (Exercise)14.2
- INNER JOIN Part-I14.3
- INNER JOIN Part-II14.4
- INNER JOIN – Part II (Exercise)14.5
- A Note on Using Joins14.6
- Duplicate Records14.7
- LEFT JOIN Part-I14.8
- LEFT JOIN Part-II14.9
- LEFT JOIN Part-II (Exercise)14.10
- RIGHT JOIN14.11
- The New and The Older Join Syntax14.12
- The New and The Older Join Syntax (Exercise)14.13
- JOIN and WHERE Used Together14.14
- JOIN and WHERE Used Together (Exercise)14.15
- Important – Prevent Error Code 1055!14.16
-
SQL Subqueries
- SQL Subqueries with IN nested inside WHERE15.1
- SQL Subqueries with IN nested inside WHERE (Exercise)15.2
- SQL Subqueries with EXISTS-NOT EXISTS15.3
- SQL Subqueries with EXISTS-NOT EXISTS (Exercise)15.4
- SQL Subqueries nested in SELECT and FROM15.5
- SQL Subqueries nested in SELECT and FROM (Exercise 1)15.6
- SQL Subqueries nested in SELECT and FROM (Exercise 2)15.7
-
How to Establish SQL Self Join
What is SQL Views & How It Works
How to Handle Stored Procedure
- Introduction to stored routines18.1
- The MySQL syntax for stored procedures18.2
- Stored procedures – Example – Part I18.3
- Stored procedures – Example – Part II18.4
- Stored procedures – Example – Part II (Exercise)18.5
- Another way to create a procedure18.6
- Stored procedures with an input parameter18.7
- Stored Procedures with an Output Parameter18.8
- Stored Procedures with an Output Parameter (Exercise)18.9
- Variables18.10
- Variables (Exercise)18.11
- User-defined functions in MySQL18.12
- Error Code 141818.13
- User-defined functions in MySQL (Exercise)18.14
- Stored Routines – Conclusion18.15
-
Understanding Advanced SQL Elements
- Types of MySQL Variables – Local Variable19.1
- Session Variables19.2
- Global Variables19.3
- User-Defined vs System Variables19.4
- MySQL Triggers19.5
- MySQL Triggers (Exercise)19.6
- MySQL Indexes19.7
- MySQL Indexes (Exercise)19.8
- The CASE Statement19.9
- The CASE Statement (Exercise 1)19.10
- The CASE Statement (Exercise 2)19.11
- The CASE Statement (Exercise 3)19.12
-
Conclusion + BONUS
This content is protected, please login and enroll in the course to view this content!
Modal title
Main Content