Introduction to Database Systems

Database Architecture, SQL, Normalization, ER Modeling
Free tutorial
Rating: 3.3 out of 5 (14 ratings)
1,937 students
1hr 36min of on-demand video
English

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

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

Instructors

Fostering and Empowering
Bina Nusantara University
  • 4.4 Instructor Rating
  • 12,383 Reviews
  • 190,109 Students
  • 257 Courses

Bina Nusantara University (BINUS University) adalah universitas swasta terbaik di Indonesia. Visi dari BINUS University adalah "A World-class university, fostering and empowering the society in building and serving the nation". Misi dari BINUS University adalah "to build the nation and to contribute in global community development by providing world class education". BINUS University memiliki 7 fakultas dan lebih dari 40 program untuk tingkat Sarjana, Magister, dan Doctorate, 30000 mahasiswa, dan 9 kampus. Berdasarkan QS Stars ranking, BINUS University telah mencapai 5 dari 5 bintang dengan peringkat 7 di Indonesia (peringkat 1 untuk universitas swasta), peringkat 227 di Asia, dan top 1000 di dunia.



Bina Nusantara University (BINUS University) is the best private university in Indonesia. The vision of BINUS University is "A World-class university, fostering and empowering the society in building and serving the nation". The mission of BINUS University is "to build the nation and to contribute in global community development by providing world class education". BINUS University has 7 faculties and more than 40 programs for Undergraduate, Magister, and Doctorate level, 30000 students, and 9 campuses. Based on QS Stars ranking, BINUS University achieves 5 of 5 stars with ranking of number 7 in Indonesia (number 1 for private university), number 227 in Asia, and top 1000 in the world.

Lecturer Specialist S2 in Binus University
Lay Christian
  • 4.1 Instructor Rating
  • 65 Reviews
  • 3,271 Students
  • 5 Courses

Always learning. Interest in the world of data, still need to learn a lot in statistics. I'm lecturer in Binus University about Database, Data Warehouse, Data Visualization and more about data. Before Lecturer Specialist, I was teaching for Programming Laboratory to teach programming code, like C, Java, HTML, CSS, PHP, Javascript.

Database Management Specialist
Edi purnomo putra
  • 4.1 Instructor Rating
  • 92 Reviews
  • 3,495 Students
  • 5 Courses

Edi Purnomo Putra is a Lecturer Specialist in School of Information System, Bina Nusantara University.  The main scope of his knowledge is in the area of data modeling, data management, data analyst, data science and programming. His research interests are in Database System, Data information management, Data warehouse, E-Learning, Business intelligent, Big Data Analysis and data visualization.

Top companies trust Udemy

Get your team access to Udemy's top 15,000+ courses