Sql Essentials for Dummies

Stop the endless search for SQL queries Imagine having a book to consult at any time to brush up on your SQL skills. SQL Essentials For Dummies is that book-a no-frills guide to mastering SQL commands and database management. This straighforward resource is packed with clear explanations and step-by-step examples to deliver just what you need to work with databases effectively. Great for those who are new to SQL and experienced SQLers who need a quick reference, this guide offers the perfect balance of clarity and practicality to help you succeed.[><] Inside...

• Finding clear, concise explanations
• Getting only the examples you need
• Setting up a new database
• Managing access to data
• Changing and deleting data
• Defining relationships
• Keeping your database secure
• Getting tips for using SQL efficiently

List of contents

Introduction 1
Chapter 1: Getting to Know SQL 5
Chapter 2: Creating a Database with SQL 13
Chapter 3: Drilling Down to the SQL Nitty-Gritty 27
Chapter 4: Values, Variables, Functions, and Expressions 51
Chapter 5: SELECT Statements and Modifying Clauses 79
Chapter 6: Querying Multiple Tables with Subqueries 109
Chapter 7: Querying Multiple Tables with Relational Operators 127
Chapter 8: Cursors 151
Chapter 9: Assigning Access Privileges 163
Chapter 10: Ten Retrieval Tips 175
Index 179

About the author

Richard Blum is a network and systems administrator. He has worked with database systems such as Microsoft SQL Server, PostgreSQL, and MySQL. Rich also teaches online courses in programming. Allen G. Taylor is author of more than 40 books, including SQL For Dummies. He also teaches database development through a leading online education provider.

Product details

• Authors: Richard Blum, Richard Taylor Blum, Blum Richard, Richard Blum, Allen G Taylor, Taylor Allen G., The Experts at Dummies
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 26.12.2024
• EAN: 9781394296941
• ISBN: 978-1-394-29694-1
• No. of pages: 208
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Programming languages; COMPUTERS / Programming / Open Source, Computer programming / software engineering, Databases, Programming and scripting languages: general, Computer Programming / Software Development, COMPUTERS / Database Administration & Management, COMPUTERS / Languages / SQL