• LOGIN
  • No products in the cart.

If you’re ready to learn how to harness Microsoft SQL Server to deliver mission-critical performance, gain faster insights on data, or drive your hybrid cloud strategy, you’re in the right place. Through this SQL Programming Intermediate you will learn how to use a Microsoft SQL Server to install, build, and design databases. The course will help you understand database administration, including creating indexes and backing up and restoring the database.

The course will teach you about the structured query language (SQL) for manipulating business data in the most effective and sensible approach. Obtain the power of Microsoft SQL Server and grasp how to maximize the performance of any SQL that you draft.

These learning opportunities can help you get started quickly—from product exploration to deep training and certification.

Method of Assessment:

This course does not involve any assessment. Upon conclusion of the course you can order your completion certificate.

Certification:

Certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for Printed Hardcopy format and £24.99 for Both for Both PDF and Hardcopy Certificates.

Requirements

There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.

Course Curriculum

Module: 01
Topic A Aggregates FREE 00:27:00
Topic B User Defined Types 00:17:00
Topic C Table and Functions 00:10:00
Topic D Managing Code Modules 00:08:00
Module: 02
Topic A Introduction Data Tools 00:19:00
Topic B Connected Database Development 00:20:00
Topic C Updating a Connected Database 00:16:00
Module: 03
Topic A Creating New Objects with TSQL 00:12:00
Topic B Comparing Database Schemas 00:10:00
Topic C Offline Database Development 00:13:00
Topic D Database Project Settings 00:18:00
Module: 04
Topic A Using APPLY 00:15:00
Topic B MERGE Statement 00:23:00
Topic C Creating Recursive Queries 00:08:00
Topic D Grouping Sets 00:12:00
Module: 05
Topic A ROLLUP and CUBE Operators 00:12:00
Topic B Creating Pivot Queries 00:14:00
Topic C Executing Dynamic SQL 00:28:00
Module: 06
Topic A Complex Query Execution 00:26:00
Topic B Using Execution Plans 00:16:00
Topic C Execution Plan Operators 00:12:00
Topic D Common Join Operators 00:16:00
Module: 07
Topic A Hierarchy ID Data Type 00:12:00
Topic B Exploring a Hierarchy 00:09:00
Topic C Sparse Columns 00:16:00
Topic D Column Sets 00:12:00
Module: 08
Topic A Filtered Indexes 00:09:00
Topic B FILESTREAM Storage 00:22:00
Topic C Adding Sequences to Queries 00:22:00
Module: 09
Topic A Introduction to Spatial Data 00:13:00
Topic B Spatial Data in SQL Server 00:23:00
Topic C Manipulating Spatial Shapes 00:10:00
Topic D Interactions Between Objects 00:09:00
Course Certification
Order your Certificate 00:00:00

Course Reviews

4.8

4.8
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

571 STUDENTS ENROLLED

Top Sale Courses

COPYRIGHT © 2017 STPAULSCOLLEGE.CO.UK