shape-876@2x

דאטה ומסדי נתונים

Advanced SQL – Practical Techniques and Use-Cases

מספר הקורס 3591

16 סה"כ שעות אקדמאיות
2 מפגשים
* מספר המפגשים והשעות למפגש עשויים להשתנות בין קורס לקורס
calendar-1.svg

המועדים הקרובים

קורס לקבוצות

הקורס נפתח במתכונת של קבוצה בלבד, בהתאמה אישית לארגונים.
לפרטים נוספים: Muzman@johnbryce.co.il

ספרו לי עוד

Overview

This training  focuses on complex queries, and entirely composed of advanced “real-world” SQL problems and solutions.

The materials of this course are based on  various databases, challenging job interviews questions, and many complex SQL problems. Throughout this training you will learn “hands-on” advanced SQL, based on real experience of different users.

hat.png

On Completion, Delegates will be able to

This course is intended primarily for database administrators, code writers, BI developers, QA professionals, analysts and other professionals who are responsible for writing SQL queries. This course also serves as an excellent preparation for technical

kahal.png

Who Should Attend

This course is intended primarily for database administrators, code writers, BI developers, QA professionals, analysts and other professionals who are responsible for writing SQL queries. This course also serves as an excellent preparation for technical

structure.png

תכנית הלימודים

Full Syllabus
PDF להורדה

This training is not a regular course, in which a series of theoretical subjects are spread according to a certain hierarchical order. Just as every SQL problem in the real world requires understanding of various elements in the SQL language, each exercise in the course incorporates different concepts. Through understanding of the problems this course presents, you will learn many techniques, 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 using the MSSQL Server syntax.

Prerequisites

Experience and Familiarity with the SQL language concepts and syntax are a must.

Schedule Appointment

Fill out the form below, and we will be in touch shortly.

לא הצלחנו לאתר את הטופס.

בודק...