SQL Basic (Datalab internal)

Basic info

• Who is the webinar for: Datalab employees only (PM, APM, testers, USD)
• Date: Friday, 24 May 2024
• Duration: 6 hours
  • 9:00–12:00 – First part
  • 12:00–13:00 – Lunch
  • 13:00–15:00 – Second part
• Registration Fee: Free of charge
• Lecturer:
  • Andrej Marinič, Product Manager for System at Datalab tehnologije d.d.
  • Roman Josipovič, Assitant product manager for System at Datalab tehnologije d.d.
• Language and form of education: The training will take place via Teams in one of the BCS languages

Detailed content

Log

• SQL
• Authorizations
• Errors
• Export
• Measurements
• Print result

PANTHEON SQL

• Find queries
• Find tables/objects
• Diagram
• Generate SQL

Dev Site

• SQL Object Definitions
• Samples

SQL Objects

• Table
• View
• Procedure
• Function (scalar, Iniline, table)
• Trigger
• Constraint

SQL Code

• Inner join vs Left join
• Cross-apply vs. outer-apply
• Conditions
• Delete, truncate
• Create or alter

Samples Generate SQL Code with PA

• Param tables
• FX Rates
• Join to tables

Important

Clicking on the ‘Register’ button will direct you to our PartnerSite where you can complete the registration process. In the menu TeamDL | Knowledge | Education & Certification, select:

• Enroll here – Complete the registration process for the webinar. Select: Registration for Education | Education: SQL Basic: @ May 24 2024 9:00AM-15:00:00

You can register for the webinar until the end of the registration period, i.e. 17 May 2024. After this deadline, it will exceptionally be possible to register by sending an inquiry via email to dcd@datalab.si. If you decide not to attend after having registered, please let us know in writing by 17 May 2024 at the latest. If you cancel your registration after the deadline or fail to attend the education, we will still have to charge you 100% of the registration fee/person.

Rules of the game

Terms and content changes

• Content, terms, location, and other information related to this Webinar are subject to change. If such changes are made, you will be notified accordingly.
• The webinar will be held if 30 or more participants are registered.
• This webinar is reserved exclusively for Datalab employees only (PMs, APMs, testers, USD)