SQL for dummies / (Record no. 583)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 03568cam a2200409 i 4500 |
| 001 - CONTROL NUMBER | |
| control field | 20699654 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20220607085213.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 181009s2019 njua 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2018960776 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119527077 |
| Qualifying information | paperback |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | DLC |
| Language of cataloging | eng |
| Description conventions | rda |
| Transcribing agency | DLC |
| Modifying agency | EG-CaTKH |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | pcc |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.73.S67 |
| Item number | T39 2019 |
| 082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.7585 TA.S 2019 |
| Edition number | 23 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Taylor, Allen G., |
| Relator term | author. |
| 245 10 - TITLE STATEMENT | |
| Title | SQL for dummies / |
| Statement of responsibility, etc. | Allen G Taylor. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | Ninth edition. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Hoboken, New Jersey : |
| Name of producer, publisher, distributor, manufacturer | John Wiley & Sons, Inc., |
| Date of production, publication, distribution, manufacture, or copyright notice | 2019. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xv, 494 pages : |
| Other physical details | illustrations ; |
| Dimensions | 24 cm. |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| 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 0# - SERIES STATEMENT | |
| Series statement | For dummies |
| 500 ## - GENERAL NOTE | |
| General note | Includes index. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Getting started with SQL. Relational database fundamentals ; SQL fundamentals ; The components of SQL -- Using SQL to build databases. Building and maintaining a simple database structure ; Building a multi-table relational database -- Storing and retrieving data. Manipulating database data ; Handling temporal data ; Specifying valuse ; Using advanced SQL value expressions ; Zeroing in on the data you want ; Using relational operators ; Delving deep with nested queries ; Recursive queries -- Controlling operations. Providing database security ; Protecting data ; Using SQL within applications -- Taking SQL to the real world. Accessing data with ODBC and JDBC ; Operating on SML data with SQL ; SQL and JSON -- Advanced topics. Stepping through a dataset with cursors ; Adding procedural capabilities with persistent stored modules ; Handling errors ; Triggers -- The part of tens. Ten common mistakes ; Ten retrieval tips -- Appendix: ISO/IEC SQL: 2016 reserved words. |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | Get ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more. SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages ;and this book shows you how to harness the core element of relational databases with ease. Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems. Find great examples on the use of temporal dataJump right without previous knowledge of database programming or SQLAs database-driven websites continue to grow in popularity complexity SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly. |
| 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 | Database management. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Relational databases. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Computer programming. |
| 856 41 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/coventry/detail.action?docID=479919&query=sql">https://ebookcentral.proquest.com/lib/coventry/detail.action?docID=479919&query=sql</a> |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Source of classification or shelving scheme | Dewey Decimal Classification |
| Koha item type | Books |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| Cataloger's name | huda.mahmoud |
| Cataloging process | M |
| First Date, FD (RLIN) | 2022023 |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| Cataloger's name | mona.romia |
| Cataloging process | R |
| First Date, FD (RLIN) | 20220203 |
| 906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) | |
| a | 7 |
| b | cbc |
| c | orignew |
| d | 2 |
| e | epcn |
| f | 20 |
| g | y-gencatlg |
| Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Collection code | Home library | Current library | Date acquired | Cost, normal purchase price | Total Checkouts | Full call number | Barcode | Date last seen | Cost, replacement price | Price effective from | Koha item type | Date last checked out | Total Renewals |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 12/27/2020 | 472.26 | 005.7585 TA.S 2019 | 191026 | 12/27/2020 | 472.26 | 12/27/2020 | Books | |||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 12/27/2020 | 472.26 | 005.7585 TA.S 2019 | 191027 | 12/27/2020 | 472.26 | 12/27/2020 | Books | ||||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 12/27/2020 | 472.26 | 005.7585 TA.S 2019 | 191028 | 12/27/2020 | 472.26 | 12/27/2020 | Books | |||||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 12/27/2020 | 472.26 | 1 | 005.7585 TA.S 2019 | 191029 | 03/14/2022 | 472.26 | 12/27/2020 | Books | 02/13/2022 | |||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 12/27/2020 | 472.26 | 005.7585 TA.S 2019 | 191030 | 12/27/2020 | 472.26 | 12/27/2020 | Books | |||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192167 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192168 | 08/09/2021 | 472.26 | 08/09/2021 | Books | |||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192169 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192170 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192171 | 08/09/2021 | 472.26 | 08/09/2021 | Books | |||||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 1 | 005.7585 TA.S 2019 | 192172 | 03/10/2024 | 472.26 | 08/09/2021 | Books | 02/20/2024 | 1 | ||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192173 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192174 | 08/09/2021 | 472.26 | 08/09/2021 | Books | |||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192175 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192176 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192177 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 1 | 005.7585 TA.S 2019 | 192178 | 01/16/2022 | 472.26 | 08/09/2021 | Books | 11/23/2021 | ||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 1 | 005.7585 TA.S 2019 | 192179 | 05/31/2022 | 472.26 | 08/09/2021 | Books | 01/30/2022 | ||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192180 | 08/09/2021 | 472.26 | 08/09/2021 | Books | |||||||
| Withdrawn | Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192181 | 08/09/2021 | 472.26 | 08/09/2021 | Books | ||||||
| Dewey Decimal Classification | Computing | The Knowledge Hub Library | The Knowledge Hub Library | 08/09/2021 | 472.26 | 005.7585 TA.S 2019 | 192182 | 08/09/2021 | 472.26 | 08/09/2021 | Books |
