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...


Course Detail

  • Database
  • Rdbms
  • ER diagram
  • DFD
  • Normalization
  • Denormalization
  • Relationship
  • Overview of sql Server-2008
  • Feature of Sql Server-2008
  • 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
  • Simple insert query
  • Insert query using select
  • Update query
  • Delete query
  • Practical Assighnment-2
  • Notes-2
  • 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
  • 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
  • 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
  • Min
  • Max
  • Sum
  • Count
  • Group by
  • Compute and compute by
  • Pivot
  • Practical Assighnment-6
  • Notes-6
  • Inner join
  • Outer join and its type
  • Cross join
  • Equi join
  • Self join
  • Practical Assighnment-7
  • Notes-7
  • Use of subqueries
  • Using in and exists
  • Nested subqueries
  • Correlated subqueries
  • Practical Assighnment-8
  • Notes-8
  • Primary key constraint
  • Unique key constraint
  • Foreign key constraint
  • Check constraint
  • Default constraint
  • Practical Assighnment-9
  • Notes-9
  • Add column
  • Dropping table
  • Practical Assighnment-10
  • Notes-10
  • Storing xml data in a table
  • Retrieving xml data from table
  • Use of xquery
  • Modify the xml data
  • Practical Assighnment-11
  • Notes-11
  • 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
  • Create and execute procedure
  • Create and execute triggers
  • Practical Assighnment-13
  • Notes-13
  • Script generation
  • Backup of database
  • Restore database