Black Friday Sale: Save up to €500 on select courses. Ends in
Black Friday Sale: Save up to €500 on select courses. Ends in
Choose Your Start Date
Browse our upcoming live online classes. Download your brochure to learn more.
Secure your place by paying in full or availing of our payment plan. For Part-time, on demand and on campus courses, pay in three equal interest-free instalments. For full-time Bootcamps enrol with a 50% deposit and the rest at the course start date. T&C's apply.
Why UCD Professional Academy?
- Valuable, trusted certification
- Industry expert lecturers
- Flexible learning options
Database Fundamentals Course Modules
This practical course provides a comprehensive introduction to databases –their architecture, how to build them, and ways of extracting data from them. You will also learn Structured Query Language (SQL), the standardised programming language that is used to manage relational databases. An understanding of database models is particularly useful in organisations that have large volumes of raw data that is hard to reach (for example, data that isn’t scrapable or exportable, or where there is no API available). You will develop the skills to extract and manipulate such data to deliver real business value while following best practice in data management, security, and stewardship.
In addition, the course will look at other types of database (non-relational and cloud) and their use cases, plus dip into the emerging trends and evolutions in data management and database management systems.
1. Introduction To Databases
Explore the basic concepts of databases and why they are so important in data management.
- Database concepts
- Types of databases
- Database users
- Applications
2. Ethical, Privacy, & FAIR Data Principles
Gain an understanding of ethical, privacy, and FAIR (findable, accessible, interoperable, and reusable) principles for data stewardship, which are increasingly important in today’s data-driven world.
- Introduction to ethical data principles
- Data privacy and security
- Introduction to FAIR data principles
- Principles in database design
3. Database Models
Discover the most common database models (the data model in use, which determines the logical structure of any database) and their various applications.
- Hierarchical database model
- Network model
- Relational model
- Object model
- Introduction to NoSQL models
4. Relational Database Design
Learn the principles of relational database design, which determines where dependencies are within datasets.
- Normalisation
- Functional dependencies
- Keys
- Applying ethical, privacy, and FAIR principles
5. Structured Query Language (SQL)
Jump into the basics of Structured Query Language (SQL) programming language and understand its use in database management.
- SQL syntax
- SELECT statements
- Filtering data
6. Functions & Aggregates
Explore how SQL aggregate functions are used in data analysis.
- Scalar and aggregate functions
- GROUP BY
- HAVING
7. Data Manipulation
Learn about data manipulation - adding (inserting), deleting, and modifying (updating) data in a database – using SQL data manipulation language (DML).
- Basic commands/queries
8. Advanced SQL Concepts
Learn about indexing techniques and query optimisation strategies.
- Index types
- Query execution plans
- Performance tuning
9. Database Administration
Discover the roles and responsibilities of a database administrator.
- Database security
- Backup and recovery
- User management
- Ethical, privacy, and FAIR data principles
10. Database Management Systems & Emerging Trends
Explore some of the most exciting emerging trends in database technology, including big data, data analytics, and machine learning. Gain an understanding of cloud-based databases and their use cases.
- Introduction to NoSQL systems (including MongoDB)
- Trends and innovations in databases
- Cloud-based databases (AWS, Google, Azure, etc.)
11. Non-Relational Databases: Part 1
Dive into the area of non-relational (or NoSQL) databases and what type of data storage they are most suitable for. Look at the main types of non-relational database (document, key-value, column-oriented, graph).
- Non-relational database types
- MongoDB: architecture, data model, querying, and indexing
12. Non-Relational Databases: Part 2
Explore other non-relational database types and their application, including a comparative study of NoSQL databases such as Couchbase and Amazon DocumentDB.
- MongoDB: indexing strategies, and performance tuning
Access to thousands of journals, articles and papers. Free of charge.
Students taking part in this course will now have access to the EBSCO Online Library, free of charge, for the full duration of the course. Here you can browse thousands of relevant journals, articles and other reliable academic and commercial texts like the Harvard Business Review, Bloomberg Businessweek and Forbes Magazine, to supplement your learning and assignments.
Download BrochureWe've trained the employees of
Relevant skills for your team, results for you.
Whether you’re interested in making your training budget work harder with volume discounts across our standard portfolio, or have bespoke training needs to be addressed, we’ll help you level up. Our team of upskilling experts are ready to take the pain out of meeting your training targets.
Talk to our expertsFrequently Asked Questions
Is this course right for me?
This course would be ideal for a professional who is already competent at analysing and visualising data (for example using Python) but who finds themselves working with data that is not particularly organised or accessible. Given the importance of data in business today, any IT professional will find value in a better understanding of databases and how they work. The course is also suitable for business professionals who work with data regularly and want to understand how to leverage databases more effectively. Although the course teaches Structured Query Language (SQL), it does not cover other programming languages like Python or R.
How will this course help with my career?
The skills and knowledge learned on this course would be ideal for a professional looking to start or develop their career as a database administrator, data analyst, back-end developer, etc. This course is an excellent complement to your other IT skills, developing knowledge you could leverage to advance in your current role or branch out into more a specialised position.
What is the online learning experience like?
Our online experience is designed to be just as interactive, supportive, and inspiring as the UCD Professional Academy campus experience.
Online courses can be accessed from any computer or laptop with an internet connection.
Live lectures are delivered using Zoom. During these lectures, your teachers will use technology interactively to ensure an engaging learning experience. When appropriate, students will be encouraged to activate their microphones so that they can ask questions and communicate with other students.
What is the student experience like?
Student care is a high priority at UCD Professional Academy, which is why our Student Services team is on hand to support you throughout your time with us. They will respond to any queries you have, help you with any technical issues, and facilitate your learning experience at every point. All students are given access to our Student Portal, where you can see your timetable, access all your study materials, and manage your account.
How is this course assessed?
This course is assessed through a set of short MCQ exercises (20% of your assessment) completed each week, and a final project (80% of your assessment). The MCQs are designed to ensure key concepts have been learned and can be applied in context. The final project is a practical assignment where students must set up a database and then write queries using Structured Query Language (SQL) to solve given tasks, answering questions about the data contained in the database.
What are the benefits of a Professional Academy Diploma?
UCD Professional Academy Diplomas and Certificates are designed to give your career an advantage. Developed in conjunction with industry thought leaders our courses teach practical, applied skills to support you to achieve your career and business goals. Professional Academy Diplomas are suitable for career minded learners wishing to advance their professional skills and prospects rather than their academic credentials.
The Professional Academy is an independent wholly owned part of UCD designed to address the need for skills development in the workforce. Courses tend to be short, designed and delivered by industry practitioners, and are not part of nor do they lead to a traditional University award such as a degree or a masters. They are widely accepted by employers and many students are sponsored to study by their organisation.
For full details of UCD Professional Academy’s Certification & Governance please visit https://www.ucd.ie/professionalacademy/governance/
What payment options are available?
You can secure your spot on most of our Live Online, On-Campus, or On-Demand courses with a low 30% deposit. The remaining balance can be paid in two equal instalments (30 and 60 days later).
For full-time Bootcamp courses, you can secure your spot with a 50% deposit, with the remaining balance due prior to the start of your course.
Please note that standard terms and conditions apply, which you can review here: https://www.ucd.ie/professionalacademy/terms-and-conditions/
How do I get my Professional Academy Diploma?
Your UCD Professional Academy Diploma will be issued electronically on a secure platform, with a link that you can share with employers and others wishing to verify your credentials. You can also add this certification to your LinkedIn profile.
This Professional Academy Diploma is not on the National Framework of Qualifications as a credit-bearing course. This is not unusual for professional courses of this nature, where the need is for fresh and actionable skills immediately applicable in the workplace.