Database Engineering Complete Course | DBMS Complete Course

In this program, you’ll learn:
Core techniques and methods to structure and manage databases.
Advanced techniques to write database driven applications and advanced data modeling concepts.
MySQL database management system (DBMS) and data creation, querying and manipulation.
How to code and use Python Syntax
How to prepare for technical interviews for database engineer roles.

⭐⭐⭐⭐🕑TIME STAMP📋⭐⭐⭐⭐⭐

👉INTRODUCTION TO DATABASES
🕑0:00:00 Course Introduction
🕑0:12:32 DataBases and Data
🕑0:26:40 Intro To SQL
🕑0:39:52 Basic Databases Structure
🕑0:49:52 SQL Data Types
🕑1:01:29 Create and read
🕑1:21:36 Update and delete
🕑1:31:50 SQL operators
🕑1:47:06 Sorting and Filtering data
🕑2:05:56 Designing Database schema
🕑2:16:42 Relational Database design
🕑2:31:46 Database Normalization
🕑2:53:32 Graded Assessment
🕑2:56:17 Course wrap up

👉INTRODUCTION TO VERSION CONTROL
🕑2:59:07 Course Introduction
🕑3:06:49 Introduction to Version Control
🕑3:25:01 Unix Commands
🕑4:02:19 Git and Github
🕑4:54:41 Create a Repository with Forking
🕑4:56:02 Graded Assessment
🕑4:58:46 Course wrap up

👉DATABASE STRUCTURES AND MANAGEMENT WITH MYSQL
🕑5:00:37 course Introduction
🕑5:09:57 Filtering Data
🕑5:25:20 Joining Tables
🕑5:55:55 Grouping Data
🕑6:09:02 Updating and Inserting Data
🕑6:15:17 Constraints
🕑6:25:03 changing Table Structure
🕑6:37:50 Subqueries
🕑6:51:20 Virtual Tables
🕑7:01:15 Functions in MYSQL
🕑7:28:56 Procedures
🕑7:37:05 Graded Assessment Final Project
🕑7:40:29 Course Wrap up

👉ADVANCED MYSQL Topics
🕑7:43:05 Course Introduction
🕑7:46:30 Advanced MySQL Functions and Stored Procedures
🕑8:04:18 MySQL Triggers and events
🕑8:26:01 Optimizing Database queries
🕑8:40:25 Further Optimization Techniques
🕑8:59:11 Evaluating MySQL for Data Analysis
🕑9:06:52 Performing Data Analysis in MySQL
🕑9:22:59 Graded Assessment
🕑9:27:00 Course Wrap up

👉PROGRAMMING IN PYTHON
🕑9:28:51 course introduction
🕑9:33:45 Welcome to Python Programming
🕑10:24:28 Control Flow and Conditionals
🕑10:58:00 Functions and Data Structures
🕑11:30:33 Error Exceptions and File Handling
🕑11:55:42 Procedure Programming
🕑12:08:35 Functional Programming
🕑12:32:26 Object Oriented Programming
🕑13:10:34 Modules
🕑13:40:22 Popular Packages Libraries and Frameworks
🕑13:55:27 Testing Tools
🕑14:23:51 Graded Assessement
🕑14:25:42 Course wrap up

👉DATABASE CLIENTS
🕑14:27:42 Course Introducdtion
🕑14:37:25 Establishing a MySQL Python Connection and Creating tables
🕑14:53:26 Working With Cursors
🕑15:08:48 Performing Create read update and delete crud operations
🕑15:17:57 Advanced queries in MySQL Database using Python
🕑15:30:20 Implementing MySQL Functions Using Python
🕑15:47:15 Accessing MySQL Stored Procedures using Python
🕑15:54:53 Working with Connection Pools
🕑16:09:31 Final Project
🕑16:13:56 Course wrap up

👉ADVANCED DATA MODELING
🕑16:16:01 Course Introduction
🕑16:27:20 Database Modeling
🕑16:43:07 MYSQL WorkBench WB
🕑17:05:48 What is data warehouse
🕑17:20:49 Dimensional Data Modeling
🕑17:35:06 Introduction to data analytics
🕑17:50:11 ADvanced Data analytics in practice
🕑18:14:40 Final Project Assessment
🕑18:20:51 Course Wrap up

👉DATABASE ENGINEER CAPSTONE
🕑18:22:56 Project Info
🕑18:27:35 Setting up the project
🕑18:33:20 Adding sales reports
🕑18:36:24 Table Booking System
🕑18:45:05 Data Visualization
🕑18:48:45 Database Client
🕑18:55:44 Final Project Assessment
🕑19:00:21 course wrap up

