The objective of the course is to equip the participants with the essential skills and knowledge required to leverage SQL for effective data analysis in a business context. Through this course, participants will be introduced to the concept of database management and they will gain a comprehensive understanding of SQL fundamentals, data manipulation techniques, and advanced querying methods. By the end of the course, participants will be proficient in using SQL to extract, transform, and analyse data, enabling them to make data-driven decisions and contribute to the success of businesses through insightful data analysis.
| Target group: | Business professionals: Individuals working in various business roles, such as analysts, managers, consultants, and executives, who want to enhance their data analysis skills using SQL. |
| Duration: | 6 hours |
| Schedule: | 15th & 16th May, 2024 from 6.30PM - 8.30PM |
| Medium: | English |
| Mode: | Online (4 hour Zoom workshop + 2 hour video material) |
| Fee: | Rs. 15,000.00 per participant |
A certificate will be offered after the successful completion of the program.
Program Outline
- Database management systems
- Relational Model
- Data Manipulation with SQL
- Inserting, updating, and deleting data
- Joining multiple tables
- Aggregating and grouping data
- Advanced SQL Techniques
- Subqueries and nested queries
- Views and stored procedures
- Window functions
- Histograms, bucketing
How to Apply?
- Fill the online application form at https://www.uomba.net/programs/9/apply
Payment Instructions
- The course fee of Rs. 15,000/- may be paid at any Bank of Ceylon branch in favor of University of Moratuwa, A/C No: 70993353, Bank of Ceylon, Katubedda..
- Online bank transfers are also accepted. But ATM/CDM machine payments are not accepted.
- For physical bank payments write the payment reference as: "Training Program on Business Data Analysis with SQL".
- For online payments put the payment reference as: "SC-SQL".
Contact
Phone: 011 264 0270
Email: supungs@uom.lk