Structured Query Language (SQL) |
Objectives |
Discussion |
SQL
SQL Tips
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
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.
Links & Help |