The Complete Idiots Guide to SQL

Make database management a breeze! Databases are use everywhere these days, gathering and editing all types of data, from store inventories to employee records to website user stats. But how do you input, organize, and sort all that data and still make sense of it all? That's where SQL (Structured Query Language) comes in. The next best thing to a personal SQL instructor, this helpful guide gives your practical information you can apply to your specific relational database management system (DBMS). In it, you get- An inside look at tables, rows, columns, and other database concepts and how to manage them using SQL. Tips for putting SQL to work sorting, filtering, extracting, and updating your data. Guidance on working with multiple tables, connecting tables, and grouping data within a table. Pointers for storing SQL code in procedures, executing SQL as part of a transaction, and using constraints and triggers. Coverage of MySQL, Oracle, Microsoft SQL Server, and PostgreSQL and how SQL works with each DBMS.