-
What you'll learn
- Working with SQL Server
- Architecture
- Datatypes
- Keys in Database
-
Requirements
- Prior Knowledge of Databases
- Interest to learn
- Your dedication
-
Course Curriculum
-
MS SQL Server & T-SQL Fundamentals
- Advantages of stored procedure
- Creating and executing stored procedures with output parameters part 1
- Creating and executing stored procedures with output parameters part 2
- Stored Procedure in SQL server part 3
- Stored Procedure in SQL server part 2
- Stored Procedure in SQL server part 1
- What is SQL
- What is SQL Server
- What is DBMS
- Types of DBMS
- TCL Commands
- sql server installation
- SQL Server Data Types
- SQL Server Command Categories
- SQL Server Architecture
- Operators
- Nested Queries
- Keys in Database
- Joins
- Features of SQL Server
- Exception Handling
- DML Commands
- Difference between sql and T sql
- DDL Commands
- DCL Commands
- Constraints in Database