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
Course content
6 sections * 45 lectures * 4h 4m total length
Requirements
Basic knowledge of SQL helpful but not mandatory
Basic knowledge of relational database management systems helpful but not mandatory.
Description
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