Type and hit enter to Search
×

Complete PowerPoint Course

  • 4.9(6,865 Rating)

Course Overview

The Complete PowerPoint Course from Microsoft offers comprehensive training on using Microsoft PowerPoint effectively. This course is designed for individuals who want to master the features and functionalities of PowerPoint to create professional presentations. The curriculum covers a wide range of topics, including the basics of PowerPoint, advanced design techniques, and tips for delivering impactful presentations. Participants will learn how to create and format slides, insert and manage multimedia elements, and utilize animations and transitions to enhance their presentations. The course also includes best practices for collaborating with others and sharing presentations in various formats. By the end of the course, learners will have the skills to create visually appealing and engaging presentations that effectively communicate their message.

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.

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?