Complete PowerPoint Course
Course Overview
Schedule Dates
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.
Flexible Training Options to Meet Your Needs
We know the importance of flexibility in the success of learning and professional development. This is the reason CounselTrain provides a variety of delivery options for all IT training offered in the UAE to ensure access and convenience for each learner.
Select the method that best suits your needs.
