SQL Advanced 102 : Functions And Procedures $49 [Paid] 3 hrs

ven. 19 octobre à 18:00

Fuseau horaire : Paris (GMT+02:00)

Mathmatter Tutoring
Jackson Heights

About This Meetup: 1.5 hrs

Advanced joins and group by


SQL workbench SQL 102 Session Run SQL Workbench and connect to AWS end point Run nested Group by Join multiple tables Join and Group by in the same code Sub queries CASE Statement 1 hrs

SQL functions and procedures # Key Takeaways:

  • Stored Sub Programs

  • Advantages Of Stored Sub Programs compared to Independent SQL Statements

  • Stored Procedures

  • Creating , Altering and Dropping

  • Optional Parameters

  • Input and Output Parameters

  • Permissions on Stored Procedures

  • User Defined Functions

  • Creating, Altering and Dropping

  • Types Of User Defined Functions

  • Scalar Functions

  • Table Valued Functions

  • Inline Table Valued Functions

  • Multi Statement Table Valued Functions

  • Permissions On User Defined Functions

  • Triggers

  • Purpose of Triggers

  • Differences Between Stored Procedures and User Defined Functions and Triggers

Creating, Altering and Dropping Triggers

  • Magic Tables

  • Instead Of Triggers About the Speaker:

Shivgan Joshi

Lead Instructor

[masked] Payment Policy: We only accept payment on site and before the class. We accept payment through cash, Venmo & Paypal(+5).

Source: https://www.meetup.com/fr-FR/New-York-Python-SQL-Bootcamp-Data-Science-Analytics/events/253085493/

Mathmatter Tutoring
Jackson Heights

Nous avons temporairement désactivé la possibilité de naviguer vers les tags.