Relational Database System – Sql Tutorial
U05A1
RELATIONAL DATABASE SYSTEM – SQL TUTORIAL
IT2230
Introductions to Databases u05a1 Relational Database System – SQL Tutorial Assignment
Overview of Lesson Assignments
Table of Contents
Overview of Lesson Assignments 2
LESSON 3 3 Exercise 1 3 Exercise 3 3 Exercise 5 4 Summary of Lesson 3 4
LESSON 4 5 Create Table Exercise 5 Summary of Lesson 4 5
LESSON 5 6 Exercise 1 6 Exercise 3 6 Exercise 5 7 Exercise 7 7 Summary of Lesson 5 8
LESSON 6 9 Exercise 1 9 Exercise 3 9 Exercise 5 10 Exercise 7 10 Summary of Lesson 6 11
LESSON 7 12 Exercise 1 12 Exercise 2 12 Summary of Lesson 7 13
LESSON 8 14 Exercise 1 14 Summary of Lesson 8 14
LESSON 3
Exercise 1
[pic]
Exercise 3
[pic]
Exercise 5
[pic]
Summary of Lesson 3
The "Select" statement is very simple, but valuable query tool. It allows a person to select one or more rows of data based upon the level of detail, or filter the data chosen by a person.
In these examples above, all of the data from every column was displayed. Then more specific queries refined the results to match the details specified in the "Select" statements.
LESSON 4
Create Table Exercise
[pic]
Summary of Lesson 4
The "Create" statement sets up how the columns are to be used by the table, as well as any constraints, or rules, that the data must be inputted or displayed by the table.
My table, "2013_staff_members” contained the required columns for first and last names, job titles, ages, and salaries.
The name and title columns were set up as variable character columns with a limit of 35 characters. The age was a number field with a maximum of two characters with a
RELATIONAL DATABASE SYSTEM – SQL TUTORIAL
IT2230
Introductions to Databases u05a1 Relational Database System – SQL Tutorial Assignment
Overview of Lesson Assignments
Table of Contents
Overview of Lesson Assignments 2
LESSON 3 3 Exercise 1 3 Exercise 3 3 Exercise 5 4 Summary of Lesson 3 4
LESSON 4 5 Create Table Exercise 5 Summary of Lesson 4 5
LESSON 5 6 Exercise 1 6 Exercise 3 6 Exercise 5 7 Exercise 7 7 Summary of Lesson 5 8
LESSON 6 9 Exercise 1 9 Exercise 3 9 Exercise 5 10 Exercise 7 10 Summary of Lesson 6 11
LESSON 7 12 Exercise 1 12 Exercise 2 12 Summary of Lesson 7 13
LESSON 8 14 Exercise 1 14 Summary of Lesson 8 14
LESSON 3
Exercise 1
[pic]
Exercise 3
[pic]
Exercise 5
[pic]
Summary of Lesson 3
The "Select" statement is very simple, but valuable query tool. It allows a person to select one or more rows of data based upon the level of detail, or filter the data chosen by a person.
In these examples above, all of the data from every column was displayed. Then more specific queries refined the results to match the details specified in the "Select" statements.
LESSON 4
Create Table Exercise
[pic]
Summary of Lesson 4
The "Create" statement sets up how the columns are to be used by the table, as well as any constraints, or rules, that the data must be inputted or displayed by the table.
My table, "2013_staff_members” contained the required columns for first and last names, job titles, ages, and salaries.
The name and title columns were set up as variable character columns with a limit of 35 characters. The age was a number field with a maximum of two characters with a