SQL: The Complete Guide

Material from three leading experts covers all aspects of SQL. Revised to account for the latest versions of RDBMS, this guide explains how to create, populate, and administer high-performance databases and develop powerful and reliable applications using SQL. This book will teach you how to work with SQL commands and statements, create and configure relational databases, load and modify database objects, execute powerful queries, enhance performance, and build a security system. You will learn how to use DDL statements and apply APIs, integrate XML and Java scripts, use SQL objects, create web servers, work with remote access, and perform distributed transactions. In this book, you will find information such as descriptions of working with in-memory databases, streaming and embedded databases, mobile device databases, and much more.