Introduction to Database
3.3 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
874 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Database to your Wishlist.

Add to Wishlist

Introduction to Database

Basic knowledge about database that appropriate to the requirement of organization
3.3 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
874 students enrolled
Last updated 8/2016
Indonesian
Price: Free
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
10 Lectures
01:04:38
+
Introduction to Database Environment
2 Lectures 13:00

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.

Introduction to Database
07:13

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
Database Environment
05:47

Introduction to Database Environment

Quiz for Section 1
2 questions
+
The Structural Database Design using SQL
3 Lectures 16:50

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.
Database Planning, Design, and Administration
05:57

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
SQL Data Definition
04:53

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
Security and Administration
06:00

The structural database design using SQL

Quiz for Section 2
3 questions
+
The Operation of Data Manipulation using SQL
2 Lectures 13:20

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 (Basic)
05:37

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
SQL Data Manipulation (Advanced)
07:43

The operation of manipulation data using SQL

Quiz for Section 3
2 questions
+
Database Analysis and Design
3 Lectures 21:28

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
Normalization
08: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
Entity Relationship Modelling
08:43

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
Enhanced Entity Relationship Modelling
04:02

Database Analysis and Design

Quiz for Section 4
3 questions
About the Instructor
Bina Nusantara University
4.2 Average rating
55 Reviews
3,573 Students
3 Courses

Bina Nusantara University (BINUS University) is a private university in Indonesia. The vision of BINUS University is a world-class university … in continuous pursuit of innovation and enterprise. The mission of BINUS University is to contribute to the global community through the provision of world-class education. BINUS University has 7 faculties and more than 30 programs for Undergraduate, Magister, and Doctorate level, 25000 students, and 6 campuses. Based on QS Stars ranking, BINUS University achieves 3 of 5 stars with ranking of number 11 in Indonesia (number 1 for private university) and number 301-350 in Asian.