In this program you will learn:
Basic techniques and methods for structuring and managing databases.
Advanced techniques for writing database-driven applications and advanced data modeling concepts.
MySQL database management system (DBMS) and data creation, query and manipulation.
How to code and use Python syntax
How to prepare for technical interviews for a database engineer position.

Course material: https://drive.google.com/file/d/1wP5aPi3qOdk3D9d6QV6f0NTT_DGt2jDl/view?uspsharing

Applied Data Science from IBM: https://youtu.be/AMtFSAt0tZ0
Applied Data Science with R from IBM: https://youtu.be/5phPXk1ypZE
Complete Google Data Analytics Professional Certificate courses: https://www.youtube.com/playlist?listPLtS8Ubq2bIlVN4Zom0O-6rBysJs3wns60

TIME STAMP

INTRODUCTION TO DATABASES
0:00:00 Course introduction
0:12:32 Databases and data
0:26:40 Introduction to SQL
0:39:52 Basic database 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 a database schema
2:16:42 Relational database design
2:31:46 Database normalization
2:53:32 Graded performance assessment
2:56:17 Course completion

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 Creating a repository with forking
4:56:02 Graded performance assessment
4:58:46 Course completion

Database structures and management with MySQL
5:00:37 Course introduction
5:09:57 Filter data
5:25:20 Connecting tables
5:55:55 Group data
6:09:02 Updating and inserting data
6:15:17 Restrictions
6:25:03 Change table structure
6:37:50 Subqueries
6:51:20 Virtual tables
7:01:15 Functions in MySQL
7:28:56 Procedure
7:37:05 Graded assessment of final project
7:40:29 Course completion

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 performance assessment
9:27:00 Course completion

PROGRAMMING IN PYTHON
9:28:51 Course introduction
9:33:45 Welcome to Python programming
10:24:28 Control flow and conditions
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 Module
13:40:22 Popular package libraries and frameworks
13:55:27 Test tools
14:23:51 Graded performance assessment
14:25:42 Course completion

DATABASE CLIENTS
14:27:42 Course introduction
14:37:25 Establishing a MySQL-Python connection and creating tables
14:53:26 Working with cursors
15:08:48 Executing CRUD operations (Create Read Update and Delete)
15:17:57 Advanced queries in MySQL databases with Python
15:30:20 Implementing MySQL functions with Python
15:47:15 Accessing MySQL stored procedures with Python
15:54:53 Working with connection pools
16:09:31 Final project
16:13:56 Course completion

ADVANCED DATA MODELING
16:16:01 Course introduction
16:27:20 Database modeling
16:43:07 MySQL WorkBench WB
17:05:48 What is a data warehouse?
17:20:49 Dimensional data modeling
17:35:06 Introduction to data analysis
17:50:11 Advanced data analysis in practice
18:14:40 Final project evaluation
18:20:51 Course completion

DATABASE ENGINEER CAPSTONE
18:22:56 Project info
18:27:35 Setting up the project
18:33:20 Add sales reports
18:36:24 Table reservation system
18:45:05 Data visualization
18:48:45 Database client
18:55:44 Final project evaluation
19:00:21 Course completion

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 of 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
#Database management
#DatabaseEngineer
Database Tutorial Channel,
DBMS complete 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 a video
Database Design,
database management,
data modeling,
Relational databases,
SQL programming,
Data warehousing,
database architecture,
Big data analysis,
Cloud databases,
NoSQL databases,
Database security,
Indexing and query optimization,
data integration,
Data mining and analysis,
Business Intelligence (BI) and reporting,
Data management and compliance,
data visualization,
database management,
Distributed databases,
Graph databases,

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.