SQL Basics

In this SQL tutorial, we will learn the basics concepts of SQL Server such as DDL and DML operations to select, insert, update, create, delete, retrieve and manipulate data in the SQL Server.

CREATE, ALTER, AND DROP DATABASE IN SQL SERVER

Last updated on April 23rd, 2020 at 08:57 am

In this article, we will discuss how to Create, Alter, and Drop a database in SQL Server.
In my previous article, we have discussed all about the Types of SQL Commands.

Database Introduction

 Database  : In the SQL server a database is a place to store the data in an electronic format. It is an organized collection of database objects such as tables, views, functions, stored procedures, triggers and so on.
It allows a user to easily access or manipulate the data.

SQL server database

Create Database In SQL Server

In SQL Server, there are two ways to create a user-defined database, either by using the Transact-SQL statements or by using SQL Server Management Studio.

Read more >>

5 Types of SQL Commands: DML, DDL, DCL, TCL, DQL with Query Example

Last updated on December 23rd, 2022 at 01:40 am

There are five SQL commands supported in the SQL programming language to perform various database operations such as DML, DDL, DCL, TCL, and DQL commands.

SQL Commands

  • SQL commands are instructions that are used to communicate with the database. They are also used to perform specific tasks, functions, and queries on the data.
  • SQL commands allow you to do things like create a table, add data to tables, drop the table, modify the table, and set permissions for users.
image-types of SQL Commands
Types of SQL Commands

Read more >>

  1. Pages:
  2. 1
  3. 2