This ultimate course to kickstart your Python journey from scratch. This comprehensive course covers all the essential concepts of Python, providing explanations, examples, and practical implementations. Designed with beginners in mind, our goal is to help you learn and master Python by building a variety of projects.
Prepare for the AWS Certified Solutions Architect - Associate (SAA-C03) exam. Learn about the AWS Management Console, S3 buckets, instances, database services, cloud security, costs associated with AWS, Amazon Elastic Compute Cloud (EC2), Amazon Virtual Private Cloud (VPC), Amazon Simple Storage Service (S3), and Amazon Elastic Block Store (EBS).
This comprehensive course on HashiCorp Vault will make you an expert in deploying, configuring, and managing all key Vault services. It covers all objectives for passing the HashiCorp Certified: Vault Associate certification exam. Learn the latest HashiCorp concepts and master the core components to become a HashiCorp Vault expert.
Unlock the secrets of efficient Electronic Document Management (EDM) with our comprehensive course on Secure and Accessible File Storage. Delve into industry standards, regulations, and compliance, master the implementation and framework of EDM systems, and explore advanced topics such as AI integration. Elevate your skills in document lifecycle management, operations, and security auditing. Join us to gain the expertise needed for seamless digital transformation and effective information management in today's dynamic business environment.
Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.
Earned Value Management: In-House Training: In-House Training Earned Value Management (EVM) incorporates a set of proven practices appropriate for project or program management methodologies. These include integration of program scope, schedule, and cost objectives, establishment of a baseline plan for accomplishment of program objectives and use of earned value techniques for performance measurement during the execution of a program. Earned Value Management (EVM) incorporates a set of proven practices appropriate for project or program management methodologies. These include integration of program scope, schedule, and cost objectives, establishment of a baseline plan for accomplishment of program objectives and use of earned value techniques for performance measurement during the execution of a program. EVM provides a solid platform for risk identification, corrective actions, and management re-planning as may be required over the life of a project or program. The course emphasis is on the latest EVM principles and concepts in accordance with changes and guidelines for Earned Value Management in The Guide to the Project Management Body of Knowledge (PMBOK® Guide) and The Practice Standard for Earned Value Management published by the Project Management Institute. What you Will Learn You'll learn how to: Develop a project baseline, using an effective WBS Record actual project performance Calculate EVM measures Evaluate project performance based on EVM measures Respond to project variances Integrate EVM and risk management Determine how EVM will add value to your organization Develop an EVM implementation plan for your organization Getting Started Introductions Course structure Course goals and objectives Expectations Foundation Concepts Introduction to Earned Value Management (EVM) Benefits of EVM EVM Process Overview Applications of EVM Creating a Work Breakdown Structure Reviewing WBS concepts Reviewing WBS development process (decomposition) Using a WBS to support EVM Building a Project Baseline Defining a project baseline Developing a project baseline Using a project baseline Recording Actuals Recording actuals overview Collecting data for actual project performance Determining earned value - various methods EVM Performance Measures Using current status measures Using forecasting measures Analyzing EVM measures EVM and Risk Management Integrating EVM and Risk Management Using EVM measures in the risk register Exploring how EVM can facilitate reserves management Drawing down contingency reserves Responding to Variances Introduction to variances Process for responding to variances Response options Reporting Project Performance EVM reporting overview Meeting EVM reporting needs Addressing EVM reporting challenges Implementing an EVMS Defining EVMS requirements EVM for Agile projects Tailoring the EVMS Summary and Next Steps Review of content Review of objectives / expectations Personal action plan
In this introductory course, you will receive training on all areas of construction management, from planning and scheduling to management theories, subcontracting and cost estimation. You will also explore the project delivery and production process, project control techniques, and how to schedule construction materials. Through this formal qualification, you will also develop essential management skills and gain practical, real-world knowledge which you can use to propel your career forward. This course is ideal for those who are new to construction or currently work in the construction industry and want to update their existing skills and knowledge. Learning Objectives: Identify the fundamental stages of a construction project Demonstrate an in-depth understanding of the role of a construction manager Familiarise with the different elements of the design and construction process Know how to accurately estimate the costs of a construction project Have an awareness of health and safety regulations in the construction industry Develop your understanding of human resource management, supply chain management and construction resource management Understand the types of subcontractors in construction and the benefits of subcontracting Explore methods of project delivery and current industry trends Explore the basic components of a supply chain management system Who is This Construction Management Course for? This Construction Management Diploma is ideal for beginners who want an introduction to this field to develop the essential skills required for project planning, design and construction work. Our online courses are specially designed for distance learning, offering flexible virtual classroom modules that you can study at your own convenience. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion from Course Gate At the successful completion of the course, the learners may order the Certificate of Completion from Course Gate (soft copy) by paying only £2. For the Printed hard copy of the certificate, the learners have to pay £9. There is an additional £10 delivery charge for international students. Career Path After completing your online studies, you will have the opportunity to explore a wide range of job roles within the field of construction management, including: Construction Manager Assistant Project Manager Development Project Manager Building Inspector Construction Assistant Construction Supervisor Project Assistant Course Curriculum Module 01: Introduction to Construction Management Introduction to Construction Management 01:00:00 Assessment Module 01 Module 01 Final Quiz Exam - Construction Management 00:10:00 Module 02: Construction Project Stages Construction Project Stages 01:00:00 Assessment Module 02 Module 02 Final Quiz Exam - Construction Management 00:10:00 Module 03: Estimating Construction Project Costs Estimating Construction Project Costs 00:30:00 Assessment Module 03 Module 03 Final Quiz Exam - Construction Management 00:10:00 Module 04: Construction Project Planning Construction Project Planning 00:40:00 Assessment Module 04 Module 04 Final Quiz Exam - Construction Management 00:10:00 Module 05: Site Organisation in the Construction Industry Site Organisation in the Construction Industry 00:40:00 Assessment Module 05 Module 05 Final Quiz Exam - Construction Management 00:10:00 Module 06: Construction Resource Management Construction Resource Management 00:40:00 Assessment Module 06 Module 06 Final Quiz Exam - Construction Management 00:10:00 Module 07: Subcontracting in the Construction Industry Subcontracting in the Construction Industry 00:30:00 Assessment Module 07 Module 07 Final Quiz Exam - Construction Management 00:10:00 Module 08: Construction Cost and Time Control Part 1: Construction Cost Control 00:35:00 Part 2: Time Management in the Construction Industry 00:30:00 Assessment Module 08 Module 08 Final Quiz Exam - Construction Management 00:10:00 Module 09: Equipment Cost Management Equipment Cost Management 00:20:00 Assessment Module 09 Module 09 Final Quiz Exam - Construction Management 00:10:00 Module 10: Elements of Contractor Failure Elements of Contractor Failure 00:25:00 Assessment Module 10 Module 10 Final Quiz Exam - Construction Management 00:10:00 Module 11: Supply Chain Management in the Construction Industry Supply Chain Management in the Construction Industry 00:20:00 Assessment Module 11 Module 11 Final Quiz Exam - Construction Management 00:10:00 Module 12: Quality Management in the Construction Industry Quality Management in the Construction Industry 00:30:00 Assessment Module 12 Module 12 Final Quiz Exam - Construction Management 00:10:00 Module 13: Human Resources Management Human Resources Management 00:45:00 Assessment Module 13 Module 13 Final Quiz Exam - Construction Management 00:10:00 Module 14: Risk Analysis and Management Risk Analysis and Management 00:25:00 Assessment Module 14 Module 14 Final Quiz Exam - Construction Management 00:10:00 Module 15: Health and Safety in the Construction Industry Part 1: Key Legislation and Regulations for The Construction Industry 00:30:00 Part 2: Managing Safety within the Construction Industry 00:20:00 Assessment Module 15 Module 15 Final Quiz Exam - Construction Management 00:10:00 Module 16: Sustainability and the Environment Sustainability and the Environment 00:25:00 Assessment Module 16 Module 16 Final Quiz Exam - Construction Management 00:10:00
Project Quality Management: In-House Training In today's environment, quality is the responsibility of everyone. Project success is no longer just the fulfillment of a project on schedule, on budget, and within the scope. Today, projects aren't successful unless the customer's needs are met at the highest level of quality at the lowest cost to the organization. Project Managers must know customer needs, and manage to them throughout the project lifecycle, in order to gain acceptance. Project Quality Management provides an interactive, hands-on environment for participants to practice identification of critical quality requirements (quality planning), fulfillment of those requirements through well-designed processes (Quality Assurance), and statistical awareness of technical specifications of project deliverables (Quality Control). What You Will Learn You'll learn how to: Plan for higher quality project deliverables Measure key performance indicators on projects, processes, and products Turn data into useful project information Take action on analyzed data that will drive down non-value-added costs and drive up customer acceptance and satisfaction Reduce defects and waste in current project management processes Foundation Concepts Quality Defined Customer Focus Financial Focus Quality Management Process Management Cost of Quality Planning for Quality Project Manager Role in Planning Voice of the Customer Quality Management Plan Measurement System Accuracy Data Gathering Data Sampling Manage Quality Process Management Process Mapping Process Analysis Value Stream Mapping Standardization Visual Workplace and 5S Error Proofing (Poka-Yoke) Failure Mode and Effect Analysis Control Quality The Concept of Variation Common Cause Special Cause Standard Business Reports Tracking Key Measurements Control Charts Data Analysis Variation Root Cause Analysis Variance Management Designing for Quality
Effectively oversee the planning, design, and execution of a building project with the Construction Management Diploma Level 5 course. This certificate program is designed to teach fundamental methods of construction and management, covering all aspects of construction projects, from planning and scheduling to management theories and cost estimation. You will also explore the project delivery and production process, project control techniques, and how to schedule construction materials. Throughout this construction project management course, you will develop essential management skills and practical, real-world knowledge, to boost your professional development. This course is ideal for those who already work in the construction industry and are seeking a more senior role. Learning Objective: Understand the role and responsibilities of a Construction Manager Identify the different elements of the design and construction process Explore methods of project delivery and current industry trends Develop your problem-solving, communication and decision-making skills Learn the characteristics of a successful construction project Explore estimation strategies for working out the cost of a construction project Demonstrate a solid understanding of modern construction planning Familiarise with construction materials and equipment safety procedures Explore the basic components of a supply chain management system Who is This Course for? This Construction Management Diploma Level 5 is ideal for beginners who want an introduction to this field to develop the essential skills required for project planning, design and construction work. No previous experience is required to enrol and learners from all academic backgrounds will benefit from this specialist beginners training. Train online from the comfort of your own home and study at your own pace, with our distance learning program. On successful completion, learners will receive a certificate of achievement, which will help them to advance their career opportunities in this field. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Career Path: After completing your online studies, you will have the opportunity to explore a wide range of job roles within the field of construction management, including: Construction Manager Assistant Project Manager Development Project Manager Building Inspector Construction Assistant Construction Supervisor Project Assistant Course Curriculum Module 01: Introduction to Construction Management Introduction to Construction Management 01:00:00 Assessment Module 01 Module 01 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 02: Construction Project Stages Construction Project Stages 01:00:00 Assessment Module 02 Module 02 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 03: Estimating Construction Project Costs Estimating Construction Project Costs 00:30:00 Assessment Module 03 Module 03 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 04: Construction Project Planning Construction Project Planning 00:40:00 Assessment Module 04 Module 04 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 05: Site Organisation in the Construction Industry Site Organisation in the Construction Industry 00:40:00 Assessment Module 05 Module 05 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 06: Construction Resource Management Construction Resource Management 00:40:00 Assessment Module 06 Module 06 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 07: Subcontracting in the Construction Industry Subcontracting in the Construction Industry 00:30:00 Assessment Module 07 Module 07 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 08: Construction Cost and Time Control Part 1: Construction Cost Control 00:35:00 Part 2: Time Management in the Construction Industry 00:30:00 Assessment Module 08 Module 08 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 09: Equipment Cost Management Equipment Cost Management 00:20:00 Assessment Module 09 Module 09 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 10: Elements of Contractor Failure Elements of Contractor Failure 00:25:00 Assessment Module 10 Module 10 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 11: Supply Chain Management in the Construction Industry Supply Chain Management in the Construction Industry 00:20:00 Assessment Module 11 Module 11 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 12: Quality Management in the Construction Industry Quality Management in the Construction Industry 00:30:00 Assessment Module 12 Module 12 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 13: Human Resources Management Human Resources Management 00:45:00 Assessment Module 13 Module 13 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 14: Risk Analysis and Management Risk Analysis and Management 00:25:00 Assessment Module 14 Module 14 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 15: Health and Safety in the Construction Industry Part 1: Key Legislation and Regulations for The Construction Industry 00:30:00 Part 2: Managing Safety within the Construction Industry 00:20:00 Assessment Module 15 Module 15 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00 Module 16: Sustainability and the Environment Sustainability and the Environment 00:25:00 Assessment Module 16 Module 16 Final Quiz Exam - Construction Management Diploma Level 5 00:10:00
Online Asset Management Course eCert+ our fully featured eLearning Asset Management Course, this course includes recorded webinars and additional offline activities and guidance. Get certified today.