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 : 1333

Lesson / 13 Lesson facebook twitter

차시별 강의
No Document type Subject Categorization item Url source Copy
1. Document type webcontents Subject Categorization item
  • 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 source Copy
2. Document type webcontents Subject Categorization item
  • This material explains about developing data modeling skills, identifing basic Entity Relationship Model, components: entities, attributes, and relationships.
Url source Copy
3. Document type webcontents Subject Categorization item
  • This material explains about interpreting ERM to ERD, creating E-R diagrams as database blueprints.
Url source Copy
4. Document type webcontents Subject Categorization item
  • This material explains about Relational Data Model, Concepts of Relation, Keys
Url source Copy
5. Document type webcontents Subject Categorization item
  • This material explains about normalization techniques. 1NF, 2NF, 3NF
Url source Copy
6. Document type webcontents Subject Categorization item
  • This material explains about the concept of data storing in MySQL, defining the data types of database
Url source Copy
7. Document type webcontents Subject Categorization item
  • This material explains about the rules for entity integrity, creating/altering/dropping databases
Url source Copy
8. Document type webcontents Subject Categorization item
  • This material explains about SELECT Statement, Using Column Aliases Limit, Order.
Url source Copy
9. Document type webcontents Subject Categorization item
  • This material explains about complex SQL queries : Sub Queries, Join, Union, Group, Having, Aggreegation Functions.
Url source Copy
10. Document type webcontents Subject Categorization item
  • 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 source Copy
11. Document type webcontents Subject Categorization item
  • 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 source Copy
12. Document type webcontents Subject Categorization item
  • This material explains about Stored Procedures, Functions, and Triggers
Url source Copy
13. Document type webcontents Subject Categorization item
  • This material explains about SQL in Programming, SQL Injection
Url source Copy