Database Engineer

9 Courses · 297 Lessons
🔍

C1 Introduction to Databases 28 lessons

M1 Database Fundamentals 7
1Database Kya Hai▸ 2Database Architecture▸ 3Data Models▸ 4Database Lifecycle▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Types of Databases 7
1Relational Databases▸ 2NoSQL Databases▸ 3SQL vs NoSQL▸ 4Cloud Databases▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 SQL Basics 7
1SQL Introduction▸ 2SELECT Queries▸ 3INSERT UPDATE DELETE▸ 4Functions aur Aggregates▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Introduction to Data Modeling 7
1Data Modeling Basics▸ 2Entities aur Relationships▸ 3ER Diagrams▸ 4Keys aur Constraints▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C2 Version Control 28 lessons

M1 Introduction to Version Control 7
1Version Control Kya Hai▸ 2Git Setup▸ 3Basic Workflow▸ 4Database Version Control▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Git Commands and Workflows 7
1Remote Repositories▸ 2Stash aur History▸ 3Undo Operations▸ 4Tags aur Releases▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 Branching and Merging 7
1Branch Basics▸ 2Merging▸ 3Conflict Resolution▸ 4Team Workflows▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Collaboration with GitHub 7
1GitHub Platform▸ 2Pull Requests▸ 3Issues aur Projects▸ 4GitHub Actions for Databases▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C3 Database Structures and Management with MySQL 28 lessons

M1 MySQL Setup and Configuration 7
1MySQL Installation▸ 2Server Configuration▸ 3User Management▸ 4Command Line Tools▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Tables Data Types and Constraints 7
1Data Types▸ 2Create Tables▸ 3Constraints▸ 4ALTER Table▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 CRUD Operations 7
1INSERT Operations▸ 2SELECT Advanced▸ 3UPDATE aur DELETE▸ 4Bulk Operations▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Joins and Subqueries 7
1JOIN Types▸ 2MultiTable Queries▸ 3Subqueries▸ 4Views▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C4 Advanced MySQL Topics 28 lessons

M1 Stored Procedures and Functions 7
1Stored Procedures Basics▸ 2Control Flow in Procedures▸ 3Functions▸ 4Error Handling▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Triggers and Events 7
1Triggers Fundamentals▸ 2Advanced Triggers▸ 3Scheduled Events▸ 4Audit Trail Implementation▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 Indexing and Query Optimization 7
1Index Fundamentals▸ 2Index Types aur Strategy▸ 3EXPLAIN aur Query Analysis▸ 4Query Optimization Techniques▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Transactions and Concurrency 7
1Transaction Basics▸ 2Isolation Levels▸ 3Locking Mechanisms▸ 4Transaction Design Patterns▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C5 Programming in Python 28 lessons

M1 Python Basics and Syntax 7
1Python Introduction▸ 2Variables aur Data Types▸ 3Control Flow▸ 4Functions▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Data Structures in Python 7
1Lists▸ 2Dictionaries▸ 3Tuples aur Sets▸ 4Strings Advanced▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 ObjectOriented Programming 7
1Classes aur Objects▸ 2Inheritance▸ 3Encapsulation aur Polymorphism▸ 4Special Methods▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Modules and File Handling 7
1Modules aur Packages▸ 2File Reading aur Writing▸ 3CSV aur JSON Handling▸ 4Exception Handling▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C6 Database Clients 28 lessons

M1 Connecting Python to MySQL 7
1MySQL Connector Setup▸ 2Executing Queries▸ 3CRUD with Python▸ 4Error Handling aur Best Practices▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Using ORMs for Database Access 7
1ORM Introduction▸ 2Models Define karna▸ 3CRUD with ORM▸ 4Advanced ORM Patterns▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 Connection Pooling and Management 7
1Connection Pooling Basics▸ 2SQLAlchemy Pool▸ 3Connection Lifecycle▸ 4Production Configuration▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Data Access Patterns and Best Practices 7
1Repository Pattern▸ 2Data Transfer Objects▸ 3Query Optimization Patterns▸ 4Security Best Practices▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C7 Advanced Data Modeling 28 lessons

M1 EntityRelationship Modeling 7
1ER Model Concepts▸ 2ER Diagrams▸ 3Advanced ER Concepts▸ 4ER to Relational Mapping▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Normalization and Normal Forms 7
1Why Normalization▸ 2First aur Second Normal Form▸ 3Third Normal Form aur Beyond▸ 4Normalization Exercise▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 Denormalization Strategies 7
1When to Denormalize▸ 2Denormalization Techniques▸ 3Maintaining Consistency▸ 4RealWorld Scenarios▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Data Warehousing Concepts 7
1Data Warehouse Fundamentals▸ 2Star Schema Design▸ 3Snowflake aur Galaxy Schema▸ 4Warehouse Implementation▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C8 Database Engineer Capstone 28 lessons

M1 Capstone Project Planning 7
1Project Requirements▸ 2Project Plan▸ 3ER Design▸ 4Schema Planning▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Database Design and Implementation 7
1Schema Implementation▸ 2Stored Procedures aur Views▸ 3Python Client Development▸ 4Testing aur Validation▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 Application Integration 7
1API Development▸ 2Database Integration▸ 3Authentication aur Security▸ 4Frontend Integration▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Performance Optimization and Presentation 7
1Performance Profiling▸ 2Optimization Techniques▸ 3Documentation▸ 4Project Presentation▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸

C9 Coding Interview Preparation 28 lessons

M1 Data Structures for Interviews 7
1Arrays aur Strings▸ 2Linked Lists aur StacksQueues▸ 3Hash Tables aur Trees▸ 4Graphs aur Heaps▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M2 Algorithm Strategies 7
1Sorting aur Searching▸ 2Recursion aur Dynamic Programming▸ 3Greedy aur Backtracking▸ 4Complexity Analysis▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M3 SQL Interview Questions 7
1SQL Basics Interview▸ 2Advanced SQL Problems▸ 3Database Design Questions▸ 4Performance Questions▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Mock Interviews and Tips 7
1Interview Format▸ 2Problem Solving Approach▸ 3Mock Interview Practice▸ 4Career Preparation▸ 5Module Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