1664 Database courses

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This comprehensive, hands-on course empowers beginners with essential web development skills. From HTML, CSS, and JavaScript to GitHub and Bootstrap, master the tools of the trade. Learn to build, style, and deploy websites effortlessly. No prior knowledge of programming or web development is needed.

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will help you build a solid foundation to become a proficient worker in the sector. This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 : MS Word Diploma Course 02 : Proofreading & Copyediting Course 03 : PowerPoint Diploma Course 04 : Microsoft Excel Level 3 Course 05 : New Functions in Microsoft Excel 2021 Course 06 : Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07 : Microsoft Excel: Excel Sheet Comparison with VBA Course 08 : Microsoft Excel: Master Power Query in 120 Minutes! Course 09 : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10 : Excel Pivot Tables Course 11 : Data Analysis in Microsoft Excel Complete Training Course 12 : Excel Must know Formulas and Functions Course 13 : Excel spreadsheet for Beginner Course 14 : Excel Data Analysis Course 15 : Excel Vlookup, Xlookup, Match and Index Course 16 : Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17 : PowerBI Formulas Course 18 : Outlook Tips and tricks Course 19 : Excel PowerQuery and PowerPivot Course 20 : Complete Microsoft Power BI 2021 Course 21 : The Complete Microsoft Outlook Masterclass Course 22 : Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course 23 : Microsoft Access Tables and Queries Course 24 : Microsoft Access Databases Forms and Reports Course 25: Microsoft Teams Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 27: Data Protection and Data Security Level 2 Course 28: Office Skills and Administration Management Diploma Course 29: Touch Typing Essentials Course 30: Document Control 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in The Ultimate Guide: Ms Word, Ms Excel, Powerpoint & Access Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Description Take your steps towards learning the advanced concepts of SQL by taking this SQL Developer 2014 Advanced. Through the course, you will master SQL skills and be able to take full command of SQL. You will learn to create materialised views and improve performance by using simple SQL syntax. Learn about partition the tables and performance optimisation using SQL partitioning and explore how to use analytic SQL to aggregate, analyse and report, and model data using the SQL analytic capabilities. You will also learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure by practising SQL Hierarchical features. Use of regular expressions and sub-expressions to search, match and replace strings using SQL built-in functions also explained in this course. Step up to the next level to learn more about the advanced SQL theories which will put you better in your performance and career advancement. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. 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. Module: 01 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 02 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 03 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 04 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Are you ready to embark on an enlightening journey of wisdom with the Data Analysis bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analysis with SQL & Tableau for Data Analytics. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Introduction to Data Analytics with Tableau Course 2: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 3: Big Data Analytics with PySpark Power BI and MongoDB Course 4: Google Data Studio: Data Analytics Course 5: SQL for Data Science, Data Analytics and Data Visualization Course 6: Business Analysis Course Level 5 Course 7: Financial Analysis Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analysis with SQL & Tableau for Data Analytics bundle illuminate your path to wisdom. The Data Analysis with SQL & Tableau for Data Analytics bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analysis with SQL & Tableau for Data Analytics package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analysis bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analysis with SQL & Tableau for Data Analytics community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analysis with SQL & Tableau for Data Analytics Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analysis bundle. Establish robust bases across each course nestled within the Data Analysis bundle. Decipher intricate concepts through the articulate content of the Data Analysis bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analysis with SQL & Tableau for Data Analytics bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analysis bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analysis with SQL & Tableau for Data Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analysis bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analysis bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analysis journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analysis with SQL & Tableau for Data Analytics Bundle. Career path Armed with the Data Analysis with SQL & Tableau for Data Analytics bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analysis bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Overview of AutoCAD Programming Using C#.NET Join our AutoCAD Programming Using C#.NET Level 7 course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The AutoCAD Programming Using C#.NET Level 7 course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The AutoCAD Programming Using C#.NET Level 7 course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This AutoCAD Programming Using C#.NET Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this AutoCAD Programming Using C#.NET Level 7. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the AutoCAD Programming Using C#.NET Level 7 course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This AutoCAD Programming Using C#.NET Level 7 is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the AutoCAD Programming Using C#.NET Level 7 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this AutoCAD Programming Using C#.NET Level 7 Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Course Outline and Introduction Module 01: Introduction 00:01:00 Module 02: Who is this course for? 00:01:00 Module 03: What Will I Learn from this Course? 00:01:00 Module 04: What is CSharp (C#)? 00:01:00 Module 05: What is AutoCAD .NET API? 00:01:00 Module 06: What are the advantages of programming in AutoCAD .NET API? 00:02:00 Unit 02: .Net Framework and Visual Studio 2017 Community Edition Module 01: Section Overview 00:01:00 Module 02:.NET Framework Architecture Overview 00:03:00 Module 03: .NET Framework Class Library, Common Type System, Common Language Runtime 00:03:00 Module 04: More about.NET Framework Common Language Runtime (CLR) 00:02:00 Module 05: Visual Studio 2017 Integrated Development Environment (IDE) 00:03:00 Module 06: Visual Studio 2017 IDE Demo 00:07:00 Unit 03: C# Fundamentals Module 01: Section Overview 00:03:00 Module 02: DataTypes and Variables - Value Types (signed/unsigned integers) 00:04:00 Module 03: DataTypes and Variables - Signed and Unsigned Integer Demo 00:06:00 Module 04: DataTypes and Variables - Floating Point and Decimal 00:02:00 Module 05: DataTypes and Variables - Floating Point and Decimal Demo 00:04:00 Module 06: DataTypes and Variables - Boolean 00:03:00 Module 07: DataTypes and Variables - Reference Types 00:03:00 Module 08: DataTypes and Variables - Class Type 00:03:00 Module 09: DataTypes and Variables - Class Type - Demo 00:11:00 Module 10: DataTypes and Variables - Interface Type 00:01:00 Module 11: DataTypes and Variables - Array Type 00:02:00 Module 12: DataTypes and Variables - Array Type - Demo (Single Dimension) 00:08:00 Module 13: DataTypes and Variables - Array Type - Demo (Multi Dimension) 00:10:00 Module 14: C# Operators Overview 00:02:00 Module 15: C# Assignment Operators 00:03:00 Module 16: C# Assignment Operators - Demo 00:06:00 Module 17: C# Unary Operators 00:02:00 Module 18: C# Unary Operators - Demo 00:02:00 Module 19: C# Primary Operators 00:03:00 Module 20: C# Primary Operators - Demo 00:07:00 Module 21: C# Equality Operators 00:01:00 Module 22: C# Equality Operators - Demo 00:02:00 Module 23: C# Additive Operators 00:02:00 Module 24: C# Additive Operators - Demo 00:01:00 Module 25: C# Multiplicative Operators 00:01:00 Module 26: C# Multiplicative Operators - Demo 00:01:00 Module 27: C# - Relational and Type Operators 00:04:00 Module 28: C# - Logical, Conditional and Null Operators 00:04:00 Module 29: C# - Logical, Conditional and Null Operators - Demo 00:07:00 Module 30: C# Keywords (Reserved Words) 00:04:00 Module 31: C# - Conditionals Overview 00:01:00 Module 32: C# Conditionals - If-Then-Else Statement 00:03:00 Module 33: C# Conditionals - If-Then-Else Statement - Demo 00:07:00 Module 34: C# Conditionals - Switch Statement 00:03:00 Module 35: C# Conditionals - Switch Statement - Demo 00:04:00 Module 36: C# - Loops Overview 00:04:00 Module 37: C# Loops - For Loop 00:02:00 Module 38: C# Loops - For Loop - Demo 00:02:00 Module 39: C# Loops - Foreach Loop 00:02:00 Module 40: C# Loops - Foreach Loop - Demo 00:05:00 Module 41: C# Loops - While Loop 00:02:00 Module 42: C# Loops - While Loop - Demo 00:02:00 Module 43: C# Loops - Do While Loop 00:02:00 Module 44: C# Loops - Do While Loop - Demo 00:03:00 Module 45: Modifiers Overview 00:04:00 Module 46: Debugging Overview 00:03:00 Module 47: Debugging - Demo 1 00:05:00 Module 48: Debugging - Demo 2 00:12:00 Module 49: Debugging - Demo 3 00:06:00 Module 50: Error and Exception Handling - Overview 00:02:00 Module 51: ExceptionHandling - Demo 1 00:07:00 Module 52: ExceptionHandling - Demo 2 00:07:00 Module 53: ExceptionHandling - Demo 3 00:13:00 Module 54: Introduction to Object Oriented Programming (OOP) 00:04:00 Module 55: OOP - Encapsulation - Demo (Part 1) 00:11:00 Module 56: OOP - Encapsulation - Demo (Part 2) 00:12:00 Module 57: OOP - Inheritance - Demo (Part 1) 00:07:00 Module 58: OOP - Inheritance - Demo (Part 2) 00:05:00 Module 59: OOP - Polymorphism - Demo (Part 1) 00:10:00 Module 60: OOP - Polymorphism - Demo (Part 2) 00:03:00 Unit 04: Exploring AutoCAD .NET API Module 01: AutoCAD .NET API - Overview 00:01:00 Module 02: AutoCAD .NET API Assemblies 00:02:00 Module 03: Using AutoCAD .NET API in C# - Hello AutoCAD Demo Part 1 00:12:00 Module 04: Using AutoCAD .NET API in C# - Hello AutoCAD Demo - Part 2 00:04:00 Module 05: AutoCAD .NET API Object Hierarchy 00:03:00 Module 06: AutoCAD .NET API - Application Object Overview 00:03:00 Module 07: AutoCAD .NET API - Document Object Overview 00:03:00 Module 08: AutoCAD .NET API - Database Object Overview 00:03:00 Unit 05: Creating AutoCAD Objects using AutoCAD .NET API Module 01: Creating AutoCAD Objects using AutoCAD .NET API - Overview 00:01:00 Module 02: Creating a Line Object - Lab (Part 1) 00:14:00 Module 03: Creating a Line Object - Lab (Part 2) 00:03:00 Module 04: Creating a MText Object - Lab 00:10:00 Module 05: Creating a Circle Object - Lab 00:07:00 Module 06: Creating an Arc Object - Lab 00:05:00 Module 07: Creating a LWPolyline Object - Lab 00:05:00 Unit 06: Manipulate AutoCAD Objects Module 01: Manipulate AutoCAD Objects - Overview 00:01:00 Module 02: Copy Object using C# - Theory 00:01:00 Module 03: Copy Object using C# - Lab (Part 1) 00:11:00 Module 04: Copy Object using C# - Lab (Part 2) 00:02:00 Module 05: Copy multiple objects using C# - Lab (Part 1) 00:09:00 Module 06: Copy multiple objects using C# - Lab (Part 2) 00:01:00 Module 07: Erase Object using C# - Lab (Part 1) 00:06:00 Module 08: Erase Object using C# - Lab (Part 2) 00:05:00 Module 09: Move Object using C# - Lab (Part 1) 00:06:00 Module 10: Move Object using C# - Lab (Part 2) 00:02:00 Module 11: Mirror Object using C# - Lab (Part 1) 00:10:00 Module 12: Mirror Object using C# - Lab (Part 2) 00:02:00 Module 13: Rotate Object using C# - Lab (Part 1) 00:07:00 Module 14: Rotate Object using C# - Lab (Part 2) 00:03:00 Module 15: Scale Object using C# - Lab 00:05:00 Module 16: Copy Object Exercise 00:02:00 Module 17: Copy Object Solution 00:06:00 Module 18: Erase Object Exercise 00:02:00 Module 19: Erase Object Solution 00:07:00 Module 20: Move Object Exercise 00:02:00 Module 21: Move Object Solution 00:06:00 Module 22: Mirror Object Exercise 00:02:00 Module 23: Mirror Object Solution 00:06:00 Module 24: Rotate Object Exercise 00:02:00 Module 25: Rotate Object Solution 00:06:00 Module 26: Scale Object Exercise 00:01:00 Module 27: Scale Object Solution 00:05:00 Unit 07: Exploring AutoCAD Dictionaries (Layers, LineTypes, TextStyles) Module 01: Exploring AutoCAD Dictionaries - Layers Overview 00:03:00 Module 02: Listing all the Layers in the drawing using C# 00:11:00 Module 03: Creating a Layer in AutoCAD using C# 00:09:00 Module 04: Updating a Layer in AutoCAD using C# 00:09:00 Module 05: Turning the Layer On/Off in AutoCAD using C# 00:05:00 Module 06: Thawing/Freezing Layer in AutoCAD using C# 00:04:00 Module 07: Deleting a Layer in AutoCAD using C# 00:03:00 Module 08: Locking/UnLocking a Layer in AutoCAD using C# 00:05:00 Module 09: Assigning a Layer to an AutoCAD object using C# 00:03:00 Module 10: Exploring AutoCAD Dictionaries - LineTypes Overview 00:01:00 Module 11: Listing all the LineTypes in the drawing using C# 00:07:00 Module 12: Loading a LineType in the drawing using C# 00:07:00 Module 13: Setting the Current LineType in AutoCAD using C# 00:03:00 Module 14: Deleting a LineType in AutoCAD using C# 00:03:00 Module 15: Setting a LineType to an object using C# 00:04:00 Module 16: Exploring AutoCAD Dictionaries - TextStyles Overview 00:01:00 Module 17: Listing all the TextStyles in the drawing using C# 00:08:00 Module 18: Updating current TextStyle Font in AutoCAD using C# 00:10:00 Module 19: Setting the Current TextStyle in AutoCAD using C# 00:08:00 Module 20: Setting a TextStyle to an object using C# 00:04:00 Unit 08: User Input Functions Module 01: User Input Functions Overview 00:01:00 Module 02: Using GetString Method - Lab (Part 1) 00:13:00 Module 03: Using GetString Method - Lab (Part 2) 00:10:00 Module 04: Using GetPoint Method - Lab 00:12:00 Module 05: Using GetDistance Method - Lab 00:04:00 Module 06: Using GetKeyWords Method - Lab (Part 1) 00:12:00 Module 07: Using GetKeyWords Method - Lab (Part 2) 00:02:00 Unit 09: Selection Sets and Filters Module 01: Selection Sets and Filters - Overview 00:02:00 Module 02: Using SelectAll Method - Lab (Part 1) 00:11:00 Module 03: Using SelectAll Method - Lab (Part 2) 00:02:00 Module 04: Using SelectOnScreen Method - Lab (Part 1) 00:06:00 Module 05: Using SelectOnScreen Method - Lab (Part 2) 00:01:00 Module 06: Using SelectWindow Method - Lab 00:08:00 Module 07: Using SelectCrossingWindow Method - Lab 00:08:00 Module 08: Using SelectFence Method - Lab 00:08:00 Module 09: Using PickFirstSelection Method - Lab 00:11:00 Module 10: Using SelectionSet Filters - Overview 00:01:00 Module 11: Using SelectionSet Filters - Selecting Lines 00:09:00 Module 12: Using SelectionSet Filters - Selecting MTexts Lab 00:07:00 Module 13: Using SelectionSet Filters - Selecting Polylines Lab 00:03:00 Module 14: Using SelectionSet Filters - Selecting Blocks (FrenchDoors) Lab 00:07:00 Module 15: Using SelectionSet Filters - Selecting Blocks (BiFoldDoors) Lab 00:04:00 Module 16: Using SelectionSet Filters - Selecting objects in a Layer (Walls) Lab 00:07:00 Module 17: Using SelectionSet Filters - Selecting all objects in a Layer (Stairs) Lab 00:05:00 Module 18: Using SelectionSets and Filters - Exercises 00:02:00 Unit 10: Developing Title Block Project - Hands On! Module 01: TitleBlock Project - Overview 00:05:00 Module 02: Creating Project and TBlock Class - Lab 00:14:00 Module 03: Creating Classes for each Paper Sizes - Lab 00:07:00 Module 04: Creating TitleBlock Class - Lab 00:14:00 Module 05: Handling User Selected Paper Size - Lab 00:05:00 Module 06: Creating the TitleBlock Border Lines - Lab 00:06:00 Module 07: Creating the Horizontal Partition Lines - Lab (Part 1) 00:11:00 Module 08: Creating the Horizontal Partition Lines - Lab (Part 2) 00:05:00 Module 09: Creating Vertical Partition Lines - Lab 00:11:00 Module 10: Project Check on the Partition Lines - Lab 00:07:00 Module 11: Creating the TitleBlock Labels - Lab (Part 1) 00:10:00 Module 12: Creating the TitleBlock Labels - Lab (Part 2) 00:09:00 Module 13: Creating the TitleBlock Labels - Lab (Part 3) 00:11:00 Module 14: Project Check on the Labels 00:07:00 Module 15: Creating Drawing Information Texts 00:08:00 Module 16: Debugging the TitleBlock Project - Lab 00:10:00 Module 17: Completing and Running the TitleBlock Plugin 00:05:00 Module 18: Audit Drawing Project - Overview 00:02:00 Module 19: Audit Drawing Project - Demo 00:07:00 Module 20: Creating the AuditDrawing Project 00:11:00 Module 21: Creating the AuditDrawing DisplayOnScreen Method 00:14:00 Module 22: Creating the AuditDrawing Write to TXT File Method 00:08:00 Module 23: Creating the AuditDrawing Write to CSV File Method 00:06:00 Module 24: Creating the AuditDrawing Write to HTML File Method 00:14:00 Module 25: AuditDrawing Plugin Demo 00:04:00 Module 26: Creating the AuditBlock Method 00:05:00 Module 27: Creating the AuditBlock GatherBlocksAndCount Method 00:16:00 Module 28: Creating the AuditBlock DisplayOnScreen Method 00:06:00 Module 29: Creating the AuditBlock WriteToTXTFile Method 00:05:00 Module 30: Creating the AuditBlock WriteToCSVFile Method 00:05:00 Module 31: Creating the AuditBlock WriteToHTMLFile Method 00:07:00 Module 32: AuditBlock Completed Component - Demo 00:12:00 Unit 11: Conclusion Module 01: Conclusion 00:01:00

