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
Retrieving Columns of Data from a Database Table
Sorting Column Data Retrieved from a Database Table
Filtering Data Retrieved from a Database Table
Advanced Data Filtering
Wildcard Filtering
Creating Calculated Fields
Data Manipulation Functions
Summarizing Data
Grouping Data
Subqueries
Joining Tables
Advanced Joins
Combining Queries
Inserting Data
Deleting Data
Creating Tables
Manipulating Tables
Views
Transaction Processing
Resources
Survey question
Answer a survey question and see the results from other participants.
Miscellaneous
If you agree with the philosophies of the School for Champions and have any questions or would like to support, sponsor or contribute in some manner, please send an email.
Click on a button to share the link for this page:
Or use our form to send this link to yourself or a friend.