List of Lessons | Subjects


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

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


School for Champions




Subjects in website



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!



The School for Champions helps you become the type of person who can be called a Champion.