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.
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.
There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.
|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|
|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|
|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|
|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|
|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|
|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|
|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|
|Topic A Filtered Indexes||00:09:00|
|Topic B FILESTREAM Storage||00:22:00|
|Topic C Adding Sequences to Queries||00:22:00|
|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|
|Order your Certificate||00:00:00|
No Reviews found for this course.