Introduction to Database Systems
Database Architecture, SQL, Normalization, ER Modeling
★★★★★ 3.1
(60 reviews)
2 hours of content
What you'll learn
- 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
Introduces database concepts, relational modeling, normalization, and SQL for data definition and manipulation. Learners can design relational schemas and write basic SQL queries.
Who this course is for
For students and developers starting with relational database theory and SQL.
#database
#sql
#normalization
#er-modeling
#dbms
#relational-model