SQL Training Institute in Hyderabad

Tech Marshals is one of the best SQL Training Institute and most trusted brand of hands-on trainings in SQL & PLSQL courses in hyderabad. Get trained By Real time Industry professionals more than 10+ Years Experience to get hands on experience

MS SQL SEREVER

       

Introduction To DBMS

  • File Management System And Its Drawbacks
  • Database Management System (DBMS) and Data Models
  • Physical Data Models
  • Logical Data Models
  • Relational Data Model (RDBMS)
  • Object Relational Data Model (ORDBMS)
  • Entity – Relationship (E-R) Model

Introduction To SQL Server

  • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
  • Connecting To Server
  • Server Type
  • Server Name
  • Authentication Modes
  • Sql Server Authentication Mode
  • Windows Authentication Mode
  • Login and Password
  • Sql Server Management Studio and Tools In Management Studio

TSQL (Transact Structured Query Language)

Introduction To TSQL

  • History and Features of TSQL
  • Types Of TSQL Commands
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Data Control Language (DCL)
  • Transaction Control Language (TCL)
  •  Database(Create,Alter,Drop)
  •  Constrains
  • Procedural Integrity Constraints
  • Declarative Integrity Constraints
  • Not Null, Unique, Default and Check constraints
  • Primary Key and Referential Integrity or foreign key constraints
  • Data Types In TSQL
  • Table(Create,Alter,Drop)

Data Manipulation Language(DML)

  • Insert
  • Identity
  • Creating A Table From Another Table
  • Inserting Rows From One Table To Another
  •  Update
  •  Delete
  •  Truncate
  • Differences Between Delete and Truncate

Data Query Language (DQL)

  • Select
  • Where clause
  • Order By Clause
  • Distinct Keyword
  • Isnull() function
  • Column aliases
  • Between … And
  • In
  • Like
  • Is Null

 Functions

  • Scalar Functions
  • Numeric Functions
  • Date Functions
  • Aggregate Functions
  • Group By and Having Clauses
  • Super Aggregates Over(partition by …) Clause
  • Ranking Functions
  • Common Table Expressions (CTE)

Joins

  • Inner Join
  • Self Join
  • Outer Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join

Sub Queries

  • Single Row Sub Queries
  • Multi Row Sub Queries
  • Co-Related Sub Queries

Indexes

  • Clustered Index
  • NonClustered Index
  • Create , Alter and Drop Indexes
  • Using Indexes

Views

  • Purpose Of Views
  • Creating , Altering and Dropping Indexes
  • Simple and Complex Views
  • Encryption and Schema Binding Options in creating views

Transaction Management

  • Introduction
  • Begin Transaction
  • Commit Transaction
  • Rollback Transaction
  • Save Transaction

 Cursors

  • Working With Cursors
  • Types Of Cursors
  • Static, Dynamic and Keyset Cursors
  • Local and Global Cursors

Stored Procedures

  • Creating , Altering and Dropping
  • Input and Output Parameters
  • User Defined Functions
  • Creating, Altering and Dropping
  • Types Of User Defined Functions
  • Table Valued Functions
  • Inline Table Valued Functions
  • Multi Statement Table Valued Functions

Triggers

  • Purpose of Triggers
  • Differences Between Stored Procedures and User Defined Functions and Triggers
  • Creating, Altering and Dropping Triggers
  • Exception Handling
  • Implementing Exception Handling
  • Adding and removing User Defined Error Messages To And From SQL Server Error Messages List

Security

  • Login Creation
  • SQL Server Authenticated Login
  • Windows Authenticated Login
  • User Creation
  • Granting Permissions
  • Revoking Permissions

COURSES OFFERED

ETHICAL HACKING
DEVOPS
HADOOP
AWS
DIGITAL MARKETING
SALESFORCE
SQL
DATA SCIENCE
ANDROID AND IOS
WEB DESINING & DEVLOPMENT

WORKSHOPS OFFERED

ETHICAL HACKING
DEVOPS
HADOOP
EMBEDDED SYSTEMS
DIGITAL MARKETING
MATLAB
IOT
DATA SCIENCE
RASPBERRY -PI
VLSI
SALESFORCE
INFORMATION SECURITY
IOT (INTERNET OF THINGS)
IMAGE PROCESSING
PHOTOGRAPHY
DRONE
AND MORE