Tag: SQL

Intro to SQL: Querying and managing data


From Khan Academy: “Learn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.” The course includes the following steps: SQL basics – “We’ll show you the basics of creating tables and selecting data in various different ways.” More advanced SQL queries – “Learn how … Continue Reading

Advanced SQL for Data Scientists


From LinkedIn: “There is an increased need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common data science tasks, including finding, exploration, and extraction within relational databases. The course begins with a brief … Continue Reading

Intro to Relational Databases


From Udacity: “This course is a quick, fun introduction to using a relational database from your code, using examples in Python. You’ll learn the basics of SQL (the Structured Query Language) and database design, as well as the Python API for connecting Python code to a database. You’ll also learn a bit about protecting your database-backed web apps from common security problems. After taking this course, you’ll be able to … Continue Reading

The SuperDataScience Podcast


From iTunes: “The goal of the Super Data Science podcast is to bring you he most inspiring Data Scientists and Analysts from around the World to help you build your successful career in Data Science. Data is growing exponentially and so are salaries of those who work in analytics. This podcast can help you learn how to skyrocket your analytics career. Big data, visualization, predictive modeling, forecasting, analysis, business processes, … Continue Reading

Mode Analytics SQL Tutorial


“This tutorial is designed for people who want to answer questions with data. For many, SQL is the ‘meat and potatoes’ of data analysis—it’s used for accessing, cleaning, and analyzing data that’s stored in databases. It’s very easy to learn, yet it’s employed by the world’s largest companies to solve incredibly challenging problems.” The tutorial is conducted in Mode, “an analytics platform that brings together a SQL editor, Python notebook, … Continue Reading

Chris Albon’s blog

/ /

“Notes on Data Science, Machine Learning, & Artificial Intelligence” Chris Albon is a data scientist “with a Ph.D. in quantitative political science and a decade of experience working in statistical learning, artificial intelligence, and software engineering.” Since starting the site as a home for his “personal notes on statistics, data science and programming,” the site “has grown and today is visited by thousands everyday looking for information on everything from … Continue Reading

DataQuest Data Science Blog


Written by the makers of Dataquest.io, a data science tutorial site, the blog covers topics across data science from those curious about the field to specific tips for advanced users. Posts include: tips and tutorials for using Python, R, SQL, Kaggle, cheat sheets, definitions of data science terms, links to resources, data science success stories, and general advice on entering the data science field.

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