- Have any question?
- 📲0177-1175826
- ✉️
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 1
- Creating a Database – Part 1 (Exercise)
- Creating a Database – Part 2
- Creating a Database – Part 2 (Exercise)
- Introduction to Data Types
- String Data Types
- Integers
- Fixed and Floating-Point Data Types
- Other Useful Data Types
- Creating a Table
- Creating a Table (Exercise)
- Using Databases and Tables
- Using Databases and Tables (Exercise)
- Additional Notes on Using Table
- Additional Notes on Using Tables (Exercise)
-
Understanding MySQL Constraints
-
How Professionals Deal with Codes
-
Loading The 'Employees' Database
-
SQL Select Statement (Very Important)
- SELECT….FORM…..
- SELECT – FROM (Exercise)
- WHERE
- WHERE (Exercise)
- AND
- AND (Exercise)
- OR
- OR (Exercise)
- Operation Precedence
- Operator precedence (Exercise)
- IN – NOT IN
- IN – NOT IN (Exercise)
- LIKE – NOT LIKE
- LIKE – NOT LIKE (Exercise)
- Wildcard Characters
- Wildcard Characters (Exercise)
- BETWEEN….. AND
- BETWEEN – AND (Exercise)
- IS NOT NULL – IS NULL
- IS NOT NULL – IS NULL (Exercise)
- Other Comparison Operations
- Other comparison operators (Exercise)
- SELECT DISTINCT
- SELECT DISTINCT (Exercise)
- Introduction to Aggregate Function
- Introduction to Aggregate Functions (Exercise)
- ORDER BY
- ORDER BY (Exercise)
- GROUP BY
- Using Aliases
- Using Aliases (AS) (Exercise)
- HAVING
- HAVING (Exercise)
- WHERE vs HAVING
- WHERE vs HAVING (Exercise)
- LIMIT
- LIMIT (Exercise)
-
SQL INSERT Statement
-
SQL UPDATE Statement
-
SQL DELETE Statement
-
SQL Aggregate Functions
-
Deep Dive into SQL Joins
- Introduction to JOINs
- Introduction to JOINs (Exercise)
- INNER JOIN Part-I
- INNER JOIN Part-II
- INNER JOIN – Part II (Exercise)
- A Note on Using Joins
- Duplicate Records
- LEFT JOIN Part-I
- LEFT JOIN Part-II
- LEFT JOIN Part-II (Exercise)
- RIGHT JOIN
- The New and The Older Join Syntax
- The New and The Older Join Syntax (Exercise)
- JOIN and WHERE Used Together
- JOIN and WHERE Used Together (Exercise)
- Important – Prevent Error Code 1055!
-
SQL Subqueries
- SQL Subqueries with IN nested inside WHERE
- SQL Subqueries with IN nested inside WHERE (Exercise)
- SQL Subqueries with EXISTS-NOT EXISTS
- SQL Subqueries with EXISTS-NOT EXISTS (Exercise)
- SQL Subqueries nested in SELECT and FROM
- SQL Subqueries nested in SELECT and FROM (Exercise 1)
- SQL Subqueries nested in SELECT and FROM (Exercise 2)
-
How to Establish SQL Self Join
-
What is SQL Views & How It Works
-
How to Handle Stored Procedure
- Introduction to stored routines
- The MySQL syntax for stored procedures
- Stored procedures – Example – Part I
- Stored procedures – Example – Part II
- Stored procedures – Example – Part II (Exercise)
- Another way to create a procedure
- Stored procedures with an input parameter
- Stored Procedures with an Output Parameter
- Stored Procedures with an Output Parameter (Exercise)
- Variables
- Variables (Exercise)
- User-defined functions in MySQL
- Error Code 1418
- User-defined functions in MySQL (Exercise)
- Stored Routines – Conclusion
-
Understanding Advanced SQL Elements
- Types of MySQL Variables – Local Variable
- Session Variables
- Global Variables
- User-Defined vs System Variables
- MySQL Triggers
- MySQL Triggers (Exercise)
- MySQL Indexes
- MySQL Indexes (Exercise)
- The CASE Statement
- The CASE Statement (Exercise 1)
- The CASE Statement (Exercise 2)
- The CASE Statement (Exercise 3)
-
Conclusion + BONUS
This content is protected, please login and enroll in the course to view this content!
error: Alert: Content selection is disabled!!
Modal title
Main Content