Using SQL for Data Science | Udemy

Using SQL for Data Science | Udemy
English | Size: 1.79 GB
Genre: eLearning

What you’ll learn
Install Oracle Database
Install TOAD
Install Oracle SQL developer
Connect to oracle database
Generate ERD
Query data from single and multiple columns
Count records
Filter records
Remove duplicate records
Sort records
Group records
Filter records with various operators
Extract records from multiple tables

The role of a data scientist is to turn raw data into actionable insights. Much of the world’s raw data—from electronic medical records to customer e-commerce transaction histories—lives in organized collections of tables called relational databases. Therefore, to be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL (pronounced ess-que-ell, or sequel).

As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimise their businesses. This is where the data scientist comes in. According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems.

This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you have little or no knowledge or skills in SQL.

What you will learn includes:

Downloading and installing Oracle Database
Downloading and installing TOAD
Download and installing SQL Developer
Connecting to Oracle database
Querying data from single and multiple columns
Removing duplicate records from query output
Filtering records with WHERE clause
Using various operators with the WHERE clause
Limiting data
Using aggregate functions
Sorting and Grouping data
Extracting data from multiple tables

Who this course is for:
Beginner Data Scientist
Beginner Data Analyst
Beginner Database Administrator

If any links die or problem unrar, send request to

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.

Speak Your Mind

This site uses Akismet to reduce spam. Learn how your comment data is processed.