Tecnosoft | Training Instistute Website

SQL Server

Home > Courses > SQL Server

Icon
Duration

45 DAYS

Icon
Online Fee

15,000

Icon
Classroom Fee

6,000

Icon
Students Enrolled

2000+

Icon
Reviews

Upcoming Batch Schedule for Online Training

Tecnosoft provides flexible timings to all our students. Here are the Online Training Schedule in our branches. If this schedule doesn’t match please let us know. We will try to arrange appropriate timings based on your flexible timings.

  • 27-04-2020 Monday (Monday - Friday)Weekdays Regular 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per SessionCourse Fees
  • 30-04-2020 Thursday (Monday - Friday)Weekdays Regular 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per SessionCourse Fees
  • 25-04-2020Saturday (Saturday - Sunday)Weekend Regular11:00 AM (IST) (Class 3Hrs) / Per SessionCourse Fees
  • 25-04-2020Saturday (Saturday - Sunday)Weekend Fast-track 10:00 AM (IST)(Class 6Hrs - 7Hrs) / Per SessionCourse Fees
Tecnosoft Calender
Can’t find a batch you were looking for?

Enroll Now

Get Instant access to 5000+ Online courses

Course Curriculam

  • Introduction of SQL Server
  • Features of SQL Server
  • Different Versions of SQL Server

DBMS Concepts

  • What is Database?
  • What is DBMS?
  • What is RDBMS?
  • Different types of database models?

SQL Language

  • Introduction of SQL
  • Data types of SQL
  • Role of SQL in DBMS
  • Naming rules in SQL server
DML Commands

Insert

  • Insertion of data
  • Copying of rows from table to table
  • Select
  • Combination Statements

Data integrity Constraints

  • Domain integrity
  • Entity integrity
  • Referential integrity
  • On delete cascade
  • On update cascade

Joins & Sub Queries

  • Equi join
  • Non-equi joins
  • Natural join
  • Self join
  • Outer join
  • Cross join
  • Simple queries
  • Sub queries

Functions

  • Single row functions
  • Multi row functions

Update

  • Data updating
  • Updating data using sub quires

Delete

  • Deleting data
  • Deleting data using sub quires

DDL commands

  • Create, alter drop
  • Rename
  • Truncate

DCL commands

  • Grant
  • Revoke

TCL commands

  • Commit
  • Roll back
  • Save transaction

Index

  • Unique index
  • Non-unique index

View

  • Simple view
  • Complex view
  • Read only views

Synonym

  • Private synonym
  • Public synonym
  • What is t-SQL?
  • Operators & data types in t-SQL

Flow control statements

  • If …else
  • Switch case
  • Nested if …else

Condition based loops

  • While loop
  • For loop
  • Do-while loop
Embedded SQL
Usage of select statement

Cursor

  • Implicit cursor
  • Declaring cursors
  • Explicit cursor
  • Advantages of cursor

Sub programs

  • Stored procedures
  • Difference between function and procedure
  • Advantage of stored procedure

Triggers

  • DML Triggers (After | Instead of )
  • DDL Triggers

Security

  • Windows Authentication
  • Magic Tables
  • SQL Server Authentication
  • Creating Login
  • Database Permissions
  • Dropping Login

Our Courses

Request a call back
info@tecnosoft.in
+(91) 996 642 2225

Scroll to top