End-to-End SQL Database Design and Optimization Project

Focused View

Walter Shields

2:44:35

0 View

01 - Introduction

01 - Course overview.mp4

00:47

02 - Prerequisite knowledge.mp4

01:03

02 - 1. Introduction to Databases and SQL

01 - What is a database.mp4

01:07

02 - Introduction to SQL.mp4

01:03

03 - 2. Introduction to Ecommerce Database Design

01 - Overview of ecommerce databases.mp4

00:57

02 - Key components of ecommerce databases.mp4

01:33

03 - Setting up your development environment.mp4

08:11

04 - 3. Entity Relationship Diagram (ERD)

01 - Understanding entity relationship diagrams.mp4

02:46

02 - Creating an ERD for an ecommerce database.mp4

07:31

05 - 4. Database Schema Design

01 - Designing the Products table.mp4

10:30

02 - Designing the Users table.mp4

05:52

03 - Designing the Orders table.mp4

05:36

04 - Designing the Reviews table.mp4

06:19

05 - Designing the Payments table.mp4

05:38

06 - Introduction to database normalization.mp4

02:02

07 - Normalizing the ecommerce database.mp4

05:20

06 - 5. ETL Processes for Ecommerce Data

01 - Introduction to ETL.mp4

02:17

02 - Setting up Anaconda Navigator and Jupyter Notebook.mp4

05:43

03 - Extracting data.mp4

07:31

04 - Transforming data.mp4

03:50

05 - Loading data.mp4

05:12

07 - 6. Data Validation and Integrity

01 - Implementing data validation.mp4

11:01

02 - Ensuring data integrity.mp4

04:30

08 - 7. Data Analysis and Reporting

01 - Introduction to data analysis.mp4

02:35

02 - Writing analytical queries.mp4

13:19

03 - Generating reports.mp4

07:12

09 - 8. Query Optimization

01 - Writing efficient SQL queries.mp4

06:36

02 - Query optimization and indexing.mp4

08:37

10 - 9. Final Project

01 - Project requirements and planning.mp4

04:22

02 - Implementing the final project.mp4

13:28

11 - Conclusion

01 - Final thoughts and next steps.mp4

02:07

Description

Kickstart your journey as a database administrator or platform developer by learning how to design and optimize a powerful database for ecommerce platforms. In this engaging course, instructor Walter Shields guides you through the essentials of database schema design, covering key elements like products, users, orders, and reviews. You’ll also dive into advanced techniques such as indexing strategies, query optimization, and ETL processes to ensure seamless data management. Through hands-on exercises and a capstone project, you'll gain practical experience in creating a high-performance ecommerce database. Whether you're a technical professional or a business-focused learner, this course equips you with the skills needed to build databases that scale with success.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Walter Shields

Instructor's Courses

Walter Shields is known as a Best-Selling Author, Mentor and SME in Data Analytics. He has over 25 years of experience training students and managing data systems for startups to Fortune 500 companies, from law to healthcare to big-box retail. Through his educational books and courses, Walter reaches a growing number of students and corporate organizations, training them to master skills and tools in data management, analysis, and visualization. An expert in data analysis training & solutions, Walter is a published and Best-Selling Author of “SQL Quickstart Guide”. Current partnerships include: • Manning Publishing - New Data Analytics book to be published in 2023 • LinkedIn Learning Course Author - SQL and Data Analytics course to be released in 2023 • Microsoft Learn Partner - Power BI Data Visualization courses With his passion for teaching, Walter continues to create simplified, uncomplex, fun and effective ways for his students to confidently command skills in data analytics.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.