• LOGIN
  • No products in the basket.

Login

Learn skills for database development beyond just creating a table with rows and columns using the standard query language (SQL).

The SQL Programming Advanced is designed to introduce you to the features and technologies for implementing a database beyond the basics. You will learn about the Microsoft SQL server, which is a relational database management system developed to store and retrieve data requested by other software applications. You will learn database development basics, programmatic database objects, in-memory databases, and transactions. You will also learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure by practicing SQL Hierarchical features. Use of regular expressions and sub-expressions to search, match and replace strings using SQL built-in functions also explained in this course.

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 Partitioning FREE 00:20:00
Topic B Creating Partition Tables FREE 00:30:00
Topic C Querying Partitions 00:14:00
Topic D Managing Partitions 00:17:00
Module: 02
Topic A Complex Querying 00:22:00
Topic B Rankings 00:15:00
Topic C SubQueries 00:21:00
Topic D Common Table Expressions 00:17:00
Module: 03
Topic A Complex Data and Structures 00:26:00
Topic B Efficient Queries 00:36:00
Topic C Complex Queries 00:17:00
Module: 04
Topic A XML Data Type 00:28:00
Topic B XML Schemas 00:17:00
Topic C Querying XML 00:20:00
Topic D Best Practices 00:08:00
Course Certification
Order your Certificate 00:00:00

Course Reviews

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE OR ALL COURSES FOR £69.99
  • £24.99
  • 1 year
  • Course Certificate
  • Number of Units16
  • Number of Quizzes0
  • 5 hours, 8 minutes
9 STUDENTS ENROLLED