TRAINING DESCRIPTION

This training will provide you with the skills to master SQL language for application development or data analytics.

PREREQUISITE

• any person who already know how to use computer
• Laptop with WiFi and Ethernet ports.
• Required software should be install before join the training (putty, database client)

FACILITIES

• lunch
• snack
• certificate of attendance
• printed training manual

• Data Definition Language
• Data Manipulation language
• Data Insert, Delete, Update
• Data display, single table (colom selections)
• View
• Data display, conditional (WHERE, CASE)
• Data display, multiple table (JOIN, UNION)
• Dealing with NULL
• Data display, analytics functions (sum, min, max, cube, case)
• Data display, aggregate functions (GROUP BY, HAVING) – Functions
• Triggers
• Stored Procedure

This course is aimed at any person who wants to get insight from data or using SQL for application development.

Achmad Mardiansyah

(Linux and Mikrotik Certified Consultant and Trainer)

A telecommunication and IT engineer, passionate in UNIX/Linux, Data science, IT, Programming, Telecommunication and Networking technologies. Has more than 15-year experiences in app developer, networking and system administration, in Indonesia and overseas, especially in telecommuniation environment. Familiar with Network Architecture, NOKIA HLRi, Apertio/OneNDS, HSS, Radius, and web technologies. A fast-learner, and always willing to learn new technologies. Holder of CCNA, SCSA, SCNA, RHCT/RHCSA, LFCE, MTCNA, MTCRE, MTCWE, MTCTCE, UEWA, UBRSA, UBWA and Mikrotik trainer and ubiquiti trainer certifications.

Rahayu Roesmini

(Business Development GLC Networks)

There is no shortcut to success