Advanced SQL
This project includes a complete course design for teaching the course with related learning materials. It also includes a sample schedule for delivering the course.
***********
Builds upon the database concepts taught in earlier courses, introducing advanced SQL syntax, database design and data transformation. Learners will write advanced SQL statements, design robust databases and write Extract, Transfer, Load (ETL) processes. Additional topics include alternate database technologies, emerging database trends and database administration and security.
- Date:
- 2016
- Primary Material Type:
- Collection
- Other Material Types:
- Syllabus
- Institution:
- Northcentral Technical College
- Funding Source:
- TAACCCT Round 3
- Subjects:
- advanced SQL syntax, database design, data transformation, ETL processes, Extract, Transfer, Load processes
Industry / Occupation
- Industry Partner:
- College collaborated with the program advisory committee.
- Industry Sector:
- Information Technology -- Computer Operating Systems (Programming), Digital Forensics, Cyber Security, Network Security, IT Security (51)
- Occupation:
- Computer and Mathematical Occupations (15-0000)
Education / Instructional Information
- Instructional Program:
- Computer and Information Sciences and Support Services (11)
- Educational Level of Materials:
-
- 1st year Community College or equivalent
- 2nd Year Community College or equivalent
- Time Required:
- 3 credits/72 hours
- Language:
- English (United States)
- Interactivity Type:
- Presentation only - requires user to navigate through content.
- Quality Rubric:
- Other
- Quality Note:
- The course was developed by a faculty member at the college and reviewed by the college Instructional Designer. Course materials were then reviewed by the Interface Grant Instructional Designer. Finally courses were sent to a Third Party reviewer for both ID and SME review. Colleges used local quality rubrics and an Interface rubric. The Interface specialist used the Interface Rubric and the third party reviewer used the Third Party rubric.
- Quality of Subject Matter was assured by:
-
- Using an approved rubric to conduct the evaluation of the instructional materials and providing a report
- SME Quality Report is posted in Skills Commons
- Quality of Online/Hybrid Course Design assured by:
-
- Custom Quality Rubric
- Expertise of Project's Instructional Designers
- Course Note:
- IT - Software Developer Associate Degree
Accessibility
- Accessibility Features:
-
- Text Access - Text to Speech
- Text Adjust - Compatible
- Text Adjustment - Adjust Font and Colors
- Table Markup
- Hyperlinks Rendered As Active
- Non-Decorative Images Have Alt Text
Copyright / Licensing