Introduction to Database (Indonesian Version)

Name: Introduction to Database (Indonesian Version)
Rating: 4.4 (101 reviews)

Basic knowledge about database that appropriate to the requirement of organization

Created byBina Nusantara University, Tanty Oktavia

Last updated 2/2018

Indonesian

Indonesian [Auto],

What you'll learn

Learn about the purpose and origin of database architecture
Define integrity enhancement feature of SQL and identify the scope of database security
Explain the purpose and importance of SQL and build SQL statement
Identify the main stages of the database system development lifecycle (DSDLC) and describe the main phases of database design

Course content

4 sections • 10 lectures • 1h 4m total length

Introduction to Database7:13
This lecture explains about introduction of database, differentiation between file-based system and database system, why we should move from file-based to database system, the importance of database system, and major components of the DBMS environment.
Database Environment5:47
This lecture explains about database technical environment, the function of DBMS, and three level of architecture.
Three levels of architecture consist of:
External level
Conceptual level
Internal levels
Quiz for Section 1

Database Planning, Design, and Administration5:57
This lecture explains the planning, design, and administration of database. It also explains main stages of the database system development life-cycle.
Database life-cycle consists of:
Database planning
System definition
Requirements collection and analysis
Database design
DBMS selection (optional)
Application design
Prototyping (optional)
Implementation
Data conversion and loading
Testing
Operational maintenance.
SQL Data Definition4:53
This lecture explains SQL data definition and the integrity constraint using SQL.
Integrity constraint consists of
Required data
Domain constraints
Entity integrity
Referential integrity
General constraint
Security and Administration6:00
This video explains the types of threat that can affect a database system and how to protect a computer system using computer based control.
Database security involves measurement to avoid:
Theft and fraud
Loss of confidentiality (secrecy)
Loss of privacy
Loss of integrity
Loss of availability
Quiz for Section 2

SQL Data Manipulation (Basic)5:37
This lecture explains about basic technical to manipulate (update) database using SQL statement.
The basic SQL statements for updating database are:
INSERT
UPDATE
DELETE
SQL Data Manipulation (Advanced)7:43
This lecture explains about advanced technical to manipulate (aggregate) database using SQL statement.
The advanced SQL statements for aggregating database are:
COUNT, SUM, AVG, MIN, MAX
JOIN, UNION, INTERSECT, DIFFERENCE/EXCEPT
Quiz for Section 3

Normalization8:43
This lecture explains about the functional dependencies and normalization using functional dependencies to group attributes.
The process (level) of normalization consists of:
1NF
2NF
3NF
BCNF
4NF
5NF
Higher normal forms
Entity Relationship Modelling8:43
This lecture explains about the Entity Relationship (ER) modelling in database design and how to resolve problem with ER model by using 3 types of key:
Candidate Key
Primary Key
Composite Key
Enhanced Entity Relationship Modelling4:02
This lecture explains about the limitations of the basic concepts of the Entity Relationship (ER) model and the requirements to represent more complex applications. ER model is divided into 2 type of class:
Superclass: that includes one or more distinct sub-groupings of it occurrences
Subclass: a distinct of sub-grouping of occurrences of an entity type
Quiz for Section 4

Requirements

Download and install DBMS, such as SQL Server or MySQL.

Description

This course introduces concept and terminology in database system, like architecture database, relational model, database planning, normalization technique, ER Modeling, Structure Query Language (SQL), security issues in database environment, and database technologies like Online Transaction Processing concept. It gives student basic knowledge about how to create dan modifies tables that appropriate to the requirement of organization.

Please note that the language used in this course is Indonesian. We are working to translate it into English.

Who this course is for:

This course is meant for students who want to learn basic database and SQL syntax. This course is probably not for students who want to learn advanced and complex database.

Introduction to Database (Indonesian Version)

What you'll learn

Explore related topics

Course content

Introduction to Database Environment2 lectures • 13min

The Structural Database Design using SQL3 lectures • 17min

The Operation of Data Manipulation using SQL2 lectures • 13min

Database Analysis and Design3 lectures • 21min

Requirements

Description

Who this course is for: