Mar 29, 2024  
2017-2018 Official General Catalog 
    
2017-2018 Official General Catalog [Archived Catalog]

BIT 264 - Database Languages


Database query languages enable business analysts, Web developers, and application developers to tap into data from multiple sources.  This course will cover the use of SQL (Structured Query Language) on multiple platforms such as DB2, Oracle, and MySQL.  Database fundamentals including terminology, the basics of database design and creation, and the basics of database security will also be covered.  New technologies such as analytic databases and NoSQL will be introduced within the context of their significant and growing use in bag data and real-time web applications.

Prerequisite- Corequisite
Prerequisite: BIT 260 Introduction to Database Management

Credits: 3
Hours
3 Class Hours
Course Profile
Objectives of the Course:

1.  Teach database languages which enable business analysts, Web develops and application programmers to tap into data from multiple sources.
2.  Cover the use SQL on multiple platforms.
3.  Teach the fundamentals of database terminology, design, creation and database security.
4.  Introduce new technologies in the field of database languages such as analytic databases and NoSQL.

Learning Outcomes of the Course:

Upon successful completion of this course the student will be able to:

1.  Differentiate between various database systems.
2.  Use SQL as a data definition and data manipulation language.
3.  Troubleshoot underlying query errors in information management systems.
4.  Describe database security needs and tools for implementation of security measures.
5.  Design and create a relational database system.
6.  Use NoSQL to extract data for data analytics applications.
7.  Utilize an analytic database in a business intelligence application.