NEXPERTS ACADEMY 

GET THE RIGHT CERTIFICATION

Live Online Training 
Classroom Training 

Online Training 

Learning is now made easy with the advancement of technology. In Nexperts Academy, we engage and collaborate with industry experts and committed trainers to provide quality training with best user experience.

Learn from anywhere with our most flexible training hours

DATABASE COURSE

COURSE OUTLINE

DATABASE FUNDAMENTALS


This subject introduces students to the fundamentals of effective database systems. Students are taught how data is structured and managed in an organisation in a way that can be used effectively by applications and users. They also learn to use the language SQL for effective data retrieval and modification. This subject teaches students to appreciate the significance and challenges of good database design and management, which underpin the development of functional software applications. 


Upon successful completion of this subject students should be able to:

• Explain the main issues related to the design and use of structured data.
• Construct conceptual and logical data models applying database design principles.
• Evaluate data redundancy levels and their impact on database integrity and maintainability.
• Construct conceptual data models applying data modeling principles.
• Construct logical data models adhering to data normalization principles.
• Distinguish between good and bad database design
• Construct efficient SQL queries to retrieve and manipulate data as required. 


The Role of Databases in Information Systems
The Relational Data Model
SQL: simple queries, aggregate functions, data modification statements, simple joins, complex joins, sub queries and set operators
Conceptual database design (ER modeling)
Logical design: ER conversion to a relational model
Normalization

Lorem Ipsum dolor sit amet, consectetur adipisicing elit. Voluptate veniam accusamus eaque recusandae modi velit a praesentium ipsa animi facilis repellendus magnam aliquam, numquam debitis fuga laboriosam, quos aut adipisci.