Book

Taylor, Allen G., author.

SQL all-in-one / by Allen G. Taylor with Richard Blum.

Fourth edition.

Hoboken, NJ : John Wiley & Sons, Inc., [2024]

©2024

xxi, 775 pages : illustrations (some color) ; 24 cm.

illustration

index index

Your one-stop guide to SQL. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there's no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career.

--For dummies

SQL (Computer program language)

Relational databases.

Handbooks and manuals.

Blum, Richard, 1962- author.

John Wiley & Sons, Ltd., publisher.

SQL all-in-1

SQL all-in-one for dummies

Structured query language all-in-one

Previous edition: 2019.

Includes index.

Getting started with SQL. Understanding relational databases ; Modeling a system ; Getting to know SQL ; SQL and the relational model ; Knowing the major components of SQL ; Drilling down to the SQL nitty-gritty -- Developing relational databases. System development overview ; Building a database model ; Balancing performance and correctness ; Creating a database with SQL -- Writing SQL queries. Values, variables, functions, and expressions ; SELECT statements and modifying clauses ; Querying multiple tables with subqueries ; Querying multiple tables with relational operators ; Cursors -- Securing your data. Protecting against hardware failure and external threats ; Protecting against user errors and conflicts ; Assigning access privileges ; Error handling -- Programming with SQL. Database development environments ; Interfacing SQL to a procedural language ; Using SQL in an application program ; Designing a sample application ; Building an application ; Understanding SQL's procedural capabilities ; Connecting SQL to a remote database -- Working with advanced data types in SQL: XML, JSON, and PGQ. Using XML with SQL ; Storing XML data in SQL tables ; Retrieving data from XML documents ; Using JSON with SQL ; Exploring property graph queries -- Optimizing your database. Tuning the database ; Tuning the environment ; Finding and eliminating performance bottlenecks -- Appendixes. SQL:2023 reserved words ; Glossary.

QA76.73.S67 .T386 2024

9781394242290

1394242298

892400

1

1

1

1

0