SQL Essentials For Dummies

1. Auflage Dezember 2024
208 Seiten, Softcover
Wiley & Sons Ltd
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.
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
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.