This is part one of the Zero To Hero Series in MS SQL Server. This is mainly focused on beginners who are into MS SQL Server and also for experienced developers who want to freshen up their knowledge for interviews and daily technical work. The examples in this article series will be connecting us with the real-time project. For the real-time project, we will consider a Student Management System application as an example. At the end of this article series, you will be able to know how the real-time project’s database is created and managed. The following are the topics of this series:
- Database Management System
- Types of DBMS
When I was preparing for my next job move a few months ago, I started to prepare notes on SQL. And I thought to share those notes with you all since it will be useful for beginners and experienced persons to freshen up their knowledge of SQL. Before getting into core SQL concepts, let’s begin with the basic concepts.
What is Data?
Before getting into the database, let’s talk about data. Data can be facts related to any object in consideration. For example, a number of classrooms, students, benches, staff, etc are the data related to an institution.
What is a Database?
We already know what data is. A Database is a systematic collection of data. Since the data is organized so that it can be easily accessed, managed, and updated, data is organized into rows, columns, and tables.
What is a Database Management System?
A Database Management System (DBMS) is a collection of programs that enables its users to access the database, manipulate data, and helps in the representation of data. It also helps control access to the database by various users. Let’s consider our community of CSharp Corner as an example. It needs to store, manipulate, and present data related to community members, their friends, members’ activities, articles, blogs, events, chapters, and lot more.
Types of Database Management Systems
There are four major types of the Database management system,
- Navigational Database Management System
- Rational Database Management System
- SQL Database Management System
- Object-Oriented Database Management System
Regarding the types of DBMS, You will learn more details in future articles.
What is SQL?
Structured Query Language (SQL) pronounced as “See-Quel” is the standard language for dealing with Relational databases. SQL can be effectively used for CRUD (Create, Read, Update, Delete ) operations in database records. SQL can also go beyond this, as help in optimizing and maintenance of database and much more. So now the question is, where to write the SQL syntax or statement? Databases like MS-SQL Server, MySQL, Oracle are some of the Relational Databases and here we can write SQL Syntax or statements. Almost all the SQL syntax used among the databases are similar.