Basic knowledge of Microsoft SQL Server

Basic knowledge of Microsoft SQL Server

Basic knowledge of Microsoft SQL Server! Part – 3
Basic knowledge of Microsoft SQL Server! Part – 3

Welcome to our portal; you can read articles online here related to Microsoft SQL Server from beginners to professionals. If you are looking for an easy and efficient way to learn and become master of SQL Server then absolutely you are in the right place. So let’s start Basic knowledge of Microsoft SQL Server

What is Data?

Data is information, which has some means that are efficient for movement or processing.

Example-

Ramesh, Suresh, Mobile, Address etc.

Whats is Database (DB)?

A DB (database) is a collection of data that is sorted and organized form so that its contents can easily be updated, managed, and accessed.

Example-

Name – Raghawendra Shukla, Mobile – 9793194706, Address – YC Space, Dwarka, Sec-13, New Delhi, Pin – 461001

What is Relational Database (RDB)?

An RDB (relational database) is a collection of data sets that are organized as a set of formally table form, which data can be easily accessed . A relational database uses the relational model during its creation.

Example-

Sr. No Name Mobile Address Pin
1 Raghawendra Shukla 9793254706 DRPL, Dwarka, Sec-21, New Delhi 461001
2 Shiv Shankar Shukla 9795525625 Indian Oil, Noida, Sector-15, UP 231223

What is Database Management System (DBMS)?

A DBMS (database management system) is a set of programs that enables us to extract, modify, and store information within the database. A DBMS provides users with tools to access, delete, modify, add, and analyze data that is stored in one location.

Example-

Notepad, WordPad, Fox-Pro, IMS, MSO Excel and MSO Access  etc.

What is Relational Database Management System (RDBMS)?

An RDBMS (relational database management system) is a DBMS that is based on the relational model. Many popular databases currently use are based on the relational database model.

Example-

Oracle, IBM DB2, Microsoft SQL Server, MySQL and PostgreSQL etc.

Difference between DBMS and RDBMS:

  1. In DBMS no relationship concepts but RDBMS is used to establish the relationship concept between two objects of a database like tables.
  2. DBMS supports single user only but RDBMS supports multiple users.
  3. DBMS treats data as files internally but RDBMS treats data as tables internally.
  4. DBMS satisfies 3 to 6 rules of Dr. Edgar F Codd out of 12 rules but RDBMS satisfies 8 to 10 rules of Dr. Edgar F Codd out of 12 rules.
  5. DBMS requires a low level of software and hardware configurations but RDBMS requires a high level of software and hardware configurations.
  6. In DBMS Notepad, WordPad, Foxpro, IMS, Excel, and Access are examples but in RDBMS Oracle, IBM DB2, Microsoft SQL Server, MySQL, and PostgreSQL are examples.

DATABASE OVERVIEW OBJECTS

There are basically 15 database overview objects in Microsoft SQL Server, mentioned below –

  1. Database
  2. Transaction Log   
  3. Tables
  4. File groups
  5. Diagrams
  6. Views
  7. Stored Procedures
  8. User-defined functions
  9.  Indexes
  10. CLR assemblies
  11. Reports
  12. Full-text catalogs
  13.  User-defined data types
  14. Roles
  15. Users

We will learn all these things step by step these in upcoming modules.

DATABASE OBJECTS

There are basically 4 database objects in Microsoft SQL server.

  1. Master
  2. Model
  3. Msdb
  4. Tempdb

Structure of Database

There are two types structure of a database like 1. Physical, 2. Logical.

Example:

Sr. No Physical Logical
1 Data Files DB Objects
2 Controls Tables
3 Logs Views
4   Synonyms
5   Sequences (Auto Increment, Identity)
6   Indexes
7   Procedures
8   Functions
9   Triggers

Whats is abbreviation of SEQUEL or SQL?

SEQUEL is an abbreviation for Structured English Query Language and SQL is an abbreviation for Structured Query Language. The original version called SEQUEL was designed by an IBM research center in 1974 and 1975 that’s why copyrights are under IBM of SQL/SEQUEL. Now SQL (Structured Query Language) is a domain-specific language used in programming and designed for managing data in an RDBMS (Relational Database Management System).

Language

There are two types of languages one is “How to Do (Procedural)” its example are – C, C++, .NET, JAVA, PHP, etc front end development and another is “What to Do (Non-Procedural)” its example is – OS Commands and RDBMS like Oracle, IBM DB2, Microsoft SQL Server, MySQL, and PostgreSQL, etc.

Restrictions in SQL

There are mainly three (3) types of restrictions in SQL mentioned below – 

  1. Single line query execution.
  2. Coding or programming not allowed.
  3. Not handles exceptions.

We will discuss up coming topics in next part. So please take care of you.

Assuming this tutorial post has well-acquainted aspiring to the complete requirement. If you want to download a PDF format file of this tutorial then please click here to download PDF.

Also requesting, if you have any ideas or suggestions for me or you need some important blogs/Videos or guidelines related to SQL Server, Excel, WordPress, SEO, Website technologies then please feel free to write me on below comment section or you can go through the Contact Page. I will definitely come back to you with your desired requirements.

Hope this tutorial post was helpful for you and you liked very well, I am happy to serve you better. If you liked really this tutorial post, please don’t forget to share on social media like – Facebook, Whatsapp, LinkedIn, Twitter, Instagram, etc.

Leave a Reply