Databases and Business Intelligence Solutions (Online)
| Program start date | Application deadline |
| 2023-09-01 | 2023-07-09 |
| 2024-01-01 | 2023-11-26 |
| 2024-09-01 | - |
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.
Teesside University
Overview:
Teesside University is a public university located in Middlesbrough, Tees Valley, England. It is known for its strong focus on student experience, research, and business partnerships. The university has invested heavily in its campus, offering modern facilities and a vibrant learning environment.
Services Offered:
Teesside University provides a wide range of services to its students, including:
Undergraduate and postgraduate study:
Offering a diverse selection of programs across various disciplines.Short courses and CPD:
Providing opportunities for professional development and upskilling.Online learning:
Delivering flexible and accessible learning options.International student support:
Providing dedicated services for international students.Career services:
Offering guidance and support for career planning and job searching.Student support services:
Providing academic, personal, and financial support to students.Library and IT facilities:
Offering access to extensive resources and technology.Accommodation services:
Providing on-campus and off-campus accommodation options.Sports and recreational facilities:
Offering a variety of sports and leisure activities.Student Life and Campus Experience:
Teesside University prides itself on its close-knit and supportive community. Students can expect a vibrant campus life with:
Social events and activities:
Offering opportunities to connect with fellow students and engage in extracurricular activities.Student societies and clubs:
Providing platforms for students to pursue their interests and develop their skills.Campus facilities:
Including a modern library, sports facilities, and a variety of dining options.A welcoming and inclusive environment:
Fostering a sense of belonging and diversity.Key Reasons to Study There:
Affordable excellence:
Offering a high-quality education at a competitive price.Gold rating in the Teaching Excellence Framework (TEF):
Recognized for its outstanding teaching and student experience.World-leading research:
Conducting impactful research across various fields.Strong industry partnerships:
Providing opportunities for students to gain practical experience and develop valuable connections.Vibrant and supportive community:
Offering a welcoming and inclusive environment for students to thrive.Academic Programs:
Teesside University offers a wide range of academic programs across six schools:
School of Arts & Creative Industries
School of Computing, Engineering & Digital Technologies
School of Health & Life Sciences
School of Social Sciences, Humanities & Law
Teesside University International Business School
University departments
Other:
Campus Masterplan:
Teesside University has invested £280 million in its campus to enhance the student experience and support the local community.Strong commitment to equality and diversity:
Recognized as a top employer for its commitment to inclusivity.Nationally recognized for its services to business:
Providing impactful partnerships with local and global organizations.Located in a vibrant and affordable region:
Offering a unique blend of urban and rural experiences.Entry Requirements:
EU Home Students:
- Must have completed a Level 4 qualification (or higher) and/or developed knowledge and skills in IT or computing.
- May also be considered if they have relevant work experience in place of formal qualifications.
International Overseas Students:
- Must have completed a Level 4 qualification (or higher) equivalent to UK standards and/or developed knowledge and skills in IT or computing.
- Required to meet English language proficiency requirements equivalent to IELTS 6.0 or above.
Bridging Courses:
- Teesside University offers bridging courses to help students develop the knowledge they may need to join this short course. These courses are designed for those who do not meet the standard entry requirements but have the potential to succeed on the program.
Language Proficiency Requirements:
- International students must provide evidence of their English language proficiency by achieving a minimum IELTS score of 6.0 or equivalent.
- Other acceptable English language tests include:
- PTE Academic (minimum score of 51)
- TOEFL iBT (minimum score of 79)
- Cambridge English: Advanced (minimum score of 169)
- Cambridge English: Proficiency (minimum score of 169)
Additional Notes:
- The course website states that "additional entry requirements may apply depending on your previous qualifications." It is therefore recommended that prospective students contact the university directly for further information.
- The university website also states that "we offer bridging courses to help develop the knowledge you may need to join this short course." This information is included in the "Entry Requirements" section above. I hope this information is helpful. Please let me know if you have any other questions.
