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 Dailytimetable…






