Title:
Sams teach yourself SQL in 24 hours / Ryan Stephens.
ISBN:
9780137543120
Personal Author:
Edition:
Seventh edition.
Publication Information:
[River, New Jersey] : Pearson Education Inc., [2022]
©2022
Physical Description:
xiii, 601 pages : illustrations ; 24 cm.
General Note:
Includes index.
"New sample database + standard SQL examples: use these skills anywhere" -- Cover.
Contents:
Understanding the relational database and SQL -- Exploring the components of the SQL language -- Getting to know your data -- Setting up your database -- Understanding the basics of relational (SQL) database design -- Defining entities and relationships -- Normalizing your database -- Defining data structures -- Creating and managing database objects -- Manipulating data -- Managing database transactions -- Introduction to database queries -- Using operators to categorize data -- Joining tables in queries -- Restructuring the appearance of data -- Understanding dates and times -- Summarizing data results from a query -- Using subqueries to define unknown data -- Combining multiple queries into one -- Creating and using views and synonyms -- Managing database users and security -- Using indexes to improve performance -- Improving database performance -- Working with the system catalog -- Bonus workshop for the road -- Appendixes. Common SQL commands ; Popular vendor RDBMS implementations -- Answers to quizzes and exercises.
Summary:
Featuring step-by-step instructions that walk you through the most common SQL tasks, this authoritative resource helps you use SQL to build effective data bases, efficiently review data and manage everything from performance to security.
Series Title:
OCLC Number:
on1290207487
Availability:
~0
