DATABASE FUNDAMENTALS

Learn the fundamentals of SQL for beginners as you build a database for a fictitious hardware store, covering customers, and stock and orders in this online SQL training course.
Follow the real-time videos to see exactly how to build a complex database and the methods used to extract meaningful information via queries, stored procedures, scalar functions and views.

BIG DATA

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

Anything to ask?

If you have any question about training, fees, courses or anything else, feel free to ask us anytime!


Address

Nexperts Academy Sdn Bhd,
Unit 313, Block E, Phileo Damansara 1, Jalan 16/11 off Jalan Damansara 46350, PJ Selangor, Malaysia

Working Hours

Monday Tuesday Wednesday Thursday Friday

09:00 - 17:30 09:00 - 17:30 09:00 - 17:30 09:00 - 17:30 09:00 - 17:30

Contact

Email: vaheed@nexpertsacademy.com
Phone: +6 011 1221 6872
Office: +6 03 7931 8872