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
Accessing your eBook through Kortext
Once purchased, you can view your eBook through the Kortext app, available to download for Windows, Android and iOS devices. Once you have downloaded the app, your eBook will be available on your Kortext digital bookshelf and can even be downloaded to view offline anytime, anywhere, helping you learn without limits.
In addition, you'll have access to Kortext's smart study tools including highlighting, notetaking, copy and paste, and easy reference export.
To download the Kortext app, head to your device's app store or visit https://app.kortext.com to sign up and read through your browser.

NB: eBook is only available for a single-user licence (i.e. not for multiple / networked users).