Queries, Cursors, Views  «Prev  Next»
Lesson 5 Time Sheet Database course project
Objective Describe the project that you will be working on in this course.

Time Sheet Database course project

For the course project, I will be referring to a timesheet database that can be used to track time and bill hours to a client or supervisor. Because many of you may be consultants or contractors, I thought it would be fun to build a real-world database that enables you to track your time and bill your supervisor or clients accurately.

SQL (Structured Query Language) is a database computer language designed for managing data in relational database management systems (RDBMS). SQL, is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements.
What can SQL do?
  1. SQL can execute queries against a database
  2. SQL can retrieve data from a database
  3. SQL can insert records in a database
  4. SQL can update records in a database
  5. SQL can delete records from a database