Designing an E-Commerce Application Database | Advanced SQL for Application Development
Welcome to my Channel...!
In this video we are going to Learn Advanced SQL for Application Development . These are the fundamentals of Advanced SQL for Application Development and essential trainings. we will see more and more in upcoming videos.
Exercise Files Direct Link:-👇👇👇
https://mega.nz/file/pqQ2ERgQ#ZLGK1l_6AqZb...
PHP Tutorials for Beginners to Master | A-Z Concepts in PHP
PHP Full Playlist:-👇👇👇
• PHP Tutorials for Beginners to Master | Le...
Full-Stack JavaScript App Development tutorial:-👇👇👇
• Video
Creating and Hosting Full-Stack Site using React:-👇👇👇
• Creating and Hosting a Full-Stack Site usi...
For any queries drop a mail at [email protected]
Share your thoughts about this video in the comment section and if you have any doubts post it in comment section.
BluePrism Playlist:- • BluePrism | RPA
Thank You...!
→→→→→Visit Our Channel For More Videos←←←←←
🏹LIKE
🏹SHARE
🏹SUBSCRIBE
Where There is a Will There is a Way 💘
//Chapters and time splits
00:00:00-00:00:43 Getting started with SQL for application developers
00:00:43-00:06:48 Designing an ecommerce application database
00:06:49-00:11:01 Creating tables and loading data
00:11:02-00:14:58 Using environment variables for connection parameters
00:14:59-00:17:26 Connecting to a database
00:17:27-00:21:03 Parameterizing SELECT statements
00:21:04-00:28:21 Avoiding N+1 queries
00:28:22-00:29:04 Challenge: Write a parameterized query in python
00:29:05-00:31:25 Solution: How to write a parameterized query in python
00:31:26-00:33:51 Overview of index types
00:33:52-00:35:23 Using B-tree indexes and equality operations
00:35:24-00:37:46 Covering indexes
00:37:47-00:40:04 Indexes and bulk data loading
00:40:05-00:43:07 Avoiding index locks
00:43:08-00:43:44 Challenge: Define a B-tree and a hash index
00:43:45-00:44:41 Solution: Define a B-tree and a hash indexes
00:44:42-00:46:04 Overview of object-relational mapping
00:46:05-00:49:09 Introduction to SQLAlchemy
00:49:10-00:50:13 Installing SQLAlchemy
00:50:14-01:00:00 Query with SQLAlchemy
01:00:01-01:02:10 Limitations of ORM and cautionary advice
01:02:11-01:02:47 Challenge: Create an ORM model
01:02:48-01:03:41 Solution: Create an ORM model
01:03:42-01:10:51 Overview of partitioning
01:10:52-01:16:43 Range partitioning
01:16:44-01:19:50 List partitioning
01:19:51-01:24:17 Hash partitioning
01:24:18-01:25:20 Query partitioned tables
01:25:21-01:27:01 Listing read-only replicas
01:27:02-01:27:38 Challenge: Define a partitioned table
01:27:39-01:28:32 Solution: Define a partitioned table
01:28:33-01:31:31 Database errors
01:31:32-01:36:42 Error trapping
01:36:43-01:40:53 Database not responding, timeouts and exponential backoff
01:40:54-01:44:46 Connection pooling and bulk heads
01:44:47-01:49:00 Monitoring and logging best practices
01:49:01-01:49:30 Challenge: When your Python application fails
01:49:31-01:50:02 Solution: When your Python application fails
01:50:03-01:53:35 Understanding schema changes
01:53:36-01:56:52 Ad hoc scripts for schema changes
01:56:53-01:58:53 Automated schema migration with Flyway
01:58:54-02:01:17 Automated schema migration with Liquibase
02:01:18-02:01:47 Challenge
02:01:48-02:02:39 Solution
02:02:40-02:05:07 Key considerations