Bibliograph

SQL for dummies, by Allen G. Taylor., author of SQL all-in-one for dummies

Type

Label

SQL for dummies, by Allen G. Taylor., author of SQL all-in-one for dummies

Language

eng

Illustrations

illustrations

Index

index present

Literary Form

non fiction

Main title

SQL for dummies

Oclc number

1078688845

Responsibility statement

by Allen G. Taylor., author of SQL all-in-one for dummies

Series statement

For dummies

Summary

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. --, Publisher's description

Table Of Contents

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

Classification