Tag: SQL

Databases (Stanford University)


This Database course from Stanford University consists of a set of “mini-courses” that are “based around video lectures and/or video demos. Many of them include in-video quizzes to check understanding, in-depth standalone quizzes, and/or a variety of automatically-checked interactive programming exercises. Each mini-course also includes a discussion forum and pointers to readings and resources.” The courses are organized into suggested pathways, as follows: Practical Relational Databases and SQL Practical Relational Databases and SQL … Continue Reading

Codecademy – Learn SQL


From Codecademy: “In this course, you’ll learn how to communicate with relational databases through SQL. You’ll learn–and practice with 4 projects–how to manipulate data and build queries that communicate with more than one table. Why learn SQL? We live in a data-driven world: people search through data to find insights and inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, … Continue Reading

The Complete SQL Bootcamp


From Udemy: “You’ll learn how to read and write complex queries to a database using one of the most in demand skills – PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more. Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In … Continue Reading

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.