Advanced SQL
No Thumbnail Available
Keywords
advanced SQL syntax , database design , data transformation , ETL processes , Extract , Transfer , Load processes
Project
Authors
Chavez, Jamie
Date Submitted
2016
Material Type
Collection
Secondary Material Type
Syllabus
Institution
Northcentral Technical College
Industry Partner
College collaborated with the program advisory committee.
License
CC BY
Funding Source
TAACCCT Round 3
Additional Public Access
Abstract
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.
Industry (NAISC)
Information Technology -- Computer Operating Systems (Programming), Digital Forensics, Cyber Security, Network Security, IT Security (51)
Occupation (SOC)
Computer and Mathematical Occupations (15-0000)
Instructional Program (CIP)
Computer and Information Sciences and Support Services (11)
Credit Type
Credential Type
Diploma
Associate Degree
Associate Degree
Educational Level
1st year Community College or equivalent
2nd Year Community College or equivalent
2nd Year Community College or equivalent