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

Previous edition: 2019

Includes index

Introduction -- Book 1: 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 -- Book 2: Developing relational databases. System development overview ; Building a database model ; Balancing performance and correctness ; Creating a database with SQL -- Book 3: 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 -- Book 4: Securing your data. Protecting against hardware failure and external threats ; Protecting against user errors and conflicts ; Assigning access privileges ; Error handling -- Book 5: 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 -- Book 6: 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 -- Book 7: Optimizing your database. Tuning the database ; Tuning the environment ; Finding and eliminating performance bottlenecks -- Book 8: Appendixes. SQL:2023 reserved words ; Glossary

The most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. 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. Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts Read clear explanations of SQL code and learn to write complex queries Discover how to apply SQL in real-world situations to gain control over large datasets Enjoy a thorough reference to common tasks and issues in SQL developmentThis Dummies All-in-One guide is for all SQL users--from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey