آموزش MySQL برای تحلیل داده‌ها و هوش تجاری (BI) - آخرین آپدیت

Fundamentals of Database Management with MySQL Fundamentals of Database Management with MySQL

• Course Introduction: Fundamentals of Database Management with MySQL Course Introduction: Fundamentals of Database Management with MySQL

• Overview of MySQL Overview of MySQL

• Quick Installation and Setup Quick Installation and Setup

• Installation and Setup Installation and Setup

• Basic SQL Queries Basic SQL Queries

• SQL Queries SQL Queries

• Queries (SELECT, WHERE) Queries (SELECT, WHERE)

• Querying with (SELECT, WHERE) Querying with (SELECT, WHERE)

• Retrieving Data Retrieving Data

• Data with Advanced Queries Data with Advanced Queries

• Filtering and Sorting Data Filtering and Sorting Data

• Limiting Results Limiting Results

• Understanding Joins Understanding Joins

• Inner and Outer Joins Inner and Outer Joins

• Leveraging Relationships in Analytics Leveraging Relationships in Analytics

• Brief Overview of BI Brief Overview of BI

• MySQL Role in BI MySQL Role in BI

• Indexing in MySQL Indexing in MySQL

• Connecting to BI Tools Connecting to BI Tools

• BI Tools to MySQL BI Tools to MySQL

• Quick Setup of BI Tool (e.g. Power BI) Quick Setup of BI Tool (e.g. Power BI)

• Importing and Visualizing MySQL Data Importing and Visualizing MySQL Data

• Basic Dashboard Creation Basic Dashboard Creation

• Quick Tips for Query Optimization Quick Tips for Query Optimization

• Indexing for Speed Indexing for Speed

• Brief on MySQL Security Brief on MySQL Security

• Course Completion Course Completion