MARC details
| 000 -LEADER |
|---|
| fixed length control field |
04410cam a2200493 i 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
1409140291 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
OCoLC |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20250902184000.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
231102t20242024njua 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
|---|
| LC control number |
2024933440 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781394242290 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
1394242298 |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)1409140291 |
| Canceled/invalid control number |
(OCoLC)1399406536 |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)1409140291 |
| 037 ## - SOURCE OF ACQUISITION |
|---|
| Source of stock number/acquisition |
John Wiley & Sons Inc, Customer Care Center / Consumer accounts 10475 Crosspoint Blvd, Indianapolis, IN, USA, 46256 |
| Note |
SAN 200-2272 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
IOU |
| Language of cataloging |
eng |
| Description conventions |
rda |
| Transcribing agency |
IOU |
| Modifying agency |
BDX |
| -- |
OCLCL |
| -- |
LIV |
| -- |
GRC |
| -- |
JQM |
| -- |
HRF |
| -- |
YDX |
| -- |
IMT |
| -- |
JQW |
| -- |
OCLCQ |
| -- |
OJ4 |
| -- |
MLSOD |
| -- |
OCLCO |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
QA76.73.S67 |
| Item number |
T388 2024 |
| 082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
005.7565 TAY 2024 |
| Edition number |
23 |
| 092 ## - LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC) |
|---|
| Classification number |
005.7565 |
| Item number |
T2477s |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Taylor, Allen G., |
| Relator term |
author |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
SQL all-in-one / |
| Statement of responsibility, etc. |
by Allen G. Taylor with Richard Blum |
| 246 3# - VARYING FORM OF TITLE |
|---|
| Title proper/short title |
SQL all-in-1 |
| 246 30 - VARYING FORM OF TITLE |
|---|
| Title proper/short title |
SQL all-in-one for dummies |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
4th edition |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Place of production, publication, distribution, manufacture |
Hoboken, NJ : |
| Name of producer, publisher, distributor, manufacturer |
John Wiley & Sons, Inc., |
| Date of production, publication, distribution, manufacture, or copyright notice |
[2024] |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Date of production, publication, distribution, manufacture, or copyright notice |
©2024 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxi, 775 pages : |
| Other physical details |
illustrations ; |
| Dimensions |
24 cm |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
text |
| Content type code |
txt |
| Source |
rdacontent |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
still image |
| Content type code |
sti |
| Source |
rdacontent |
| 337 ## - MEDIA TYPE |
|---|
| Media type term |
unmediated |
| Media type code |
n |
| Source |
rdamedia |
| 338 ## - CARRIER TYPE |
|---|
| Carrier type term |
volume |
| Carrier type code |
nc |
| Source |
rdacarrier |
| 490 1# - SERIES STATEMENT |
|---|
| Series statement |
--For dummies |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Previous edition: 2019 |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index |
| 505 0# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
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 ## - SUMMARY, ETC. |
|---|
| Summary, etc. |
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 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
SQL (Computer program language) |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Relational databases |
| 655 #7 - INDEX TERM--GENRE/FORM |
|---|
| Genre/form data or focus term |
Handbooks and manuals. |
| Source of term |
lcgft |
| 700 1# - ADDED ENTRY--PERSONAL NAME |
|---|
| Personal name |
Blum, Richard, |
| Dates associated with a name |
1962- |
| Relator term |
author |
| 710 2# - ADDED ENTRY--CORPORATE NAME |
|---|
| Corporate name or jurisdiction name as entry element |
John Wiley & Sons, Ltd., |
| Relator term |
publisher |
| 830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
--For dummies |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
Dewey Decimal Classification |
| Koha item type |
Book |
| Suppress in OPAC |
No |
