EBooks-Library

About eBook:If you have some experience using or administering a database but still need to learn more about the basics of SQL, this book is a great place to start. This text covers building a relational database, structuring queries, performance optimization, and administering users. Like other books in the "in 24 Hours" series, each chapter functions as a lesson and includes a summary, questions and answers, a quiz, and excercises. The second edition adds new concepts found in the SQL3 standard. A glossary in one of the appendices helps you learn SQL terminology.
In just 24 sessions of one hour or less, you will be up and running with SQL.
Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of SQL from the ground up.

• Tips point out shortcuts and solutions
• Notes clarify concepts and procedures in a straightforward manner
• Cautions help you avoid common pitfalls

Learn how to...
• Build and manage relational database objects
• Effectively query the database
• Master functions and clauses to query data
• Summarize data with views
• Uncover ways to summarize, sort and group, and restructure the appearance of data
• Performance tune SQL statements
• Use SQL to implement database security