The Wayback Machine - https://web.archive.org/web/20100129025346/http://sqlcourse2.com:80/intro2.html


Free Newsletters:
DatabaseJournal
DBANews
SQLCourse2
Advanced Online SQL Training
Search Database Journal:
 
HOME News MS SQL Oracle DB2 Access MySQL PHP SQL Etc Scripts Links Forums DBA Talk
internet.com
SQL Courses
1 Start Here - Intro
2 SELECT Statement
3 Aggregate Functions
4 GROUP BY clause
5 HAVING clause
6 ORDER BY clause
7 Combining Conditions & Boolean Operators
8 IN and BETWEEN
9 Mathematical Functions
10 Table Joins, a must
11 SQL Interpreter
12 Advertise on SQLCourse.com
13 Other Tutorial Links
14 Technology Jobs


internet.commerce
Partner With Us















internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers




Become a Marketplace Partner




Start Here - Intro

This Intermediate/Advanced SQL Tutorial will cover the SELECT statement in great detail. The SELECT statement is the core of SQL, and it is likely that the vast majority of your SQL commands will be SELECT statements. Due to the enormous amount of options available for the SELECT statement, this entire tutorial has been dedicated to it.

When constructing SQL Queries (with the SELECT statement), it is very useful to know all of the possible options and the best or more efficient way to do things. This Tutorial will help provide you with those skills.

Although it is recommended that you go through SQLCourse.com (the original site) or at least the SELECT statement on SQLCourse.com, it isn't required. YOu can start with this site, and then proceed to SQLCourse.com when you are finished. SQLCourse.com covers four other SQL Commands and allows you to practice those as well.

Note: This Intermediate/Advanced Tutorial will allow you to practice all of the advanced features coverd here on this site. Not all of these commands are available at the original SQLCourse.com site. The four other commands covered at SQLCourse.com are not supported with this Interpreter on this site.

You can submit all of your SQL commands in the Text submission box at the bottom of each of the main pages.


SQL Course 2 Curriculum
<<previous 1 2 3 4 5 6 7 8 9 10 11 12 13 14  next>>



The Network for Technology Professionals

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers