Databases & SQL 2

What's inside

Databases & SQL 2: 12 courses, 258 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.

• 12 complete courses, 258 lessons, 180 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 Server T-SQL Foundations: Queries, Functions & Basic DML
• SQL Server T-SQL in Practice: Joins, CTEs, Procedures & Error Handling
• SQL Server T-SQL Mastery: Window Functions, Indexes & Execution Plans
• Microsoft Access Foundations: Tables, Queries, Forms & Reports
• Microsoft Access in Practice: Relationships, Queries, Macros & Reports
• Microsoft Access Mastery: Access SQL, Normalisation & Split Databases
• PostgreSQL Foundations: Tables, Data Types & Queries
• PostgreSQL in Practice: Joins, JSONB, Window Functions & Views
• PostgreSQL Mastery: Indexes, EXPLAIN, Partitioning & Concurrency
• PL/SQL Foundations: Blocks, Variables & Control Flow
• PL/SQL in Practice: Procedures, Functions, Cursors & Packages
• PL/SQL Mastery: Triggers, Dynamic SQL & Performance

Details

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