Skip to Contents

Database Management System

  • Add Bookmark
    • Category : Engineering > Computer Science
    • Keyword : Database,DBMS,Database System,Database Model,Data management
    • Taught by : LAY Leangsros
    • Created By : National Institute of Posts Telecommunications and ICT
    • Offered By : ASEAN Cyber University
    • Date Added : 2017.09.15

    This course is designed to teach students to designand implement databasesIt covers principles and methodologies of database designand techniques for database application developmentThis course instructs the student in the essential concepts and design methodology for the Relational Database Modeldatabase normalizationData Definition Languagethe Data Manipulation Languageand Data control.

    Creative Commons License
    This work is licensed under a
    Creative Commons
    Attribution 4.0
    International License
    .
    • User Rating :
    • Comments : 0
    • Hits : 1512

13 Lesson facebook twitter

차시별 강의
No Contents Type & Play Subject Description URL
1. Type webcontents Subject Description
  • This material explains about notion of database system Architecture for a database system Explain the advantages and disadvantages of store data in file and database Different Type of Database
Url
URL
2. Type webcontents Subject Description
  • This material explains about developing data modeling skills, identifing basic Entity Relationship Model, components: entities, attributes, and relationships.
Url
URL
3. Type webcontents Subject Description
  • This material explains about interpreting ERM to ERD, creating E-R diagrams as database blueprints.
Url
URL
4. Type webcontents Subject Description
  • This material explains about Relational Data Model, Concepts of Relation, Keys
Url
URL
5. Type webcontents Subject Description
  • This material explains about normalization techniques. 1NF, 2NF, 3NF
Url
URL
6. Type webcontents Subject Description
  • This material explains about the concept of data storing in MySQL, defining the data types of database
Url
URL
7. Type webcontents Subject Description
  • This material explains about the rules for entity integrity, creating/altering/dropping databases
Url
URL
8. Type webcontents Subject Description
  • This material explains about SELECT Statement, Using Column Aliases Limit, Order.
Url
URL
9. Type webcontents Subject Description
  • This material explains about complex SQL queries : Sub Queries, Join, Union, Group, Having, Aggreegation Functions.
Url
URL
10. Type webcontents Subject Description
  • This material explains about data Control Language Exporting and Importing Database, managing access control of user Explain the index and view Indexing for Performance
Url
URL
11. Type webcontents Subject Description
  • This material explains about Workbench and phpMyAdmin , Forward Engineering to generate DDL from data models to create physical database objects. , Creating objects directly to database or export to script.
Url
URL
12. Type webcontents Subject Description
  • This material explains about Stored Procedures, Functions, and Triggers
Url
URL
13. Type webcontents Subject Description
  • This material explains about SQL in Programming, SQL Injection
Url
URL