4210 Courses delivered Online

This course explains how huge chunks of data can be analyzed and visualized using the power of the data analyst toolbox. You will learn Python programming, advanced pivot tables' concepts, the magic of Power BI, perform analysis with Alteryx, master Qlik Sense, R Programming using R and R Studio, and create stunning visualizations in Tableau Desktop.

Duration 1 Days 6 CPD hours This course is intended for Business decision-makers: directors (managers of managers), managers of individual contributors (ICs) or ICs working in non-IT functions/divisions (such as finance, marketing, sales, HR, product design) interested in understanding the applications of Google?s cloud technology for business improvement opportunities and transformational project(s). Through this interactive training, you?ll learn about core cloud business drivers?specifically Google?s cloud?and gain the knowledge/skills to determine if business transformation is right for you and your team, and build short and long-term projects using the ?superpowers? of cloud accordingly. You?ll also find several templates, guides, and resource links through the supplementary student workbook to help you build a custom briefing document to share with your leadership, technical teams or partners. Why cloud technology is revolutionizing business This module introduces cloud technology as a paradigm shift and explains how it?s irrevocably transforming business globally. It defines the fundamental building blocks of cloud technology?compute power and data?and what they mean for you and your business. And finally, it reveals how these building blocks help to create five superpowers using concrete use cases of their transformative abilities for business, education, and government sectors. Foster an innovation culture Cloud is not just about a technological transformation; it's a business and cultural transformation, too. This module explores how the superpowers of the cloud are brought to life through people. It looks specifically at how to organically create and scale innovation through culture and business practices. It offers key principles, drawing examples from Google?s success and real world scenarios, that you can apply in your day-to-day operations. Define the ideal business transformation challenge Previous modules describe the journey with cloud technology to include business and cultural changes as well. This module sets the groundwork to build a transformational solution using cloud technology for your role or your business. This process starts with distinguishing between scaled improvements and transformations. Next, the module demonstrates how to write an ideal challenge question and use insights generated from a data ecosystem to address the challenge. Finally, it introduces a framework that you can use to assess and refine your challenge ideas, preparing you to build a business case in a later module. Build trust with availability, security, and compliance This module addresses common concerns about data privacy and security when migrating to the cloud. It defines key terms - privacy, security, compliance, and reliability - and reveals today?s top cybersecurity challenges and threats. It discusses how data security and compliance can be maintained when data is in the cloud, as illustrated by the Shared Responsibility Model. And finally, it uses a concrete example to explain how learners can build a high-level security program in their own organization. Build a business case for your transformation challenge This module explains how to identify the most transformative solution for your business challenge. It then breaks down steps to achieve the transformational solution through creating smaller projects and plotting them onto a transformation roadmap. It describes how to use the data ecosystem you mapped in a previous module to support your overall project. Finally, it explains step by step how to build a business case and gives tips to help you pitch your project idea to gain buy-in from leadership, teams, and technical partners. Additional course details: Nexus Humans Business Transformation with Google Cloud 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 Business Transformation with Google Cloud 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.

Many businesses today, whether big or small are acquiring the idea of having virtual assistance, this reduces the workload on the company and is cheaper than having to create a whole department to take on the same tasks. Virtual assistance is fast becoming an attractive option for many. This course is designed to give you the edge, sharing processes proven to help build a successful virtual assistant business. The course will cover virtual assistant basics and what abilities are needed to become an expert one. You will walk out of this course with the knowledge that will help you to work as a virtual assistant and also help you find legitimate work online! Course Highlights Business Management: Virtual Assistant is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Business Management: Virtual Assistant into 10 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 8 hours, 55 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Business Management: Virtual Assistant Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Business Management: Virtual Assistant is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Business Management: Virtual Assistant is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Business Management: Virtual Assistant Introduction To Virtual Assistant FREE 01:00:00 What Skills Are Needed FREE 01:00:00 Arranging A Work Area 01:00:00 Decide What Services You Will Offer To Accept 01:00:00 How to Know Your Budget 00:30:00 Have A Business Plan 01:00:00 Using Sites Like Scriptlance To Find Clients 01:00:00 Marketing Strategies to Get Clients 01:00:00 Handling Clients Correctly 00:30:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Business Management: Virtual Assistant 00:20:00 Final Exam Final Exam- Business Management: Virtual Assistant 00:20:00

Are you looking to enhance your Lean Six Sigma - Lean Principle skills? If yes, then you have come to the right place. Our comprehensive course on Lean Six Sigma - Lean Principle will assist you in producing the best possible outcome by mastering the Lean Six Sigma - Lean Principle skills. The Lean Six Sigma - Lean Principle course is for those who want to be successful. In the Lean Six Sigma - Lean Principle course, you will learn the essential knowledge needed to become well versed in Lean Six Sigma - Lean Principle. Our Lean Six Sigma - Lean Principle course starts with the basics of Lean Six Sigma - Lean Principle and gradually progresses towards advanced topics. Therefore, each lesson of this Lean Six Sigma - Lean Principle course is intuitive and easy to understand. Why would you choose the Lean Six Sigma - Lean Principle course from Compliance Central: Lifetime access to Lean Six Sigma - Lean Principle course materials Full tutor support is available from Monday to Friday with the Lean Six Sigma - Lean Principle course Learn Lean Six Sigma - Lean Principle skills at your own pace from the comfort of your home Gain a complete understanding of Lean Six Sigma - Lean Principle course Accessible, informative Lean Six Sigma - Lean Principle learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Lean Six Sigma - Lean Principle Study Lean Six Sigma - Lean Principle in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Lean Six Sigma - Lean Principle Course Lean Six Sigma - Lean Principle Curriculum Breakdown of the Lean Six Sigma - Lean Principle Course Module 1: Understanding Lean Module 2: The Lean Culture Module 3: The Five Principles of Lean Module 4: Value and Waste Module 5: Value Stream Mapping (VSM) Module 6: The Principles of Flow and Pull Module 7: Overview of Six Sigma Module 8: The Define Phase Module 9: The Measure Phase Module 10: The Analyse Phase Module 11: The Improve Phase Module 12: The Control Phase CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Lean Six Sigma - Lean Principle course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Lean Six Sigma - Lean Principle. It is also great for professionals who are already working in Lean Six Sigma - Lean Principle and want to get promoted at work. Requirements To enrol in this Lean Six Sigma - Lean Principle course, all you need is a basic understanding of the English Language and an internet connection. Career path The Lean Six Sigma - Lean Principle course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Lean Six Sigma - Lean Principle. Lean Six Sigma Analyst: £30,000 to £50,000 per year Process Improvement Specialist: £35,000 to £60,000 per year Quality Assurance Manager: £40,000 to £70,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Are you looking to enhance your Lean Six Sigma skills? If yes, then you have come to the right place. Our comprehensive course on Lean Six Sigma will assist you in producing the best possible outcome by mastering the Lean Six Sigma skills. The Lean Six Sigma course is for those who want to be successful. In the Lean Six Sigma course, you will learn the essential knowledge needed to become well versed in Lean Six Sigma. Our Lean Six Sigma course starts with the basics of Lean Six Sigma and gradually progresses towards advanced topics. Therefore, each lesson of this Lean Six Sigma course is intuitive and easy to understand. Why would you choose the Lean Six Sigma course from Compliance Central: Lifetime access to Lean Six Sigma course materials Full tutor support is available from Monday to Friday with the Lean Six Sigma course Learn Lean Six Sigma skills at your own pace from the comfort of your home Gain a complete understanding of Lean Six Sigma course Accessible, informative Lean Six Sigma learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Lean Six Sigma bundle Study Lean Six Sigma in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Lean Six Sigma Course Improve your chance of gaining in demand skills and better earning potential by completing the Lean Six Sigma Lean Six Sigma Curriculum Breakdown of the Lean Six Sigma Course Module 01: Understanding Lean Module 02: The Lean Culture Module 03: The Five Principles of Lean Module 04: Value and Waste Module 05: Value Stream Mapping (VSM) Module 06: The Principles of Flow and Pull Module 07: Overview of Six Sigma Module 08: The Define Phase Module 09: The Measure Phase Module 10: The Analyse Phase Module 11: The Improve Phase Module 12: The Control Phase CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Lean Six Sigma course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Lean Six Sigma. It is also great for professionals who are already working in Lean Six Sigma and want to get promoted at work. Requirements To enrol in this Lean Six Sigma course, all you need is a basic understanding of the English Language and an internet connection. Career path The Lean Six Sigma course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Lean Six Sigma. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Follow your dreams by enrolling on the Tourism and Transportation course today and develop the experience, skills and knowledge you need to enhance your professional development. Tourism and Transportation will help you arm yourself with the qualities you need to work towards your dream job. Study the Tourism and Transportation training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Tourism and Transportation course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Tourism and Transportation course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Tourism and Transportation course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Tourism and Transportation course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Tourism and Transportation course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Tourism and Transportation course. The Tourism and Transportation course is designed by industry experts and is tailored to help you learn new skills with ease.  The Tourism and Transportation is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Tourism and Transportation when it suits you. Access the Tourism and Transportation course modules from any internet-enabled device, including computers, tablets, and smartphones. The Tourism and Transportation course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Tourism and Transportation now and start learning instantly! What You Get Out Of Studying Tourism and Transportation With Janets: Receive a digital Certificate upon successful completion of the Tourism and Transportation course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Tourism and Transportation training course is delivered through Janets' online learning platform. Access the Tourism and Transportation content from any internet-enabled device whenever or wherever you want to. The Tourism and Transportation course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Tourism and Transportation course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Tourism and Transportation course. After successfully passing the Tourism and Transportation course exam, you will be able to apply for a CPD-accredited certificate as proof of your Tourism and Transportation qualification. Certification All students who successfully complete the Tourism and Transportation course can instantly download their digital certificate. You can also purchase a hard copy of the Tourism and Transportation course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Tourism and Transportation is ideal for those who already work in this sector or are an aspiring professional. This Tourism and Transportation course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Tourism and Transportation is open to all students and has no formal entry requirements. To study the Tourism and Transportation course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Tourism and Transportation is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Tourism and Transportation and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Tourism and Transportation Travel & Tourism Introduction to Travel & Tourism 00:30:00 History of Tourism 00:30:00 Integrated Model of Tourism 00:30:00 The Meaning of Travel Tourism and Tourist 01:00:00 Types of Tourism 00:15:00 The Products & Services of Tourism 00:30:00 Tourism-Destinations 01:00:00 Managing Tourism 01:00:00 Managing Tour Operations 00:30:00 Transportation 01:00:00 Quality Management 01:00:00 The Impacts of Tourism 01:00:00 Conclusion 00:15:00 Travel & Tourism Guide Africa Safari Travel Temptations 00:30:00 Australia Travel Temptations 00:30:00 Booking Travel Temptations 00:15:00 Costa Rica Travel Temptations 00:30:00 Disneyland Travel Temptations 00:30:00 Disney World Travel Temptations 00:30:00 Egypt Travel Temptations 00:30:00 Exotic Travel Temptations 00:30:00 Travel Temptations 00:15:00 Hilo Travel Temptations 00:15:00 Hot Spots in Travel Temptations 00:15:00 How Online Travel Temptations Work 00:15:00 Indiana Travel Temptations 01:00:00 Key West Travel Temptations 00:15:00 Mexico Travel Temptations 00:30:00 Michigan Travel Temptations 01:00:00 Ohio Travel Temptations 00:30:00 Panama Travel Temptations 00:30:00 RIU Paradise Island Travel Temptations 00:15:00 San Diego Travel Temptations 00:30:00 Sandy Point Travel Temptations 00:15:00 Singapore Travel Temptations 00:30:00 Tennessee Travel Temptations 01:00:00 Travel Agents and Travel Temptations 00:15:00 Travel Destination to Alaska 01:00:00 Travel Destination to New Mexico 00:30:00 Travel Temptations in Amsterdam 00:30:00 Travel Temptations in Iowa 00:30:00 Travel temptations on a Nile River Cruise Liner 00:15:00 Travel temptations through Nevada 00:30:00 Travel Temptations in Antigua 00:30:00 Travel Temptations in California 00:30:00 Travel Temptations in Canada 00:30:00 Travel Temptations in Chicago 00:30:00 Travel temptations in Colorado 00:30:00 Travel temptations in Hawaii 00:30:00 Travel temptations in Kentucky 00:30:00 Travel temptations in Montana 00:30:00 Travel temptations in New York 00:30:00 Travel Temptations in North Carolina 00:30:00 Travel Temptations in South Carolina 00:30:00 Travel Temptations in Oregon 00:30:00 Travel Temptations in Rome 00:30:00 Travel Temptations in South Dakota 00:30:00 Travel Temptations in the Bahamas 01:00:00 Travel Temptations in the Caribbean 00:30:00 Travel Temptations in the UK 00:30:00 Travel Temptations in Washington DC 00:30:00 Wisconsin Travel Temptations 00:30:00 Conclusion to Diploma in Travel & Tourism 00:15:00 Traveling Pointers & Pitfalls Pointers for Gaining Access to Money While Traveling on the Road 00:30:00 A 'Must-Do' Before Going on a Trip 01:00:00 Practical Packing Tips 00:30:00 Wellness Tips 01:00:00 Transportation Techniques 00:30:00 Shopping Pitfalls 00:30:00 Food and Dining Tips 00:30:00 Money, Money, Money Wits 00:30:00 The 6 Top Airport Scams and What to Do to Guard against Them 01:00:00 A Commonly Hidden Foreign Airport Warning 00:30:00 Don't Prepay for that Gas 00:15:00 Surefire Ways to Guard against Air-Travel Tiredness 00:30:00 What to Do if a Person Becomes Ill While Traveling in Air? 01:00:00 The Best but Affordable Places to Eat while Traveling 00:30:00 How to Get Paid while Taking a Vacation 00:30:00 Mock Exam Mock Exam - Tourism and Transportation 00:20:00 Final Exam Final Exam - Tourism and Transportation 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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

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

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.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Week 1: Getting Started Quiz 1 00:02:00 Quiz 1 Solution 00:01:00 What is Programming 00:03:00 Quiz 2 00:01:00 Quiz 2 Solution 00:01:00 Meeting the Interpreter and Problem Quiz 3 00:01:00 Quiz 3 solution 00:01:00 Why Programming and Quiz 4 00:02:00 Gammar and Python Rules 00:04:00 Backus Naur Form 00:03:00 Quiz 4 part 2 00:01:00 Quiz 4 Part 2 Solution 00:01:00 Python Grammar and Quiz 5 00:05:00 Quiz 5 Solution 00:03:00 Quiz 6 00:01:00 Quiz 6 Solution 00:02:00 Processors 00:02:00 Introducing Variables 00:05:00 Variables Quiz 8 00:01:00 Quiz 8 Solution 00:01:00 Variables Quiz 9 00:01:00 Quiz 9 Solution 00:01:00 Variables Quiz 10 00:01:00 Quiz 10 Solution 00:03:00 Introducing Strings 00:04:00 Using Strings Quiz 11 00:01:00 String indexing 00:02:00 Quiz 13 00:01:00 Quiz 13 Solution 00:03:00 String Subsequences 00:04:00 String Subsequences Quiz 14 00:01:00 Quiz 14 Solution 00:02:00 Understanding Selection Quiz 15 00:01:00 Quiz 15 Solution 00:04:00 Finding String in String Quiz 16 00:04:00 Quiz 16 Solution 00:02:00 Testing and Quiz 17 00:02:00 Quiz 17 Solution 00:03:00 Find With Parameter Quiz 18 00:02:00 Quiz 18 Solution 00:01:00 Congratulations 00:01:00 Week 2: Procedures and Loops Unit Overview 00:03:00 Procedural Abstraction 00:03:00 Introducing Procedures 00:04:00 Procedure Code Quiz 1 00:03:00 Quiz 1 Solution 00:01:00 Output and Quiz 2 00:01:00 Quiz 2 Solution 00:02:00 Return Statement and Quiz 3 00:03:00 Quiz 3 Solution 00:02:00 Inc Procedure Quiz 4 00:01:00 Quiz 4 Solution 00:01:00 Sum Procedure and Quiz 5 00:01:00 Quiz 5 Solution 00:02:00 Sum Procedure With a Return Statement3 00:02:00 Square Procedure Quiz 6 00:01:00 Quiz 6 Solution 00:02:00 Sum 3 Quiz 7 00:01:00 Quiz 7 Solution 00:02:00 Double String Procedure Quiz 8 00:01:00 Quiz 8 Solution 00:01:00 Find Second Quiz 9 00:02:00 Quiz 9 Solution 00:02:00 Equality Comparison Quiz 10 00:04:00 Quiz 10 Solution 00:01:00 If Statement Quiz 11 00:03:00 Quiz 11 Solution 00:03:00 Is Friend Quiz 12 00:02:00 Quiz 12 Solution3 00:02:00 Is Friend Quiz 13 00:02:00 Quiz 13 Solution 00:02:00 The Or Construct 00:03:00 Quiz 14 Solution 00:06:00 While Loop Quiz 15 00:05:00 Quiz 15 Solution 00:02:00 While Loop Quiz 16 00:01:00 Quiz 16 Solution 00:01:00 Print Numbers Quiz 17 00:01:00 Quiz 17 Solution 00:02:00 Factorial Quiz 18 00:02:00 Quiz 18 Solution 00:02:00 Break Quiz 19 00:04:00 Quiz 20 00:05:00 Quiz 20 Solution 00:01:00 No Links Quiz 21 00:01:00 Print All Links Quiz 21 Solution 00:02:00 Final Quiz Solution 00:02:00 Week 3: How To Manage Data Unit Overview 00:03:00 Stooges And Quiz 1 00:01:00 Quiz 1 Solution 00:01:00 Days in Month Quiz 00:01:00 Countries Quiz 00:01:00 Quiz 3 Solution 00:01:00 Relative Size Quiz 00:01:00 Quiz 4 Solution 00:01:00 Lists Mutation 00:01:00 Different Stooges Quiz 00:01:00 Quiz 5 Solution 00:01:00 Secret Agent Man Quiz 00:01:00 Replace Spy Quiz 00:01:00 Quiz 7 Solution 00:03:00 Python List Addition and Lenght 00:02:00 List Operations In Python 00:02:00 Python Lists Length Quiz 00:01:00 Quiz 8 Solution 00:01:00 Append Quiz 00:01:00 Hard Drive Quiz 00:01:00 Quiz 11 Solution 00:01:00 Python Loops on Lists Quiz 00:02:00 Quiz 12 Solution 00:02:00 Python For Loops 00:03:00 Sum List Quiz 00:02:00 Measure a String Quiz 00:01:00 Find Element Quiz 00:02:00 Quiz 15 Solution 00:04:00 Quiz 16 Solution 00:01:00 Python Union Procedure Quiz 00:01:00 Quiz 17 solution 00:01:00 Pop in Python Quiz 18 00:02:00 Quiz 18 Solution 00:03:00 Collecting Links 00:01:00 Get All Links 00:02:00 Starting Get All Links Quiz 00:01:00 Quiz 19 Solution 00:01:00 Updating Links Quiz 00:01:00 Quiz 20 Solution 00:01:00 55. Finishing Get All Links Quiz 00:01:00 Quiz 21 Solution 00:01:00 Finishing the Python Web Crawler 00:03:00 Crawling Process Quiz 00:01:00 Quiz 22 Solution 00:01:00 Crawl Web Quiz 00:01:00 Quiz 23 Solution 00:01:00 62. Crawl Web Loop Quiz 00:01:00 Quiz 24 Solution 00:02:00 Crawl If Quiz 00:01:00 Quiz 25 Solution 00:01:00 Finishing Crawl Web and Final Quiz 00:02:00 Final Quiz Solution & Conclusion 00:03:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00