Mastering ESQL In One Day

Can someone master ESQL in just one day? YES, ESQL is not like any other programming language which has lot of statements and libraries to know. It is the most simplest language that I’ve ever seen.

The statements are limited, syntax is simple and learning is super easy. As an ACE/IIB developer, what do you do most of the time? Writing ESQL code right? Then, are you harvesting the real power of ESQL?

This one day training program is going to show you the real power of ESQL. It is going to explain you from the basics to advanced statements with examples

Here is what we’re going to cover in the course.

1. Introduction
2. Data Types
   1. Boolean
      1. TRUE
      2. FALSE
      3. UNKNOWN
   2. DateTime
   3. NULL
   4. Numeric
      1. DECIMAL
      2. FLOAT
      3. INTEGER
   5. Reference
   6. String
      1. BIT
      2. BLOB
      3. CHARACTER
3. Correlation Names
   1. Root
   2. FirstChild
   3. LastChild
   4. FirstSibling
   5. NextSibling
   6. PreviousSibling
   7. LastSibling
4. Message Components
   1. Properties
   2. Message Domain
   3. Environment
   4. Local Environment
   5. Exception List
5. Variables
   1. Declaration
   2. Normal
   3. External
   4. Shared
   5. Scope
6. Operators
   1. Simple Comparison 
      1. >, >=, <, <=, <> & =
   2. Complex Comparison
      1. BETWEEN
      2. EXISTS
      3. IN
      4. IS
      5. LIKE
      6. SINGULAR
   3. Logical
      1. AND
      2. OR
      3. NOT
   4. Numeric
   5. String
7. Field References
8. Field Types
   1. NAME
   2. TYPE
   3. NAMEVALUE
9. Conditional Statements
   1. IF….ELSEIF…..ELSE
   2. CASE
      1. Simple
      2. Searched
10. Looping Statements
    1. REPEAT UNTIL
    2. WHILE
    3. FOR
    4. LABELED LOOP
    5. ITERATE
    6. LEAVE
    7. RETURN
11. Error Handling
    1. THROW
    2. DECLARE HANDLER
12. Modules
    1. Procedures
    2. Functions
    3. CALL
    4. MOVE
    5. LASTMOVE
13. Handling NULL values
14. Propagating Multiple Messages
15. List Functions
    1. CARDINALITY
    2. EXISTS
    3. SINGULAR
    4. THE
    5. ITEM
16. Complex Functions
    1. CAST
    2. FORMAT
    3. SELECT
       1. Simple
       2. Complex
    4. ROW
    5. LIST
    6. ROW & LIST Combined
17. Working with Database
    1. INSERT
    2. SELECT
    3. UPDATE
    4. DELETE
    5. PASSTHRU
    6. Stored Procedures
18. Manipulating repeating fields
19. Calling Java methods
20. String Functions
    1. CONTAINS
    2. ENDSWITH
    3. LEFT
    4. LENGTH
    5. LOWER
    6. LTRIM
    7. OVERLAY
    8. POSITION
    9. REPLACE
    10. REPLICATE
    11. RIGHT
    12. RTRIM
    13. SPACE
    14. STARTSWITH
    15. SUBSTRING
    16. TRANSLATE
    17. TRIM
    18. UPPER
21. Miscellaneous
    1. ATTACH
    2. DETACH
    3. PATH
    4. BROKER SCHEMA
    5. DECLARE
    6. CREATE FIELD
    7. DELETE FIELD
    8. COALESCE 
    9. SLEEP
    10. UUIDASCHAR
    11. ASBITSTREAM
    12. EXTRACT

As the trainer has more than 15+ years of experience in ESQL, you can ask him any questions related to ESQL. If you’ve complex requirement, ask him how to resolve it during the training. So, why wait ?

Enroll into the training program and become a Master in ESQL in One Day.

Event Address: Online
Contact us at (612) 305-8684 or support@vaithu.com

Course Fee: USD : 75$/ INR 5000

To register the training, click here : shorturl.at/bpuLO

Alternative Link : https://docs.google.com/forms/d/e/1FAIpQLSd9GuiYIV7Kh18MwLUjqbwqFHL-n4RGl68Goaxm3LShMvV03A/viewform?entry.2109138769=Yes