Understanding SQL

by Ron Kurtus (updated 17 March 2023)

SQL (Structured Query Language) is a computer language used to query or make commands to a database. It is structured to be relatively straightforward and simple to use. SQL is used with such databases as Microsoft Access, My SQL, and Microsoft SQL Server. It is often used with Web programming languages, such as ColdFusion, ASP, and PHP.

The purpose of these lessons is to provide you with the basics of using SQL to query a database. It is also useful for those studying Web programming and e-commerce.

SQL Contents

• Basics
• Resources
• Survey results
• Share link

---

---

Basics

Database Basics

Retrieving Columns of Data

Sorting Retrieved Column Data

Filtering Data Retrieved from a Database Table

Advanced Data Filtering (coming soon)

Wildcard Filtering

Creating Calculated Fields

Data Manipulation Functions

Summarizing Data

Grouping Data

Subqueries

Joining Tables

Advanced Joins

Combining Queries

Inserting Data

Updating Data in SQL

Deleting Data

Creating Tables

Manipulating Tables

Views

Transaction Processing

Resources

SQL Resources

---

Survey results

See results of survey questions

---

My books

---

Share

Click on a button to bookmark or share this page through Twitter, Facebook, email, or other services:

---

School for Champions

---

---

---

Subjects in website

A Aging Algebra Animal Health Arithmetic Astronomy B Behavior Biographies Business C Career Character Chemistry Child Development ColdFusion Communication Competition E eCommerce Education e-Learning Electricity Electro-Optics Entrepreneurship Excellence Experiments F Fiction Writing Finances Flash Development FrameMaker Friction G Get Good Grades Gravitation Gravity H Health History I ISO 9000 InDesign K Knowledge

M Machines Magnetism Marketing Mechanics Mental Health Missile Defense N Nutrition P Physical Science Physics Publishing Q Quality R Religion S Sales Science Projects Security Senses SDI History Speaking Speech Writing Speeches Spiritual Health Sports SQL Success in Life T Technical Writing TQM Training V Value in Life Vitality W Web Design Writing Methods

---

---

Let's make the world a better place

Be the best that you can be.

Use your knowledge and skills to help others succeed.

Don't be wasteful; protect our environment.

You CAN influence the world.

---

---

Live Your Life as a Champion:

Take care of your health

Seek knowledge and gain skills

Do excellent work

Be valuable to others

Have utmost character

Be a Champion!

---