Tag: SQL

DataCamp – Introduction to Databases in Python

/

From DataCamp: “In this Python SQL course, you’ll learn the basics of using Structured Query Language (SQL) with Python. This will be useful since whether you like it or not, databases are ubiquitous and, as a data scientist, you’ll need to interact with them constantly. The Python SQL toolkit SQLAlchemy provides an accessible and intuitive way to query, build & write to SQLite, MySQL and Postgresql databases (among many others), all … Continue Reading

DataQuest – Working with Large Datasets

/

This is step 9 of 11 in the DataQuest Data Scientist Path. “Learn topics like Map-Reduce and Spark to process large datasets.” The curriculum for this step includes: Introduction to Spark Spark Installation and Jupyter Notebook Integration Transformations and Actions Spark DataFrames Spark SQL

DataQuest – Working with Data Sources

/

This course is step 4 of 6 in the DataQuest Data Analyst Path step 4 of 11 in the DataQuest Data Scientist Path. “Learn about working with data in different locations, including databases and on the web.” The curriculum for this step includes the following: APIs and Web Scraping: Working with APIs Intermediate APIs Web Scraping SQL and Databases: Beginner Introduction to SQL Logical Operators and Ordering Querying SQLite from Python … Continue Reading

Metis Data Science Bootcamp

/

Learn Data Science in 12 weeks with 100% in-person instruction from expert data scientists.

Data Science For Dummies

/

From uncovering rich data sources, to managing large amounts of data within hardware and software limitations, and beyond, you’ll develop the know-how you need to effectively interpret data and tell a story that can be understood by anyone in your organization.

What Every Data Scientist Needs to Know about SQL

/

In this series of posts, I will provide a broad overview of the key SQL topics required to successfully work with databases to do effective data science.

Introduction to SQL for Data Scientists

/

PDF document explaining basic SQL commands like joins, aggregate functions, and subqueries.

Data Science from Scratch: First Principles with Python

/

In this book, you’ll learn how many of the most fundamental data science tools and algorithms work by implementing them from scratch.

The Data Incubator Bootcamp/Fellowship

/

The Data Incubator is an intensive 7 week fellowship that prepares the best scientists and engineers with advanced degrees to work as data scientists and quants.

Becoming a Data Scientist

/

A blog documenting Renee’s path from “SQL Data Analyst pursuing an Engineering Master’s Degree” to “Data Scientist”