Search

Search

Advanced SQL – Practical Techniques and Use-Cases

Main Speaker:

Tracks:

Course ID:

44169

Time:

Daily seminar
9:00-16:30
This seminar, delivered by Ram Kedem, focuses on complex queries, and entirely composed of advanced “real-world” SQL problems and solutions. Based on decade of experience working with various databases, challenging job interviews questions, and many complex SQL problems, throughout this seminar you will learn practical implementations of subjects such as :
  • Complex scalar functions
  • Advanced techniques for filtering and sorting values
  • Working with analytical functions
  • Advanced use of Group Functions
  • Working with complex Sub-Queries
  • Use of CTE and recursive CTE
  • Advanced tables integration using JOIN, UNION and CROSS APPLY
  • XML techniques for solving complex problems
  • Working with PIVOT and UNPIVOT
All of the techniques will be presented by the MSSQL Server syntax. Target Audience This seminar is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, and Data Analysts. Experience and Familiarity with the SQL language concepts and syntax are a must


For further information, fill in your details and we will contact you shortly


Contact us

For further information, fill in your details and we will contact you shortly