SQL Essentials For Dummies

A right-to-the-point guide on all the key topics of SQL programming

SQL Essentials For Dummies is your quick reference to all the core concepts of SQL—a valuable common standard language used in relational databases. This useful guide is straightforward—with no excess review, wordy explanations, or fluff—so you get what you need, fast. Great for a brush-up on the basics or as an everyday desk reference, this book is one you can rely on.

• Strengthen your understanding of the basics of SQL
• Review what you've already learned or pick up key skills
• Use SQL to create, manipulate, and control relational databases
• Jog your memory on the essentials as you work and get clear answers to your questions

Perfect for supplementing classroom learning, reviewing for a certification, and staying knowledgeable on the job, SQL Essentials For Dummies is the convenient, direct, and digestible reference you've been looking for.

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

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.

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