SQL essentials

SQL essentials

Description This training will provide you with the skills to master SQL language for application development or data analytics.
Content – 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
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)
Recommended for This course is aimed at any person who wants to get insight from data or using SQL for application development.
Duration 4 days
Daily
timetable
duration: 08:00-17:00
lunch: 12:00
break: 10:30, 15:30
Trainer see trainer
Schedule see schedule
Price see schedule
Language english (if all students are from indonesia, then we use indonesian)
Registration see schedule, contact us
Facilities – lunch
– snack
– certificate of attendance
– printed training manual
Past classes see gallery

Some questions

  • Do i have to attend this training? Can i just learn by myself with google help? Sure, of course you can – if you really have the time to learn them. Unix/Linux has lots of parameters and complexities which involves a steep learning curve and take longer time. Additionally, many mikrotik tutorial in the internet are confusing and unclear which could jeopardise your server. So, yes, you could just try to figure it all out for yourself, however we strongly believe that you will get many benefits by attending one of our training courses. You will not only learn from the trainer with high quality training materials, but also get best practices and experiences by many case studies discussed in the class. We think it is a great investment for your future
    ———
    Apakah saya harus menghadiri training ini? bisakah saya belajar sendiri dengan bantuan google? Tentu, anda bisa melakukannya, dengan catatan anda benar-benar mempunyai waktu untuk itu. UNIX/Linux mempunyai banyak sekali parameter dan tingkat kompleksitas juga tinggi, ini membuat kurva belajar yang tinggi dan memerlukan waktu belajar yang panjang. ditambah lagi bahwa banyak tutorial di internet yang membingungkan bagi beberapa orang sehingga dapat membahayakan jaringan anda. Jadi, ya anda dapat mengukur diri sendiri untuk belajar semuanya sendiri, meskipun demikian, kami sangat percaya bahwa anda akan dapat banyak benefit jika menghadiri training kami. Anda tidak hanya belajar dari instruktur yang berpengalaman dengan traning material yang berkualitas tinggi, tapi juga mendapat best practices dan berbagi pengalaman dengan beberapa case study yang dibahas di kelas. Sehingga kami pikir ini adalah investasi yang sangat baik untuk masa depan anda.

 

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on telegram
Telegram
Share on email
Email
Share on whatsapp
WhatsApp