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
No Reviews found for this course.