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