 |
SQL Essentials for DummiesFor Dummies, 2024by Richard Blum and Allen G. Taylor |
Description
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.
Table 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
Useful Web sites:
Linux
DistroWatch
Here's where I keep up to date on the latest Linux distribution news.
Ubuntu
The most popular desktop Linux distribution.
openSUSE
A popular full-featured Linux distribution, great for both desktops and servers.
CentOS
A popular Linux server distribution.
Web Programming
PHP online manual
The ultimate resource in all PHP programming topics
MySQL online manual
The MySQL database online manual.
W3Schools
A great online tutorial and reference for many Web programming languages.
Bass Guitar
Fender basses
One of my favorites, I love the Fender Jazz bass. It's such a versatile instrument you can take it to just about any gig!
Lakland basses
The Lakland Skyline 55-01 bass is yet another of my favorite basses!
Bible Study
Reformed Theological Seminary
When I'm not reading computer books, I'm doing bible studies. The Reformed Theological Seminary has some great online courses for free that cover the basics of reformed theology.
BiblicalTraining.org
A smorgasbord of more reformed and evangelical seminary course recordings, all for free!