Querying SQL Server 2012 Online Course

Querying SQL Server 2012 Online Courses

 

This course introduces viewers to Microsoft Transact-SQL, the language used to input and retrieve data from Microsoft SQL servers. The series is designed for viewers of all experience levels as it walks through running your very first query all the way through crafting advanced server-side stored procedures. 2KO Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification, to ensure students have access to the best Querying SQL certification training in Malawi.

 

Overview
This module will teach students how to write necessary Transact-SQL queries for MS SQL Server 2014. This module is planned for Database Developers, Database Administrators, and Business Intelligence professionals. After completing this module, students will be able to: explain the basic architecture and concepts of MS SQL Server and comprehend the differences and similarities between Transact-SQL and other computer languages.

 

Objectives
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with T-SQL
Implement error handling
Implement transactions

Details about this course
Over 18 and a half hours of learning
Includes video, presentations, workbooks, quizzes, flashcards & games
Receive a Certificate of Excellence on successful completion
Presented by highly qualified, industry leading experts
12 Months access (Unless indicated otherwise)

 

Note that we offer this course for both Server 2012 and Server 2014 Online

 

To buy a course now using Credit Card, click the icon below