Advanced SQL – Practical Techniques and Tricks

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

Advanced SQL – Practical Techniques and Tricks

DB-301

This training, unique of its kind in Israel, focuses on complex queries, and entirely composed of advanced “real-world” problems and solutions.

This course is based on a decade of experience working with various databases, challenging job interviews questions, and many complex SQL problems Ram has encountered during his line of work. In this course, students learn approximately 100 different practical applications and “real-world” problems.

Audience

Target Audience:
This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for querying the database.

Prerequisites:
– Basic working knowledge of relational databases
– Familiarity with the SQL language concepts and syntax

Course Topics
  • Introduction to complex Scalar Functions
  • Advanced techniques for sorting and filtering values​​
  • Working with analytic functions
  • Using advanced Group Functions
  • Working with complex sub-queries
  • Using CTE and recursive CTE
  • Advanced combination of tables using JOIN , UNION, and CROSS APPLY
  • XML techniques for solving complex queries
  • Working with PIVOT and UNPIVOT
Detailed Course Outline
© Copyright - Skilit - Site by Dweb