Duration 5 Days 30 CPD hours This course is intended for Experienced VMware administrators, automation and orchestration specialists, system integrators, and private cloud and public cloud administrators Overview By the end of the course, you should be able to meet the following objectives: Describe the features and benefits of integrating vRealize Orchestrator and vRealize Automation Describe the role of vRealize Orchestrator workflows and content elements in automation Use the vRealize Orchestrator client to access and navigate the vRealize Orchestrator platform Use the vRealize Orchestrator client to import and run vRealize Orchestrator library workflows Design, develop, and run custom reusable vRealize Orchestrator workflows Integrate vRealize Automation with vRealize Orchestrator to deliver custom IT services Use the vRealize Automation event broker service to trigger specific vRealize Orchestrator workflows or ABX Actions Leverage the event broker to extend IaaS (Infrastructure-as-a-Service) machine lifecycle processes Use XaaS to extend vRealize Automation into other enterprise systems Use VMware APIs to run vRealize Orchestrator workflows Use the vSphere Client Code Capture feature During this five-day course, you focus on using VMware vRealize© Orchestrator? to extend the functionality of VMware vRealize© Automation?. You learn how to provide XaaS (Anything as a Service) and implement Machine Lifecycle Extensibility using the VMware vRealize© Automation? Event Broker. You also learn how to create vRealize Orchestrator workflows and vRealize Automation ABX actions. You learn about various features, including basic scripting implementation along with logic processing to implement a variety of functions to use in your environment. This course teaches implementing debugging, loops, conditions, and user interactions in vRealize Orchestrator. The course introduces the new vRealize Orchestrator HTML 5 interface, along with API calls and REST functions, to give you the groundwork to implement a variety of plugins and scripts. This course is designed to give you the tools to craft custom solutions in the product. Course Introduction Introductions and course logistics Course objectives Overview of vRealize Automation and vRealize Orchestrator Define the purpose of vRealize Automation Outline the purpose of vRealize Orchestrator Describe the main components of vRealize Automation Describe the main components of vRealize Orchestrator Creating Schema Elements Invoking JavaScript from a vRealize Orchestrator workflow Invoking a vRealize Orchestrator Workflow from a vRealize Orchestrator workflow Invoking an action from a vRealize Orchestrator workflow Using vRealize Orchestrator workflows both synchronously and asynchronously Working with Variables Defining inputs, outputs, and variables in vRealize Orchestrator workflows Binding variables in vRealize Orchestrator workflows Wrapping vRealize Orchestrator workflows Using APIs and the API Explorer Creating actions in vRealize Orchestrator Using vRealize Orchestrator input forms Handling user interactions in vRealize Orchestrator Handling Exceptions, Logging, and Debugging Handling exceptions in vRealize Orchestrator workflows Using logs in vRealize Orchestrator workflows Debugging vRealize Orchestrator workflows Branching and Looping Using branching in vRealize Orchestrator workflows Using loops in vRealize Orchestrator workflows Working with Assets Using configuration elements in vRealize Orchestrator Using resources in vRealize Orchestrator Using packages in vRealize Orchestrator Working with Plug-Ins Downloading and installing Plug-Ins Using the SSH plug-In in vRealize Orchestrator Using the REST plug-in in vRealize Orchestrator Using the vRealize Automation plug-in in vRealize Orchestrator Using the PowerShell plug-in in vRealize Orchestrator Working with Versioning and Git Using versioning in vRealize Orchestrator Using Git in vRealize Orchestrator Scheduling, Sleeping, and Waiting Using scheduling in vRealize Orchestrator Using sleeping in vRealize Orchestrator Using waiting in vRealize Orchestrator Introduction to vRealize Automation Extensibility Introduction to extensibility Using ABX actions Using Python Using Nodejs Using PowerShell Using vRealize Automation Lifecycle Extending vRealize Automation with Event Broker Overview of vRealize Automation Event Broker Creating vRealize Automation subscriptions Data exchange between vRealize Automation and vRealize Orchestrator Using ABX Actions Overview of Action Based Extensibility (ABX) Comparison of vRealize Orchestrator and ABX Creating ABX Actions scripts, REST, and flows Using Day-2 Actions in vRealize Automation Describe the visualization capabilities of NSX Network Detection and Response Working with Services, Custom Resources, and Resource Actions Using vRealize Orchestrator as a content source in vRealize Automation Creating custom resources in vRealize Automation Creating resource actions in vRealize Automation Using Day-2 Actions in vRealize Automation Using vSphere Client Code Capture Enabling vSphere Client code capture Using vSphere Client code capture to capture code in vRO, Javascript, PowerCLI or other languages. Using the captured code in vRealize Orchestrator workflows or actions.