3800 Office Skills courses

Duration 3 Days 18 CPD hours This course is intended for This course is intended for both novice and experienced project managers, managers, schedulers, and other project stake holders who need to incorporate the discipline of project management with Microsoft Project 2016. Overview ?Understand the discipline of project management as it applies to using Microsoft Project 2016.?Create a Work Breakdown Structure.?Identify Task Types & Relationships.?Define Resources within Project.?Make Work Package Estimates.?Create an Initial Schedule.?Create a Resource Leveled Schedule.?Create Projects from templates, Excel files.?Create Global templates.?Create formulas and graphical indicators.?The steps to record a macro.?Format Output and Print Reports.?Integrate Multiple Projects.?Set up a Project with a Calendar, Start date, and scheduling method.?Understand Manually Schedule vs. Auto Schedule.?Manage multiple projects.?Be able to create a master project list with shared resources. The course begins with the basic concepts and leads students through all the functions they?ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress. Introduction to Microsoft Project Describe how Project relates to the discipline of Project management. Learn what the new features are in Project 2016. Navigate to the primary views available using the Ribbon. Choose Views that display task, resource, or assignment information. Select table within views to change the information that is available to see and edit. Relate the features of Project to the 5 steps for building a plan in Project. Lab 1: Introduction to Mastering Microsoft Project A Quick and Easy Overview of Managing with Project Create a new project and prepare it for data entry. Enter project tasks. Sequence the tasks. Define resources. Estimate Task duration and assign resources. Baseline the project. Track project progress. Lab 1: Creating a Basic Project with a template Lab 2: Creating a Basic Project Setting Up a Project Use multiple methods to create a new project from an Excel file and a SharePoint Tasks list. Establish one or more calendars to constrain resource availability. Configure Project to calculate the schedule from the Start Date forward, or from the Finish Date backward. Lab 1: Setting Up a Project Manually Schedule vs. Auto Schedule Students practice switching tasks between Manually Schedule and Auto Schedule modes. By switching modes, students learn the impact made on the project schedule and the individual tasks. Lab 1: Explore Task Modes Creating a Work Breakdown Structure Build and use summary and subordinate tasks. Understand and use milestones. Develop WBS Outlines. Assign completion criteria. Evaluate the WBS. Understand and use WBS templates. Lab 1: Manipulate a WBS Lab 2: Supporting the Project Plan Identifying Task Relationships Understand the different types of task relationships. Understand and use various methods to create relationships. Determine and display task sequence. Understand and use lag, lead, and delay. Understand the new feature of Task Paths. Lab 1: Display the sequence Defining Resources within Project Define resource types. Define individual resources that will be used on the project. Record the cost (s) of using each type of resource. Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource. Lab 1: Resource Calendar and Availability Making Work Package Estimates Enter estimates for duration and costs for each task. Distinguish between task types and describe when each is appropriate. Describe the relationship between work, units, and duration. Describe the way Effort Driven scheduling is affected by work, units, and duration. Assign tasks to resources using the Team Planner view. Lab 1: Work, Duration and Labor Creating an Initial Schedule Calculate float and identify a project?s critical path. Understand and identify task constraints. Create milestones. Use the Task Inspector to troubleshoot the initial schedule. Lab 1: Calculating an Initial schedule Create a Resource Leveled Schedule Adjust a project schedule to account for limited people and other resources. View the overall cost and schedule of a project. Identify resources that have been over allocated for a project schedule. Use multiple ways to adjust tasks and assignments to remove over allocation for any resource. Lab 1: Resource Leveling Managing the Project Learn how to set a baseline. Lean how to enter and track project performance data. Learn how to apply different tracking methods. Learn how to perform a variance analysis on a project. Lab 1: The Baseline Lab 2: Baselining & Tracking Performance Lab 3: Variance Formatting Output and Printing Reports Print Views Formats Sorting Filtering Grouping Custom Fields Reporting Other File Formats Lab 1: Use the Grouping Feature Lab 2: Create Reports in Project Managing Multiple Projects Learn how to use common resources among multiple projects. Learn how to link tasks between multiple projects. Learn how to create a consolidated view of multiple projects. Lab 1: Identifying Over allocated Resources from a Resource Pool and Consolidated File Advanced Topics Learn how to customize the Ribbon and the Quick Access Toolbar. Learn how to customize WBS numbering. Learn the concepts of Formulas and Graphical indicators. Learn the purpose of the Global template and Organizer. Learn how to use Task Deadlines. Learn how to record a Macro. Lab 1: Recording a Macro in Project Summary Learn how to access the Office App Store. Additional course details: Nexus Humans 55205 Mastering Microsoft Project 2016 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55205 Mastering Microsoft Project 2016 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for new and experienced programmers that want to learn how to write and troubleshoot Python code. This is the Microsoft recommended course for preparing for the 98-381 test. Previous programming experience is not required but recommended. Overview By the end of this course, you will be able to: Create Operations using Data Types and Operators Create Control Flow Operations Create Input and Output Operations Write and Document code to solve a specified problem Troubleshoot Problems and Write Error Handling Operations Perform Operations Using Modules and Tools This five-day instructor-led course (three-day boot camp) is intended for students who want to learn how to write, debug and document Python code Module 1: Perform Operations Using Data Types and Operators Assign data types to variables Perform data and data type operations Perform Arithmetic, Comparison and Logical Operations Review Module 2: Control Flow with Decisions and Loops Construct and analyze code segments that use branching statements Construct and analyze code segments that perform iterations Review Module 3: Perform Input and Output Operations Create Python code segments that perform file input and output operations Create Python code segments that perform console input and output operations Review Module 4: Document and Structure Code Construct and analyze code segments Document code segments using comments and documentation strings Review Module 5: Perform Troubleshooting and Error Handling Analyze, Detect and Fix code segments that have errors Analyze and construct code segments that handle exceptions Review Module 6: Perform Operations Using Modules and Tools Use Built-In Modules to perform basic operations Use Built-In Modules to perform complex operations Review

