وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

End-to-End SQL Database Design and Optimization Project

سرفصل های دوره

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.


01 - Introduction
  • 01 - Course overview
  • 02 - Prerequisite knowledge

  • 02 - 1. Introduction to Databases and SQL
  • 01 - What is a database
  • 02 - Introduction to SQL

  • 03 - 2. Introduction to Ecommerce Database Design
  • 01 - Overview of ecommerce databases
  • 02 - Key components of ecommerce databases
  • 03 - Setting up your development environment

  • 04 - 3. Entity Relationship Diagram (ERD)
  • 01 - Understanding entity relationship diagrams
  • 02 - Creating an ERD for an ecommerce database

  • 05 - 4. Database Schema Design
  • 01 - Designing the Products table
  • 02 - Designing the Users table
  • 03 - Designing the Orders table
  • 04 - Designing the Reviews table
  • 05 - Designing the Payments table
  • 06 - Introduction to database normalization
  • 07 - Normalizing the ecommerce database

  • 06 - 5. ETL Processes for Ecommerce Data
  • 01 - Introduction to ETL
  • 02 - Setting up Anaconda Navigator and Jupyter Notebook
  • 03 - Extracting data
  • 04 - Transforming data
  • 05 - Loading data

  • 07 - 6. Data Validation and Integrity
  • 01 - Implementing data validation
  • 02 - Ensuring data integrity

  • 08 - 7. Data Analysis and Reporting
  • 01 - Introduction to data analysis
  • 02 - Writing analytical queries
  • 03 - Generating reports

  • 09 - 8. Query Optimization
  • 01 - Writing efficient SQL queries
  • 02 - Query optimization and indexing

  • 10 - 9. Final Project
  • 01 - Project requirements and planning
  • 02 - Implementing the final project

  • 11 - Conclusion
  • 01 - Final thoughts and next steps
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 43882
    حجم: 384 مگابایت
    مدت زمان: 165 دقیقه
    تاریخ انتشار: ۸ اسفند ۱۴۰۳
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید