I. ABOUT THE PROGRAM

The Structured Query Language (SQL) is one of the most effective tools for Actuaries when they deal with large amount of data, which goes much beyond the capacity of MS Excel. While Python, R, VBA, SAS and SPSS are used in many situations, the SQL is the best to communicate with the Data Base/ Big Data. When the big data science and Artificial intelligence (AI) growing beyond one’s imagination, Actuaries to overcome the emerging challenges by equipping themselves with all such tools and techniques which AI is based upon. This program envisages to bring in confidence and capacity among all actuarial professionals to effectively deal with all types of data, be it structured, semi-structured or unstructured. 
The 22-hour interactive webinar series covers basic and advanced SQL functions and its applications in various data scenarios. Participants will have hands-on experience by their engagement in tasks and assignments based on real life situations.

II. PROGRAM SCHEDULE

Webinars will be spread over 11 sessions of 2 hours each duration, starting from 27 June 2023. In order to ensure opportunity for learning across all members of the profession and to engage participants for an effective learning and hands on experience, sessions are uniformly spread during the week. 

A detailed program schedule is available in ANNEXURE-I 

Recorded videos of all webinars will be made available in the member’s login page until 31 August 2023. However, it is highly recommended to attend all LIVE sessions without fail for optimum learning out of the program.

III. REGISTRATION

Fee for Members	Rupees Four thousand (₹4,000.00) (18% GST extra)
For Non-members	Rupees Eight thousand (₹8,000.00) (18% GST extra)
Bulk registrations	A minimum registration count of 25 will be accepted, where both members and non-members can together register with a lump sum payment of ₹1,00,000.00 (18% GST extra). Any additional count of registrations beyond 25 will be considered with the same average rate.
Registration menu	Login to IAI >>Training program>>SQL
Registration opens on	On 1 June 2023 11.00AM.
Registration closes on	On 25 June 2023 6.00PM.
Member Registration	Click here
Non Member Registration	Click here

IV. FACULTY

Dr. Deepak Kumar Singh, PhD (IIT, Kanpur), MTech (IIIT, Allahabad) is the CEO of DK Infosolutions Private Limited and visiting faculty of Indian Institute of Information Technology, Lucknow. He is the Chair- Incubation centre at Jaipuria Institute of Management at Lucknow. He also advise to many Companies, Institutions and the Government of UP for their different projects. Being a passionate teacher, he has trained many executives and students in India, China, Japan, Singapore and Tanzania. His core areas of expertise are AI, ML, IoT and data Analytics.

V. COVERAGES

• Relational Databases
• Creating Databases and Tables
• Data Types and Constraints
• Basic SQL Queries
• Filtering and Sorting Data
• Filtering and Sorting Data
• Aggregating Data with Group By
• Subqueries and Nested Queries
• Modifying Data with SQL
• Modifying Data with SQL
• Modifying Data with SQL
• Database Transactions
• Stored Procedures and Functions
• Performance Tuning and Optimization

VI. CONTACT

Point of contact for all related queries: Mr. Ravindra Mastekar at: 022 62433348 or ravindra@actuariesindia.org

 

Program Schedule (ANNEXURE-I)

27^th June 2023 to 27^th July 2023, Time 7.00pm to 9.00 pm

STRUCTURED QUERY LANGUAGE (SQL) : Program Schedule

Date	Day	Program	Topic
27-06-2023	Tuesday	Basic using SQLite	Introduction to SQL2, Databases and RDMBS
29-06-2023	Thursday		Install a Database Engine and SQLite Introduction
01-07-2023	Saturday		SQL Syntax and basic queries
11-07-2023	Tuesday	Medium to Advance	SQL Data Types and SQL Operators
13-07-2023	Thursday		SQL Expressions and SQL Comments
15-07-2023	Saturday		Data Definition Language Commands & Operations and Data Manipulation Language Commands &Operations
18-07-2023	Tuesday		SQL Data Control Language Commands and SQL Functions
20-07-2023	Thursday		SQL Queries, Sub Queries and Clauses
22-07-2023	Saturday		SQL Joins and Views
25-07-2023	Tuesday		SQL Indexes and Transactions
27-07-2023	Thursday		SQL Injection and  SQL vs. NoSQL