Message Us

SQL Server Training

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. This tutorial explains some basic and advanced concepts of SQL Server such as how to create and restore data, create login and backup, assign permissions, etc.


In Gwalior, Techies provide you SQL SERVER training under the assistance of IT professionals with 5+ years of efficiency who is managing live projects. It helps students to achieve a successful position in IT industry. So if you want more details regarding this training program you just have to fill the training form and hit the submit button & our team will get in touch with you as soon as possible.

Course Detail

Introduction of Database

  • Database
  • Rdbms
  • ER diagram
  • DFD
  • Normalization
  • Denormalization
  • Relationship
  • Overview of sql Server-2008
  • Feature of Sql Server-2008

Database and Table Creation

  • Create and use database datatype
  • Create table Data integrity DDL statement DML statement
  • Primary key and foregn key Use constraints
  • Practical Assighnment-1
  • Notes-1

Insert update Delete Query

  • Simple insert query
  • Insert query using select
  • Update query
  • Delete query
  • Practical Assighnment-2
  • Notes-2

Selection of Data(using select query)

  • Select all data
  • Select specific column
  • Customize the display(change the col name in display)
  • Concatenate the text value in the output
  • Calculating the column
  • Practical Assighnment-3
  • Notes-3

User of where clause

  • Using arithmetic operation
  • Using comparisons operator
  • Using and/or operator
  • Range
  • In and not in
  • Like operator
  • Null value
  • Use of order by
  • Top value of the table
  • Distinct
  • Practical Assighnment-4
  • Notes-4

Functions in Sql Server

  • Use of string function
  • Use of date function
  • Use of mathematical function
  • Use of ranking function
  • Use of system function
  • Practical Assighnment-5
  • Notes-5

Aggregate and Group by

  • Min
  • Max
  • Sum
  • Count
  • Group by
  • Compute and compute by
  • Pivot
  • Practical Assighnment-6
  • Notes-6

Joins

  • Inner join
  • Outer join and its type
  • Cross join
  • Equi join
  • Self join
  • Practical Assighnment-7
  • Notes-7

Subqueries

  • Use of subqueries
  • Using in and exists
  • Nested subqueries
  • Correlated subqueries
  • Practical Assighnment-8
  • Notes-8

Constraints

  • Primary key constraint
  • Unique key constraint
  • Foreign key constraint
  • Check constraint
  • Default constraint
  • Practical Assighnment-9
  • Notes-9

Alter

  • Add column
  • Dropping table
  • Practical Assighnment-10
  • Notes-10

XML Data

  • Storing xml data in a table
  • Retrieving xml data from table
  • Use of xquery
  • Modify the xml data
  • Practical Assighnment-11
  • Notes-11

Advanced Topic

  • Indexes
  • Xml indexes
  • View(create,alter,drop)
  • Use of if-else statement
  • Use of case statement
  • Use of while statement
  • Use of exception handling
  • Practical Assighnment-12
  • Notes-12

Procedure and Triggers

  • Create and execute procedure
  • Create and execute triggers
  • Practical Assighnment-13
  • Notes-13

Extra Topic

  • Script generation
  • Backup of database
  • Restore database


Apply for Training







Training Technologies

" Techies Group "

We typically reply in a few minutes

Hi !
Welcome To Techies IT Solutions!
How Can I Help You😊

By using the chat, I confirm that I have read the privacy policy and do not object to the use of my personal data.

Chat With US