For an instructor lead, in-depth look at learning SQL click below.
SQL Server is one of the most popular relational database management systems (RDBMS) used in modern computing. As the backbone of a multitude of applications and websites, understanding SQL Server administration is key for anyone in IT, data science, or any field that handles data. This post will guide you through some of the basics of SQL server administration.
What is SQL Server?
SQL Server is a RDBMS created by Microsoft. It is used to manage and store information in a structured way. This is done through the use of tables that can be connected through common data, an appealing trait when handling large amounts of interrelated data.
Getting Started With SQL Server Management Studio (SSMS)
The SSMS is the main interface for SQL Server administration. Here you can manage, configure and access all data within your SQL server.
Example: How to Connect to a Database
|
1 2 3 4 5 |
--Connecting to a Database USE YourDatabaseName; GO |
The USE statement is used to select which database you want to connect to, and GO tells the server to execute the command that precedes it.
Example: Querying data
SQL language revolves around the idea of querying databases for specific information. Here’s an example of how you’d do that:
|
1 2 3 4 |
--This is your basic SELECT statement SELECT * FROM Students; |
In this sample code, ‘*’ means ‘everything’, so you are selecting everything from the ‘Students’ table.
Server Administration Basics
As a SQL Server administrator, there are several basic tasks such as creating a database, creating tables, inserting data and retrieving data.
Example: Creating a Database
|
1 2 3 4 |
--Creating a Database CREATE DATABASE School; |
After executing the above statement, a new database named ‘School’ will be created in your SQL Server.
Example: Creating a Table
|
1 2 3 4 5 6 7 8 9 10 11 12 |
--Creating a Table USE School; CREATE TABLE Students ( StudentID int, StudentName varchar(255), Age int, Address varchar(255), Marks int ); |
This statement will create a new table named ‘Students’ in your School database.
Example: Inserting Data
|
1 2 3 4 5 |
--Inserting Data into Table INSERT INTO Students VALUES (1, 'John Doe', 17, '123 ABC Street', 85); |
This will insert a new row in the ‘Students’ table.
Finally, remember that learning SQL Server administration is not a sprint, it’s a marathon. It might take some time, but with consistent practice, you’ll master the art of SQL Server administration.
`