DMA

Understand concepts of Data and storage of data. This course is aimed to impart knowledge about storing data, concepts of database, retrieval of data and manipulation of data. It is aimed to cover effective storage of data, statistical analysis of data and graphical presentation of data. It also covers concepts of database and fundamental of query languages to insert, access, and manipulate data. This course is not spreadsheet or database specific.

Share WhatsApp

Course Overview

• Concepts of worksheet:

• Formulas, Chart and Data

• Database characteristics

• Database Models

• Types of keys

• Why normalization

• Normalization Rules

• Concepts of Structure Query Language (SQL)

• DDL Statements

• DML and DQL(Data Query Language) Statements

• Using where clause and operators with where clause

• Constraints ( Table level and Attribute Level)

• SQL Functions

• Creating sequence

• Views