Duration 3 Days 18 CPD hours This course is intended for This course is intended for both novice and experienced project managers, managers, schedulers, and other project stake holders who need to incorporate the discipline of project management with Microsoft Project 2019. Overview Understand the discipline of project management as it applies to using Microsoft Project 2019. Create a Work Breakdown Structure. Identify Task Types & Relationships. Define Resources within Project. Make Work Package Estimates. Create an Initial Schedule. Create a Resource Leveled Schedule. Create Projects from templates, Excel files. Create Global templates. Create formulas and graphical indicators. The steps to record a macro. Format Output and Print Reports. Integrate Multiple Projects. Set up a Project with a Calendar, Start date, and scheduling method. Understand Manually Schedule vs. Auto Schedule. Manage multiple projects. Be able to create a master project list with shared resources. This three-day instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they?ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress. 1 - Introduction to Microsoft Project Describe how Project relates to the discipline of Project management. Learn what the new features are in Project 2019. Navigate to the primary views available using the Ribbon. Choose Views that display task, resource, or assignment information. Select table within views to change the information that is available to see and edit. Relate the features of Project to the 5 steps for building a plan in Project. Learn new accessibility features in Project 2 - A Quick and Easy Overview of Managing with Project Create a new project and prepare it for data entry. Enter project tasks. Sequence the tasks. Define resources. Estimate Task duration and assign resources. Baseline the project. Track project progress. 3 - Setting Up a Project Use multiple methods to create a new project from an Excel file and a SharePoint Tasks list. Establish one or more calendars to constrain resource availability. Configure Project to calculate the schedule from the Start Date forward, or from the Finish Date backward. 4 - Manually Schedule vs. Auto Schedule Students practice switching tasks between Manually Schedule and Auto Schedule modes. By switching modes, students learn the impact made on the project schedule and the individual tasks. 5 - Creating a Work Breakdown Structure Build and use summary and subordinate tasks. Understand and use milestones. Develop WBS Outlines. Assign completion criteria. Evaluate the WBS. Understand and use WBS templates. 6 - Identifying Task Relationships Understand the different types of task relationships. Understand and use various methods to create relationships. Determine and display task sequence. Understand and use lag, lead, and delay. Understand the new feature of Task Paths. 7 - Defining Resources within Project Define resource types. Define individual resources that will be used on the project. Record the cost (s) of using each type of resource. Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource. 8 - Making Work Package Estimates Enter estimates for duration and costs for each task. Distinguish between task types and describe when each is appropriate. Describe the relationship between work, units, and duration. Describe the way Effort Driven scheduling is affected by work, units, and duration. Assign tasks to resources using the Team Planner view. 9 - Creating an Initial Schedule Calculate float and identify a project?s critical path. Understand and identify task constraints. Create milestones. Use the Task Inspector to troubleshoot the initial schedule. 10 - Create a Resource Leveled Schedule Adjust a project schedule to account for limited people and other resources. View the overall cost and schedule of a project. Identify resources that have been overallocated for a project schedule. Use multiple ways to adjust tasks and assignments to remove over allocation for any resource. 11 - Managing the Project Learn how to set a baseline. Lean how to enter and track project performance data. Learn how to apply different tracking methods. Learn how to perform a variance analysis on a project. Learn how to Reschedule Work Learn how to inactivate tasks Learn how to synch projects to SharePoint 12 - Formatting Output and Printing Reports Print Views Formats Sorting Filtering Grouping Custom Fields Reporting Other File Formats 13 - Managing Multiple Projects Learn how to use common resources among multiple projects. Learn how to link tasks between multiple projects. Learn how to create a consolidated view of multiple projects. 14 - Advanced Topics Learn how to customize the Ribbon and the Quick Access Toolbar. Learn how to customize WBS numbering. Learn the concepts of Formulas and Graphical indicators. Learn the purpose of the Global template and Organizer. Learn how to record a Macro.

Duration 2.75 Days 16.5 CPD hours This course is intended for This course is designed for a person with an understanding of project management concepts, as well as general desktop computer skills, and who will be responsible for creating and maintaining project plans. This course will give you the fundamental understanding as well as acquiring the advanced knowledge and skills needed to update a project plan in Microsoft Project during the execution, monitoring, and controlling phases of a project. Overview Identify project management concepts and navigate Microsoft 2. 2. Project Professional. Create a new project plan. Add tasks to a project. Manage task relationships within a project. Manage project resources. fnalize a project plan. Update a project plan. Generate project views to manage a project. Create project reports to share a project's status. Reuse project plan information. Work with multiple projects. This course will familiarize the user with the basic features and functions of MS Project so that it can be used effectively and efficiently in a real-world environment. MS project will give the ability to project managers to update a project plan in Project during the execution, monitoring, and controlling phases of a project GETTING STARTED WITH MICROSOFT PROJECT Topic A: Identify Project Management Concepts Topic B: Navigate in the Microsoft Project Desktop environment DEFINING A PROJECT Topic A: Create a New Project Plan File Topic B: Set Project Plan Options Topic C: Assign a Project Calendar ADDING PROJECT TASKS Topic A: Add Tasks to a Project Plan Topic B: Enter Task Duration Estimates MANAGING TASKS Topic A: Create a Work Breakdown Structure Topic B: Define Task Relationships Topic C: Schedule Tasks MANAGING PROJECT RESOURCES Topic A: Add Resources to a Project Topic B: Create a Resource Calendar Topic C: Enter Costs for Resources Topic D: Assign Resources to Tasks Topic E: Resolve Resource Conflicts FINALIZING A PROJECT PLAN Topic A: Optimize a Project Plan Topic B: Set a Baseline Topic C: Share a Project Plan UPDATING A PROJECT PLAN Topic A: Enter Task Progress Topic B: Enter Overtime Work Topic C: Edit Tasks Topic D: Update Cost Rate Tables Topic E: Update a Baseline VIEWING PROJECT PROGRESS Topic A: Use View Commands Topic B: Add a Custom Field Topic C: Create Custom Views Topic D: Format and Share the Timeline View REPORTING ON PROJECT PROGRESS Topic A: View Built-in Reports Topic B: Create Custom Reports Topic C: Create a Visual Report REUSING PROJECT PLAN INFORMATION Topic A: Create a Project Plan Template Topic B: Share Project Plan Elements with Other Plans WORKING WITH MULTIPLE PROJECTS Topic A: Share Resources Topic B: Link Project Plans Additional course details: Nexus Humans Microsoft Project training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Project course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. Use advanced analysis techniques. Enhance reports and dashboards. Publish and share reports and dashboards. Extend Power BI beyond the desktop. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Connecting to Data Sources Topic A: Create Data Connections Topic B: Configure and Manage Data Relationships Topic C: Save Files in Power BI Performing Data Cleaning, Profiling, and Shaping Topic A: Clean, Transform, and Load Data with the Query Editor Topic B: Profile Data with the Query Editor Topic C: Shape Data with the Query Editor Topic D: Combine and Manage Data Rows Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Enhancing Data Analysis Topic A: Customize Visuals and Pages Topic B: Incorporate Tooltips Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards Using Advanced Analysis Techniques Topic A: Create Calculated Tables, Variables, and Parameters Topic B: Enhance Visuals with Statistical Analysis Topic C: Perform Advanced Analysis Enhancing Reports and Dashboards Topic A: Enhance Reports Topic B: Enhance Dashboards Publishing and Sharing Reports and Dashboards Topic A: Publish Reports Topic B: Create and Manage Workspaces Topic C: Share Reports and Dashboards Extending Power BI Beyond the Desktop Topic A: Use Power BI Mobile Topic B: Extend Access with the Power BI API Additional course details: Nexus Humans Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for Anyone whose role requires them to use existing Power BI Reports or Dashboards to consume the contents. Roles can include management at all levels, team leaders or anyone who needs to commission the production of reports or dashboards. It is assumed that attendees on the course are familiar with charts. Please note that this course is not suitable for new Excel users, delegates need Ability to create charts Ability to use filters in data Overview This course covers the use of Power BI Desktop and the Power BI service hosted in Office 365 to identify core features, terminology and processes applicable when using reports or dashboards.Delegates will learn how to: Power BI Concepts and Main Features How a report is created Navigating reports and dashboards How to apply filters and slicers To use Insights, Analytics and Natural Language Queries Power BI provides a variety of methods for using reports and dashboards within which data can be viewed and analyzed visually. Getting Started with Power BI Power BI Concepts and Versions Introduction to Main Features: Jargon buster From Data to Reports and Dashboards Visualizations Overview Visualizations Available Visualizations as Filter Reports and Dashboards Similarities and differences Understanding what you are looking at Understanding what you are looking at Using a Report in Power BI Filters, sorting and using slicers See the actual data See Data and See Records Drill visualizations Off the shelf data analysis Quick Conditional Formatting Analytics lines Use Insight for Increases and Decrease Forecast Analytics Changing calculations and Show As Working with Dashboards Dashboards in Power BI Defined How is a dashboard different from a report? Working in the Dashboard window

Duration 4 Days 24 CPD hours This course is intended for This is an introductory-level C++ programming course designed for developers with experience programming in C or other languages. Practical hands-on prior programming experience and knowledge is required. Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in basic coding with C++, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn: Writing procedural programs using C++ Using private, public and protected keywords to control access to class members Defining a class in C++ Writing constructors and destructors Writing classes with const and static class members Overloading operators Implementing polymorphic methods in programs Writing programs using file I/O and string streams Using manipulators and stream flags to format output Using the keyword template to write generic functions and classes Writing programs that use generic classes and functions Writing programs that use algorithms and containers of the Standard Library Apply object-oriented design techniques to real-world programming problems Using algorithms and containers of the Standard Library to manipulate string data Understand how C++ protects the programmer from implementation changes in other modules of an application Using try() blocks to trap exceptions Using catch() blocks to handle exceptions Defining exceptions and using throw to trigger them Introduction to C++ Programming / C++ Essentials is a skills-focused, hands-on C++ training course geared for experienced programmers who need to learn C++ coupled with sounds coding skills and best practices for OO development. Students will leave this course armed with the required skills to put foundation-level C++ programming skills right to work in a practical environment. The central concepts of C++ syntax and style are taught in the context of using object-oriented methods to achieve reusability, adaptability and reliability. Emphasis is placed on the features of C++ that support abstract data types, inheritance, and polymorphism. Students will learn to apply the process of data abstraction and class design. Practical aspects of C++ programming including efficiency, performance, testing, and reliability considerations are stressed throughout. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency Moving from C to C++ (Optional) New Compiler Directives Stream Console I/O Explicit Operators Standard Libraries Data Control Capabilities Handling Data New Declaration Features Initialization and Assignment Enumerated Types The bool Type Constant Storage Pointers to Constant Storage Constant Pointers References Constant Reference Arguments Volatile Data Global Data Functions Function Prototypes and Type Checking Default Function Data Types Function Overloading Problems with Function Overloading Name Resolution Promotions and Conversions Call by Value Reference Declarations Call-by-Reference and Reference Types References in Function Return Constant Argument Types Conversion of Parameters Using Default Initializers Providing Default Arguments Inline Functions Operator Overloading Advantages and Pitfalls of Overloading Member Operator Syntax and Examples Class Assignment Operators Class Equality Operators Non-Member Operator Overloading Member and Non-Member Operator Functions Operator Precedence This Pointer Overloading the Assignment Operator Overloading Caveats Creating and Using Objects Creating Automatic Objects Creating Dynamic Objects Calling Object Methods Constructors Initializing Member consts Initializer List Syntax Allocating Resources in Constructor Destructors Block and Function Scope File and Global Scope Class Scope Scope Resolution Operator :: Using Objects as Arguments Objects as Function Return Values Constant Methods Containment Relationships Dynamic Memory Management Advantages of Dynamic Memory Allocation Static, Automatic, and Heap Memory Free Store Allocation with new and delete Handling Memory Allocation Errors Controlling Object Creation Object Copying and Copy Constructor Automatic Copy Constructor Conversion Constructor Streaming I/O Streams and the iostream Library Built-in Stream Objects Stream Manipulators Stream Methods Input/Output Operators Character Input String Streams Formatted I/O File Stream I/O Overloading Stream Operators Persistent Objects Introduction to Object Concepts The Object Programming Paradigm Object-Orientated Programming Definitions Information Hiding and Encapsulation Separating Interface and Implementation Classes and Instances of Objects Overloaded Objects and Polymorphism Declaring and Defining Classes Components of a Class Class Structure Class Declaration Syntax Member Data Built-in Operations Constructors and Initialization Initialization vs. Assignment Class Type Members Member Functions and Member Accessibility Inline Member Functions Friend Functions Static Members Modifying Access with a Friend Class Templates Purpose of Template Classes Constants in Templates Templates and Inheritance Container Classes Use of Libraries Strings in C++ Character Strings The String Class Operators on Strings Member Functions of the String Class Inheritance Inheritance and Reuse Composition vs. Inheritance Inheritance: Centralized Code Inheritance: Maintenance and Revision Public, Private and Protected Members Redefining Behavior in Derived Classes Designing Extensible Software Systems Syntax for Public Inheritance Use of Common Pointers Constructors and Initialization Inherited Copy Constructors Destructors and Inheritance Public, Protected, Private Inheritance Exceptions Types of Exceptions Trapping and Handling Exceptions Triggering Exceptions Handling Memory Allocation Errors C++ Program Structure Organizing C++ Source Files Integrating C and C++ Projects Using C in C++ Reliability Considerations in C++ Projects Function Prototypes Strong Type Checking Constant Types C++ Access Control Techniques Polymorphism in C++ Definition of Polymorphism Calling Overridden Methods Upcasting Accessing Overridden Methods Virtual Methods and Dynamic Binding Virtual Destructors Abstract Base Classes and Pure Virtual Methods Multiple Inheritance Derivation from Multiple Base Classes Base Class Ambiguities Virtual Inheritance Virtual Base Classes Virtual Base Class Information The Standard Template Library STL Containers Parameters Used in Container Classes The Vector Class STL Algorithms Use of Libraries

Duration 5 Days 30 CPD hours This course is intended for This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices. Targeted at: DBAs and Architects, and appropriate for Analysts, Support Engineers, and other IT professionals Overview Please refer to overview This is an immersive 5-day class that offers hands-on labs and combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration into a one-week class, with significant savings over list price. Upon course completion, you will be prepared to manage mission critical PostgreSQL installations, and perform core administration tasks with confidence and skill. Course Outline 1 - POSTGRES SYSTEM ARCHITECTURE 2 - INSTALLATION AND GETTING STARTED 3 - CONFIGURATION, CREATING, MANAGING DATABASES 4 - USER TOOLS ? USING PSQL 5 - GUI TOOLS - USING PGADMIN 4 6 - SECURITY BASICS 7 - SQL PRIME BACKUP AND RECOVERY 8 - ROUTINE MAINTENANCE 9 - POSTGRES DATA DICTIONARY 10 - MOVING DATA 11 - SQL TUNING 12 - PERFORMANCE TUNING 13 - STREAMING REPLICATION 14 - TABLE PARTITIONING 15 - EXTENSION MODULES 16 - MONITORING 17 - UPGRADING BEST PRACTICES

Duration 3.25 Days 19.5 CPD hours This course is intended for This course is intended for IT administrators with a minimum 2-5 years of experiencing working with Microsoft Windows Server, Windows 10, and Office 365 licensing. The course will utilize a pre-provisioned lab environment which includes Microsoft 365 E5 licenses and Enterprise Mobility and Security E5 licenses for each student. Powershell management topics will be discussed where applicable in the respective topics. This course will address Windows devices only enrolled in Intune. Configuring and Licensing Intune Endpoint Manager - quick discussion, portal access Discuss which licenses include Intune Discuss Microsoft Intune device-only subscription Discuss Azure Active Directory basic, P1, P2 licensing Intune setup and overview of capabilities Supported configurations Logging in and using Intune Admin portal via Azure Portal and via Endpoint manager site Configure a domain name (needed to support labs though may be done already for E1B/district) Add users and groups in Azure Portal Configure Azure AD connect and discuss AAD Connect Health Assigning licenses manually, via Powershell, and via AAD groups Set the MDM authority and enable device enrollment Add Apps to Intune - covered in detail in a later topic Configuring device profiles - covered in detail in a later topic Company Portal discussion - covered in detail in a later topic Configure app policies - covered in detail in a later topic Windows device management What is co-management - brief discussion on Endpoint Manager with Configuration Manager Registering, joining, hybrid join to Azure AD Enrollment method capabilities Azure AD joined Azure AD joined with Autopilot (User driven mode) Azure AD joined with Autopilot (Self deploying mode) Autopilot pre-provisioned deployment (formally known as white-glove) Device group tags for profile deployment Troubleshooting Autopilot Policy conflicts Known issues Using Powershell to connect to and manage Intune Software deployment Add apps to Intune Windows Store apps Microsoft Store for Business apps LOB apps - Sideloading Adding Win32 apps Running Powershell Scripts on devices Assigning Apps Monitor Apps Discovered Apps Configure Apps App Configuration Policies Office app policys Custom OMA-URI Policies Troubleshooting Managing devices Windows 10 Feature Updates Update rings to manage updates Mapping drives to SMB shares Discuss OneDrive for Business Manage Enterprise Wireless - Windows Configuration Designer, provisioning packages Implementing Conditional Access - device based, app based Printer management Universal Print Deploying printer settings Remote administration Intune Device Management Inventory Fresh Start Full Scan Remote Lock Restart Sync devices Bulk device actions Teamviewer integration requirements Intune Reporting Accessing Reports Exporting Reports using Graph

