Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 40 Minute(s)
Language
English
Taught by
Analytics Vidhya
Rating
Course Overview
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
Course Content
- 10 section(s)
- 94 lecture(s)
- Section 1 Introduction to Databases
- Section 2 Installing MySQL/ MariaDB
- Section 3 Getting started
- Section 4 Modifying Databases structures
- Section 5 Importing and Exporting Data
- Section 6 Data Analysis
- Section 7 Real Life Project - Descriptive Analytics of FIFA 19 Players
- Section 8 Getting Data from Multiple Tables
- Section 9 Introduction to Indexing
- Section 10 MySQL built-in functions
What You’ll Learn
- 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
Skills covered in this course
Reviews
-
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
