000 04410cam a2200493 i 4500
001 1409140291
003 OCoLC
005 20250902184000.0
008 231102t20242024njua 001 0 eng d
010 _a2024933440
020 _a9781394242290
020 _a1394242298
035 _a(OCoLC)1409140291
_z(OCoLC)1399406536
035 _a(OCoLC)1409140291
037 _bJohn Wiley & Sons Inc, Customer Care Center / Consumer accounts 10475 Crosspoint Blvd, Indianapolis, IN, USA, 46256
_nSAN 200-2272
040 _aIOU
_beng
_erda
_cIOU
_dBDX
_dOCLCL
_dLIV
_dGRC
_dJQM
_dHRF
_dYDX
_dIMT
_dJQW
_dOCLCQ
_dOJ4
_dMLSOD
_dOCLCO
050 4 _aQA76.73.S67
_bT388 2024
082 0 4 _a005.7565 TAY 2024
_223
092 _a005.7565
_bT2477s
100 1 _aTaylor, Allen G.,
_eauthor
245 1 0 _aSQL all-in-one /
_cby Allen G. Taylor with Richard Blum
246 3 _aSQL all-in-1
246 3 0 _aSQL all-in-one for dummies
250 _a4th edition
264 1 _aHoboken, NJ :
_bJohn Wiley & Sons, Inc.,
_c[2024]
264 4 _c©2024
300 _axxi, 775 pages :
_billustrations ;
_c24 cm
336 _atext
_btxt
_2rdacontent
336 _astill image
_bsti
_2rdacontent
337 _aunmediated
_bn
_2rdamedia
338 _avolume
_bnc
_2rdacarrier
490 1 _a--For dummies
500 _aPrevious edition: 2019
500 _aIncludes index
505 0 _aIntroduction -- 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 _aThe 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 _aSQL (Computer program language)
650 0 _aRelational databases
655 7 _aHandbooks and manuals.
_2lcgft
700 1 _aBlum, Richard,
_d1962-
_eauthor
710 2 _aJohn Wiley & Sons, Ltd.,
_epublisher
830 0 _a--For dummies
942 _2ddc
_cBK
_n0
999 _c605
_d605