Engineering 1 - Nerds Lesson

 

👉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