V e rsion: 3/20/2019 2
Additional Course Information
Topical Outline: Each offering of this course must include the following topics (be sure to include information regarding lab,
practicum, and clinical or other non-lecture instruction).
Define: SQL and relational database
Define: table, row, cell, column, primary key
Select statements
Select clauses
Where clauses
Equal condition
Less than condition
In, between, like, null, not null conditions
Order by clause
Compound conditions in where clause
Creating: tables and views
Difference/similarities between tables and views
Deleting tables and views
Adding/deleting rows and columns
Commit and rollback
Insert, update and delete constraints
Transactions
Column formats
Use of the data dictionary
Primary and foreign keys – creating and use
Duplicate row issues
Data formats
Sequences
Indexes
Referential integrity
Inserts, updates and deletes using referential integrity
Check, unique, not null and primary key constraints
Inner joins
Course Learning Outcomes:
Learning Outcomes – Upon successful completion of this course, students will:
This course incorporates the National Workforce Center for Emerging Technologies Programming/Software
Engineering skill standards recognized by the Texas Skill Standards Board.
Methods of Assessment:
Critical Work Function Key Activities assessed in this course:
C3 Develop appropriate data model and database scheme
Required text(s), optional text(s) and/or materials to be supplied by the student:
• Oracle 11g: SQL, 2nd Edition; Joan Casteel; Course Technology; ISBN 9781439041284
• Oracle 10g Developer: PL/SQL programming; Joan Casteel; Course Technology; ISBN 978-1-4239-0136-5
Suggested Course Maximum:
20
