Jul 04, 2020
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: BIT 260 Introduction to Database Management
3 Class Hours
Learning Outcomes of the Course:
Upon successful completion of this course the student will be able to:
- Differentiate between various database systems.
- Use SQL as a data definition and data manipulation language.
- Troubleshoot underlying query errors in information management systems.
- Describe database security needs and tools for implementation of security measures.
- Design and create a relational database system.
- Use NoSQL to extract data for data analytics applications.
- Utilize an analytic database in a business intelligence application.
Add to Portfolio (opens a new window)