27600 Courses

Construction Cost Estimation Estimating costs is a critical component of construction management. A construction project's success is heavily reliant on cost estimation. The construction cost estimation process is a detailed process that necessitates a number of steps in order to determine the true costs of a project. In the construction industry, professional cost estimators are hired to evaluate and analyze project costs. As a result, the demand for cost estimators continues to rise with each passing year. This Level 1 Construction Cost Estimation course is designed for anyone who wants to become a competent and confident Construction Manager. This Construction Cost Estimation course is designed by highly skilled professionals to provide you with an effective understanding of the cost estimation process in construction management. Learn how and why accurate construction project estimates are required while studying a breakdown of the estimating procedure and key planning processes. You will also learn the significance of estimating for variations, how project budgets must often be revised, and the risks of inaccurate estimation in this Construction Cost Estimation course. Other three courses that are included with our Construction Cost Estimation Course Course 01: Level 1 Health and Safety in a Construction Environment Course 02: Level 2 Health and Safety in the Workplace Training Course 03: Level 7 Construction Management Course Others Benefits of Construction Cost Estimation Course Free 4 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [Note: Free PDF certificate will be provided as soon as the Construction Cost Estimation Course is completed] Construction Cost Estimation Industry Experts Designed this Construction course into 3 detailed modules. Detailed Course Curriculum of this Construction course Module 01: An Overview of Construction Management Module 02: More About Construction Management Module 03: Cost Estimation in Construction Industry Assessment Method of Construction Cost Estimation After completing each module of the Construction Cost Estimation Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Construction Cost Estimation After completing the MCQ/Assignment assessment for this Construction Cost Estimation course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Construction Cost Estimation This Construction Cost Estimation Course is ideal for: Managers, supervisors and team leaders Small business owners and Entrepreneurs Staff working in Construction industry and wishing to enhance their CVs Requirements Construction Cost Estimation There are no specific requirements for this Construction Cost Estimation course because it does not require any advanced knowledge or skills. Career path Construction Cost Estimation Opportunities included with our Construction Cost Estimation course: Cost Estimation - Construction Assistant Cost Estimation - Construction Coordinator Cost Estimation - Site Assistant Certificates Certificate of completion Digital certificate - Included

High quality specifications are of paramount importance in achieving the right technical performance and value for money. This long-established training programme has been developed to help those involved in producing specifications to create high quality documents in an organised and effective way. It provides a sound foundation for those new to the topic whilst at the same time offering new insights to those with more experience. The programme emphasises the need for a clear definition of requirements combined with the ability to communicate those requirements effectively to third parties. A structured method of preparing specifications is provided, and a range of practical techniques is presented, to enable participants to put the principles into practice. The commercial and contractual role of specifications is also addressed. The objectives of the workshop are to: Provide a clear understanding of the role and purpose of specifications Present a framework for organising and producing specifications Define the key steps involved in creating effective specifications Demonstrate methods for assisting in defining requirements Provide tools and techniques for scoping and structuring specifications Show the role of specifications in managing variations and changes to scope Present methods to assist the writing and editing of specifications Review how specifications should be issued and controlled DAY ONE 1 Introduction Review of course objectives Review of participants' needs and objectives 2 Creating effective specifications The role of specifications in communicating requirements The costs, benefits and qualities of effective specifications Understanding the differences between verbal and written communication The five key steps of 'POWER' writing: prepare-organise-write-edit-release Exercise: qualities of an effective specification 3 Step 1: Preparing to write - defining readership and purpose; the specification and the contract Designing the specifications required; applying BS 7373 Defining the purpose, readership and title of each document Effective procedures for writing, issuing and controlling specifications The roles and responsibilities of the key players Understanding contracts; the contractual role of the specification Integrating and balancing the technical and commercial requirements Writing specifications to achieve the appropriate contract risk strategy Deciding how to specify: when to use functional and technical specifications The role of specifications in managing variations and changes to scope 4 Case study 1 Teams review a typical project scenario and identify the implications for the specification Feedback and discussion 5 Step 2: Organising the specification content Defining the need and establishing user requirements Deciding what issues the specification should cover Scoping techniques: scope maps, check lists, structured brainstorming Clarifying priorities: separating needs and desires Dealing with requirements that are difficult to quantify Useful techniques: cost benefit analysis, QFD, Pareto analysis 6 Case study 2 Teams apply the scoping techniques to develop the outline contents for a specification Feedback and discussion DAY TWO 7 Step 2: Organising the specification content (cont) Deciding what goes where; typical contents and layout for a specification The three main segments: introductory, key and supporting Creating and using model forms: the sections and sub-sections Detailed contents of each sub-section Tools and techniques for outlining and structuring specifications 8 Case study 3 Teams develop the detailed specification contents using a model form Feedback and discussion 9 Step 3: Writing the specification The challenges of written communication Identifying and understanding the readers needs Choosing and using the right words; dealing with jargon Problem words; will, shall, must, etc; building a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity Being concise and ensuring clarity Choosing and using graphics to best effect Exercises and examples 10 Step 4: Editing the specification Why editing is difficult; how to develop a personal editing strategy Key areas to review: structure, content, accuracy, clarity, style and grammar Editing tools and techniques 11 Step 5: Releasing and controlling the specification Key requirements for document issue and control Final formatting and publication issues; document approval Requirements management: managing revisions and changes 12 Course review and action planning What actions should be implemented to improve specifications? Conclusion

