SQL all-in-one
SQL all-in-one
Book - 2024
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.
Сохранить в:
Holdings -
Central
| Barcode | Status | Material Type | CallNumber |
|---|---|---|---|
| 37413322156714 | Доступно | Non-fiction | 005.7565 TAYLOR |
| Главные авторы: | , |
|---|---|
| Формат: | |
| Язык: | English |
| Опубликовано: |
Hoboken, NJ :
John Wiley & Sons, Inc.,
[2024]
|
| Редактирование: | 4th edition. |
| Серии: | --For dummies.
|
| Предметы: |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | 953516 | ||
| 008 | 231102t20242024njua 001 0 eng d | ||
| 005 | 20240529202050.8 | ||
| 010 | |a 2024933440 | ||
| 035 | |a (OCoLC)523241 | ||
| 040 | |a IOU |b eng |e rda |c IOU |d BDX |d OCLCL |d LIV |d GRC |d JQM |d HRF |d YDX |d IMT |d JQW |d OCLCQ |d OJ4 |d MLSOD |d OCLCO | ||
| 019 | |a 1399406536 | ||
| 020 | |a 9781394242290 | ||
| 020 | |a 1394242298 | ||
| 035 | |a (OCoLC)1409140291 |z (OCoLC)1399406536 | ||
| 037 | |b John Wiley & Sons Inc, Customer Care Center / Consumer accounts 10475 Crosspoint Blvd, Indianapolis, IN, USA, 46256 |n SAN 200-2272 | ||
| 082 | 0 | 4 | |a 005.7565 |2 23 |
| 092 | |a 005.7565 TAYLOR | ||
| 049 | |a UAGA | ||
| 100 | 1 | |a Taylor, Allen G., |e author. |0 http://id.loc.gov/authorities/names/n86134183 | |
| 245 | 1 | 0 | |a SQL all-in-one / |c by Allen G. Taylor with Richard Blum. |
| 246 | 3 | |a SQL all-in-1 | |
| 246 | 3 | 0 | |a SQL all-in-one for dummies |
| 250 | |a 4th edition. | ||
| 264 | 1 | |a Hoboken, NJ : |b John Wiley & Sons, Inc., |c [2024] | |
| 264 | 4 | |c Ã2024 | |
| 300 | |a xxi, 775 pages : |b illustrations ; |c 24 cm. | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 336 | |a still image |b sti |2 rdacontent | ||
| 337 | |a unmediated |b n |2 rdamedia | ||
| 338 | |a volume |b nc |2 rdacarrier | ||
| 490 | 1 | |a --For dummies | |
| 500 | |a Previous edition: 2019. | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a 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. | |
| 520 | |a 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. | ||
| 650 | 0 | |a SQL (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh86006628 | |
| 650 | 0 | |a Relational databases. |0 http://id.loc.gov/authorities/subjects/sh86007768 | |
| 655 | 7 | |a Handbooks and manuals. |2 lcgft |0 http://id.loc.gov/authorities/genreForms/gf2014026109 | |
| 700 | 1 | |a Blum, Richard, |d 1962- |e author. |0 http://id.loc.gov/authorities/names/nb2002065697 | |
| 710 | 2 | |a John Wiley & Sons, Ltd., |e publisher. |0 http://id.loc.gov/authorities/names/no2013019429 | |
| 758 | |i has work: |a SQL all-in-one for dummies (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGmvVJMYM3t4yjKwVWpxCP |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 830 | 0 | |a --For dummies. |0 http://id.loc.gov/authorities/names/n92122684 | |
| 938 | |a Brodart |b BROD |n 135331595 | ||
| 938 | |a YBP Library Services |b YANK |n 20501700 | ||
| 994 | |a C0 |b UAG | ||
| 999 | f | f | |i 9aa1dc80-f03a-437f-9c5e-f4351d484d97 |s 5a44b59e-a225-4796-b1d3-e7aa574a7778 |t 0 |
| 952 | f | f | |p Standard Circulation |a City of Spokane |b Spokane Public Library |c Branches |d Central |t 0 |e 005.7565 TAYLOR |i Non-fiction |m 37413322156714 |