Título:
Sams teach yourself SQL in 24 hours / Ryan Stephens.
ISBN:
9780137543120
Autor personal:
Edición:
Seventh edition.
Información de publicación:
[River, New Jersey] : Pearson Education Inc., [2022]
©2022
Descripción física:
xiii, 601 pages : illustrations ; 24 cm.
Nota general:
Includes index.
"New sample database + standard SQL examples: use these skills anywhere" -- Cover.
Contenido:
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.
Síntesis:
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.
DAK_SERIES_TITLE_DSP:
DAK_OCLC_NUMBER:
on1290207487
Disponibilidad:
~0
