Databases and Business Intelligence Solutions (Online)

Program Overview

This online course in Databases and Business Intelligence Solutions equips learners with the skills to build and maintain server databases and BI solutions. Through hands-on experience with T-SQL, data analysis, and KPI exploration, participants gain expertise in designing databases, querying data, and developing insightful BI dashboards. The program is ideal for career advancement or upskilling in the data and analytics domain.

Program Outline

Degree Overview:

Overview:

This short course in Databases and Business Intelligence Solutions (Online) develops your ability to build and maintain server databases and Business Intelligence (BI) solutions for industry use. You'll delve into server database design, construction, and querying data using Transactional Structured Query Language (TSQL). Additionally, you'll explore data analytics and key performance indicators (KPIs) to craft a comprehensive BI dashboard.

Objectives:

• Equip learners with the knowledge and skills to build and maintain server databases.
• Introduce learners to the design, development, and implementation of BI solutions.
• Provide hands-on experience with T-SQL for data querying.
• Foster understanding of data analysis and utilization of KPIs for BI dashboard development.

Description:

This online program offers a comprehensive understanding of databases and BI solutions, equipping you with the necessary skills to support industry needs. You'll gain expertise in designing and building databases, querying data using T-SQL, and developing insightful BI dashboards through data analytics and KPI exploration. The course is ideal for individuals seeking career advancement or upskilling opportunities in the data and analytics domain.

Outline:

Content:

• Server Database Design and Construction: Learn the principles of relational database design, data modeling, and normalization techniques for efficient data storage and retrieval.
• T-SQL for Data Querying: Master T-SQL, the language used to query data in relational databases, including data manipulation, aggregation, and filtering functions.
• Data Analysis and KPIs: Explore techniques for data analysis, including descriptive statistics, data visualization, and identification of key performance indicators for business insights.
• BI Dashboard Development: Gain experience in crafting effective BI dashboards that present data insights and visualizations for informed decision-making.

Structure:

• 12 weeks of online learning.
• Weekly schedule:
• One-hour recorded online lecture.
• Two hours of live online classes (Wednesdays, 4:00 PM - 6:00 PM).
• Two hours of live online classes (Thursdays, 6:00 PM - 8:00 PM).
• Total learning commitment: approximately 400 hours.

Individual Modules:

• Module 1: Introduction to Database Management Systems (DBMS)
• Fundamentals of DBMS, relational database models, data integrity, and normalization.
• Module 2: Server Database Design
• Entity-relationship modeling, database design methodologies, and optimization strategies.
• Module 3: T-SQL for Data Querying
• Introduction to T-SQL syntax, data definition language (DDL), and data manipulation language (DML).
• Advanced querying techniques, including joins, aggregates, and subqueries.
• Module 4: Data Analysis and KPI Identification
• Descriptive statistics, data visualization techniques, and identifying KPIs for business performance measurement.
• Module 5: BI Dashboard Development
• Designing effective dashboards, integrating data visualizations, and implementing real-time data updates.

Assessment:

• Coursework assignments.
• Practical work exercises.
• Assessments evaluating subject knowledge, critical thinking, and skill acquisition.

Teaching:

• Support for individual needs with personalized support plans.
• Regular assessment opportunities and feedback.
• Online lectures, live classes, and virtual learning environment (VLE) for student interaction and collaboration.

Careers:

• Potential career paths in database administration, business intelligence analysis, and data science.
• Opportunities to enhance employability and pursue new career opportunities.
• Option to progress to a university degree by transferring eligible credits.

Other:

• This course is part of a series focusing on digital innovation skills.
• Funding opportunities available for eligible individuals.
• Study Support Bursaries accessible to support overcoming barriers to studying.

Note:

This information is based on the provided context. If you need further details or have specific questions, please consult the course website or contact the Teesside University online learning team.