'Selling' doesn't work. You've got to help customers buy. And that means engaging with the customer in a positive way, showing that you understand their requirement and giving them confidence that your product or service is the best possible way of meeting that requirement. This may sound painless but there's more to it than meets the eye and it's all too easy to get it wrong. You need to follow a process. This programme will help participants: Understand 'how buyers buy' and align their selling activities accordingly Recognise the difference between 'latent pain' and 'active vision' opportunities Conduct effective pre-call planning and research Stimulate interest and establish credibility with your prospects Get prospects to share / admit high priority pain Engage in consultative dialogue that promotes the differentiating strengths of your offerings Gain access to 'power' people within an opportunity Effectively qualify and disqualify opportunities based on objective decision criteria Better control and manage sell cycles Improve their chances of winning competitive opportunities Shorten sales cycles and avoid 'no decision' Negotiate the steps leading to a successful sale 1 An introduction to selling Understanding the key points that encourage a customer to purchase from us The difference between consultative selling and a transactional sale Understanding the roles that trust and empathy play in a sale Understanding how tricks and manipulation can sink a sale Vital pre-meeting research that must take place before a conversation Understanding how the customer sees us and why positioning is important 2 Structuring the sales conversation process Defining a set process for structuring a sales call with a chance to demonstrate understanding How the first minute of a conversation can destroy a sale Understanding BPO objectives for a sale How a step-by-step sales conversation process helps win more sales Understanding the mis-match between the customers buying process How our sales processes can lead to mistakes 3 How and why people buy An insight into the emotional factors behind how people arrive at purchasing decisions Using research from neuroscience that shows how sales people can really make mistakes Understanding how people make decisions about larger purchases Understanding the stakeholders in companies and their buying motives How to analyse the stakeholders and determine a win-plan 4 Understanding the funnel Studying the sales and buying process to understand the ratios of sales to prospects and better forecasting Understanding the role of forecasting in sales analysis Why many forecasts are nearly always wrong Understanding the stages of a sales process How 'verifiable outcomes' can really change forecasting 5 Questioning techniques Understanding the different questioning techniques and when they should be used Using the 'knowledge tree' as a framework for questioning Understanding the use of real empathy to help customers uncover their needs How effective research can really empower your questions How to ask 'high gain' questions How to ask difficult questions without feeling intrusive 6 Features and benefits How to practically apply them in a sales scenario How to align the benefits to customers' business goals Really understanding the difference and how to demonstrate true economic benefits to a customer How to discover business goals, and align value propositions to these How to craft an effective value proposition for a customer Using the SAR storytelling method to really engage customers to align their thinking patterns Using the latest neuroscience research that explains what customers are really thinking 7 Overcoming objections How 'confirmation bias' can hinder any sales conversation How the CLARA method of responding to customer concerns can dramatically improve the chances of customers responding to us in a positive way Practising the method to become comfortable and congruent with it 8 Closing the sale A deep dive into what closing is How different sales have different closes How too many closing methods can destroy a sale How to lead up to a close with a logical sequence of questions Using the ACSAT trust method of closing A clear methodology with a chance to practise the skills in a fun way

