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.
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