Introduction to Database Systems

Description

In this course, you will :

• Understand the definition of database, DBMS, DBMS components, DBMS advantages and disadvantages, and three-level database architecture
• Understand relational model terminology and how to apply Entity-Relationship (ER) modeling in database design comprehend the objective of normalization, data redundancy, how to detect functional dependencies, and the normalization process
• grasp the data types allowed by the SQL standard, how to create a table, and how to use SQL to specify integrity requirements
• grasp how to edit a database using INSERT, edit, and DELETE, as well as how to get data from one or more tables using SELECT

Syllabus:

• Introduction to Databases
• The Relational Model
• Normalization
• SQL – Data Definition
• SQL – Data Manipulation