https://investasi.pasamankab.go.id/https://investasi.pasamankab.go.id/bo/https://investasi.pasamankab.go.id/ran/https://www.tiendacapilar.com/https://www.carreirosdomonte.com/https://doglongevity.vet/https://rapamycinforcats.com/https://www.restaurantecentralgrill.com/https://investasi.pasamankab.go.id/sg/https://investasi.pasamankab.go.id/static/
SQL Sever Course in Pune -Blend InfoTech -Trainwick
TrainWick.com

Course Detail

Home / Course Detail
SQL Sever Course

SQL Sever Course - Blend InfoTech

Course Detail

Email to Friend Share Course Report Abuse

Course Description

SQL Sever Course Syllabus:

DATABASE DEVELOPEMENT

Introduction To SQL Sever

  • An introduction to Microsoft SQL Server
  • Versions OF SQL SERVER

Querying Database

  • Identify the features of client-server architecture
  • Introducing parts of SQL.
  • Use the SELECT statement with logical operators

RETRIEVING RESULT SETS

  • Use wildcard
  • Use order by clause
  • Use the top keyword
  • Use the distinct keyword
  • Date and string functions

USING SUBQUERIES AND MANAGING DATABASE

 

 

  • Use sub queries
  • Use sub queries with the IN clause
  • Use sub queries with the Any clause
  • Use sub queries with the Exists clause
  • Creating nested queries
  • Use the SELECT INTO statement
  • Use the UNION operator

REATING TABLES AND ENFORCING DATA INTEGRATING

  • Create tables
  • Use constraints
  • Drop tables

MANAGE DATA IN TABLES

  • Create rules
  • Create defaults
  • Manipulate tables using INSERT,DELETE,UPDATE statement
  • Truncate table

IMPLEMENTING INDEXES AND VIEWS

  • Create Indexes
  • Differentiate types of indexes
  • Create views

IMPLEMENTING RELATIONSHIP BETWEEN TABLES

  • Joins
  • Union
  • Subqueries

IMPLEMENTING PROCEDURES, FUNCTIONS, CURSORS AND TRIGGERS

  • Overview of stored procedures
  • Specify types of stores procedures
  • Types of cursors
  • Create triggers
  • Specify types of triggers

DATABASE ADMINISTRATION

Installing and Configuring SQL Server

Learn Installing and Configuring SQL Server.

Managing Databases and Files

Learn database planning and creation, and using database options to control database behavior.

Disaster Recovery

Detail disaster recovery techniques for SQL Server

Managing Security

learn about the SQL Server security model and how to use SQL Server security features to control access to databases and their contents.

Transferring Data

transfer data to and from SQL Server using UI and command-line tools, and learn about transferring and transforming data with SQL Server Integration Services.

Automating Administrative Tasks

learn how to automate routine administrative tasks using jobs, operators, and alerts.

Implementing Replication

techniques for configuring SQL Server replication.

Maintaining High Availability

Learn concepts and methods for maintaining high availability with SQL Server.

Monitoring SQL Server

to monitoring SQL Server performance and activity.

Apply Now Quick Query

Institute Overview

Blend InfoTech
Pune, Maharashtra, India
18 Current Posted Courses

Blend InfoTech  Blend Group is having its Corporate Office at Pune. Blend is a Group of companies started by a group of professionals with vision to excel in the field of Information Technology, Finance and Various Services, like Tr... Read More

Related Courses

Google Map

Quick Links
Courses By City
Courses By Categories
Contact Us
Copyright © 2025 TrainWick.com. All Rights Reserved - Trainwick