SQL-TABLE OF CONTENTS

DATABASE DEVELOPMENT

Create, Alter, and Drop Database

Table in SQL Server

SQL INSERT INTO Statement

SQL FOREIGN KEY Constraint

SQL PRIMARY KEY Constraint

SQL NOT NULL Constraint

SQL UNIQUE KEY Constraint

SQL DEFAULT Constraint

SQL CHECK Constraint

SQL WHERE Clause

SQL IDENTITY Column

SQL HAVING Clause

SQL SELECT Statement

SQL SELECT DISTINCT Statement

SQL GROUP BY Clause

SQL DELETE Statement

SQL WHERE Clause

SQL UPDATE Statement

SQL SELECT INTO Statement

SQL JOINS

SQL TRUNCATE Statement

SQL OPERATORS

SQL STORED PROCEDURES

How to get day from date in SQL

How to get month from date in SQL

How to get year from date in SQL

How to modify date in SQL using DATEADD Function

DATABASE ADMINISTRATION

How To Create SQL Server Full Database Backup

How To Restore SQL Server Database From Backup

Export SQL Server Table Data To A Text File

Import Data From Text File to SQL Server Table

Export SQL Server Table Data To Excel (XLSX)

Import Data From Excel (XLSX) To SQL Server Table

How To Export SQL Table To Access Database

How To Import Access Database Table To SQL Server Table

How To Generate Database Script With Data

Recommended Readings