SQL Server Mentalist

Hi friends

Continuing from my last post on same series

BISQL # 69–Laymen to SQL Developer # 1 – Introduction to brand New SQL Server Zero to Basics Series « SQL Server Mentalist

As this is just beginning for our brand new series and before digging into actual depth of SQL Server lets understand and form base ground to SQL Server

In this Assignment we will cover most of Only Database side I mean Database means any Database so don’t get confused .
Question Covered in this post are

• What is IT – Information technology and its components.
• What is DATA
• Definition of Database.
• Definition of Database Management .
• Definition of Database Management System.

Following question are present in all 1st assignment

Following are my complete question list for 1^st Assignments

1 – Definition of Database Management (also Definition of Database)

• What is IT – Information technology and its components.
• What is DATA

2 – Definition of Database Management System

3 – Limitation of File Processing System

{Covering following points  Data Redundancy , Data Isolation, Accessing Data, Integrity, Atomicity, Concurrent Access ,Security }

4 -Data Abstraction

5 -Data Independence

6 -Instance Schema

7 -Data Model(ER , Relational)

8 -Database Language -DDL,DML

9 -Users of Database

10 -Storage Manager

11 -Database System Architect

What is IT – Information technology:??

• People
• Procedures
• Software
• Hardware
• Data

Now what are Above five terms and basic info for them

PEOPLE are an essentials part of system. The purpose of information system is to make people, or end users like you, more productive.

PROCEDURES are rules or guidelines to follow when using software, hard ware, and data. They are typically documented in manuals written by computer professionals.

SOFTWARE (programs) provides step-by step instructions to control the computer to convert data into information.

HARDWARE consists of the physical equipment. It is controlled by software and processes data to create information.

DATA consists of unprocessed facts including text, numbers, images, and sound. Information is data that has been processed by the computer.

Connectivity is an additional part to today’s information systems. It allows computers to connect and share information. To be computer competent, end users need to understand information technology (IT).

What is DATA ?

Data is raw,unprocessed facts,including text,numbers,images and sounds.

Four common types of data

1. Document files
2. Worksheet files
3. Database files
4. Presentation files

Document files

• created by word processors to save the document

Worksheet files

• created by electronic spreadsheets to analyze things like budget.

Database files

• created by database management programs to contain highly structured and organized data.

Presentation files

• created by presentation graphics programmers to save presentation materials like Microsoft Power Point.

Lets start Understanding what is Database (Few reference are from Wikipedia..)

What is Database ?

A database is an organized collection of data for one or more purposes, usually in digital form.

The term "database" may be narrowed to specify particular aspects of organized collection of data and may refer to the logical database, to physical database as data content in computer data storage or to many other database sub-definitions.

Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, PostgreSQL, MySQL and SQLite. A database is not generally portable across different DBMS, but different DBMSs can inter-operate to some degree by using standards like SQL and ODBC to support together a single application.

What is Definition of Database Management ?

A database is an application that manages data and allows fast storage and retrieval of that data.

There are different types of database but the most popular is a relational database that stores data in tables where each row in the table holds the same sort of information. In the early 1970s, Ted Codd, an IBM researcher devised 12 laws of normalization. These apply to how the data is stored and relations between different tables.

SQL is a simplistic programming language that is used in relational databases.

What is Definition of Database Management System?

Also known as DBM In short, a DBMS is a database program. Technically speaking, it is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs.

Some DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro. Since there are so many database management systems available, it is important for there to be a way for them to communicate with each other. For this reason, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program’s proprietary syntax into a syntax other databases can understand

From Wiki :A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and the use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists.

Hope you like it and enjoy learning !!

Thanks for visiting my blog !!

Hope you will like this Laymen to SQL Developer series !!

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Link Resource Website