Database and Its Applications Full Course | Introduction to Database Managment System

Database and Its Applications Full Course | Introduction to Database
Management System | Tutorial on SQL | E-R Model and Data Models

Data Base Applications 



Unit Introduction: This unit introduces the term database, its types,
and its advantages. It also focuses on basic structure and elements of
database. At the end provide solid concept of entities.



Unit No. 1 Database Foundation
Introduction, Data and Information, Components, Advantages
Data Association, Entities, Keys and Its Types, Attributes
Data Associations, Data Structure Diagram



Unit No. 2 E-R Model and Data Models
Basic constructs (Symbols), Degree of Relationships, Cardinality, and
Gerund
Modeling Time Dependent Data, Super Types, Sub types
Hierarchical, Network, Relational, Comparison of All Data Models
Relations, Characteristics of relation, Converting E-R Model into
Relation



Unit. No. 3 Normalization (1NF, 2NF, 3NF) 



Unit No. 4 Database Design (Conceptual Design, PhysicalDesign)



Unit No. 5 SQL Introduction
Introduction, Creating, Altering & Deleting Table
Inserting, Updating, & Deleting Rows, Querying the Tables
SQL Functions
Arithmetic, Group (Average, Count, Max, Min, Sum)
Date, Special Functions (In, Between, Like, Null)



Unit No. 6 Introduction to Forms
Form Components, Form Module, Blocks, Items, Objects, Object Navigator

Properties Window, Layout Editor



Unit No. 7 Basic Form Design
Using Wizard for Form Design, Customizing a Form
Defining Items
Buttons, Check Boxes, Display items, List Items, Radio Groups, Text
Items
Creating LOV, Crating Master Detail Form



Unit No. 8 Introduction to Reports
Report Design Consideration
Report Objects
Basic Report Design



Objectives

Unit No. 1
Importance of Database
Database Concepts
Various Architectures of Database
The Cost, Risk and Environment of Database Management System
Difference between Data & Information
The Concept of Entity, and Attributes
Various Types of Attributes
How Entities are recognized in an Entity Type
How various types are associated with one another?

Objectives of Unit No. 2
Architecture of entity relationship model
Various types of relationship
How the complexities of relationship are handled
Effect of cardinality in relationship
How multi value attributes are modeled
How time dependent attributes are modeled
Associative entity types are modeled
Hierarchical data model
Network data model
Relational data model
Why relational data model is in use?
The basics of database design

Tags: moddb, database software, database management system, what is database, database definition, types of database, online database, access database, relational database, dbms, oracle database, database query, database administrator, database schema, sql database, create database, database  management, database system, database design, database normalization, database examples, best database, database download, database search, database tutorial, uses of database, database as a service, sample database, relational database management system, microsoft database,