Course details

.Net is a rising application development framework that adopts new programming methodology and is platform independent .Net framework uses C# as primary coding language. The IT professionals and students who are familiar with object oriented 

Courses Outline-SQl Server

Installing and Configuring SQL Server

  • Install SQL Server 2008.
  • Configure SQL Server 2008 instances and databases.
  • Configure SQL Server security
  • Configure linked servers by using SQL Server Management Studio (SSMS).

Implementing High Availability and Disaster Recovery

  • Implement database mirroring
  • Implement log shipping
  • Manage database snapshots.

Supporting Data Consumers

  • Retrieve data to support ad hoc and recurring queries
  • Manipulate relational data
  • Manage XML data
  • Implement an HTTP endpoint
  • Implement Service Broker components
  • Import and export data from a file
  • Manage replication.

Maintaining Databases

  • Implement and maintain SQL Server Agent jobs
  • Manage databases by using Transact-SQL
  • Back up a database
  • Restore a database
  • Move a database between servers

Creating and Implementing Database Objects

  • Implement a table
  • Implement a view
  • Implement triggers
  • Implement functions
  • Implement stored procedures
  • Implement constraints
  • Implement indexes
  • Create user-defined types
  • Implement a full-text search.

Monitoring and Troubleshooting-

SQL Server Performance

  • Gather performance and optimisation data by using the SQL Server Profiler
  • Performance and optimisation of data by using the Database Engine Tuning Advisor
  • Monitor and resolve blocks and deadlocks
  • Diagnose and resolve database server errors
  • Monitor SQL Server Agent job history
  • Gather performance and optimisation data by using DMVs.
Updated on 23 August, 2016

About Broadway Infosys Nepal

Broadway Infosys Nepal is one of the best inclusive computer training institutes in Kathmandu, Nepal. Established in 2008, our professional IT Training and Development center has been employing experts in this field to impart professional education to trainees. We offer well-structured complete professional training in various Programming Languages, Graphics & Multimedia, Web Designing as well as Development Training that is based upon the current recruitment needs in the IT market.

Further, we also provide training on thorough understanding of:

  • Project Requirement Identification and Analysis,
  • Software Development Life Cycle,
  • Functional Design,
  • Testing and Implementation
  • Quality Assurance

Since establishment, we have successfully established and maintained network with more than fifty IT and other companies which has made us able to offer and provide our students with internship and job opportunities.

See all Broadway Infosys Nepal courses
Are you from Broadway Infosys Nepal ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or