Structured Query Language (SQL)

Objectives


Discussion

SQL

SQL Tips

Back to top


Demonstration

In this demo we will learn to write SQL statements.  However, we will use another web-site to do this.  Visit www.sqlcourse.com and complete the following courses.  You should read the discussions and complete the exercises.

3 Selecting data

4 Creating tables

5 Inserting into a table

6 Updating records

7 Deleting records

8 Drop a table

Back to top

Exercises

The questions refer to the following database table named StudentInfo with the four fields.  SSN and Name are text fields.  Graduation Year and GPA are number fields. BirthDate is a date field.

StudentInfo

SSN

Name

Graduation Year

BirthDate

GPA

1.  Write a SQL statement to select all information about students who are graduating in 2005.

2.  Write a SQL statement to select the Names of students who have a GPA over 3.0.

3.  Write a SQL statement to add a new person with the following information:  SSN = 123-45-6789; Name = "NewGuy"; Graduation Year = 2010; BirthDate = 4/16/1992; GPA = 4.0. 

4.  Write a SQL statement to delete all students whose Graduation Year is 2003.

Back to top
Links & Help
Back to top