× {{alert.msg}} Never ask again
Receive New Tutorials GET IT FREE

SQL SQL Tutorials

There is no better way to begin your SQL education. Check out these Beginner & Intermediate tutorials and start building your own SQL app!


MongoDB vs RethinkDB: Comparing Oranges with Oranges Rudraksh MK Rudraksh MK  ●  SQL · Rethinkdb · MongoDB · Reql  ●  May 25, 2016
 MongoDB vs RethinkDB: Comparing Oranges with Oranges

This post aims at a very broad overview of the key differences between Mongo and Rethink.

Continue Reading
Beginner's Guide to Getting Started with Sails.js Shahid Shaikh Shahid Shaikh  ●  Node.js · JavaScript · SQL · Sails.js  ●  Dec 24, 2015
Beginner's Guide to Getting Started with Sails.js

Sails.js is a node.js framework that allows you to build enterprise-ready, custom MVC ( model, view, controller ) applications on the go. Here's how to get started with configuring your first Sails.js app.

Continue Reading
Getting Started with SQL: Creating a Table, Inserting Values and Retrieving Data Codementor  ●  SQL  ●  Dec 23, 2015
Getting Started with SQL: Creating a Table, Inserting Values and Retrieving Data

SQL is a powerful query language which is used to access relational databases. Here's a quickstart guide to SQL tables.

Continue Reading
Spark & R: data frame operations with SparkR Jose A Dianes Jose A Dianes  ●  Spark · SQL · R · Data Science  ●  Sep 21, 2015
Spark & R: data frame operations with SparkR

In this third tutorial (see the previous one) we will introduce more advanced concepts about SparkSQL with R that you can find in the SparkR documentation, applied to the 2013 American Community Survey housing data. These concepts are related with data frame manipulation, including data slicing, summary statistics, and aggregations.

Continue Reading
Spark & R: loading data into SparkSQL data frames Jose A Dianes Jose A Dianes  ●  Spark · SQL · R · Data Science  ●  Sep 18, 2015
Spark & R: loading data into SparkSQL data frames

In this second Spark & R tutorial, we will read data into a SparkSQL data frame as well as have a quick look at the schema.

Continue Reading
Spark & Python: SQL & DataFrames Jose A Dianes Jose A Dianes  ●  Spark · Python · SQL · Data Science  ●  Jul 03, 2015
Spark & Python: SQL & DataFrames

Instructions My Spark & Python series of tutorials can be examined individually, although there is a more or less linear ‘story’ when followed in sequence. By using the same dataset they try to solve a related set of tasks with it. It is not the only one but, a good way of following these Spark tutorials is by first cloning the GitHub...

Continue Reading
5 MySQL Queries to Speed up Development Shahid Shaikh Shahid Shaikh  ●  SQL · MySQL · Data  ●  Jun 16, 2015
5 MySQL Queries to Speed up Development

MySQL is one of the most widely used relational database management system. Even though we are in an era where document-oriented systems like MongoDB and other Big Data programs seem to be all the rage, but MySQL is still the choice of various popular websites such as Facebook, Quora, etc.

Continue Reading
A SQLAlchemy Cheat Sheet Sheena Sheena  ●  Python · Sqlalchemy · SQL  ●  Mar 18, 2015
A SQLAlchemy Cheat Sheet

##Introduction SQLAlchemy is a deep and powerful thing made up of many layers. This cheat sheet sticks to parts of the ORM (Object Relational Mapper) layer,and aims to be a reference not a tutorial. That said, if you are familiar with SQL then this cheat sheet should get you well on your way to understanding SQLAlchemy. Basic Models One...

Continue Reading