Investigate and recognise the role of project sponsor and the importance of the relationship between sponsor and project manager and how this can be improved. Course overview Duration: 1 day (6.5 hours) This workshop is designed to investigate, understand and develop the role of the project sponsor. By taking elements of effective governance from the guidance published by the APM (Association for Project Management) and Axelos Managing Successful Programmes, an improved project sponsor capability can be developed. The workshop will also explore the importance of the relationship between sponsor and project manager and how this can be improved. Whilst predominately designed for the project sponsor role, there is provision for a discussion with project manager representatives to agree an action plan to improve the delivery of projects within an organisation. Objectives  By the end of the course you will be able to: Describe and commit to the role of the Project Sponsor Identify the key principles of governance that can contribute to success Describe the environment in which the projects are delivered Explain the financial and resource constraints within the project environment Define the criteria used for project selection Identify the expectations of key stakeholders and develop a clear communication plan to engage with them Identify and resolve areas of conflict Describe the relationship with the Project Manager Create an effective environment and relationship for project success Content Introduction The Project Environment The Principles of Governance The background to the training Roles The Project Sponsor The Project Manager The Project Board Sponsor responsibilities Defining Project Selection Criteria and Prioritisation Business Case and Justification Finance and Funding Resourcing the projects Stakeholder Engagement Project Governance Resolving conflict between stakeholders Benefits Realisation Capitalising the lessons learned during project reviews Delivering success The relationship with the Project Manager and team Action Plan for the future The workshop will use case studies drawn from previous client projects, both successful and less successful.

Description The Diploma in UI Design course teaches you all about UI or user interface design. You will learn the procedures of designing design modern, intuitive, meaningful, compelling user interfaces for desktop and mobile devices. For developing UI for machines and software, you need to have an active command over Photoshop and colour theory. The course will help you to master the essential tools and functions for designing UI. The course covers the Keyboard shortcuts for Photoshop, Photoshop extension for speed up your design, using different colour schemes, using typography and other online tools. The course teaches you to design modern HERO or Headers, dashboard graphs and other elements of the website. You will also learn about Custom Script, Gradients and Patterns for UI design. Upon completion, you will be able to create a stunning UI for mobile or desktop. Entry Requirement: Novice/Beginner Level Designers Web Designer Graphic Designer Web Developers who want to learn UI Design UI Designer who wants more advanced techniques Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introductions 1) Promo Intro Video 00:04:00 1.1) Upload And Review Your Work-1 00:03:00 Setting Up Photoshop for UI Design 2.2) Setting up Photoshop CC Preferences 00:06:00 2.3) Color Profile Settings for ui design 00:05:00 2.5) Creating Custom Shortcut Keys 00:04:00 2.6) Installing scripts in Photoshop 00:06:00 2.8) What area Photoshop Extensions 00:07:00 2.9) Power of Photoshop Extensions 00:09:00 2.10) How to install Extension in mac and win update 00:16:00 (Optional - Can watch at the end) Color Calibration and Monitors for Designers 2.5-1 Color Calibration 00:08:00 2.5-2 Monitor You Need-1 00:02:00 2.5 - 3 OS Based clor Calibration 00:07:00 Basics of Photoshop for Beginners 00.Customize Toolbar 00:04:00 01.how Photoshop interface works 00:05:00 02.creating photoshop new document 00:04:00 03.what are artboards 00:06:00 04.Layers Panel Part 1 00:06:00 05.Layer Panel Filtering And Finding Part 2 00:06:00 07.Type tool 00:05:00 08.Character Panel 00:07:00 09.Paragraph Panel 00:04:00 10.New Shape Tool 00:08:00 12.Deep dive in Pen Tool 00:16:00 12.selections-april2017 New 00:07:00 13.pen tool in web design 00:04:00 14.Alignments 00:06:00 15.common-shortcuts 00:15:00 16.Clipping_Masks 00:03:00 17.exercise_clipping_mask 00:01:00 18.LayerMasks_HB 00:05:00 19.smart_objects 00:08:00 20.linked smart objects_Revised 00:07:00 21.Layer comps usage 00:06:00 22 Using Smart Guides In Photoshop-1 00:05:00 Layer Styles Basics for UI Design 1.Drop Shadow Layer Effect 00:04:00 2. Inner Shadow UI Design 00:02:00 3.stroke_effect 00:03:00 4. Re-using layer styles 00:02:00 Gradients in Web and UI Design 1.what.are.gradients 00:02:00 2.uses.of.gradients 00:04:00 3.3ways-to-create-gradients 00:05:00 4.how to use gradient editor 00:08:00 5.using-gradient-overlay 00:06:00 Using Patterns in Web and UI Design 1.what are patterns 00:02:00 2. two methods of applying patterns 00:05:00 3.create Pattern From an Img File 00:03:00 04. using .pat files in photoshop 00:05:00 Basics of UI Design | Light, Shadows, Color schemes & Typography 01. How light and shadow works in UI Design 00:04:00 2.examples of lightshadow 00:02:00 3.color schemes for beginners 00:02:00 4.getting scheme from logo and hsb 00:01:00 5.online tools for color schemes 00:07:00 6.how to choose fonts and typography 00:09:00 7.Using Grids for Web Design 00:06:00 8.Creating Grids In Photoshop 00:06:00 UI Design Exercises & Challanges with Step by Step solutions 1.soft-shadow button challange 00:01:00 2.soft_button_solution 00:13:00 3.3d Button Challange 00:01:00 4.Pressed effect in Photoshop 00:07:00 5.modern pattern part 1 00:09:00 6.modern header design part 2 00:09:00 7.moder header design new variation 00:09:00 8.color overlay header 00:11:00 09 Gradienteffect Header Design-audiosynced 00:13:00 9.Actual Exercise Transparent Image Header-1 00:13:00 10.tabs-intro 00:01:00 11.tabs-part1 00:14:00 12.tabs-part2 00:08:00 Image Editing 101 for UI Designers 1.removing White Bg With Blending Options 00:03:00 2.Spot Healing brush usage 00:04:00 3.making Colors Pop in Photohsop 00:07:00 4.magnetic Lasso Tool to remove background 00:16:00 5.select And Mask Tool 00:10:00 IOS App Design : Exercise Iphone Food Deals App 1.Gathering Resources IOS App-Design 00:04:00 2.Lets Start The IOS App Design 00:05:00 3.Adding Images To Design the App design 00:06:00 4.Adding Text On App Screen 00:06:00 5.Adding Phone And Book Now Buttons 00:12:00 6.Using Mobile Mockups 00:04:00 UDEMY ONLY App Design Challane-exercise 00:06:00 BONUS: Dribbble styled Dashboard UI Design (Student Request) 1.area graph base design 00:04:00 2area graph grid 00:05:00 3.adding text to graph area 00:08:00 4.drwaing area graph with pen tool 00:04:00 5.designing extras adding dots and hover info 00:06:00 7.final Adjustments To Area Graph-1 00:10:00 8.area graph to line graph 00:04:00 9.circular bar graph base shape.mp4 00:06:00 10.adding Gradients And Shadows To Circular Graphs-1 00:13:00 11.designing stats with text 00:09:00 12.bar Graph Design In Photoshop Pt 00:09:00 13.Bar Graph Adding Text 00:06:00 14.Student-request-ciruclar-percentage graph 00:08:00 Wifreframes in UI Design + Ultimate Web Design Challange 1.what Are Wirefreams 00:04:00 2.Tools Used For Wireframes 00:12:00 Dribbble Shot Redesign Exercise - Student Request dribbble redesig part 1 00:15:00 dribble shot part 2 00:15:00 Exercises : Form UI Design with Photoshop 1.Base Of Login Form 00:07:00 2.Form Fields Design 00:12:00 3.Finishing Form Design 00:12:00 Pro Secret Tips and Tools for Designers and Developers Converting psd to CSS 00:06:00 Exporting Images from Photoshop 00:07:00 Tips on Using Grids 00:02:00 Photoshop Features Updates and New Versions 3.Match Fonts Cc2015.5-1 00:03:00 Cc2018 Update-1 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Understand the biases we all have and the impact they can have in the workplace. Look at how to minimise their impact on others and the organisation. Course overview Duration: 1 day (6.5 hours) The purpose of this course is to help individuals understand and recognise their own unconscious biases, and to provide strategies on how to minimise the impact of those biases in the workplace. The course will provide an overview of what unconscious bias is, its prevalence and impact, and ways to mitigate its effects. Objectives By the end of the course you will be able to: Define unconscious bias and recognise different types of bias Understand how unconscious bias affects decision-making and behaviours in the workplace Identify their own unconscious biases Understand the impact of unconscious bias on individual and team performance Apply strategies to mitigate the effects of unconscious bias in the workplace Content Module 1: Introduction to Unconscious Bias Definition of unconscious bias History and prevalence of unconscious bias Different types of unconscious bias (e.g. affinity bias, confirmation bias) Module 2: Understanding the Impact of Unconscious Bias How unconscious bias affects decision-making and behaviours in the workplace Examples of unconscious bias in the workplace Impact of unconscious bias on individual and team performance Module 3: Recognising Your Own Unconscious Biases Identifying personal biases Tools to recognise and minimise unconscious biases Module 4: Mitigating the Impact of Unconscious Bias in the Workplace Best practices for reducing unconscious bias in the workplace Strategies for managerial and executive leadership to combat unconscious bias Tips for creating a culture of inclusion and diversity

