Home
Blog
Tutorials
- SQL
  - Database Development
  - Database Administration
Schools
Guest Post
Toggle website search

Home
Blog
Tutorials
- SQL
  - Database Development
  - Database Administration
Schools
Guest Post
Toggle website search

SQL-Database Development

Create Database
Create Table
Primary Key Constraint
Identity Column
Foreign Key Constraint
Unique Key Constraint
Default Key Constraint
Check Constraint
NOT NULL Constraint
Insert Statement
Select Statement
WHERE Clause
Distinct Statement
Select Into Statement
Delete Statement
Truncate Statement
Having Clause
Group By Clause
Joins in SQL
Stored Procedures in SQL
Find Nth Highest Salary
Date and Time Functions
Row_Number() Function
Get Day From Date
Get Month From Date
Get Year From Date
Modify Date
IN and NOT IN Operators

SQL-Database Administration

SQL Full Backup
Restore Full Backup
Export Table Data To Text File
Import Data From Text File
Export Table Data To Excel
Import Data From Excel
Export Table To Access Database
Import Data From Access Database
Generate Database Script
Create SQL Server Login
Create Database User
Change Schema Name
Public Server Role

Get all latest content delivered to your email a few times a month. Updates and news about all categories will send to you.

Email is required Email is not valid

Accept GDPR Terms This field is required

Thanks for your subscription.

Failed to subscribe, please contact admin.

Guest Post

Post Title

Post Content

Post Image

SeekTuts

SeekTuts main objective is to provide you quality education specially in computer science like Database Development and Administration, Servers Administration, and in other programming languages.

Newsletter

Leave this field empty if you're human:

Insert/edit link

Enter the destination URL

URL

Link Text

Open link in a new tab

Or link to existing content

Search

No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.