Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases.
Transactions About the Author Chris Fehily is a statistician and author based in San Francisco..
Views 14.
Indexes 13.
Creating, Altering, and Dropping Tables 12.
Inserting, Updating, and Deleting Rows 11.
Set Operations 10.
Subqueries 9.
Joins 8.
Summarizing and Grouping Data 7.
Operators and Functions 6.
Retrieving Data from a Table 5.
SQL Basics 4.
The Relational Model 3.
Running SQL Programs 2.
Contents Introduction 1.
Fully indexed and cross-referenced.
Plenty of tips, tricks, and timesavers.
Troubleshoot and optimize queries.
Avoid common pitfalls involving nulls.
Execute transactions to maintain the integrity of your data.
Insert, update, delete, and merge data.
Create, alter, and drop tables, indexes, and views.
Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.
Use aggregate functions to summarize data.
Convert and manipulate data with SQL\'s built-in functions and operators.
Filter the data that you don\'t want to see.
Retrieve, sort, and format data.
Master tables, columns, rows, and keys.
Organize your database in terms of the relational model.
Learn the core language for standard SQL, and variations for the most widely used database systems.
Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.
You can download the sample database to follow along with the author\'s examples.
SQL code listings help you see the elements and structure of the language.
Hundreds of examples of varied difficulty encourage you to experiment and explore.
You\'ll find general concepts, practical answers, and clear explanations of what the various SQL statements can do.
Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases