Booking options
£25
£25
Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
On-Demand course
5 hours 8 minutes
All levels
Take your steps towards learning the advanced concepts of SQL by taking this SQL Developer 2014 Advanced.
Through the course, you will master SQL skills and be able to take full command of SQL.
You will learn to create materialised views and improve performance by using simple SQL syntax. Learn about partition the tables and performance optimisation using SQL partitioning and explore how to use analytic SQL to aggregate, analyse and report, and model data using the SQL analytic capabilities. 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 practising 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.
Step up to the next level to learn more about the advanced SQL theories which will put you better in your performance and career advancement.
After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
Module: 01 | |||
Topic A Partitioning | FREE | 00:20:00 | |
Topic B Creating Partition Tables | 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 | ||
Order Your Certificate and Transcript | |||
Order Your Certificates and Transcripts | 00:00:00 |