20% off all books with the code: BOOKS
  • check 10+ million books
  • check New arrivals every day
  • check Trusted by 1M+ customers
  • check Great prices & discounts
  • check Shipping across Europe

SQL: The Practical Guide - Kerem Koseoglu

English
2025-07-04
€65.74 €82.17

-20% with code BOOKS

In stock at our supplier

Shipping in 10-16 days

30-day return policy

Whether you’re managing large datasets or writing your first query, build your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code ... Full description

You May Also Like

Description

Whether you’re managing large datasets or writing your first query, build your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-world applications! 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 authorizationsRelational Database ElementsUnderstand 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 EnvironmentFollow 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 SublanguagesUse 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. 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)

More Information

Author Kerem Koseoglu
Publisher Rheinwerk Verlag GmbH
Release year 2025
Cover type Softcover
EAN 9781493226795
Write Your Own Review
You're reviewing: SQL: The Practical Guide
Your Rating:

Goodreads Reviews

€65.74 €82.17