Think in SQL: A Standards-First Guide with PostgreSQL Context
All categories
test
Alle Lehrmaterialien wurden mit LiaScript erstellt und sind im interaktiven Modus veranstaltungsweise über die untenstehenden Links erreichbar.
Unit 1: Foundations of Relational Databases
Test
Test
Unit 2: Writing Basic SQL Queries
Test
Test
Unit 3: Working with NULL and Aggregates
Test
Test
Unit 4: Joining Tables
Test
Test
Unit 5: Using Subqueries
Test
Test
Unit 6: Modifying Data
Test
Test
Unit 7: Creating Tables and Structuring Data
Test
Test
Unit 8: Enforcing Data Integrity
Test
Test
Unit 9: Creating and Using Views
Test
Test
Unit 10: Enhancing Performance with Indexes and Execution Plans
Test
Test
Unit 11: Recursive Queries and Query Structure
Test
Test
Unit 12: Summarizing and Presenting Data
Test
Test
Unit 13: Privileges and the Data Control Language (DCL)
Test
Test
Unit 14: Functions and Triggers
Test
Test
Unit 15: PostgreSQL and JSON
Test
Test
Unit 16: PostgreSQL and XML
Test
Test