 Название: SQL: The Practical Guide to Master Relational Databases, SQL Syntax, and Sublanguages for Effective Database Management
Автор: Kerem Koseoglu
Издательство: Rheinwerk Publishing
Год: 2025
Страниц: 926
Язык: английский
Формат: epub (true)
Размер: 10.8 MB
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 authorizations
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.
Structured Query Language (SQL) is a programming language that’s used to manage, manipulate, and query contents of relational database systems. SQL was one of the first languages to target E.F. Codd’s relational model. Mind you that SQL is not a general-purpose language like Python, Java, or Rust. It’s rather a domain-specific language (DSL) tailored to a specific goal. In our case, the goal of SQL is to manage and query relational databases, nothing more. But since SQL is the de facto standard for that purpose, it’s widely used in conjunction with general-purpose languages. For example, a developer might code the business logic of their app in Python while coding the data manipulation part in SQL.
However, you don’t need to be a programmer to enjoy SQL! Many nonprogrammers simply use a database app or tool to connect to a database and execute handwritten SQL code to achieve the results they want. For instance, business users and data scientists often query databases to extract meaningful data to support their tasks. The declarative nature of SQL makes it approachable by a wide audience.
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.
Скачать SQL: The Practical Guide to Master Relational Databases, SQL Syntax, and Sublanguages for Effective Database Management
|
Навигация
Вход на сайт
Реклама
SQL: The Practical Guide to Master Relational Databases, SQL Syntax, and Sublanguages for Effective Database Management 
