Myvideo

Guest

Login

Database Engineering Complete Course | DBMS Complete Course

Uploaded By: Myvideo
1 view
0
0 votes
0

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. Course Material : πŸ‘‰Applied Data Science By IBM: πŸ‘‰Applied Data Science with R By IBM: πŸ‘‰Google Data Analytics Professional Certificate Complete Courses: β­β­β­β­πŸ•‘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,

Share with your friends

Link:

Embed:

Video Size:

Custom size:

x

Add to Playlist:

Favorites
My Playlist
Watch Later