Duration 1 Days 6 CPD hours This course is intended for Anyone who wants to learn how to create movies - from a home movie to professional looking films using iMovie. This one-day hands-on course will teach the participant the full functionality of iMovie. The course will begin with how to import video and photographs into iMovie; how to review and organize the footage; how to shape a story using the editing and trimming tools; how to add music and sound and other video effects and overlays. Lastly, the class will explore sharing your completed movies with your Mac computer, YouTube and other streaming outlets. Introduction to iMovie Adding Media from Photo Library Other Ways to Import Media From iPad, iPhone, or iPod Touch Record Video Directly into iMovie Importing Media from Mac Playing or Skimming Video Sorting and Searching for Clips Marking Clips as Favorite or Rejected Creating Movies Creating a New Movie Viewing and Managing Projects Setting Movie Themes Selecting Clips Adding and Trimming Clips Moving and Splitting Clips Adding and Modifying Transitions Adding and Editing Titles Adding Music and Sound Clips Working with Trailers (If required) Creating Trailer Adding Video Adding Titles and Credits Converting Trailer to Movie Adding Video Effects Enhancing Clip Adjusting Clip?s Order Cropping and Rotating Clips Stabilizing Shaky Clips Adding Video Effects Adding Freeze Frame Creating Effects with Multiple Clips Slow Down and Speed Up Clips Adding Instant Replay or Rewind Effect Copy Effects and Adjustments Sharing Video Clips and Projects Email Movie, Trailer, and Clip Exporting Quick Time File Exporting an Image Share Online Customizing iMovie iMovie Preferences Customizing Project Settings Changing iMovie Window Layout Changing How Clips are Displayed Organizing Media Organizing Media and Events Working with Multiple Libraries Consolidating Projects and Events Keyboard Shortcuts and Gestures Overview of Keyboard Shortcuts Keyboard Shortcuts Multi-Touch Gestures Force Touch Trackpad Gestures