SQL SERVER

do you know SQL Server??

Let's read..

SQL SERVER


1. SQL is an acronym or abbreviation of Structured Query Language.
2. SQL SERVER is a relational database management system (RDBMS) designed for applications with client / server architecture. The terms client, server, and client / server can be used to refer to very general or specific concepts of hardware or software. At a very general level.

So in general SQL Server is a Software created by Microsoft companies used to create a database that can be implemented for Client Server.
CLIENT is any component of a system that requests services or resources from other system components.
SERVER is any system component that provides services or resources to other system components.

Then in the previous sense there is the word RDBMS. Here's the explanation:
RDBMS stands for Relational Database Management System.
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in the RDBMS is stored in a database object called a table.

TABLE is a collection of related entry data and consists of columns and rows.

As mentioned above, SQL stands for Structured Query Language, which has the following functions:

  • SQL allows you to access and manipulate the database.
  • SQL can execute queries against the database
  • SQL can retrieve data from the database
  • SQL can insert data in the database
  • SQL can update data in database
  • SQL can delete data from the database
  • SQL can create a new database
  • SQL can create a new table in the database
  • SQL can create stored procedures in the database
  • SQL can combine multiple tables in a database
  • SQL can set permissions on tables, procedures, and more

Those are some of the functions of SQL, which may still be many other hidden functions

 Why you should learn SQL Server? :
1. SQL Server is a product of Microsoft, so if you use Windows, then programming language with Visual Studio, and your server using Windows Server OS that all use the product from microsoft it will be easy to configure the account and very kompability because it comes from the company the same one.
2. SQL Server Has Privileged Access or Access rights used to access the database on SQL Server. Therefore if you are using a domain on Server then SQL Server is very support with one login door can access many applications from microsoft products
3. For the World of Work SQL Server is widely used in large companies. For those of you who still sit in the world of school or college, working in large companies is a dream. So if a large company only uses SQL Server then if you can operate SQL Server the opportunity to get into the big company will open.


Just it, thank you..
Comment if you know more..

Komentar

Posting Komentar

Postingan populer dari blog ini

Sang Saka Merah Putih (The flag of the Republic of Indonesia)

Gambar
Sang Saka Merah Putih  (The flag of the Republic of Indonesia) The flag of the Republic of Indonesia, which is briefly called the State Flag, is Sang Saka Merah Putih, Merah Putih, Merah Putih, or sometimes called Sang Dwiwarna (two colors). The Red and White Country Flag is rectangular with the width of 2/3 (two-thirds) of the length and the top is red and the bottom is white with both sections the same size. The meaning of Color :  The flag of Indonesia has a philosophical meaning. Red means courage, white means holiness. Red symbolizes the human body, while the white symbolizes the human soul. Both complement each other and perfect the human body and soul to build Indonesia. In terms of history, since ancient times both red and white colors contain a sacred meaning. Explanation: The red color is similar to the color of Java sugar (palm sugar) and white color similar to the color of rice. These two ingredients are the main ingredients in Indonesian cuisine, e...
Baca selengkapnya

The meaning of traditional song (Bungong Jeumpa)

Gambar
Hi guys,.. Do you know about Bungong Jeumpa? the traditional songs of Aceh.. Let read.. BUNGONG JEUMPA "Bungong Jeumpa" is one of the traditional regional songs coming from the Aceh region. Some historians associate the song Bungong Jeumpa associated with Jeumpa Kingdom, Aceh, based on the Highlights of Radja Jeumpa written Ibrahim Abduh which he adapted from saga Radja Jeumpa. Jeumpa Kingdom is a kingdom that developed around the 7th century AD. Located around the hills, from the side of the river Peudada in the west to Pante Krueng Peusangan in the east. King Jeumpa's own palace is located in the village of Blang Seupeueng which is fenced in the north, now called "Cot Cibrek Pintoe Ubeuet". Lyrics of the song "Bungong Jeumpa" in Aceh Language : Bungong Jeumpa Bungong jeumpa, bungong jeumpa meugah di Acèh Bungong teuleubèh, teuleubèh indah lagoë na Putéh kunèng meujampu mirah Keumang siulah cidah rupa itu Lam sina ...
Baca selengkapnya