SQL For Dummies

Name: SQL For Dummies
Author: Allen Taylor

Paperback Engels 2019 9e druk 9781119527077

Verwachte levertijd ongeveer 8 werkdagen

37,57

In winkelwagen

Samenvatting

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.

Specificaties

ISBN13:9781119527077

Trefwoorden:Programmeren, SQL, SQL (Standard Query Language), Database programming

Taal:Engels

Bindwijze:paperback

Aantal pagina's:512

Uitgever:John Wiley & Sons

Druk:9

Verschijningsdatum:18-1-2019

Hoofdrubriek:IT-management / ICT

Serie:Dummies (Engelstalig)

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw cijfer

?

Log in om te stemmen

Inhoudsopgave

U kunt van deze inhoudsopgave een PDF downloaden

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