SQL Master - Part One
This is part one of SQL Master Series in MS SQL Server. This is mainly focused for beginners who are into MS SQL Server and also for experienced who want to fresh up for interviews and daily technical works.
Introduction
This is part one of the "SQL Master" 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. By the end of this article series, you will become an expert in MS SQL queries and the example in this article series will be related to the Real-Time project. The following are the topics of this series:
This is part one of the "SQL Master" 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. By the end of this article series, you will become an expert in MS SQL queries and the example in this article series will be related to the Real-Time project. The following are the topics of this series:
- Background
- Data
- Database
- Database Management System
- Types of DBMS
- SQL
- Conclusion
Background
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, member's activities, articles, blogs, events, chapters and lot more.
Types of Database Management Systems
There are four major types of the Database management system,
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, member's 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.
Conclusion
In this article, we have learned some basic concepts about the database and SQL. In future write-ups, you will learn more details about SQL concepts. I hope this was helpful, and please share your feedback in the comment section.
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.
Conclusion
In this article, we have learned some basic concepts about the database and SQL. In future write-ups, you will learn more details about SQL concepts. I hope this was helpful, and please share your feedback in the comment section.
