(042) 35831312

Everyday (9AM to 10PM)
Post Inquiry
We'll get back to you

Certified SQL Server Specialist


Microsoft SQL Server 2016 provides a robust architecture for enterprise level data management, developer’s productivity and business intelligence. This hands-on course is designed to provide necessary knowledge and hands-on experience for installation and configuration and administration of SQL Server 2016; designing and implementing SQL Server databases, querying and manipulating data from SQL Server and implementing a Data Warehouse with SQL Server 2016.

Brief Contents
  • Introduction to Microsoft SQL Server 2016
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2016 Data Types
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Sub-queries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server Metadata
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
  • Improving Query Performance
  • Introduction to SQL Server 2012 and its Toolset
  • Preparing Systems for SQL Server 2012
  • Installing and Configuring SQL Server 2012
  • Working with Databases
  • Understanding SQL Server 2012 Recovery Models
  • Backup of SQL Server 2012 Databases
  • Restoring SQL Server 2012 Databases
  • Importing and Exporting Data
  • Authenticating and Authorizing Users
  • Authorizing Users to Access Resources
  • Auditing SQL Server Environments
  • Automating SQL Server 2012 Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server 2012 with Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server 2012
  • Monitoring SQL Server 2012
  • Managing Multiple Servers
  • Troubleshooting Common SQL Server 2012 Administrative Issues
  • Introduction to Data Warehousing
  • Data Warehouse Hardware
  • Designing and Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Incorporating Data from the Cloud into a Data Warehouse
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse
Training Methodology
Audience
Course Project

Participants of the course will complete hands-on labs and project assignments with help of their trainers.

Certificate
  • MCP: Quering Data with Transact-SQL
Duration & Frequency
  • 2 Month (8 weeks; with 3 training sessions of 1.5 hours a week)

Jun
24

Free Saminar At 07:30 PM
Lahore

  Classes start from Jun 27, 2019
  • Tuesday :
    07:30 PM To 09:00 PM
  • Thursday :
    07:30 PM To 09:00 PM
  • Thursday (Lab) :
    09:00 PM To 10:30 PM

Apr
07

Free Saminar At 03:00 PM
Rawalpindi

  Classes start from Apr 13, 2019
  • Saturday :
    06:30 PM To 08:00 PM
  • Saturday (Lab) :
    08:00 PM To 09:30 PM
  • Sunday :
    08:00 AM To 09:30 AM

Online registeration will soon be available !!

Post Inquiry
  • 349 Ferozepur Road, M-Block Gulberg
  • Phone : +(42)3583 1311, +(42) 3583 1312
  •  Cell : +(92 300) 410 2039
  • 26 Main Murree Road, Block B, Satellite Town
  • Phone : +(51) 426 4087, +(51) 426 4088
  •  Cell : +(92 333) 888-5779

Alternate Text

EVS Professional Training Institute is training division of eVentureSolutions (Pvt.) Ltd. It was established in 2005 to produce highly skilled human resource in latest tools and technologies for IT industry of Pakistan. To achieve this objective EVS has developed professional training centers in Lahore and Rawalpindi/Islamabad and Future plans of EVS include establishing similar training centers in other cities of Pakistan i.e. Faisalabad, Multan and Karachi. EVS not only offer public course at its training institutes but also provide custom training to corporate customers according to their requirements. All training courses at EVS are developed and delivered by certified experts from industry.

Read More