SQL

• PugSQL
• Window functions in SparkSQL
• Advanced SQL queries in pandas
• SQL window functions
• 5 SQL common queries
• SQL window functions
• Intermediate SQL queries
• 6 lesser known queries
• 10 SQL tips
• Settings for NLS in SQL Developer
• Advanced SQL concepts
• SQL advanced functions: qualify, arrays and more
• SQL CASE
• Python built-in database: SQLite
• Advanced SQL for Data Scientists: cube, array, window and math functions
• Lost at SQL: the SQL learning game
• Window Functions: A Must Know for Data Engineers and Data Scientists
• How to Low-Pass Filter in Google BigQuery
• Harlequin: the SQL IDE for your terminal
• SQLModel: a library for interacting with SQL databases from Python code, with Python objects
• Sampling with SQL
• Outerbase Studio: A lightweight Database GUI in your browser