Using SQL for Data Science

Using SQL for Data Science, available at $19.99, has an average rating of 4.5, with 45 lectures, based on 24 reviews, and has 1281 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner Data Scientist or Beginner Data Analyst or Beginner Database Administrator It is particularly useful for Beginner Data Scientist or Beginner Data Analyst or Beginner Database Administrator.

Enroll now: Using SQL for Data Science

Summary

Title: Using SQL for Data Science

Price: $19.99

Average Rating: 4.5

Number of Lectures: 45

Number of Published Lectures: 45

Number of Curriculum Items: 45

Number of Published Curriculum Objects: 45

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Beginner Data Scientist

Beginner Data Analyst

Beginner Database Administrator

Target Audiences

Beginner Data Scientist

Beginner Data Analyst

Beginner Database Administrator

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

Course Curriculum

Chapter 1: Database Setup

Lecture 1: Introduction

Lecture 2: What is Data Science

Lecture 3: Database Concepts

Lecture 4: Tools of the trade

Lecture 5: Download and Install Oracle

Lecture 6: Unlock sample schema

Lecture 7: Download and Install TOAD

Lecture 8: Connect TOAD to Oracle

Lecture 9: Download and Install SQL Developer

Lecture 10: Connect SQL developer to Oracle

Lecture 11: Introduction to ERD

Lecture 12: Generating ERD In SQL developer

Lecture 13: Generating ERD In TOAD

Chapter 2: Querying Data by Selecting Columns

Lecture 1: Selecting single columns

Lecture 2: Selecting Multiple Columns

Lecture 3: Removing duplicate records

Lecture 4: Counting Records

Chapter 3: Filtering Rows

Lecture 1: Filtering records with WHERE clause

Lecture 2: Limiting records returned from a query

Lecture 3: Operators used with WHERE clause -Part 1

Lecture 4: Operators used with WHERE clause -Part 2

Lecture 5: Filtering with IN operator

Lecture 6: Using ALL operator

Lecture 7: Using ANY operator

Lecture 8: Using NOT operator

Lecture 9: Using IS NULL operator

Lecture 10: Using LIKE operator

Chapter 4: Aggregate Functions

Lecture 1: Introduction to aggregate functions

Lecture 2: MAX

Lecture 3: MIN

Lecture 4: COUNT

Lecture 5: SUM

Lecture 6: AVG

Lecture 7: Aliases

Chapter 5: Sorting Data

Lecture 1: Using ORDER BY

Lecture 2: Using GROUP BY and HAVING clause

Chapter 6: Extracting data from multiple tables

Lecture 1: Introduction to Table Joins

Lecture 2: Keyword used in join operations

Lecture 3: Creating Equi Join

Lecture 4: Creating Non-Equi Join

Lecture 5: Creating Natural Join

Lecture 6: Creating Self Join

Lecture 7: Creating Cartesian Join

Lecture 8: Creating Outer Join

Lecture 9: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 4 votes

4 stars: 7 votes

5 stars: 12 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!