Main Menu

Credit Cards

Our Partners

Authorized Pearson Vue Test Center





Microsoft SQL Server 2012


Course Duration: 30 hours

Course Description:

Configure, maintain,  and administrate one of the most popular database for business application solutions.

Chapter I - Overview of Microsoft SQL Server 2012

  • Installing, configuring, and upgrading
  • Using SQL Server 2012 administration and development tools
  • Designing databases
  • Creating your first table
  • Building and maintaining indexes

Chapter II - Advanced database design topics

  • Table compression
  • Table partitioning
  • Database snapshots
  • The SELECT statement
  • Other SQL Statements

Chapter III - Using Transact-SQL (TSQL)

  • Advanced data retrieval topics
  • Modifying data
  • Built-in scalar functions
  • Creating other database objects

Chapter IV - Advanced TSQL topics

  • Views
  • User-defined functions
  • Stored procedures
  • Data manipulation triggers
  • SQL Server replication
  • Replication

Chapter V - Database Maintenance

  • Backups
  • Managing and maintaining indexes and statistics
  • Maintenance plans

Chapter VI - Database Management

  • SQL Server Profiler
  • Extended events
  • SQL Server security
  • Resource Governor
  • SQL Server Agent

Chapter VII

  • Database mail

Chapter VIII

  • Data definition triggers

Chapter IX

  • Dynamic management objects

Chapter X - Front end applications demonstration:

  • Visual Basic.NET
  • C#.NET
  • JAVA
  • PHP

Other Short Courses..

What do you think?

Leave a Question



@ Christine

Please see schedules below.

Espana, Manila

Sat 3-9pm 02-18-2017 to 03-18-2017

Buendia, Makati

Sun 3-9pm 02-05-2017 to 03-05-2017
when will be the next training schedule? Thank you
@ Christine Bato

The fee is 12000 pesos in cash. Yes, it is available in Buendia, Makati branch. Please see schedule below.

Buendia, Makati

Sun 3-9pm 01-15-2017 to 02-12-201
Hi, Any available schedule training for Microsoft SQL 2014 and how much is the fee? Is it available in Makati BRanch?
Ano po schedule ng Sunday preferrably po sa Espaņa branch? Thanks.
@ Reagan Sid Daguio

The fee is 12000 pesos in cash. Meron kaming every Saturday at Sunday schedule.
How much is this course po and what schedules are available po?
CNCTC Live Chat Inquiry

Job Openings


Stay Informed Subscribe

Name *

Email *