Duration 5 Days 30 CPD hours This course is intended for This course is intended for information technology (IT) professionals who need to improve their expertise in Windows Server 2016 in the area of storage and compute functionality. Overview After completing this course, you will be able to: Configure and install Windows Server 2016 Manage Server Core, server upgrade and migration strategy Understand storage options Manage partition table formats Manage basic and dynamic disks, file systems Manage virtual hard disks, and drive hardware Manage disks and volumes Select and manage proper storage solutions for a specific scenario Storage Spaces and Data Deduplication implementation Configure and Manage Microsoft Hyper-V, virtual machines and Hyper-V containers Configure disaster recovery technologies Manage and Configure failover clustering for Hyper-V virtual machines Configure, plan and implement a Network Load Balancing (NLB) Work with deployment images This course is intended for information technology (IT) professionals who have basic knowledge of Windows Server. It is designed for professionals who have primary responsibility of managing storage and computing by using Windows Server 2016. Professionals who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.This course covers content that was in retired Microsoft Course 20740. Module 1: Installing, upgrading, and migrating servers and workloads Introducing Windows Server 2016 Preparing and installing Server Core Preparing for upgrades and migrations Migrating server roles and workloads Windows Server activation models Module 2: Configuring local storage Managing disks in Windows Server Managing volumes in Windows Server Module 3: Implementing enterprise storage solutions Overview of DAS, NAS, and SANs Comparing Fibre Channel, iSCSI, and Fibre Channel over Ethernet Understanding iSNS, DCB, and MPIO Configuring sharing in Windows Server 2016 Module 4: Implementing Storage Spaces and Data Deduplication Implementing Storage Spaces Managing Storage Spaces Implementing Data Deduplication Module 5: Installing and configuring Hyper-V and virtual machines Overview of Hyper-V Installing Hyper-V Configuring storage on Hyper-V host servers Configuring networking on Hyper-V host servers Configuring Hyper-V virtual machines Managing virtual machines Module 6: Deploying and managing Windows and Hyper-V containers Overview of containers in Windows Server 2016 Preparing for containers Installing, configuring, and managing containers by using Docker Module 7: Overview of high availability and disaster recovery Defining levels of availability Planning high availability and disaster recovery solutions with Hyper-V virtual machines Backing up and restoring by using Windows Server Backup High Availability with failover clustering in Windows Server 2016 Module 8: Implementing failover clustering Planning a failover cluster Creating and configuring a new failover cluster Maintaining a failover cluster Troubleshooting a failover cluster Implementing site high availability with stretch clustering Module 9: Implementing failover clustering with Windows Server 2016 Hyper-V Overview of yhe integration of Hyper-V Server 2016 with failover clustering Implementing Hyper-V VMs on failover clusters Key features for VMs in a clustered environment Module 10: Implementing Network Load Balancing Overview of NLB Configuring an NLB cluster Planning an NLB implementation Module 11: Creating and managing deployment images Introduction to deployment images Creating and managing deployment images by using MDT Virtual machine environments for different workloads Module 12: Managing, monitoring, and maintaining virtual machine installations WSUS overview and deployment options Update management process with WSUS Overview of Windows PowerShell DSC Overview of Windows Server 2016 monitoring tools Using Performance Monitor Monitoring event logs Additional course details: Nexus Humans 55324 Installation, Storage and Compute with Windows Server 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 55324 Installation, Storage and Compute with Windows Server 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 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. Introduction to Data on the Google Cloud Platform Highlight Analytics Challenges Faced by Data Analysts Compare Big Data On-Premises vs on the Cloud Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud Navigate Google Cloud Platform Project Basics Lab: Getting started with Google Cloud Platform Big Data Tools Overview Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools Demo: Analyze 10 Billion Records with Google BigQuery Explore 9 Fundamental Google BigQuery Features Compare GCP Tools for Analysts, Data Scientists, and Data Engineers Lab: Exploring Datasets with Google BigQuery Exploring your Data with SQL Compare Common Data Exploration Techniques Learn How to Code High Quality Standard SQL Explore Google BigQuery Public Datasets Visualization Preview: Google Data Studio Lab: Troubleshoot Common SQL Errors Google BigQuery Pricing Walkthrough of a BigQuery Job Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs Optimize Queries for Cost Lab: Calculate Google BigQuery Pricing Cleaning and Transforming your Data Examine the 5 Principles of Dataset Integrity Characterize Dataset Shape and Skew Clean and Transform Data using SQL Clean and Transform Data using a new UI: Introducing Cloud Dataprep Lab: Explore and Shape Data with Cloud Dataprep Storing and Exporting Data Compare Permanent vs Temporary Tables Save and Export Query Results Performance Preview: Query Cache Lab: Creating new Permanent Tables Ingesting New Datasets into Google BigQuery Query from External Data Sources Avoid Data Ingesting Pitfalls Ingest New Data into Permanent Tables Discuss Streaming Inserts Lab: Ingesting and Querying New Datasets Data Visualization Overview of Data Visualization Principles Exploratory vs Explanatory Analysis Approaches Demo: Google Data Studio UI Connect Google Data Studio to Google BigQuery Lab: Exploring a Dataset in Google Data Studio Joining and Merging Datasets Merge Historical Data Tables with UNION Introduce Table Wildcards for Easy Merges Review Data Schemas: Linking Data Across Multiple Tables Walkthrough JOIN Examples and Pitfalls Lab: Join and Union Data from Multiple Tables Advanced Functions and Clauses Review SQL Case Statements Introduce Analytical Window Functions Safeguard Data with One-Way Field Encryption Discuss Effective Sub-query and CTE design Compare SQL and Javascript UDFs Lab: Deriving Insights with Advanced SQL Functions Schema Design and Nested Data Structures Compare Google BigQuery vs Traditional RDBMS Data Architecture Normalization vs Denormalization: Performance Tradeoffs Schema Review: The Good, The Bad, and The Ugly Arrays and Nested Data in Google BigQuery Lab: Querying Nested and Repeated Data More Visualization with Google Data Studio Create Case Statements and Calculated Fields Avoid Performance Pitfalls with Cache considerations Share Dashboards and Discuss Data Access considerations Optimizing for Performance Avoid Google BigQuery Performance Pitfalls Prevent Hotspots in your Data Diagnose Performance Issues with the Query Explanation map Lab: Optimizing and Troubleshooting Query Performance Advanced Insights Introducing Cloud Datalab Cloud Datalab Notebooks and Cells Benefits of Cloud Datalab Data Access Compare IAM and BigQuery Dataset Roles Avoid Access Pitfalls Review Members, Roles, Organizations, Account Administration, and Service Accounts

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is as follows: Network Administrators Administrators interested in Automation Individuals interested in devops, specifically for networking Overview This course teaches students to blend Python skillsets with Ansible through the lens of automating networks. Automation techniques for the most popular vendor (incl. Cisco, Juniper, Arista) will be subjects of study, however, students may request examples from vendors within their own environments. Topics begin with a focus on automating networks with Python; this skill set is then folded into a broadening understanding of automating with Ansible. Students will have programmatic experience automating enterprise class networks by the conclusion of this course (includes writing custom Ansible modules with Python). Class is a combination of lecture, demonstration, and hands-on labs. Students are invited to share their own relevant Python and Ansible scripts with the instructor to ensure class subjects are as relevant as possible. All notes and scripts will be made available to students by the end of each day via a cloud-share or email. Lab time will be given reinforce that day's topics and demonstrations. No two networks are the same! Learn to automate your network with a Python and Ansible skillset. Course can be taught across all major (and most minor) network vendors. Course demonstrations can be adapted to best-fit the customer?s network to ensure all lessons have maximum relevance. Day 1 ? Critical Python Catchup & Review Overview of Python and Ansible Python white space rules & best practices Printing and more Printing Date types and Variables Packing and Unpacking Variables f Strings Conditional expressions Relational and Boolean operators Lists, Tuples, Dictionaries Indexing and slicing Built-in functions Iterating with Loops (for and while) Working with files Software Control Management (SCM) (Git, Github, Bitbucket, Cloudshare, etc.) Using Python to access REST interfaces Working with JSON Python, Ansible and Paramiko Using Paramiko to SSH with keys and passwords RESTful API review API keys Paramiko Review Using Paramiko to SFTP with keys and passwords Day 02 ? Python and Network Automation Introduction to Netmiko (automating routers and switches) Using Netmiko to send commands to / from network devices Working with YAML Converting JSON to YAML with Python Ansible keywords YAML and JSON for data exchange Ansible and YAML Ansible Playbook components Tying together Python and Ansible ? Using Python within Ansible Ansible Network Modules What is new in Ansible (most current updates / release notes) Network Agnostic modules Writing network playbooks Reviewing the construction of network playbooks Writing Ansible playbooks that respond to network failures Day 03 ? Blending Python and Ansible Skillsets Review how to use Python within Ansible Calling Python scripts with Ansible Jinja2 Templating Engine for Python (and Ansible) Using Templates in Ansible playbooks Jinja2 filters, looping, and other useful tricks for automating with Ansible Playbook tagging for selective runs When to use Python and when to use Ansible ?Big Picture? options for using Python & Ansible within your Network Ansible Roles Day 04 ? Customizing Ansible with Python Review ? Running Scripts with Ansible Prompting for Ansible user input Ansible Galaxy & Getting at Roles Writing a custom Ansible Module with Python Ansible ?Engine? vs Ansible ?Tower? ? marketing hype, capabilities, costs, etc. Case Study: Automate your Enterprise Network When to use Python and when to use Ansible Writing your own Ansible modules in Python ?Big Picture? options for using Python & Ansible within your Network Overview ? NETCONF / YANG and what they mean for Python and Ansible Molecule ? Testing your roles Additional course details: Nexus Humans Network Automation with Python and Ansible 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 Network Automation with Python and Ansible 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 4 Days 24 CPD hours This course is intended for This is an intermediate course for individuals responsible for developing and implementing effective storage management techniques. Overview Establish a DFSMS configuration to automatically enforce your installation's storage management policies Convert service level requirements into appropriate parameters for data class, storage class, management class, and storage groups Create and test Automatic Class Selection (ACS) routines Convert volumes and move data to system-managed volumes with DFSMS Data Set Services (DFSMSdss) Specify appropriate management class and storage group parameters for DFSMS Hierarchical Storage Management (DFSMShsm) processing of system-managed data sets Plan to maintain your DFSMS environment using Naviquest Establish procedures to control, manage, and recover the storage management subsystem with ISMF and operator commands Develop a DFSMS implementation plan In this course you will learn how to plan and implement DFSMS and learn how to manage temporary and permanent data sets with an emphasis on disk storage. Course introduction and DFSMS overview Specify the storage administration functions that can be automatically performed by the system Identify the types of data set services that need to be established by negotiating service level agreements Correlate data set service requirements to the SMS configuration components: data class, storage class, management class, storage group, and automatic class selection routines Activating SMS Identify the functions eligible for exploitation with the installation of DFSMS Data Facility Product (DFSMSdfp) and the activation of SMS Create SMS control data sets Code SYS1.PARMLIB operands necessary to bring up SMS Create a minimal configuration Activate a configuration Writing ACS routines Identify the purpose of the ACS routines Develop an understanding of the statements Differentiate between literals and masks Describe the read variables available in the ACS routines Managing temporary data sets Create/alter storage classes and storage groups Identify steps to install and use the starter set Write ACS routines to handle temporary data sets Activate a system to manage temporary data sets Code commands to change volume/group SMS status Issue operator commands to display current status Exploiting DFSMS Describe the purpose of the data class Identify the features that the data class can exploit Create data sets using the space parameter Define Virtual Storage Access Method (VSAM) and volume attributes for data class Identify special data sets and their exploitation through the data class Managing permanent data sets Create/alter data classes, storage classes, management classes, and storage groups Translate current (DFSMShsm) service level agreements to management class parameters Identify alternatives and concerns for standard naming conventions Establish the controls for automatic backup of data sets Establish the controls for automatic volume dump Write ACS routines to manage permanent data Create a configuration that manages permanent data sets Create a new managed data set Identify function of storage class exit provided by Custom-Built Installation Process Offering (CBIPO) and resulting System Management Facility (SMF) records Using Naviquest Create test cases using Naviquest Perform storage administration tasks in batch Create online DFSMS reports Create model commands using Naviquest Use the COPYFILT macro Device preparation and data movement Initialize volumes as system-managed Move data into/out from system-managed control Convert volumes to/from system-managed Move data to utilize new hardware capabilities Controlling DFSMS Code commands to change SMS volume/group status Issue commands to save configurations and use alternate Active Control Data Set (ACDS) Issue command to use alternate Communication Data Set (COMMDS) Issue VARY SMS commands Communicate with the security administrator about storage management requirements Additional considerations Establish a plan for implementing SMS Locate sources of implementation planning checklists Identify the tools available to document the current system Identify multiple site considerations for recovery and exploitation Additional course details: Nexus Humans SS84 IBM DFSMS Implementation 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 SS84 IBM DFSMS Implementation 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.