Untitled document
At the conclusion of this course, the student should 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
Untitled document
Database Systems: A Practical Approach to Design, Implementation, and Management (6th). Connolly, Thomas and Begg, Carolyn. Pearson: 2015 (classic)
| 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 |