Untitled document
Upon completion of the course, students will be able to:
1. Describe a relational database
2. Install and configure a database server environment
3. Implement SQL statements using data design, definition, and manipulation techniques
4. Implement stored procedures
5. Develop complex data analysis queries in SQL
6. Apply transaction and database administration concepts
7. Define and manage access controls for relational databases
Untitled document
1. Definition of "relational database"
a. Contrast relational database and file-based databases
b. History of relational database theory
c. Client/server computing
d. History and current options in the database market
e. MySQL, the SQL language, and understanding tables
2. Database server set-up
a. Installing and configuring MySQL
b. Storage engines Index Sequential Access Method (ISAM) and Inno Database (InnoDB)
3. SQL basics: Syntax, Data Manipulation Language (DML), Data Definition Language (DDL), tables, select, distinct, where, and/or, order by, query and reporting in SQL
4. Data design
a. Data normalization theory
b. Primary key and foreign keys
c. Entity and relationship diagramming
5. Data definition
a. Create database, create table and create index
b. Synonyms, views, stored procedures
6. Data manipulation: insert, update and delete
7. Stored procedures: programming in the database
8. Data analysis: SQL functions, unions, group by, and complex joins
9. Web data analysis: creating data analysis web applications using Python
10. Transactions: theory and practice for simple and distributed transactions using SQL
11. Database administration: partitioning, replication, enterprise management tools, backup and recovery
12. Security concepts of relational databases
a. User management
b. Access controls
c. Data integrity
| Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing. | Writing
0 - 0% |
| None | |
| This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments are more appropriate for this course. |
|
| Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills. | Problem Solving
50 - 70% |
| SQL problem solving projects | |
| Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams. | Skill Demonstrations
0 - 0% |
| None | |
| Exams: All forms of formal testing, other than skill performance exams. | Exams
30 - 50% |
| Objective examinations (multiple choice, true false, matching, completion, etc.) | |
| Other: Includes any assessment tools that do not logically fit into the above categories. | Other Category
0 - 10% |
| Participation and attendance | |
Untitled document
Database Systems: A Practical Approach to Design, Implementation, and Management (6th). Connolly, Thomas and Begg, Carolyn. Pearson: 2015
| Student Preparation |
| Matric Assessment Required: | E | Requires English Assessment |
| Prerequisites-generate description: | NP | No Prerequisite |
| Advisories-generate description: | A | Auto-Generated Text |
| Prereq-provisional: | N | NO |
| Prereq/coreq-registration check: | N | No Prerequisite Rules Exist |
| Requires instructor signature: | N | Instructor's Signature Not Required |
| | | |
| BASIC INFORMATION, HOURS/UNITS & REPEATABILITY |
| Method of instruction: | 02 | Lecture |
| | 72 | Internet-Based, Delayed Interaction |
| | 71 | Internet-Based, Simultaneous Interaction |
| Area department: | CS | Computer Studies |
| Division: | 72 | Arts & Humanities |
| Special topic course: | N | Not a Special Topic Course |
| Program Status: | 1 | Both Certificate and Major Applicable |
| Repeatability: | 00 | Two Repeats if Grade was D, F, NC, or NP |
| Repeat group id: | | |
| | | |
| SCHEDULING |
| Audit allowed: | N | Not Auditable |
| Open entry/exit: | N | Not Open Entry/Open Exit |
| Credit by Exam: | N | Credit by examination not allowed |
| Budget code: Program: | 0000 | Unrestricted |
| Budget code: Activity: | 0701 | Computer & Information Science |
| | | |
| OTHER CODES |
| Disciplines: | Computer Information Systems
OR
Computer Science |
| Basic Skills: | N | Not a Basic Skills Course |
| Level below transfer: | Y | Not Applicable |
| CVU/CVC status: | Y | Distance Ed, Not CVU/CVC Developed |
| Distance Ed Approved: | Y | Either online or hybrid, as determined by instructor |
| Emergency Distance Ed Approved: | Y | Fully Online
Partially Online
Online with flexible in-person activities
|
| Credit for Prior Learning: | N | Agency Exam |
| N | CBE |
| N | Industry Credentials |
| N | Portfolio |
| Non-credit category: | Y | Not Applicable, Credit Course |
| Classification: | Y | Career-Technical Education |
| SAM classification: | C | Clearly Occupational |
| TOP code: | 0707.20 | Database Design and Administration |
| Work-based learning: | N | Does Not Include Work-Based Learning |
| DSPS course: | N | NO |
| In-service: | N | Not an in-Service Course |
