Databases & SQL 1

What's inside

Databases & SQL 1: 9 courses, 190 lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation with code examples, then gives you a lab: read the code or data in the worksheet, work out the result yourself, or write the code in your own editor. When you are done, check your answers against the solutions and hints in the appendix.

• 9 complete courses, 190 lessons, 135 exam questions with answers
• Labs with row and column labels – easy to follow
• Tasks with exact solutions and hints in the appendix
• All companies and data are fictional practice material

Every course is also available as an interactive course on code24lab.com.

Courses in this book

• SQL Foundations: SELECT, Filters, Sorting & Aggregates
• SQL in Practice: Joins, Subqueries, CTEs & Set Operations
• SQL Mastery: Window Functions, Indexing & Query Optimisation
• MySQL Foundations: Databases, Tables, Keys & Basic Queries
• MySQL in Practice: Joins, Views, Stored Routines & Triggers
• MySQL Mastery: Performance, Replication Basics & Administration
• Oracle SQL Foundations: Queries, Functions & Single-Row Logic
• Oracle SQL in Practice: Joins, Subqueries, Hierarchies & Analytics
• Oracle SQL Mastery: Tuning, PL/SQL Essentials & Advanced Features

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	634
Series	The Code24Lab Workbook, volume 1
Author	Babala Özdemir
Delivery	Instant download after payment