

Database Fundamentals
Course Overview
Course Content
5 modules · 22 topics01Module 1: Understanding Core Database Concepts6 topics
- Understand how data is stored in tables
- Understand relational database concepts
- Understand data manipulation language (DML)
- Understand data definition language (DDL)
- Understand how SQL can be used to create database objects, such as tables and views
- Estimated Time Duration for this Topic
02 Module 2: Creating Database Objects5 topics
- Choose data types
- Understand tables and how to create them
- How to create views (just an overview)?
- How to create stored procedures and functions (just an overview)?
- Estimated Time Duration for this Topic
03 Module 3: Manipulating Data5 topics
- Select data
- Insert data
- Update data
- Delete data
- Estimated Time Duration for this Topic
04Module 4: Understanding Data Storage4 topics
- Understand normalization
- Understand primary, foreign, and composite keys
- Understand indexes
- Estimated Time Duration for this Topic
05Module 5: Administering a Database2 topics
- Understand database security concepts
- Understand database backups and restore
Schedule Dates
4 upcoming batches| Batch Dates | Duration | Batch Options | Language | Action |
|---|---|---|---|---|
| 28 December 2026 - 30 December 2026 | 3 Days | 8 hours & 4 hours | English / Arabic | |
| 29 March 2027 - 31 March 2027 | 3 Days | 8 hours & 4 hours | English / Arabic | |
| 05 July 2027 - 07 July 2027 | 3 Days | 8 hours & 4 hours | English / Arabic | |
| 11 October 2027 - 13 October 2027 | 3 Days | 8 hours & 4 hours | English / Arabic |
Can’t find a suitable date? Request a schedule that fits your team.
Request More InformationFAQs
Who is this course intended for?
This course is designed for individuals starting their career in database administration or development, particularly those interested in Microsoft technologies.
What are the prerequisites for enrolling in this course?
No specific prerequisites are required, but basic computer literacy and an understanding of fundamental IT concepts will be beneficial.
What skills will I gain from this course?
You will learn to:
- Understand core database concepts and relational database theories.
- Create and manage database objects using SQL.
- Manipulate data through selection, insertion, updating, and deletion.
- Implement data storage techniques like normalization and indexing.
- Administer databases, including security, backups, and restoration.
Will there be hands-on exercises?
Yes, the course includes practical exercises and hands-on labs to apply the concepts learned and gain real-world experience.
How does this course benefit my career?
This course provides foundational skills in database management, preparing you for advanced studies or entry-level positions. It enhances your technical knowledge and makes you a valuable asset in the field of database management.
How can I enroll in the course?
You can enroll by visiting the CounselTrain website and following the registration process. For further assistance, you can contact our support team.
Flexible Training Options to Meet Your Needs
Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.
Select the method that best suits your needs.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.
Learn moreHighlights
Classroom Training
Participate in interactive, face-to-face training in our top 5-star training facilities in Dubai.
Learn moreHighlights
Onsite Training
Learn a customised curriculum in your workplace to ensure the most impact and team participation.
Learn moreHighlights
Overseas Training
Participate in our international training sessions and improve your abilities with world-class instructors.
Learn moreHighlights
Related Courses
Other courses in the same category that might interest you.


55246-A: SQL 2016 AlwaysOn High Availability
View Course
Designing Database Solutions for Microsoft SQL Server 2014 from Microsoft
View Course
