5666 Productivity courses

Duration 3 Days 18 CPD hours This course is intended for The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. Overview After completing this course, students will be able to: ? Perform Power BI desktop data transformation. ? Describe Power BI desktop modelling. ? Create a Power BI desktop visualization. ? Implement the Power BI service. ? Describe how to connect to Excel data. ? Describe how to collaborate with Power BI data. ? Connect directly to data stores. ? Describe the Power BI developer API. ? Describe the Power BI mobile app. The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. Introduction to Self-Service BI Solutions Introduction to business intelligence Introduction to data analysis Introduction to data visualization Overview of self-service BI Considerations for self-service BI Microsoft tools for self-service BI Lab : Exploring an Enterprise BI solution Introducing Power BI Power BI The Power BI service Lab : Creating a Power BI dashboard Power BI Using Excel as a data source for Power BI The Power BI data model Using databases as a data source for Power BI The Power BI service Lab : Importing data into Power BI Shaping and Combining Data Power BI desktop queries Shaping data Combining data Lab : Shaping and combining data Modelling data Relationships DAX queries Calculations and measures Lab : Modelling Data Interactive Data Visualizations Creating Power BI reports Managing a Power BI solution Lab : Creating a Power BI report Direct Connectivity Cloud data Connecting to analysis services Lab : Direct Connectivity Developer API The developer API Custom visuals Lab : Using the developer API Power BI mobile app The Power BI mobile app Using the Power BI mobile app Power BI embedded

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.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 4 Days 24 CPD hours This course is intended for The audience for this course is either: a Dynamics 365 consultant who wants to learn Commerce, or a retail analyst with core Dynamics 365 experience who wants to apply their skills to the Dynamics product family. Overview After completing this course, students will be able to: Configure Dynamics 365 Commerce Headquarters Configure products, prices, discounts, loyalty, and affiliations Manage Point of Sale (POS) in Dynamics 365 Commerce Configure and Manage Dynamics 365 Commerce call centers Manage e-commerce Dynamics 365 Commerce functional consultants set up and use the application functionality in Dynamics 365 Commerce, and provide support for the application. The functional consultant typically has a strong understanding of unified commerce business operations, and experience configuring, deploying, maintaining, and using Microsoft Dynamics 365 Commerce. This four-day course covers the essentials for the role Module 1: Get started with Dynamics 365 Commerce Introduction to Unified Commerce platform Dynamics 365 Commerce architecture Deployment of Dynamics 365 Commerce Hardware and peripherals Module 2: Configure Commerce Headquarters Configure prerequisites and Commerce parameters Configure and maintain payment processing Configure Commerce Data Exchange (CDX) Configure delivery modes and charges Configure and work with statements Module 3: Products and Merchandising Product information management Merchandising in Dynamics 365 Commerce Product recommendations and product discovery Module 4: Retail Pricing Manage Pricing Manage discounts and promotions Module 5: Loyalty and customer experience Customer Management Loyalty and affiliations Module 6: Point of sale Introduction to POS Channel Setup Configure Cash and Shift management Worker Setup Point of Sale Setup Customer management at POS Transaction processing Inventory processing End of day processing Reporting Configure and work with Task management Test POS Maintain registers and devices Localization Module 7: Configure and work with call centers in Dynamics 365 Commerce Configure channel Configure Product Catalogs Configure Order Holds Create call center orders Configure call center directed selling Configure Returns and Refunds Configure continuity orders and installment billing Module 8: Work with E-Commerce in Dynamics 365 Commerce Describe e-commerce core capabilities Configure an E-Commerce Channel in Dynamics 365 HQ Configure an E-Commerce site Configure and manage E-Commerce site content Describe & Demonstrate digital asset management Configure business-to-business (B2B) site Configure Ratings and reviews functionality Demonstrate E-Commerce Order Processing Module 9: Manage order fulfillment and inventory in Dynamics 365 Commerce Configure and work with Stock replenishment Configure and work with Order fulfillment Module 10: Work with Dynamics 365 Fraud Protection Overview of Dynamics Fraud Protection Describe Dynamics Fraud Protection Services Configure and work with Dynamics Fraud Protection with Dynamics 365 Commerce Additional course details: Nexus Humans MB-340T00: Microsoft Dynamics 365 Commerce Functional Consultant 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 MB-340T00: Microsoft Dynamics 365 Commerce Functional Consultant 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 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

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 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 2 Days 12 CPD hours This course is intended for This is an Intermediate PowerBI course geared for experienced users who wish to leverage the tool's more advanced capabilities Overview This course is about 50% hands-on lab and 50% lecture, designed to train attendees in essential PowerBI data handling functions and reporting skills, coupling the most current, effective techniques with the soundest practices. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses. Working in a hands-on learning environment led by our expert facilitator, students will learn how to: Create Advanced Power BI Reports Advanced understanding of the data schemas and extracting data Perform advanced transformations of data or any data schema Utilize time-phased data in the creation of complex analyses Create new measures using DAX Filter data using row-level security Create and deploy content packs Use Power BI to integrate with line-of-business applications Next Level Power BI for Experienced Users is a two day, course that provides attendees already experienced with Microsoft Power BI basics with a hands-on exploration of intermediate and beyond level features. This course is geared for attendees ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise?s other line-of-business tools. Get Project Online Data Select and mine relevant tables with ODATA Advanced ODATA data mining Importing other data formats Advanced Editing of data queries Advanced Data Transformations Managing table relationships Creating & using data hierarchies Creating custom columns and measures and metrics for filtering and reporting Creating Power BI Reports Using advanced visualizations Configuring drill-down Modifying visual interactions Importing and creating custom visuals Configure Power BI Security Creating Dashboard and row-level security Utilizing Filtering using row-level security Publishing Reports and Dashboards Building Mobile Reporting Creating and deploying content packs Configuring natural language query

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