Your hands-on guide to programming databases with SQL!, Ready to boost your SQL skills? Start with an overview of SQL's syntax, features, and applications. Then dive into the five SQL sublanguages and apply them for tasks such as modifying tables and querying data. See SQL in action by working with an example PostgreSQL database and code samples from real-world applications! Relational Database Elements, Learn the elements of database structures, from tables to views to keys. Review advanced concepts like normalization, stored procedures, triggers, and authorization. Setting Up Your Environment, Follow click-by-click instructions to install and set up a local PostgreSQL database and a pgAdmin or Visual Studio Code IDE. Explore a SQL demo in your environment and experiment with code samples. SQL Sublanguages, Use SQL sublanguages for your daily tasks, from creation to querying. Insert, update, and delete data in tables and then modify multiple tables together.

Learn to query data from single or combined tables and to limit data access using authorizations. Highlights include, Schemas, Tables, Views, Keys, PostgreSQL, Data definition language, Data manipulation language, Transaction control language, Data query language, Data control language.