The SQL Server (Structured Query Language) is the set of instructions used to interact with a relational database. SQL statements are aimed to Insert, Update or Manipulate, and Extract data from the Relational Database Management Systems.
SQL Server
- Install Software
- Install Adventure Works Database
- Create, Rename, and Delete a Database
- Create Table
- ALTER Table
- SELECT Statement
- WHERE Clause
- ALIAS Column
- Order By Clause
- TOP Clause
- Select Distinct Statement
- Select Into Statement
- Insert Into Select Statement
- Insert Statement
- Update Statement
- Delete Statement
- Truncate Table
- Group By Clause
- Having Clause
- Bulk Insert Statement
- Query Builder
- Pivot
- UnPivot
- Merge
- SubQuery
- CASE Statement
- Common Table Expressions (CTE)
- Coalesce
- IS NULL
- IS NOT NULL
- Local and Global Temporary Tables
- Table Variable
- Derived Tables
Data Type
Constraints and Indexes
- Primary Key
- Foreign Key
- Check Constraint
- Default Constraint
- Unique Constraint
- Clustered Index
- Non Clustered Index
- Filtered Index
Joins
Operators
- And & Or Operators
- Arithmetic Operators
- Between Operator
- Comparison Operators
- Exists
- Except
- Intersect
- In Operator
- Like Operator
- Not Exists
- Not In Operator
- Union
- Union All
Decision Making Statements
- If Else Statement
- Else If Statement
- While Loop
- Nested While Loop
- Break Statement
- Continue Statement
- Goto Statement
- IIF Function
- Choose Function
SQL Advanced
- Change Data Capture
- Try Catch
- Views
- User Defined Functions
- Stored Procedures
- Introduction to Stored Procedures
- Select Statement Inside the Stored procedure Example
- Insert Statement Inside the Stored Procedure Example
- Update Statement within the Stored Procedure Example
- Input Parameters in a Stored Procedures
- Output Parameters in a Stored Procedure
- Return Values in a Stored Procedure
- Useful System Stored Procedures
- Triggers
- Cursors
- Tranasctions
SQL Server Management Studio
- Management Studio (SSMS) Introduction
- Install Management Studio (SSMS)
- Uninstall Management Studio (SSMS)
- Create Login – SQL Server Authentication
- Create Windows Login
- Creating Server Roles
- Back Up Database
- Maintenance Plan
SQL Server Built-in Functions
Following are the built-in functions available in T-SQL Server 2014
Ranking Functions
The List of available Ranking functions are:
Mathematical Functions
The following are the list of mathematical function in SQL Server
String Functions
The following are the list of available string function in SQL Server:
- Introduction
- ASCII
- CHAR
- CHARINDEX
- CONCAT
- CONCAT_WS
- DIFFERENCE
- FORMAT
Aggregate Functions
Below table will show you the list of aggregate function available in SQL Server
Date Functions
Logical Functions
Analytic Function
Conversion Function
Configuration Functions
System Functions
- @@Identity
- IsNull
- IsNumeric
- Error_Line
- Error_Number
- Error_Message
- Error_Severity
- Error_State
- Host_Id
- Host_Name
SET Statements
XML Functions
SQL Interview Questions
- Create ODBC Connection
- Create ODBC Connection- Using Native Client
- Calculating Running Total
- Connecting to R programming
- Configure Database Mail
- Create Native Client 11.0 Connection
- Cross Join Vs Inner Join
- Concatenate Rows into String
- Converting Rows into Columns without using PIVOT
- Converting Column Names into Rows without using UNPIVOT
- Count Records in a Group
- Difference between DATEPART and DATENAME
- Difference between UNION and UNION ALL
- Differentiate among CTE, Temp Tables, Derived tables, Table Variables
- Delete Duplicate Rows
- Export Data to CSV
- Extract Domain From Email
- Formatting DATE
- Get Column Names from Table
- How to Swap Column Values
- How to check if a Table exists
- Nth Highest Salary
- Inserting values into Identity Column using IDENTITY INSERT
- Insert Stored Procedure result into Temporary Table
- Insert Images into Table
- Replace String in a Table Column
- Reverse String Words
- Rename Table Name, and Column Name
- Return Date Part Only from a Datetime datatype
- Select First Row in each group
- UPDATE Table Columns from SELECT Statement
- Backup Database Automatically
- Find all Dependencies on Table
- Find all Tables that Contain Specific Column Name
- List of Outer Joins
Thank You for Visiting Our Blog
What is the database used in this tutorial
Adventure Works DW 2014, and Adventure Works 2014
Could you please let me know where can i get the schema for SQLTutorials database used in your example(s)?
Fantastic source to learn SQL.
Great Job !!
Thank you Chaitanya
Super contribution..
Thank You
Fantastic.. it's really useful to learn SQL.. thank you
Thanks Vishwa
Great Information, Please add topics like execution plan and statistics , Performance tuning steps and sql agent jobs
Thanks Abhinav
We will do as soon as possible
Thank you so mush for your efforts on this. Very helpful and easy to understand! Appreciate it
Thanks Swathy
Thank you very much for the information ..
can you please add topics like Transaction Isolation Levels and Performance Tuning
🙂
Thanks to everyone who is part of this great work. Learned some good basics here.
I would suggest this as one of the best SQL courses available in online for free especially for the beginners.
Thank You
Full package !!! awesome tutorial.. easy to learn
Thanks you so much,…
Thank You Dhanasekar
Thank you, for a great tutorial of SQL server.
Thanks Abhishek
Thank You for the Valuable tutorial. its really very nice..
please add the performance tuning tips and how to understand the execution plans.
how to use partition in table sqlserver?
Cool tutorials Suresh…..You made this website with html5 or wordpress?
Where Can i find exercises files for Adventure work databases for practice….If anyone have please share the link
Please refer https://www.tutorialgateway.org/download-and-install-adventureworks-database/
I have downloaded the adventure work2014 but in that i haven't found costomer tables which is used in the exercise