HTML

Home
Basics Elements and Attributes Headings and Paragraphs Styles and Colors Class and ID Attribute Quotation and Formating Elements Forms Tasks
Introduction CSS Types pseudo class Table with Styles Overflow Properties Display Properties Position Property Line-Height&Letter-Spacing Periodic Table
Introduction Display Properties Identifiers Operators String Methods Array Functions Object Event Handling Dialog Boxes Calculator Design
Introduction Basic Sql Alter and Tables Constraints Insert and Select Operators Joins Group by&Union Backup Exception Handling Views&User Defined Functions Company Database
Introduction Variables & Operators Conditional & Looping Statements Functions & String Expressions Pointers & Recursion Array & Files Patterns
Introduction
Configuration Introduction Sql
MasterDev
Data:
  • Data is nothing but a piece of information which includes text,images,audios and videos.
  • When ever the data is processed,structured or organized in a meaningful format then that is called information.
Database:
  • A database is a collection of information. which is stored in a structured format which can easily accessed,updated,managed and deleted.
DBMS:
  • DBMS stands for Data Base Management System.
  • It is a software which is used to create update retrieve and delete the data.
  • It also allows the users to store,access and manipulate the data easily.
We have four types of DBMS
 1.Hierarchical Dbms: It stores the data in a binary tree format.
 2.Network Dbms: It is also like hierarchical dbms but it is having many to many relationship.
                               Each child can have more than one parent.
 3.Relational Dbms: It stores the data in rows and columns(table) format.
 4.Object oriented Dbms: It supports the creation and modeling of data as objects.

RDBMS:
  • RDBMS stands for Relational Data Base Management system.
  • It store the data in tuples (table) format.
  • Each table contains a unique primary key.Tables can related to another table.
Types of RDBMS:
We have different types of relational databases.
 1.My Sql:
  •   It is free and open source.
  •   It runs on 20 platforms like Windows,Linux,Unix and Mac os.
  •   It consits of a multi threaded sql servers.That means it supports multiple back ends and different client programs.
  •   It is reliable,scalable and very fast to use.
2.Oracle
  •     It is a database commonly used for running Online Transaction Processing.
  •     It is the first database designed for enterprise grid computing.
  •     It supports for very large databases.
3.Ms sql server:
  •    It is a free software.
  •    It uses transaction or T-sql language.
  •    It is a software which may run on same computer or on another computer across a network.
4.Sybase:
  •    It is a relational database management server.
  •    It is the first enterprise database for linux.
5.IBM DB 2:
  •    It is a product from IBM.
  •    DB2 product is executed with the support of Object-Oriented features.
  •   DB2 products are offered for UNIX-based systems and personal computer operating systems 


Subscribe to: Posts (Atom)