Learn 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
- Install SQL Server
- SQL Server Management Studio Overview
- Windows Authentication in SQL Server
- SQL Server Authentication
- Create a New User in SQL Server
- GRANT/REVOKE Permissions to User in SQL Server
- Data Types in SQL Server
- SQL Server Naming Conventions
- CREATE Database in SQL Server
- CREATE Table in SQL Server
- Add Columns to Table in SQL Server
- What is Identity Column?
- Rename Column and Table in SQL Server
- Drop Columns from a table in SQL Server
- What is the Schema in SQL Server?
- Relations between tables in SQL Server
- IF ELSE Statement in SQL Server
- Loops in SQL Server
- Built-in Functions in SQL Server
SQL Queries
Constraints
- Primary Key in SQL Server
- Modify/Delete Primary Keys
- Foreign Keys in SQL Server
- Modify/Delete Foreign Keys
- Check Constraints in SQL Server
- 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 |
Database Objects
- Views in SQL Server
- Modify/Delete Views
- Functions in SQL Server
- Stored Procedures in SQL Server
- Stored Procedure Parameters
- Indexes in SQL Server
- Non-clustered Indexes
- Modify/Delete Indexes
- Triggers in SQL Server
- DDL Triggers
- LOGON Triggers
- Enable/Disable Triggers
- Modify/Delete Triggers
- Sequence in SQL Server
- Synonyms in SQL Server