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 (coming soon)
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.
My Book
Share link
Click on a button to send an email, Facebook message, Tweet, or other message to share the link for this page: