Course Overview
Schedule Dates
Complete PowerPoint Course
09 September 2024 - 13 September 2024
Complete PowerPoint Course
09 December 2024 - 13 December 2024
Complete PowerPoint Course
10 March 2025 - 14 March 2025
Complete PowerPoint Course
16 June 2025 - 20 June 2025
Course Content
- Microsoft SQL Server Installation
- How to connect MS SQL (Windows Authentication)
- How to connect MS SQL (SQL Server Authentication)
- Creating Database
- SQL Data Types and Column Data Types on SSMS Creating Table
- Creating Table and Overview of Primary Key and Foreign Key
- Creating Temporary tables
- Insert statement
- Update statement
- Delete statement
- CREATE table statement
- DROP statement
- ALTER statement
- TRUNCATE statement
- RENAME
- Create Database user
- GRANT permissions and REVOKE permissions
- SQL Statement basic
- SELECT Statement ,SELECT DISTINCT
- SELECT with column heading
- SELECT WHERE Clause – theory
- SELECT WHERE Clause – practical
- Introduction
- Count() , Sum() , Min() , Max() and AVG()
- Order By statement
- BETWEEN command
- Wildcard Characters and LIKE
- Group by – theoryand practical
- Inner join
- Left outer join
- Right outer join
- Full outer join
- Union and Cross join
- Check constraint
- NOT NULL constraint
- UNIQUE constraint
- Creating Views
- Reporting with multiple tables
- Timestamp
- Extract from timestamp
- Mathematical scalar functions
- SELECT with calculations
- Create stored procedure
- Stored procedure with parameter
- Import Flat File
- Import .csv or excel file
- Creating and Restoring Database backup
FAQs
This course is designed for individuals of all skill levels who want to master Microsoft PowerPoint, from beginners to advanced users looking to enhance their presentation skills.
There are no specific prerequisites for this course. Basic computer literacy and familiarity with Microsoft Office applications can be helpful but are not required.
Yes, the course includes hands-on exercises and projects to help reinforce the concepts learned and provide practical experience in creating PowerPoint presentations.
Yes, technical support is available to assist participants with any issues or questions that may arise during the course.