👉CODING INTERVIEW PREPARATION
🕑19:03:20 Course introduction
🕑19:16:05 The Coding Interview
🕑19:37:40 Introduction to Computer Science
🕑20:07:21 Basic Data Structures
🕑20:14:07 Collection Data Structures
🕑20:30:54 Advanced Data Structures
🕑20:56:39 Sorting And Searching
🕑21:09:10 Working with Algorithms
🕑21:35:44 Final Graded Assessment

♥️♥️Thanks for watching don't forget to like and Subscribe♥️♥️

✨✨PLEASE IGNORE THESE TAGS✨✨
#database
#databasemanagement
#databaseengineer
database tutorial channel,
dbms full course,
dbms course,
dbms and sql,
dbms computer,
dbms complete course,
dbms classes,
dbms data modeling,
dbms for beginners,
dbms gate lectures,
dbms gate crash course,
dbms in one video
Database design,
Database management,
Data modeling,
Relational databases,
SQL programming,
Data warehousing,
Database architecture,
Big data analytics,
Cloud databases,
NoSQL databases,
Database security,
Indexing and query optimization,
Data integration,
Data mining and analysis,
Business intelligence (BI) and reporting,
Data governance and compliance,
Data visualization,
Database administration,
Distributed databases,
Graph databases,

[goodluckythomas]

Voila !!! I took this course couple months back and started to study it seriously around february this yeah and guess what ??!!! In the end of May this year I got a job as DBA. Thank you Nerd for your help mate

[gavinkalaher]

Watch out for the errors in this course, though! Incorrectly referenced Primary Key-Foreign Keys in tables, loads of typos etc - I submitted loads of reports for content improvement. I unenrolled on Coursera because the platform incorrectly marked my correct MySQL syntax as incorrect (when it was pasted into an input field on a test), even though it executed perfectly in the console and outputted the desired tables. As it's now free on YouTube, I'll continue with the course when I get time. Thanks for the upload Nerd's Lesson!

[wilsonibekason]

This is by far, the best Database engineering, I have seen on Youtube, thank you so much for this

[DellAnderson]

Very glad to find this informative course. If they ever recreate it (so far don't see a need for redoing as most major errors appear to be fixed by voice overs), but perhaps linger a bit longer on the presentations screens and less on video of speaker (I don't really care what he looks like!). And perhaps actually summarize each section with concise summaries rather than thinly disguised quizzes asking us "You should be able to define the term database schema", and then say "Well Done" without checking and confirming your answer or understanding. Especially when this 'summary' is presented several sections later than the term was defined. Leaves the viewer a bit uneasy whether they have learned everything properly. They may have the idea of what a schema is, or what 'partial dependency' is, but definitions can be tricky to put into words until one truly understands and works with material for a while, which is unlikely the first time thru a course like this.

[qamaruddinkhichi]

The course is unbelievable. Thanks for such a deep content.

[stephayayo]

The presentation is good. There may be errors here and there but that does not dismiss the work presented. There are always updates. I am waiting for the update that will take care of the cited mistakes (They take us to the next level).

[DD-cfiv]

What great high-quality content. I love you guys

[TheNelate]

8:31:27 -> Mistake: Using functions on columns that aren't indexed. 8:31:39 -> You should also avoid using functions on columns that are indexed as this could cause the database not to use the index. So where should the functions be used in the where clause?

[DH-tsho]

I OWE YOU SO MUCH. I owe so much that I am in debt till death, to you and so many others.

[vikramadityamathur]

Crisp, clear and highly informative. Thanks!

[lawankibiya]

I don't know how i will rate this contented, to me i deserved millions of stars⭐⭐⭐

[batdorjdelgersaikhan]

Nice I been waiting BDSM Course Thanks a lot

[VidPlex]

Thanks Man, I always wanted to Learn DB Engineering...

[alphacomedy]

This is just amazing guys, i loved it, the presentation is just on another level

[wongsimon]

Really big thanks to the effort paid in making this course.

[KhaleequrRahman]

excellent!!! just plain simple crisp but comprehensive.👏👏👏👏👏

[cck]

This channel being powered from Pakistan.... Amazing and my best wishes for Pakistan...

[prasantkumar]

Thank you for the DBMS Complete Course.

[Friendlytails]

Bro i accidentally clicked on your channel but i think i have found the gold nail in lacks of dust salute u sir 🫡🫡

[karunakaranr]

Amazing content and presentation. Thanks a ton...