YoVDO

Awesome SQL – Tips and Tricks for Application Developers

Offered By: Devoxx via YouTube

Tags

Devoxx Courses SQL Courses Application Development Courses JSON Courses Database Optimization Courses Common Table Expressions Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover advanced SQL techniques and modern features in this 46-minute Devoxx conference talk. Explore the evolution of SQL beyond SQL-92, learning powerful constructs like window functions, Common Table Expressions (CTEs), recursive queries, pivoting, lateral joins, JSON integration, upsert operations, queue job processing with SKIP LOCKED, and efficient pagination methods. Gain insights into the latest trends in database technology, including NewSQL systems that combine SQL flexibility with ACID guarantees. Master these cutting-edge SQL tricks to impress DBAs, optimize query performance, and enhance your application development skills. Dive into practical examples and real-world applications of these advanced SQL features, equipping yourself with the knowledge to leverage the full potential of modern relational database systems.

Syllabus

Introduction
Trends in technology
Stack Overflow
SQL
History of SQL
History of Database
Why use SQL
Top database systems
What does SQL mean
SQL is a standard
SQL 92
Example
Pagination
Derived Tables
SQL Gadgets
SQL Standard
Common Table Expressions
Recursive Table Expressions
Recursive Common Tables
Calculate Total Cost
Aggregation
Recursive
Noncore members
Query structure
Root ID
Window Functions
How does it work
Streams
Ranking
Limit order
March
Dis constraint violation
Merge
SQL 2006
SQL 2011
MySQL
transform
virtual table
new SQL databases
cockroach GDB
volDB
BigQuery
Google Spanner
Questions


Taught by

Devoxx

Related Courses

Accelerating Analytical Queries using the AlloyDB Columnar Engine
Google via Google Cloud Skills Boost
نمذجة البيانات المتقدمة
Meta via Coursera
Modelado de datos avanzado
Meta via Coursera
Advanced Monitoring and Optimizing with DynamoDB (Portuguese)
Amazon Web Services via AWS Skill Builder
Advanced Monitoring and Optimizing with DynamoDB (Spanish)
Amazon Web Services via AWS Skill Builder