Sql Tutorials

Every sql tutorial on PySpark.in, grouped by topic. Each article covers one subject in depth with runnable examples you can try in the free browser compiler.

Aggregations and Grouping

• Aggregations
• Group By
• SQL Wildcards

Introduction

• Introduction to Databases

Introduction to Database

• Introduction to Databases

Introduction to SQL

• Creating Tables
• Inserting Rows
• Retrieving Data
• Update Rows
• Delete Rows
• Alter Tables
• Alter Tables

Modeling Databases

• Core Concepts of ER Model
• Creating a Relational Database

Querying with SQL

• Comparison Operators
• String Operations
• Logical Operators
• IN and BETWEEN Operators
• ORDER BY and DISTINCT

SQL Functions

• SQL Expressions
• SQL Functions

SQL Joins

• Natural Join
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN
• CROSS JOIN
• SELF JOIN
• Joins on Multiple Tables

Window Functions

• Window Functions

Run the examples in the free PySpark compiler · Practice challenges · Short answer guides