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
No Reviews found for this course.
Related Courses
CCTV Operator Level 2
£24.99
IT Support Technician
£24.99
Top Sale Courses
70-247 – Configuring and Deploying a Private Cloud with System Center 2012 R2 (MCSE)
4.9( 9 REVIEWS )2 STUDENTS
Absenteeism and Tardiness
0( 0 REVIEWS )1 STUDENTS
Acceptance and Commitment Therapy (ACT)
0( 0 REVIEWS )4 STUDENTSAcceptance and Commitment Therapy (ACT) – ACCREDITED CERT
0( 0 REVIEWS )16 STUDENTS
Accountancy Diploma Level 3
4.9( 8 REVIEWS )41 STUDENTS