Fundamentals of Database Management Systems

Fundamentals of Database Management Systems Training Courses

Informasi Jadwal training 2016, 2017, 2018, 2019, 2020, 2021 – JADWAL TRAINING / PELATIHAN / BIMTEK / DIKLAT / SEMINAR / WORKSHOP : Fundamentals of Database Management Systems – TERBARU BULAN  JANUARI/ FEBRUARI/MARET/APRIL/MEI/JUNI/JULI/AGUSTUS/SEPTEMBER/OKTOBER / NOVEMBER / DESEMBER , berikut ini Jadwal Training Fundamentals of Database Management Systems yang siap di registrasi dan akan diselenggarakan di berbagai kota besar di Indonesia, Lokasi Training Pilihan :  Yogyakarta, Bandung, Jakarta, Bali, Surabaya, Medan, Palembang, Lombok, Kupang, Balikpapan, Makasar, Malang, Batam, Semarang, dan berbagai kota besar lainnya di Indonesia.

Apabila Training/Pelatihan Fundamentals of Database Management Systems ini sesuai dengan kebutuhan Perusahaan anda, silahkan menghubungi Tim Marketing Kami untuk mendapatkan Informasi lengkap mengenai Jadwal penyelenggaran Training beserta Surat Penawaran, Silabus Training,  dan CV Instruktur, dengan menghubungi kami via telepon atau sms di nomor 0823 2326 5005 – 0857 2459 5005 (WA) , atau  mengirim surel di email kami trainingcenterindo@gmail.com / info@jadwaltraining.co.id .

Training Fundamentals of Database Management Systems

Description

Database management systems play an essential role in most modern transportation management, administrative, and control systems. Therefore, transportation professionals are often responsible for making design, development, operations, and maintenance decisions concerning database management systems. In addition, many transportation professionals are users of database management systems to support their responsibilities. Clearly, in order to effectively accomplish their mission, transportation professionals do not need to be database experts. However, a basic understanding of database management systems has become important.

This course emphasizes the importance of database design, use, and management to ITS. The module begins with a general description of databases and database management systems, including the relationships that exist among a database, a DBMS, and an application. Relational database tables, Entity-Relationship Models, and the role of metadata are discussed in detail. Finally, the module describes SQL, and explores the role of databases in data warehousing and Geographic Information Systems.

Course Objectives

Upon completion of the course, participants will be able to:

  • Explain how databases work
  • Describe how databases are designed
  • Recall how to work with databases to support decision making
  • Relate how databases are used for advanced applications, namely data warehousing and geographic information systems (GIS)

 

Audience

Transportation professionals who are ultimately responsible for the design, procurement, and operations of transportation systems that rely heavily on database management systems. The course is not intended for individuals with extensive database backgrounds, nor is it intended for individuals seeking to learn the “mechanics” of using a particular database package.

Course Outline

  1. Databases and DBMSs
    a. Data Management
    b. The Database
    c. The Database Management System (DBMS)
    d. Relationships
    e. Role of DBMSs in ITS
  2. How Databases Work
    a. Why Use a Database?
    b. Benefits of Relational Databases
    c. Relational Database Structure
    d. Relational Database Tables
    e. Relating Tables with Keys
    f. Knowledge Check: Relational DB Terms
    g. Normalizing Databases
    h. Relational Database Tutorial
  3. Database Design
    a. Why Is Database Design Important?
    b. Entity-Relationship Models
    c. E-R Models: Terms
    d. Entities
    e. Entity Attributes
    f. Sample E-R Diagram
    g. E-R Models Exercise
    i. Knowledge Check: E-R Model Terms
    j. Relationships
    k. Relationships: Diagramming
    l. Relationship Examples
    m. Designing a Database with E-R Diagrams
    n. Knowledge Check: Relationships
    o. Exercise
    p. Database Documentation/Metadata
  4. Working with Databases
    a. Structured Query Language (SQL)
    b. SQL Example
    c. SQL Functions
    d. More About SQL
  5. Data Warehousea. Introduction
    b. ITS Data Warehouse
    c. Data Warehouse: Other Features
    d. Key Issues Related to ITS Data Warehousing
    e. Strengths of Data Warehousing in ITS
    f. Strengths of Data Warehousing in ITS (cont’d)
    g. Strengths of Data Warehousing in ITS (cont’d)
    h. Strengths of Data Warehousing in ITS (cont’d)
    i. Weaknesses of Data Warehousing
  6. Geographic Information Systems (GIS)a. What Is GIS?
    b. Representing Spatial Location in a Database
    c. Spatial Coordinate Systems
  7. DBMS Vocabulary Review
  8. Course Summary

 

Investasi dan Fasilitas Training

  • Harga : (dilampirkan dalam Brosur penawaran)
  • Fasilitas : Certificate, Training kits, USB 8 GB, Lunch, Coffe Break, Souvenir, City Tour
  • Untuk peserta luar kota disediakan transportasi antar-jemput dari Bandara/Stasiun ke Hotel (berlaku bagi perusahaan yang mengirimkan minimal 2 peserta)
  • Quota minimum Running 2 peserta ( jogja ), 3 Peserta ( Solo, Semarang) Quota minimum Running 3 peserta (Jakarta , Bandung dan Surabaya ) –  ( Untuk Manado, Bali , Batam, Pontianak, Balikpapan dan Lombok Quota minimal 4 peserta)

 

Permintaan Brosur penawaran Training ( Waktu dan Tempat) silahkan Menghubungi kami via :

Mobile : 0823 2326 5005 – 0857 2459 5005

Email : trainingcenterindo@gmail.com / info@jadwaltraining.co.id

Blog : https://informasitrainingdanseminar.wordpress.com

Web: www.informasitraining-indonesia.com

Web www.jadwaltraining.co.id