Database Architecture, SQL, Normalization, ER Modeling
In computing, a database is an organized collection of data stored and accessed electronically from a computer system. Where databases are more complex, they are often developed using formal design and modeling techniques.
The database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum of the total in the database, the DBMS and the associated applications can be referred to as a “database system”. Often the term “database” is also used loosely to refer to any of the DBMS, the database system or an application associated with the database.
This course introduces concepts and terminologies in database system, like database architecture, relational model, Structured Query Language (SQL), security issues in database environment, normalization technique, ER modeling, and database technologies like Data warehouse concept. It gives student basic knowledge about how to create and modify tables that appropriate to the requirements of organization.
The content format for this course mainly learns from video and take a quiz to assessment knowledge for the course. Total duration for this course is one hour. Short enough for the duration of the learning time, compact and simple to understand.