List of Lessons | Subjects


 

Succeed in Using SQL

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. If you have any questions, send me an email.

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 question

Answer a survey question and see the results from other participants.

Yes | No  

See results of all questions



Share

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

 

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.