Duration 1 Days 6 CPD hours This course is intended for Reporting Fundamentals in Lightning Experience is ideal for Sales Rep/Managers, Service Rep/Managers, Beginning Admin, and Business Analyst/Solution Architects. Overview When you complete this course, you will be able to:Work with standard reports.Establish a report building process.Build custom reports using different reporting formats in Lightning.Group and summarize reports in Lightning.Use field filters and filter logic.Add charts and conditional highlighting.Create dashboards in Lightning This course will teach you how to customize existing reports as well as use the Salesforce reporting toolset to create your own reports. Introducing the CourseReports Tab, Folders, and Formats Navigate the Reports Tab to Find Suitable Reports Create Custom Folders in Classic to be Used in Lightning Describe the Different Formats of Reports Run and Modify Existing Reports Using the Report Builder Establish a Report Building Process Navigate the Report Builder Create Custom Reports Using a Standard Report Type Use Filters and Filter Logic Export Your Report Summarizing Your Data Understand the Difference Between a Summary and Matrix Report Use Bucket Fields to Segment Your Data Use Custom Summary Formulas to Perform Calculations on Your Report Data Getting More Insight from Your Data Add Conditional Highlighting to a Report Create Charts to Display Summary Data Schedule and Email a Report to Run Dashboards Articulate What a Dashboard Is Understand the Benefits of Creating Dashboards in Lightning Create a Dashboard Using the Dashboard Builder Additional course details: Nexus Humans Salesforce Reporting Fundamentals in Lightning Experience (RPX101) 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 Salesforce Reporting Fundamentals in Lightning Experience (RPX101) 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.
Dive into the fascinating world of crime analysis with our CPD Accredited Course designed to sharpen your understanding of crime patterns, trends, and data interpretation. This course unpacks the core principles of analysing criminal activity through a methodical and evidence-based approach. It’s ideal for professionals eager to elevate their knowledge and apply analytical thinking to enhance public safety strategies. With a focus on data handling, statistical methods, and crime mapping, you’ll discover how to interpret complex information to support investigative processes and policy-making. Delivered entirely online, this course respects your schedule and location while ensuring you receive up-to-date, engaging content. You’ll explore a range of analytical techniques used by experts in the field, all explained clearly and with a touch of wit to keep the material lively. Whether you work in law enforcement, security, or research, this course will enrich your expertise, helping you make sense of the numbers behind the headlines. Ready to delve deeper into crime analysis? This is your chance to boost your professional credentials without stepping outside your door. Learning Outcomes: It's your chance to start with ourCriminology course and give your resume the stamp of approval that employers are looking for. So, pick up your card now and fill up your virtual basket with this highly-rated Crime Analysis - CPD Accredited online training program from Training Express Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Crime Analyst profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Introduction to Crime Analysis Module 02: The Criminal Justice System in England and Wales Module 03: Classification of Crime Module 04: Crime Scene Module 05: Crime Mapping Module 06: Tactical Crime Analysis Module 07: Strategic and Administrative Crime Analysis Module 08: Criminal Behaviour and Psychology Module 09: Financial and Environmental Criminology Module 10: Criminal Justice Module 11: Criminal Profiling: Science, Logic and Metacognition Module 12: Phases of Profiling Module 13: Criminal Intelligence Analysis Module 14: Technology in Criminal Intelligence Analysis Module 15: Research Method and Statistics in Crime Analysis Module 16: Policing and Cyber Security Module 17: Forecasting Future Occurrences and Prediction Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Crime Analysis - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Crime Analysis - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Crime Analysis - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Crime Analysis - CPD Accredited training.
This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! What Will I Learn? Prepare your environment Introducing Database Program Units Creating and Maintaining Stored Procedures & Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System-Supplied Packages Creating and Maintaining Database Triggers Implementing System Event Triggers Requirements Familiarity with database and programming principles Who is the target audience? Application designers and developers Database administrators Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Course Certification
C# Programming Masterclass is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this C# Programming Masterclass and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Introduction Introduction 00:04:00 Basics to get started Intro 00:02:00 Visual Studio 00:07:00 Comments 00:02:00 Variables 00:08:00 Print and read console 00:04:00 Math 00:08:00 LogIc Intro 00:02:00 Boolean 00:07:00 IF 00:08:00 IF ELSE, ELSE 00:08:00 Switch 00:05:00 WHILE loop 00:07:00 FOR loop 00:03:00 Methods (basic) Basics of a method 00:07:00 Parameters 00:05:00 Returns 00:08:00 Classes (basics) Basics of a class 00:07:00 Access 00:06:00 Static 00:07:00 Variavles (basic) Read line 00:03:00 Arrays 00:06:00 FOR EACH loop 00:05:00 Convert 00:04:00 Cast 00:04:00 Error handling Try and Catch 00:07:00 Usefull methods Date 00:12:00 Text (advanced) Split, remove, substring 00:14:00 Classess (advanced) More on construction 00:11:00 More on access 00:04:00 Inheritance 00:09:00 EXAMPLE - time converter 00:17:00 Binary (advanced) Read a text file 00:13:00 Write a text file 00:10:00 Serialize object to byte array 00:15:00 Asynchronous (advanced) Task 00:07:00 Async and await 00:15:00 Multitasking 00:07:00 Search in objects (linq) Where 00:11:00 Find 00:05:00 Order, group and merge 00:10:00 Pratice Conclusion Bonus lecture 00:01:00
Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who want to learn the Python programming language in preparation for using Python to develop software for a wide range of applications, such as data science, machine learning, artificial intelligence, and web development. Overview In this course, you will develop simple command-line programs in Python. You will: Set up Python and develop a simple application. Declare and perform operations on simple data types, including strings, numbers, and dates. Declare and perform operations on data structures, including lists, ranges, tuples, dictionaries, and sets. Write conditional statements and loops. Define and use functions, classes, and modules. Manage files and directories through code. Deal with exceptions. Though Python has been in use for nearly thirty years, it has become one of the most popular languages for software development, particularly within the fields of data science, machine learning, artificial intelligence, and web development?all areas in which Python is widely used. Whether you're relatively new to programming, or have experience in other programming languages, this course will provide you with a comprehensive first exposure to the Python programming language that can provide you with a quick start in Python, or as the foundation for further learning. You will learn elements of the Python 3 language and development strategies by creating a complete program that performs a wide range of operations on a variety of data types, structures, and objects, implements program logic through conditional statements and loops, structures code for reusability through functions, classes, and modules, reads and writes files, and handles error conditions. Lesson 1: Setting Up Python and Developing a Simple Application Topic A: Set Up the Development Environment Topic B: Write Python Statements Topic C: Create a Python Application Topic D: Prevent Errors Lesson 2: Processing Simple Data Types Topic A: Process Strings and Integers Topic B: Process Decimals, Floats, and Mixed Number Types Lesson 3: Processing Data Structures Topic A: Process Ordered Data Structures Topic B: Process Unordered Data Structures Lesson 4: Writing Conditional Statements and Loops in Python Topic A: Write a Conditional Statement Topic B: Write a Loop Lesson 5: Structuring Code for Reuse Topic A: Define and Call a Function Topic B: Define and Instantiate a Class Topic C: Import and Use a Module Lesson 6: Writing Code to Process Files and Directories Topic A: Write to a Text File Topic B: Read from a Text File Topic C: Get the Contents of a Directory Topic D: Manage Files and Directories Lesson 7: Dealing with Exceptions Topic A: Handle Exceptions Topic B: Raise Exceptions
Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data
Psychology Secrets is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Psychology Secrets and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 7 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed. After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Psychology Secrets Intro By Prof. Paul - WHY This Course is SO Important To Your Life! 00:02:00 Goals & Fundamentals 00:17:00 Understanding HOW Feelings Work & How You Can USE This! 00:12:00 'The Imprint Period' - How You Were Created - How You Were Programmed 00:17:00 The Amazing Truth About Values & Beliefs 00:18:00 Do You Know The Difference Between Reality & Lies? Are You Sure? 00:25:00 Personal Illusions That Are Holding You Back - Break Free! 00:20:00 EGO - The Great Deceiver 00:35:00 The Inner-Critic How To WIN The INNER Battle 00:08:00 Understanding Self-Image & Your Multiple Minds 00:21:00 How To Defeat The PAST & The FUTURE 00:18:00 Emotional Reasoning & Logic Systems - How To WIN! 00:08:00 Understanding & Meeting Your Needs - The Hidden Secrets 00:11:00 Understanding Motivation - The Ultimate Driving Force 00:17:00 Defeat This Major Block . And Free Your Mind! 00:08:00 Discover 'The Source & Solution To All Your Problems' 00:15:00 Agenda & Lies - How They impact Your Life 00:11:00 Gambits - Games People Play 00:12:00 Break Free From The Problems of 'Attachment' & 'The Sheep Mentality' 00:14:00 'The Dirty Secret Of Psychology' & How To Free Yourself! 00:25:00 Tap Into The Power Of The Unconscious Mind 00:21:00 How To Control Your Own Mind - And WHY Almost Nobody Does! 00:05:00 Why FEAR Dominates Our Lives & How To Beat it! 00:05:00 Final Thoughts, Tips & Suggestions To Radically Improve Your Life 00:17:00 Mock Exam Mock Exam - Psychology Secrets 00:20:00 Final Exam Final Exam - Psychology Secrets 00:20:00