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

Complete Guide to AI and Data Science for SQL Developers From Beginner to Advanced

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

01 - Introduction
  • 01 - Masterclass introduction
  • 02 - What you should know
  • 03 - Using the course exercise files

  • 02 - 1. Introduction to Data Science
  • 01 - Data science explained
  • 02 - Data or information What's the difference
  • 03 - Data's increasing influence
  • 04 - Comparing data roles
  • 05 - Necessary skills for data science
  • 06 - Real-world applications
  • 07 - Challenge Data
  • 08 - Solution Data

  • 03 - 2. AI, ML, and DL
  • 01 - The evolving face of artificial intelligence
  • 02 - Machine learning problem classifications
  • 03 - Machine learning approaches for business scenarios
  • 04 - Challenge AI
  • 05 - Solution AI

  • 04 - 3. Introduction to Stats and Probability
  • 01 - Statistics defined
  • 02 - Statistical mindset
  • 03 - Types of statistics
  • 04 - Descriptive statistics
  • 05 - Inferential statistics (probability)
  • 06 - Python
  • 07 - Challenge Statistics
  • 08 - Solution Statistics

  • 05 - 4. Predicting House Prices with Linear Regression
  • 01 - Project goal
  • 02 - Project steps
  • 03 - Python environment setup
  • 04 - SQL environment setup
  • 05 - Project approach

  • 06 - 5. Data Preparation and Exploration
  • 01 - Importing necessary libraries and dataset overview
  • 02 - Loading the data
  • 03 - Checking the data info
  • 04 - Summary statistics of the dataset
  • 05 - Checking the distribution of the variables
  • 06 - Applying log transformation and re-checking distribution
  • 07 - Challenge Preparation
  • 08 - Solution Preparation

  • 07 - 6. Data Visualization and Exploration
  • 01 - Bivariate analysis Heat-map
  • 02 - Visualizing relationships Age of homes and distance to work
  • 03 - Visualizing relationships Highway access and property tax
  • 04 - Checking correlation after removing outliers
  • 05 - Visualizing relationships Other pairs of variables
  • 06 - Challenge Visualization
  • 07 - Solution Visualization

  • 08 - 7. Data Preprocessing
  • 01 - Splitting the dataset into train and test sets
  • 02 - Checking for multicollinearity using VIF
  • 03 - Removing multicollinearity by dropping the tax feature
  • 04 - Challenge Preprocessing
  • 05 - Solution Preprocessing

  • 09 - 8. Model Building and Evaluation
  • 01 - Creating the linear regression model and model summary Part 1
  • 02 - Creating the linear regression model and model summary Part 2
  • 03 - Creating the linear regression model and model summary Part 3
  • 04 - Dropping insignificant variables and re-creating the model
  • 05 - Checking assumptions for linear regression
  • 06 - Assumption 1 Checking for mean residuals
  • 07 - Assumption 2 Checking homoscedasticity
  • 08 - Assumption 3 Checking linearity
  • 09 - Assumption 4 Checking normality of error terms
  • 10 - Q-Q plot for checking the normality of error terms
  • 11 - Model performance comparison on train and test data
  • 12 - Applying cross-validation and evaluation
  • 13 - Challenge Model building
  • 14 - Solution Model building

  • 10 - 9. Model Interpretation and Reporting
  • 01 - Extracting and creating a DataFrame of coefficients
  • 02 - Writing the linear regression equation and coefficients
  • 03 - Conclusions and business recommendations
  • 04 - Challenge Interpretation
  • 05 - Solution Interpretation

  • 11 - 10. Final Capstone Project
  • 01 - Final capstone project details
  • 02 - Final capstone project solution walkthrough

  • 12 - Conclusion
  • 01 - Next steps
  • 179,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 33428
    حجم: 478 مگابایت
    مدت زمان: 248 دقیقه
    تاریخ انتشار: ۷ فروردین ۱۴۰۳
    طراحی سایت و خدمات سئو

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