
SQL Essentials For Dummies
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
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.
More details
Other editions
Additional editions

Persons
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.
Content
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
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.