Database Engineer

9 Courses · 180 Lessons
🔍
📖 C1 Introduction to Databases 4 Modules · 20 Lessons
▶ M1 Database Fundamentals 5
1L1 Database Kya Hai→ 2L2 Database Architecture→ 3L3 Data Models→ 4L4 Database Lifecycle→ 5L5 Module Review→
▶ M2 Types of Databases 5
1L1 Relational Databases→ 2L2 NoSQL Databases→ 3L3 SQL vs NoSQL→ 4L4 Cloud Databases→ 5L5 Module Review→
▶ M3 SQL Basics 5
1L1 SQL Introduction→ 2L2 SELECT Queries→ 3L3 INSERT UPDATE DELETE→ 4L4 Functions aur Aggregates→ 5L5 Module Review→
▶ M4 Introduction to Data Modeling 5
1L1 Data Modeling Basics→ 2L2 Entities aur Relationships→ 3L3 ER Diagrams→ 4L4 Keys aur Constraints→ 5L5 Module Review→
📖 C2 Version Control 4 Modules · 20 Lessons
▶ M1 Introduction to Version Control 5
1L1 Version Control Kya Hai→ 2L2 Git Setup→ 3L3 Basic Workflow→ 4L4 Database Version Control→ 5L5 Module Review→
▶ M2 Git Commands and Workflows 5
1L1 Remote Repositories→ 2L2 Stash aur History→ 3L3 Undo Operations→ 4L4 Tags aur Releases→ 5L5 Module Review→
▶ M3 Branching and Merging 5
1L1 Branch Basics→ 2L2 Merging→ 3L3 Conflict Resolution→ 4L4 Team Workflows→ 5L5 Module Review→
▶ M4 Collaboration with GitHub 5
1L1 GitHub Platform→ 2L2 Pull Requests→ 3L3 Issues aur Projects→ 4L4 GitHub Actions for Databases→ 5L5 Module Review→
📖 C3 Database Structures and Management with MySQL 4 Modules · 20 Lessons
▶ M1 MySQL Setup and Configuration 5
1L1 MySQL Installation→ 2L2 Server Configuration→ 3L3 User Management→ 4L4 Command Line Tools→ 5L5 Module Review→
▶ M2 Tables Data Types and Constraints 5
1L1 Data Types→ 2L2 Create Tables→ 3L3 Constraints→ 4L4 ALTER Table→ 5L5 Module Review→
▶ M3 CRUD Operations 5
1L1 INSERT Operations→ 2L2 SELECT Advanced→ 3L3 UPDATE aur DELETE→ 4L4 Bulk Operations→ 5L5 Module Review→
▶ M4 Joins and Subqueries 5
1L1 JOIN Types→ 2L2 MultiTable Queries→ 3L3 Subqueries→ 4L4 Views→ 5L5 Module Review→
📖 C4 Advanced MySQL Topics 4 Modules · 20 Lessons
▶ M1 Stored Procedures and Functions 5
1L1 Stored Procedures Basics→ 2L2 Control Flow in Procedures→ 3L3 Functions→ 4L4 Error Handling→ 5L5 Module Review→
▶ M2 Triggers and Events 5
1L1 Triggers Fundamentals→ 2L2 Advanced Triggers→ 3L3 Scheduled Events→ 4L4 Audit Trail Implementation→ 5L5 Module Review→
▶ M3 Indexing and Query Optimization 5
1L1 Index Fundamentals→ 2L2 Index Types aur Strategy→ 3L3 EXPLAIN aur Query Analysis→ 4L4 Query Optimization Techniques→ 5L5 Module Review→
▶ M4 Transactions and Concurrency 5
1L1 Transaction Basics→ 2L2 Isolation Levels→ 3L3 Locking Mechanisms→ 4L4 Transaction Design Patterns→ 5L5 Module Review→
📖 C5 Programming in Python 4 Modules · 20 Lessons
▶ M1 Python Basics and Syntax 5
1L1 Python Introduction→ 2L2 Variables aur Data Types→ 3L3 Control Flow→ 4L4 Functions→ 5L5 Module Review→
▶ M2 Data Structures in Python 5
1L1 Lists→ 2L2 Dictionaries→ 3L3 Tuples aur Sets→ 4L4 Strings Advanced→ 5L5 Module Review→
▶ M3 ObjectOriented Programming 5
1L1 Classes aur Objects→ 2L2 Inheritance→ 3L3 Encapsulation aur Polymorphism→ 4L4 Special Methods→ 5L5 Module Review→
▶ M4 Modules and File Handling 5
1L1 Modules aur Packages→ 2L2 File Reading aur Writing→ 3L3 CSV aur JSON Handling→ 4L4 Exception Handling→ 5L5 Module Review→
📖 C6 Database Clients 4 Modules · 20 Lessons
▶ M1 Connecting Python to MySQL 5
1L1 MySQL Connector Setup→ 2L2 Executing Queries→ 3L3 CRUD with Python→ 4L4 Error Handling aur Best Practices→ 5L5 Module Review→
▶ M2 Using ORMs for Database Access 5
1L1 ORM Introduction→ 2L2 Models Define karna→ 3L3 CRUD with ORM→ 4L4 Advanced ORM Patterns→ 5L5 Module Review→
▶ M3 Connection Pooling and Management 5
1L1 Connection Pooling Basics→ 2L2 SQLAlchemy Pool→ 3L3 Connection Lifecycle→ 4L4 Production Configuration→ 5L5 Module Review→
▶ M4 Data Access Patterns and Best Practices 5
1L1 Repository Pattern→ 2L2 Data Transfer Objects→ 3L3 Query Optimization Patterns→ 4L4 Security Best Practices→ 5L5 Module Review→
📖 C7 Advanced Data Modeling 4 Modules · 20 Lessons
▶ M1 EntityRelationship Modeling 5
1L1 ER Model Concepts→ 2L2 ER Diagrams→ 3L3 Advanced ER Concepts→ 4L4 ER to Relational Mapping→ 5L5 Module Review→
▶ M2 Normalization and Normal Forms 5
1L1 Why Normalization→ 2L2 First aur Second Normal Form→ 3L3 Third Normal Form aur Beyond→ 4L4 Normalization Exercise→ 5L5 Module Review→
▶ M3 Denormalization Strategies 5
1L1 When to Denormalize→ 2L2 Denormalization Techniques→ 3L3 Maintaining Consistency→ 4L4 RealWorld Scenarios→ 5L5 Module Review→
▶ M4 Data Warehousing Concepts 5
1L1 Data Warehouse Fundamentals→ 2L2 Star Schema Design→ 3L3 Snowflake aur Galaxy Schema→ 4L4 Warehouse Implementation→ 5L5 Module Review→
📖 C8 Database Engineer Capstone 4 Modules · 20 Lessons
▶ M1 Capstone Project Planning 5
1L1 Project Requirements→ 2L2 Project Plan→ 3L3 ER Design→ 4L4 Schema Planning→ 5L5 Module Review→
▶ M2 Database Design and Implementation 5
1L1 Schema Implementation→ 2L2 Stored Procedures aur Views→ 3L3 Python Client Development→ 4L4 Testing aur Validation→ 5L5 Module Review→
▶ M3 Application Integration 5
1L1 API Development→ 2L2 Database Integration→ 3L3 Authentication aur Security→ 4L4 Frontend Integration→ 5L5 Module Review→
▶ M4 Performance Optimization and Presentation 5
1L1 Performance Profiling→ 2L2 Optimization Techniques→ 3L3 Documentation→ 4L4 Project Presentation→ 5L5 Module Review→
📖 C9 Coding Interview Preparation 4 Modules · 20 Lessons
▶ M1 Data Structures for Interviews 5
1L1 Arrays aur Strings→ 2L2 Linked Lists aur StacksQueues→ 3L3 Hash Tables aur Trees→ 4L4 Graphs aur Heaps→ 5L5 Module Review→
▶ M2 Algorithm Strategies 5
1L1 Sorting aur Searching→ 2L2 Recursion aur Dynamic Programming→ 3L3 Greedy aur Backtracking→ 4L4 Complexity Analysis→ 5L5 Module Review→
▶ M3 SQL Interview Questions 5
1L1 SQL Basics Interview→ 2L2 Advanced SQL Problems→ 3L3 Database Design Questions→ 4L4 Performance Questions→ 5L5 Module Review→
▶ M4 Mock Interviews and Tips 5
1L1 Interview Format→ 2L2 Problem Solving Approach→ 3L3 Mock Interview Practice→ 4L4 Career Preparation→ 5L5 Module Review→