DataScienceLearn

4

Lessons

1

Videos

All

Skill Level

4 Hours

Duration

English

Language

Set Up & Introduction

In order to get started, make sure you have your environment set up. In order to do this, I recommend referencing these links:

  • You can download Python here.
  • Most Python code written here will be written on a Jupyter Notebook. You can reference this guide on Jupyter’s site for installation. Google Colab works as well.
  • Some important libraries we’ll be using for data preprocessing include pandas, numpy, matplotlib, and seaborn. All of which can be installed following these guidelines.
  • You can download the CSV file we’ll be referencing here.

Completing this course will help you:

Who is the course for?

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent eu orci faucibus orci malesuada semper eget non tellus. Cras sed dignissim purus. Mauris varius neque leo, eu pellentesque justo venenatis et. Sed ultricies risus non turpis tempus, nec consectetur nulla suscipit.

Learning Path

XXXXXXXXXX​

The SELECT command is where we put the attributes we’re hoping to retrieve, the FROM command is used to signify which table we plan on selecting our attributes from, the * means “all”, and a WHERE command is used to provide a condition to determine which specific entries from those columns we hope to retrieve. Here’s an example of one of these queries.

Video 48 Min  + 2 Min read to complete

Ready to get Started?

More Courses

You might also be interested in these courses

Course 2

SQL Queries

Before we dive into writing SQL queries, it's important to understand what SQL and MySQL are. SQL (Structured Query Language) represents the syntax used in manipulating relational databases, whereas MySQL is a RDBMS (Relational Database Management System). In other words, MySQL uses Structured Query Language to manipulate databases.

SQL Queries

View Course & Get Started
View Course

Course 3

Data Exploration

This initial "exploration" will help us choose and create a model later on as well as give us insight into our data.

Data Exploration

View Course & Get Started
View Course