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,
Hide player controls
Hide resume playing