You will learn from very basics to advance. Topics covered are explained in very easy way along with examples.
- Installing SQL Server 2017
- Installing Management Studio
- Creating a Simple Database
- Creating Your First Table
- Alter Tables through GUI
- Adding Identity (Auto-increment) Column
- Understanding UNIQUE KEY Constraint
- Understanding PRIMARY KEY Constraint
- Using Criteria Pane to visually make queries
- Generating SELECT (JOIN) Query through Criteria Pane
- Understanding FOREIGN KEY through GUI
- Introduction to T-SQL
- Concatenate (join two or more) Columns in Query
- Removing Records using DELETE Statement
- Modifying Records using UPDATE Statement
- Using Distinct Keyword
- Creating COMPUTED COLUMNS
- Creating COMPUTED Columns with USER DEFINED Functions
- Making Custom Functions Deterministic with SCHEMABINDING Keyword