![]() COMP 1630 is a required course for the Applied Database Administration and Design (ADAD) Associate Certificate the Applied Data Analytics Certificate (ADAC) and the Computer Systems Certificate (CSC). Online activities via the BCIT Learning Hub are mandatory. Students in are required to participate in group work, there is significant reading and assignments required outside of class. Current trends in database such as Replication, Data Warehousing, Online Analytical Processing (OLAP), using databases on the web and in the cloud are discussed. Advanced topics include: an introduction to SQL, DDL- data definition language and DML- data manipulation language, views, security, transaction management, triggers and stored procedures. ![]() Topics include functional dependencies, normalization, database design methodologies, entity relationship modeling and the use of UML as a diagramming notation. There is also a heavy focus on the Structured Query Language (SQL) to define and manipulate data. Labs and exercises take place in a Windows 11 PC environment. COMP 1630 starts with tools and processes for data modeling in Relational Database Management Systems (RDBMS). Students are introduced to relational database design concepts and industry standards. This intensive, hands-on course is the prerequisite for follow-on database courses in several BCIT Computing programs. Centre for Applied Research & Innovation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |