SQL For Dummies 9e by Taylor, Allen G. [Paperback]

Description: 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 data * Jump right in--without previous knowledge of database programming or SQL As database-driven websites continue to grow in popularity--and complexity--SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly. Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 40 books, including SQL For Dummies and Crystal Reports For Dummies. He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development internationally through a leading online education provider. Introduction 1 Part 1: Getting Started with SQL 5 Chapter 1: Relational Database Fundamentals 7 Chapter 2: SQL Fundamentals 23 Chapter 3: The Components of SQL 55 Part 2: Using SQL to Build Databases 83 Chapter 4: Building and Maintaining a Simple Database Structure 85 Chapter 5: Building a Multi-table Relational Database 109 Part 3: Storing and Retrieving Data 141 Chapter 6: Manipulating Database Data 143 Chapter 7: Handling Temporal Data 163 Chapter 8: Specifying Values 179 Chapter 9: Using Advanced SQL Value Expressions 209 Chapter 10: Zeroing In on the Data You Want 223 Chapter 11: Using Relational Operators 259 Chapter 12: Delving Deep with Nested Queries 283 Chapter 13: Recursive Queries 303 Part 4: Controlling Operations 313 Chapter 14: Providing Database Security 315 Chapter 15: Protecting Data 331 Chapter 16: Using SQL within Applications 351 Part 5: Taking SQL to the Real World 365 Chapter 17: Accessing Data with ODBC and JDBC 367 Chapter 18: Operating on XML Data with SQL 377 Chapter 19: SQL and JSON 399 Part 6: Advanced Topics 413 Chapter 20: Stepping through a Dataset with Cursors 415 Chapter 21: Adding Procedural Capabilities with Persistent Stored Modules 427 Chapter 22: Handling Errors 445 Chapter 23: Triggers 457 Part 7: The Parts of Tens 463 Chapter 24: Ten Common Mistakes 465 Chapter 25: Ten Retrieval Tips 469 Appendix: ISO/IEC SQL: 2016 Reserved Words 473 Index 479

Price: 28.66 USD

Location: East Hanover, New Jersey

End Time: 2024-12-03T08:20:09.000Z

Shipping Cost: 0 USD