This is an introductory tutorial to Database fundamentals. In this tutorial, you will learn how to plan and create databases for your applications.
Topics that will be covered are:
Database - Database Attributes
- Entity Relation
Database - Database Mapping
- Relational Data Model Database - Relational
Constraints
Database - Modeling
What is data?
In simple words, data can be facts related to any object under consideration. For example, your name, age, height, weight, etc. are some data related to you. A photo, image, file, pdf, etc. can also be considered data.
Some more practical examples:
An online phone book uses a database to store data about people, phone numbers, and other contact details.
Your electricity service provider uses a database to manage billing, customer related issues, handling fault data, etc.
Also consider Facebook. It needs to store, manipulate and present data related to members, their friends, member activities, messages, advertisements and much more.
We can provide numerous examples of database usage.
What is SQL?
SQL is the standard language for dealing with relational databases. SQL can be used to insert, search, update and delete records from the database. SQL can perform many other operations, including database optimization and maintenance.
SQL stands for Structured Query language, pronounced as "SQL" or sometimes as "See-Quel"... Relational databases like MySQL database, Oracle, MS SQL Server, Sybase, etc. use ANSI SQL.
Post a Comment
0Comments