Название: SQL All-in-One For Dummies, 4th Edition
Автор: Аllеn G. Тауlоr
Издательство: For Dummies
Год: 2024
Страниц: 800
Язык: английский
Формат: epub (true)
Размер: 10.1 MB

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 development

SQL isn’t a general-purpose language, such as C++ or Java. Instead, it’s strictly designed to deal with data in relational databases. With SQL, you can carry out all the following tasks:
• Create a database, including all tables and relationships.
• Fill database tables with data.
• Change the data in database tables.
• Delete data from database tables.
• Retrieve specific information from database tables.
• Grant and revoke access to database tables.
• Protect database tables from corruption due to access conflicts or user mistakes.

SQL (pronounced ess cue el, but you’ll hear some people say see quel) is the international standard language used in conjunction with relational databases — and it just so happens that relational databases are the dominant form of data storage throughout the world. In order to understand why relational databases are the primary repositories for the data of both small and large organizations, you must first understand the various ways in which computer data can be stored and how those storage methods relate to the relational database model. To help you gain that understanding, I spend a good portion of this chapter going back to the earliest days of electronic computers and recapping the history of data storage.

This book isn’t just about SQL; it’s also about how SQL fits into the process of creating and maintaining databases and database applications. In this book, I cover how SQL fits into the larger world of application development and how it handles data coming in from other computers, which may be on the other side of the world or even in interplanetary space.

This 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.

Contents: