• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

4210 Operations courses delivered Online

Complete AutoLISP Programming

4.5(3)

By Studyhub UK

Embark on a transformative journey into the realm of AutoLISP programming with our comprehensive course titled 'Complete AutoLISP Programming.' Crafted with precision and expertise, this course is not just a curriculum; it's a key to unlocking a world of possibilities within AutoCAD customization. Imagine seamlessly creating macros for essential commands, mastering AutoLISP rules, variables, math functions, list functions, user input functions, object handling functions, selection sets, conditionals, and delving into the intricacies of AutoCAD objects and data models. Authored by industry experts, this course goes beyond the basics, providing a Quick Win Demo and hands-on projects that reinforce your newfound skills. Learning Outcomes Develop a deep understanding of AutoLISP programming rules, enabling you to create efficient and customized AutoCAD commands. Master the application of AutoLISP variables in real-world programming scenarios, honing your skills through practical exercises. Acquire proficiency in AutoLISP math functions, empowering you to perform complex mathematical operations seamlessly within AutoCAD. Unlock the potential of AutoLISP's list functions, gaining the ability to manipulate lists for enhanced program functionality. Explore AutoLISP's user input functions, object handling functions, and delve into the intricacies of conditionals and equality functions. Why choose this Complete AutoLISP Programming course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this The Complete AutoLISP Programming course for? CAD enthusiasts and draftsmen seeking to elevate their AutoCAD customization skills. Architects aiming to streamline and enhance their design processes. Engineers looking to automate repetitive tasks and boost productivity. Students and professionals in the fields of architecture, engineering, and design. Anyone with a passion for programming and a desire to delve into the world of AutoCAD customization. Career path AutoCAD Programmer: £35,000 - £45,000 CAD Automation Specialist: £40,000 - £50,000 Architectural Technologist: £30,000 - £40,000 Engineering Design Consultant: £35,000 - £45,000 BIM Specialist: £40,000 - £50,000 Project Manager (CAD): £45,000 - £55,000 Prerequisites This Complete AutoLISP Programming does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Complete AutoLISP Programming was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:01:00 Module 02: Course Outline 00:05:00 Module 03: Introduction to AutoLISP 00:02:00 Module 04: Who is this Course for? 00:02:00 Module 05: What will I Learn? 00:01:00 Module 06: About the Author 00:02:00 Module 07: Why Learn AutoLISP? 00:02:00 Module 08: Tools 00:04:00 Unit 02: Quick Win Demo Module 01: Create Zoom Command Macros 00:13:00 Module 02: Create Layer Command Macros 00:10:00 Module 03: Create Insert Command Macros 00:07:00 Module 04: Create Audit Commands 00:06:00 Unit 03: AutoLISP Rules Module 01: AutoLISP Rules 00:05:00 Unit 04: AutoLISP Variables Module 01: Understanding AutoLISP Variables 00:05:00 Module 02: Using Variables in a Real World Program - Part 1 00:08:00 Module 03: Using Variables in a Real World Program - Part 2 00:08:00 Module 04: Using Variables in a Real World Program - Part 3 00:05:00 Module 05: Using Variables in a Real World Program - Part 4 00:07:00 Unit 05: AutoLISP Math Functions Module 01: Math Functions in Theory 00:06:00 Module 02: Math Functions by Example 00:15:00 Unit 06: AutoLISP's List Functions Module 01: List Functions Theory - Part 1 00:06:00 Module 02: CAR Function - Demo 00:02:00 Module 03: CDR Function - Demo 00:02:00 Module 04: CADR Function - Demo 00:02:00 Module 05: CADDR Function - Demo 00:02:00 Module 06: CAAR Function - Demo 00:02:00 Module 07: CDDR Function - Demo 00:01:00 Module 08: List Functions Theory - Part 2 00:05:00 Module 09: list Function - Demo 00:01:00 Module 10: cons Function - Demo 00:02:00 Module 11: nth Function - Demo 00:01:00 Module 12: Foreach Function - Demo 00:04:00 Module 13: List Functions Theory - Part 3 00:05:00 Module 14: Assoc Function - Demo 00:04:00 Module 15: Subst Function - Demo 00:06:00 Module 16: Last Function - Demo 00:02:00 Module 17: Reverse Function - Demo 00:02:00 Unit 07: AutoLISP's User Input Functions Module 01: User Input Functions Theory - Part 1 00:05:00 Module 02: User Input Functions Theory - Part 2 00:04:00 Module 03: GetPoint Function - Demo 00:02:00 Module 04: GetInt Function - Demo 00:03:00 Module 05: GetString Function - Demo 00:04:00 Module 06: GetReal Function - Demo 00:02:00 Module 07: GetDist Function - Demo 00:04:00 Module 08: GetCorner Function - Demo 00:04:00 Module 09: GetAngle Function - Demo 00:10:00 Module 10: GetKword Function - Demo 00:05:00 Unit 08: Object Handling Functions Module 01: Object Handling Functions - Theory 00:04:00 Module 02: Entsel Function - Demo 00:03:00 Module 03: Entnext Function - Demo 00:03:00 Module 04: Entlast Function - Demo 00:02:00 Module 05: Entget Function - Demo 00:04:00 Module 06: Object Handling Functions - Exercises 00:02:00 Module 07: Object Handling Functions - Solutions to Exercises 00:06:00 Unit 09: AutoLISP's Selection Sets Module 01: Selection Sets - Theory 00:08:00 Module 02: Ssget Function - Demo 00:11:00 Module 03: Ssadd Function - Demo 00:05:00 Module 04: Ssdel Function - Demo 00:03:00 Module 05: Ssmemb Function - Demo 00:03:00 Module 06: Ssname Function - Demo 00:03:00 Module 07: Sslength Function - Demo 00:05:00 Module 08: Selection Sets - Exercises 00:04:00 Module 09: Selection Sets - Solutions to Exercises 00:13:00 Unit 10: Conditionals And Equality Functions Module 01: Using If and Progn Statements 00:05:00 Module 02: Using While and EQ Functions 00:05:00 Module 03: Using Cond and And Functions 00:04:00 Unit 11: AutoCAD Objects - Data Model Module 01: AutoCAD Objects: Re-examined (Part 1) 00:04:00 Module 02: AutoCAD Objects: Re-examined (Part 2) 00:05:00 Module 03: Line Object: Re-examined (Demo) 00:05:00 Module 04: Circle Object: Re-examined (Demo) 00:04:00 Module 05: Text Object: Re-examined (Demo) 00:08:00 Module 06: Dimension Object: Re-examined (Demo) 00:11:00 Module 07: Block/Attribute Object: Re-examined (Demo) 00:28:00 Unit 12: Symbol Table And Dictionary Handling Functions Module 01: Symbol Table and Dictionary-Handling Functions - Theory 00:05:00 Module 02: Tblsearch - Demo 00:13:00 Module 03: Tblnext - Demo 00:09:00 Unit 13: Hands-On Projects Module 01: CDIM - Project 00:12:00 Module 02: CHSTYLE - Project 00:16:00 Module 03: EXTATTR - Hands-On Project 00:26:00 Unit 14: Conclusion Module 01: Conclusion Message and Thank you! 00:01:00

Complete AutoLISP Programming
Delivered Online On Demand7 hours 26 minutes
£10.99

Django with Tailwind CSS

By Packt

Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!

Django with Tailwind CSS
Delivered Online On Demand12 hours 38 minutes
£52.99

Six Sigma - CPD Certified

4.7(26)

By Academy for Health and Fitness

Six sigma provides an excellent opportunity to gain the skills and knowledge you'll need to advance in your career. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Gain experience online and interact with experts. This can prove to be the perfect way to get notice by a prospective employer and stand out from the crowd. Six Sigma has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take six sigma is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes.. Why Prefer Our Six Sigma Course? Opportunity to earn a certificate that is accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery). Innovative and engaging content. Free assessments. 24/7 tutor support. **** Course Curriculum **** Here are the topics you will cover in the Six Sigma Course. Module 01: Overview of Six Sigma Module 02: The Define Phase Module 03: The Measure Phase Module 04: The Analyse Phase Module 05: The Improve Phase Module 06: The Control Phase Assessment Process Once you have finished the learning stages in the course, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the six sigma. Enrol on the six sigma and learn a new professional skill from anywhere, at any time! Requirements Enrol on the six sigma with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the six sigma without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the six sigma online from your computer, tablet, or smartphone, and learn in a way that suits you. Certificates Certificate of completion Digital certificate - £10

Six Sigma - CPD Certified
Delivered Online On Demand2 hours
£12

Complete Business Management - CPD Certified

5.0(3)

By School Of Health Care

Complete Business Management: Business Management Do you aspire to excel in Business Management and join the corporate leadership team? Do you want to start your own venture in Business Management? If yes, then this Business Management course is tailored for you! This comprehensive Business Management course is divided into several in-depth modules, providing you with a rich and convenient learning experience in Business Management. Through this Business Management qualification, students gain new skills and knowledge in critical areas of Business Management. You'll master strategies for building strong teams, delegating tasks, managing business risks, handling workplace conflict, and improving customer service. This Business Management course is designed to provide students with vital Business Management knowledge and insight into the role of managers in modern organizations. By the end of this Business Management program, you'll have a solid understanding of project management, forecasting operations, performance management, negotiation, and human resource practices essential in Business Management. Learning Objectives You will be able to do the following at the end of the course: Learn everything there is to know about business management and why it is so important. Familiarize yourself with all of the terms used in the field of business management. Promote organizational direction, learn and apply leadership and management theory. Develop a variety of important skills, such as communication, negotiation, and dispute resolution. Learn about project management, risk management, supply chain management, and human resource management. Determine the personal and technical abilities needed to achieve strategic goals. Create a solid personal development strategy. Learn how to run a company strategically. Examine the company laws and regulations in the United Kingdom. Create an action plan for your business. Special Offers of this Complete Business Management: Business Management Course: This Complete Business Management: Business Management Course includes a FREE PDF Certificate. Lifetime access to this Complete Business Management: Business Management Course Instant access to this Complete Business Management: Business Management Course 24/7 Support Available to this Complete Business Management: Business Management Course Complete Business Management: Business Management This Business Management: Business Management course is tailored to give you a comprehensive understanding of what it takes to thrive in the corporate world. Through this Business Management: Business Management program, you'll develop the skills necessary for effective leadership, project management, and performance evaluation. The Business Management: Business Management course also covers key areas such as strategic planning, operations forecasting, and human resource management. Whether you’re looking to advance in your current role or start your own business, this Business Management: Business Management course will equip you with the tools to succeed in today’s competitive business landscape. Who is this course for? Complete Business Management: Business Management Anyone who aspires to the top of the corporate ladder in any business or workplace setting should take this course. Those who are self-employed or own small businesses should consider taking this course. Professionals in the field of business, program managers, facility managers, and program administrators should enrol. Students and recent graduates will also benefit from this. Requirements Complete Business Management: Business Management To enrol in this Complete Business Management: Business Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Complete Business Management: Business Management Course. Be energetic and self-motivated to complete our Complete Business Management: Business Management Course. Basic computer Skill is required to complete our Complete Business Management: Business Management Course. If you want to enrol in our Complete Business Management: Business Management Course, you must be at least 15 years old. Career path Complete Business Management: Business Management

Complete Business Management - CPD Certified
Delivered Online On Demand5 hours 12 minutes
£12

Level 5 Accounting and Finance & Payroll Management

5.0(3)

By School Of Health Care

Level 5 Accounting and Finance & Payroll Management Level 5 Accounting and Finance & Payroll Management is concerned with the daily flow of money into and out of businesses or institutions. Level 5 Accounting and Finance & Payroll Management refers to the management of assets, liabilities, and planning for future growth. This Level 5 Accounting and Finance & Payroll Management course helps companies measure, monitor, and plan their operations effectively. If you're passionate about becoming an accounting assistant or finance manager, the Level 5 Accounting and Finance & Payroll Management course is for you. This Level 5 Accounting and Finance & Payroll Management course provides a comprehensive introduction to accounting, financial processes, concepts, and responsibilities, preparing you for a successful career in this field. Learning Outcomes After completing the Level 5 Accounting and Finance & Payroll Managementcourse, the learner will be able to - Learn the fundamentals of accounting and finance. Recognize the various types of cost data and cost analysis. Cost management and analysis reports. Understand how to handle accounts receivable and credit. Understand inventory management. Recognize the time value of money Identify accounting conventions and how to record financial data Improve managerial performance by understanding Special Offers of this Level 5 Accounting and Finance & Payroll Management Course This Level 5 Accounting and Finance & Payroll Management Course includes a FREE PDF Certificate. Lifetime access to this Level 5 Accounting and Finance & Payroll Management Course Instant access to this Level 5 Accounting and Finance & Payroll Management Course 24/7 Support Available to this Level 5 Accounting and Finance & Payroll Management Course [ Note: Free PDF certificate as soon as completing the Level 5 Accounting and Finance & Payroll Management Course] Level 5 Accounting and Finance & Payroll Management Unlock your potential with our Level 5 Accounting and Finance & Payroll Management course! This comprehensive program focuses on the daily flow of money in and out of businesses, equipping you with the essential tools to manage finances effectively. With Level 5 Accounting and Finance & Payroll Management, you’ll master the management of assets, liabilities, and the strategic planning of future growth. Designed to help companies measure, monitor, and plan their financial operations, the Level 5 Accounting and Finance & Payroll Management course provides a deep dive into business finance as both an idea and profession. Start today and elevate your career with Level 5 Accounting and Finance & Payroll Management! Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Level 5 Accounting and Finance & Payroll Management Course. Who is this course for? Level 5 Accounting and Finance & Payroll Management This Level 5 Accounting and Finance & Payroll Management is for the ones who are interested in banking sector specially account and finance. Anyone who wants to advance their professional life. Requirements Level 5 Accounting and Finance & Payroll Management To enrol in this Level 5 Accounting and Finance & Payroll Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 5 Accounting and Finance & Payroll Management Course. Be energetic and self-motivated to complete our Level 5 Accounting and Finance & Payroll Management Course. Basic computer Skill is required to complete our Level 5 Accounting and Finance & Payroll Management Course. If you want to enrol in our Level 5 Accounting and Finance Course, you must be at least 15 years old. Career path Level 5 Accounting and Finance & Payroll Management After completing this Level 5 Accounting and Finance & Payroll Management course, you may be able to pursue a variety of promising career opportunities, such as: Account manager Finance manager Administrative specialist and many more.

Level 5 Accounting and Finance & Payroll Management
Delivered Online On Demand10 hours 42 minutes
£12

Transport and Logistics - CPD Certified

5.0(3)

By School Of Health Care

Transport and logistics: Transport and logistics Course Online Introducing the Ultimate Transport and Logistics Bundle Course! Are you fascinated by the complex world of logistics and transportation? Do you aspire to be at the forefront of supply chain management? Look no further, because we have the perfect solution for you - the Transport and logistics: Transport and logistics Course! With this extensive Transport and logistics: Transport and logistics Course, you will be prepared to pursue rewarding career opportunities in Transport and logistics: Transport and logistics Course supply chain operations, transportation planning, and much more. Don't miss out on this Transport and logistics: Transport and logistics Course incredible opportunity to elevate your career in transport and logistics. Enroll in the Transport and logistics: Transport and logistics Course today and secure your spot at the forefront of this dynamic industry! Main Course: Level 4 Transport Manager Course Free Courses included with Transport and logistics: Transport and logistics Course: Along with Transport and logistics Course you will get free Level 4 Logistics Management Along with Transport and logistics Course you will get free Level 7 Advanced Diploma in Supply Chain Management Along with Transport and logistics Course you will get free Level 5 Negotiation Skills Along with Transport and logistics Course you will get free Level 7 Diploma in Facilities Management Special Offers of this Transport and logistics: Transport and logistics Course: This Transport and logistics Course includes a FREE PDF Certificate. Lifetime access to this Transport and logistics Course Instant access to this Transport and logistics Course 24/7 Support Available to this Transport and logistics Course Transport and logistics: Transport and logistics Course Online Our Transport and logistics: Transport and logistics Course will provide you a firm foundation in knowledge by covering every facet of transport management. You will gain knowledge of industry best practices, new trends, and cutting-edge technologies with this Transport and logistics: Transport and logistics Course. Our Transport and logistics: Transport and logistics Course ensures that you are well-prepared for the difficulties of the contemporary transportation scene. Also, you may study logistics strategy, operations, road freight, and rail freight management through our Transport and logistics: Transport and logistics Course. The UK's travel infrastructure is also explicitly covered and described in the Level 4 Transport Manager course. Who is this course for? Transport and logistics: Transport and logistics Course Online The Transport and logistics: Transport and logistics Course is ideal for those already working in this field or are interested in becoming one. This Transport and logistics: Transport and logistics Course is designed to broaden your knowledge and boost your CV. Requirements Transport and logistics: Transport and logistics Course Online To enrol in this Transport and logistics: Transport and logistics Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Transport and logistics: Transport and logistics Course. Be energetic and self-motivated to complete our Transport and logistics: Transport and logistics Course. Basic computer Skill is required to complete our Transport and logistics: Transport and logistics Course. If you want to enrol in our Transport and logistics: Transport and logistics Course, you must be at least 15 years old. Career path Transport and logistics: Transport and logistics Course Online You will be able to grasp certain knowledge and abilities with the utmost confidence after completing this Transport and logistics: Transport and logistics Course.

Transport and Logistics - CPD Certified
Delivered Online On Demand3 hours 6 minutes
£12

Property Investment - It's all about the numbers

By Property SQ2

Property Investment key calculations for profit, mortgage, return on investment. Invest like a pro, know your numbers work on every property deal.

Property Investment - It's all about the numbers
Delivered Online On Demand1 hour 20 minutes
£19.95

Oracle Data Integrator 19c Configuration and Administration (TTOR30319)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This intermediate-level hands-on course is geared for experienced Administrators, Analysts, Architects, Data Scientists, Database Administrators and Implementers Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Administer ODI resources and setup security with ODI Apply ODI Topology concepts for data integration Describe ODI Model concepts Describe architecture of Oracle Data Integrator Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Implement Changed Data Capture with ODI Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs. Throughout this course participants will explore how to centralize data across databases, performing integration, designing ODI Mappings, and setting up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem, allowing administrators and data scientists to farm out map-reduce operations from established relational databases to Hadoop. They can also read back into the relational world the results of complex Big Data analysis for further processing. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Administer ODI resources and setup security with ODI Apply ODI Topology concepts for data integration Describe ODI Model concepts Describe architecture of Oracle Data Integrator Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Implement Changed Data Capture with ODI Introduction to Integration and Administration Oracle Data Integrator: Introduction Oracle Data Integrator Repositories Administering ODI Repositories Create and connect to the Master Repository Export and import the Master Repository Create, connect, and set a password to the Work Repository ODI Topology Concepts ODI Topology: Overview Data Servers and Physical Schemas Defining Topology Agents in Topology Planning a Topology Describing the Physical and Logical Architecture Topology Navigator Creating Physical Architecture Creating Logical Architecture Setting Up a New ODI Project ODI Projects Using Folders Understanding Knowledge Modules Exporting and Importing Objects Using Markers Oracle Data Integrator Model Concepts Understanding the Relational Model Understanding Reverse-Engineering Creating Models Organizing ODI Models and Creating ODI Datastores Organizing Models Creating Datastores Constraints in ODI Creating Keys and References Creating Conditions Exploring Your Data Constructing Business Rules ODI Mapping Concepts ODI Mappings Expressions, Join, Filter, Lookup, Sets, and Others Behind the Rules Staging Area and Execution Location Understanding Knowledge Modules Mappings: Overview Designing Mappings Multiple Sources and Joins Filtering Data Overview of the Flow in ODI Mapping Selecting a Staging Area Configuring Expressions Execution Location Selecting a Knowledge Module Mappings: Monitoring and Troubleshooting Monitoring Mappings Working with Errors Designing Mappings: Advanced Topics 1 Working with Business Rules Using Variables Datasets and Sets Using Sequences Designing Mappings: Advanced Topics 2 Partitioning Configuring Reusable Mappings Using User Functions Substitution Methods Modifying Knowledge Modules Using ODI Procedures Procedures: Overview Creating a Blank Procedure Adding Commands Adding Options Running a Procedure Using ODI Packages Packages: Overview Executing a Package Review of Package Steps Model, Submodel, and Datastore Steps Variable Steps Controlling the Execution Path Step-by-Step Debugger Starting a Debug Session New Functions Menu Bar Icons Managing ODI Scenarios Scenarios Managing Scenarios Preparing for Deployment Using Load Plans What are load plans? Load plan editor Load plan step sequence Defining restart behavior Enforcing Data Quality with ODI Data Quality Business Rules for Data Quality Enforcing Data Quality with ODI Working with Changed Data Capture CDC with ODI CDC implementations with ODI CDC implementation techniques Journalizing Results of CDC Advanced ODI Administration Setting Up ODI Security Managing ODI Reports ODI Integration with Java

Oracle Data Integrator 19c Configuration and Administration (TTOR30319)
Delivered OnlineFlexible Dates
Price on Enquiry

BA28 - Requirements Analysis and Use Cases

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course has been expressly designed for the Business Analyst, Business System Analyst, System Analyst, and/or Requirements Engineer. The Designer, Developer and Tester who are actively involved in utilizing use cases may also benefit from this workshop. Overview Employ use cases to elicit requirements, at a business, system or subsystem levelEmploy use cases to document the scope of a projectWrite use cases in a clear and unambiguous way.Model use cases with workflow diagramsPlan and divide up the project work based on your use casesManage a use case as it evolves over time and goes through many changes This course provides a strong foundation in the mechanics of use case diagramming and writing textual descriptions of use cases. In this highly interactive workshop, you will learn how to enhance and refine your use case skills, how to involve your stakeholders in the use case process, and how to develop use cases that provide valuable information to the designers and testers. Use cases that meet the needs of designers can be too technical and too detailed for other stakeholders. Use cases that satisfy business users are usually not very helpful to designers and testers. How do you satisfy these two disparate interests? And how do you handle the details like business rules, data validations and user interface specifications? Introduction Course objectives Understanding of business analysis Knowledge areas of BABOK© Guide Overview of Use Cases Describe the purpose and value of a use case approach Use case terminology Introducing a use case approach Needs Assessment Purpose of Needs Assessment Needs Assessment and use cases Defining and understanding the strategic goals and objectives Understanding the business process Identifying actors Identifying business information Analyzing locations and operations Drawing the business use case diagram Building the business architecture Defining solution options Defining System Scope Product scope/project scope System actors versus business actors Analyzing the business process model Analyzing business use cases Identifying candidate use cases Identifying scenarios Diagramming use cases Draw a use case diagram Create a use case catalog Evaluating, Prioritizing, and Packaging Use Cases Iterative nature of this work Evaluating use cases Use case priority Use case risk Use case complexity Use case dependencies Evaluate and Prioritize use cases Dividing work up between releases Packaging A process for how to perform packaging Writing the Main Success Scenario Use case descriptions Primary and secondary goals Assumptions Pre-conditions Triggers Post-conditions Scenario example Main success scenario Conditional execution Use cases and requirements Best practices for writing a use case description Writing the Other Scenarios Scenarios and flows Alternate scenarios and flows Alternate vs. basic flow Guidelines for alternate flows Exception flows Failed post conditions Write alternate and exception flows Process Modeling to Describe Use Case Flows UML© Activity Diagram Notation Sequencing activities Developing an activity diagram Facilitated sessions Draw a UML© Activity Diagram Using Advanced Diagramming Techniques Commonality Dependency Relationships Identify relationships Comparing the different relationships Developing a Requirements Specification Requirements and use cases Detailed requirements Common approaches to specifications Non-functional requirements Write non-functional requirements User interface requirements UI data descriptions Business rules Decision tables and inference rules How to document simple calculations Reporting requirements Data requirements Data accessibility requirements Traceability Course Summary Wrap-up Finding more information Additional course details: Nexus Humans BA28 - Requirements Analysis and Use Cases 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 BA28 - Requirements Analysis and Use Cases 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.

BA28 - Requirements Analysis and Use Cases
Delivered OnlineFlexible Dates
Price on Enquiry

Introduction to Writing SQL Queries (TTSQL003)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data

Introduction to Writing SQL Queries (TTSQL003)
Delivered OnlineFlexible Dates
Price on Enquiry