Learn SQL Server

Learn MS SQL Server

SQL Server is a relational database management system (RDBMS) by Microsoft. It supports SQL along with additional features known as T-SQL or Transact-SQL. Microsoft provides set of tools to manage local or remote SQL Server databases such as SSMS (SQL Server Management Studio), SQL Server Agent, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, etc.

Basics

  1. Install SQL Server
  2. SQL Server Management Studio Overview
  3. Windows Authentication in SQL Server
  4. SQL Server Authentication
  5. Create a New User in SQL Server
  6. GRANT/REVOKE Permissions to User in SQL Server
  7. Data Types in SQL Server
  8. SQL Server Naming Conventions
  9. CREATE Database in SQL Server
  10. CREATE Table in SQL Server
  11. Add Columns to Table in SQL Server
  12. What is Identity Column?
  13. Rename Column and Table in SQL Server
  14. Drop Columns from a table in SQL Server
  15. What is the Schema in SQL Server?
  16. Relations between tables in SQL Server
  17. IF ELSE Statement in SQL Server
  18. Loops in SQL Server
  19. Built-in Functions in SQL Server

SQL Queries

  1. Insert data into table
  2. Update data
  3. Delete Data from a table
  4. Select Query in SQL Server
  5. WHERE Clause
  6. GROUP BY Clause
  7. HAVING Clause
  8. ORDER BY Clause
  9. Inner Join in SQL Server
  10. Left Join in SQL Server
  11. Right Join in SQL Server
  12. Full Join in SQL Server
  13. Self Join in SQL Server
  14. Build dynamic SQL queries in SQL Server

Constraints

  1. Primary Key in SQL Server
  2. Modify/Delete Primary Keys
  3. Foreign Keys in SQL Server
  4. Modify/Delete Foreign Keys
  5. Check Constraints in SQL Server
  6. Unique Constraints in SQL Server
SQL Server Skill Test
MS SQL Server, DB design, indexes, tabels, data types, etc.

No of Questions: 20
Level: Easy
Start SQL Server Test 1
SQL Server Q & A
SQL Server Q & A

Database Objects

  1. Views in SQL Server
  2. Modify/Delete Views
  3. Functions in SQL Server
  4. Stored Procedures in SQL Server
  5. Stored Procedure Parameters
  6. Indexes in SQL Server
  7. Non-clustered Indexes
  8. Modify/Delete Indexes
  9. Triggers in SQL Server
  10. DDL Triggers
  11. LOGON Triggers
  12. Enable/Disable Triggers
  13. Modify/Delete Triggers
  14. Sequence in SQL Server
  15. Synonyms in SQL Server

SQL Server Articles

  1. How to reset identity column values in SQL Server?
  2. How to find gaps in identity column values in SQL Server?
  3. DateTime vs DateTime2 in Sql Server
  4. Difference between Functions and Stored Procedures in SQL Server