Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to Database Systems
Rating: 4.3 out of 5(201 ratings)
5,898 students

Introduction to Database Systems

Database Architecture, SQL, Normalization, ER Modeling
Created byBina Nusantara University, Lay Christian, Edi purnomo putra
Last updated 11/2021
English

What you'll learn

  • Student will recognize meaning of database, DBMS, component of DBMS environment, Advantages and disadvantages of DBMS, and three-level database architecture
  • Student will understand terminology of relational model and how to use Entity–Relationship (ER) modeling in database design
  • Student will understand the purpose of normalization, data redundancy, how to identify functional dependencies, the process of normalization
  • Student will understand data types supported by SQL standard, how to create a table and define integrity constraints using SQL
  • Student will understand how to update database using INSERT, UPDATE, and DELETE, how to retrieve data from one table and multiple table using SELECT

Course content

5 sections • 10 lectures • 1h 35m total length

  • Introduction to Databases12:04
  • Database Environment13:41
  • Introduction to Databases

Requirements

  • Students have basic knowledge of database

Description

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.

Who this course is for:

  • Student who wants to learn Database Systems

Report abuse