課程資料
課程簡介
Structured Query Language (SQL)
Structured Query Language (SQL) is a must have skill for every data professional. Whether you are a data engineer, a Business Intelligence Professional or a data scientist - you will need Structured Query Language (SQL) in your day to day work.
This course will start from basics of databases and structured query language (SQL) and teach you every thing you would need in any data science profession including Writing and executing efficient Queries, Joining multiple tables and appending and manipulating tables.
Key takeaways from Structured Query Language (SQL) for Data Science course:
Start using MySQL – the most popular Database Management System
Learn how to perform database tasks in SQL
How to insert, update, and delete records from your database
How to create reports and perform basic analysis using SQL’s aggregate functions
How to perform efficient joins to fetch your data from multiple tables
課程章節
- 10 個章節
- 94 堂課
- 第 1 章 Introduction to Databases
- 第 2 章 Installing MySQL/ MariaDB
- 第 3 章 Getting started
- 第 4 章 Modifying Databases structures
- 第 5 章 Importing and Exporting Data
- 第 6 章 Data Analysis
- 第 7 章 Real Life Project - Descriptive Analytics of FIFA 19 Players
- 第 8 章 Getting Data from Multiple Tables
- 第 9 章 Introduction to Indexing
- 第 10 章 MySQL built-in functions
課程內容
- Learn Structured Query Language (SQL) for Data Science applications
- Learn MySQL – the most popular Database Management System
- Understand the basics of databases, primary key, Foreign Key and Indexing
- Learn how to perform database tasks in SQL
- How to insert, update, and delete records from your database?
- How to create reports and perform basic analysis using SQL’s aggregate functions
- Learn how to write efficient SQL Queries and Joins
此課程所涵蓋的技能
評價
-
SShalmali Bhattacharya
Beautiful excellent awesome
-
RRam Sambandan
The course was very useful and covered all topics
-
NNagaraju Gajula
Goodl
-
GGanesh Nagappa Shetty
One of the the worst course on Udemy. very badly managed. No installation procedure shown for windows. Instructer says follow link in the course material and no material supplied. I suggest not to subscribe to this course. Waste of time and Money