SQL Server Training Provided by Revanth Technologies Training Institute in Hyderabad
SQL Server free videos and free material uploaded by Revanth Technologies Training Institute. This session contains about SQL Server Updated syllabus , Lecture notes , videos , MCQ , Privious Question papers and Toppers Training Provided Training of this course. If Material not uploaded check another subject
Life Cycle of
Database :SQL Server
Design
Implementation
Tuning and Maintenance
Module1: Design
Basics (DBMS, RDBMS)
SQL Server Environment(SSMS)
Creating a Database
Constructing Tables
Data Types
Data Integrity [where all constraints will be covered]
Relationships in Database (one-one, one-many, many-many)
Normalization and Normal Forms
DDL – Data Definition Language
DML – Data Manipulation Language
DCL – Data Controlling Language
Module2:
Implementation
SQL Programming Concepts
System Defined Functions
Clauses in SQL Server
PIVOT & UNPIVOT
Error Handling Functions
Many More…
Joins
Subqueries
Views
With CTE
Indexes
Stored Procedures
User Defined Functions
Transactions and Locks
Cursors
Triggers
XML Integration
Module 3: Tuning and
Maintenance
Performance Tuning -- Partitions
Isolation Levels and
SQL Server Agent
Overview of Security, Replication and Database Maintenance
Write a public review