SQL The Practical Guide
ISBN 978-1-4932-2679-5 490 pages, 2025
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2680-1 490 pages, 2025, Print edition paperback
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2681-8
- Master SQL programming for database management and manipulation
- Learn to use the five SQL sublanguages: DDL, DML, TCL, DQL, and DCL
- Define schemas and tables; modify and query data; and configure database authorizations
In this book, you’ll learn about:
-
Relational Database Elements
Understand the fundamentals of relational databases and schemas. Learn the elements of database structures, from tables to views to keys. Then review more 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. See a SQL demo in action in your environment and experiment with code samples.
-
SQL Sublanguages
Use the sublanguages of SQL for your daily tasks. Start by creating and altering database objects. Insert, update, and delete data in tables and then modify multiple tables together. Query data from single or combined tables and limit data access using authorizations.
Highlights include:
-
Databases
-
Schemas
-
Tables
-
Views
-
Keys
-
PostgreSQL
-
Data definition language (DDL)
-
Data manipulation language (DML)
-
Transaction control language (TCL)
-
Data query language (DQL)
-
Data control language (DCL)
-
Entity-relationship diagrams (ERD)
You may also like:
-
Python 3 –
The Comprehensive Guide1036 pages, paperback
Ready to master Python? Learn to write effective code with this award-winning comprehensive guide, whether you’re a beginner or a professional programmer. Review core Python concepts, including functions, modularization, and object orientation, and walk through the available data types. Then … More about the bookfrom $54.99
Available
E-book | Print edition | Bundle -
SAP Business Technology Platform
729 pages, hardcover
Discover SAP’s unified technology platform with this introductory guide! Get started with the building blocks of SAP Business Technology Platform: architecture design, runtime environments, and the development approach. Take a tour of the integrated tools and services for application development, … More about the bookfrom $84.99
Available
E-book | Print edition | Bundle -
Configuring SAP S/4HANA Finance
744 pages, hardcover
Starting a new SAP S/4HANA Finance implementation? Get it right the first time! From setting up an organizational structure to defining master data, this comprehensive guide to configuring SAP S/4HANA Finance walks you through each key task. Follow step-by-step instructions … More about the bookfrom $84.99
Available
E-book | Print edition | Bundle