Browse Courses

SQL Server

Course Description

Curriculum

Chapter 1 : Database Concepts 

1Database Concepts

  • Introduction to Database
  • Data Models, Acid Properties, Database Terms
  • Advantages and importance of Database

Chapter 2 : SQL Server Introduction 

1SQL Server Introduction

  • Introduction to SQL Server
  • History of SQL Server
  • Versions of SQL Server
  • SQL Server Components
  • Different Editions of SQL Server.

Chapter 3 : Installation 

1Installation

  • Software Installation (Links)

Chapter 4 : SSMS 

1SSMS

  • What is SSMS(SQL Server Management Studio)
  • How to connect to SQL Server using SSMS
  • SSMS components, SQL commands categories

Chapter 5 : SQL Commands 

1SQL Commands

  • DDL, DML,DCL,TCL and DQL

Chapter 6 : Database 

1Database

  • Introduction to Database, Creating a Database, Understanding System Database
  • Manipulating database ( using Window and Commands)

Chapter 7 : DDL Commands 

1DDL Commands

  • Data types, Creating Table
  • Renaming a Table
  • Alter a table
  • Drop a Table
  • Truncate Table
  • Identity Column

Chapter 8 : Constraint 

1Constraint

  • Introduction to Constraint
  • Types of Constraints
  • Row/Table Level Constraint
  • Adding and Dropping Constraints
  • Enable/Disable Constraints, Example

Chapter 9 : DML Commands 

1DML Commands

  • INSERT INTO, DELETE and UPDATE commands

Chapter 10 : SQL Select [DQL] 

1SQL Select [DQL]

  • Select Statement
  • Clauses (TOP, DISTINCT, ORDER BY, WHERE)

Chapter 11 : Operators 

1Operators

  • SQL Operators, Set Operators

Chapter 12 : Aggregate Functions 

1Aggregate Functions

  • Usage, GROUP BY, HAVING clauase

Chapter 13 : Single Row Functions 

1Single Row Functions

  • Different types with examples

Chapter 14 : Sub Queries 

1Sub Queries

  • Advantage, Syntax, Types of Sub Queries
  • Single Row and Multi row sub queries

Chapter 15 : Joins 

1Joins

  • Advantages, Syntax, Keywords, Example
  • Types of Joins, Implementation

Chapter 16 : Views 

1Views

  • Introduction, Table vs View
  • Simple and Complex views

Chapter 17 : Indexes 

1Indexes

  • Introduction
  • Architecture
  • Table Scan
  • Using Index
  • Clustered and Non-clustered Index

Chapter 18 : TCL 

1TCL

  • Transaction Control Language
  • ACID Test
  • Using Commit
  • Rollback
  • Understanding Lock, etc.,

Chapter 19 : Exception Handling 

1Exception Handling

  • Introduction, blocks, Example

Chapter 20 : T-SQL 

1T-SQL

  • Introduction to T-SQL
  • T-SQL statements
  • Control structures

Chapter 21 : System Functions 

1System Functions

  • List and usage of system functions
  • With example queries

Chapter 22 : Cursors 

1Cursors

  • Introduction,
  • Advantages and importance
  • Declare and usage of cursor
  • Examples in detail

Chapter 23 : Stored Procedures 

1Stored Procedures

  • Introduction, Syntax, Creation of SP,
  • Invoking a stored procedure, dropping, Task

Chapter 24 : User Defined Functions 

1User Defined Functions

  • Introduction, Syntax, Creation of UDF,
  • Invoking functions, dropping, Task

Chapter 25 : Triggers 

1Triggers

  • Introduction
  • Advantages
  • Creating a Trigger
  • Implementation
  • Examples and Task

Chapter 26 : Transcation 

1Transcation

  • Introduction
  • Implementation
  • Example

$500

  • Lectures0
  • Video
  • Skill level Full Course
  • Languages English

Take the world's best courses

and take your career to the next level!


New to Truway? Create a new account

By signing up, you agree to our Terms of Use and Privacy Policy.
Already have an account? Login