3582 Analyst courses in Dunfermline delivered On Demand

This course teaches the fundamental concepts of DAX in Power BI. If you have the questions: How do I learn DAX? What is the best way to learn DAX fast?-then this is the best course for you. This course teaches fundamental concepts and does not cover visualization or various advanced DAX patterns for specific questions.

Software development is the process of conceiving, specifying, designing, programming, documenting, testing, and bug-fixing involved in creating and maintaining applications, frameworks, or other software components.

The course aims to provide a comprehensive understanding of Talent Management, including its concept, purpose, and benefits. It aims to explore the financial value of Talent Management, with an emphasis on how effective Talent Management can improve a company's bottom line. The course also aims to analyze the Talent Management Process, from talent acquisition and development to performance evaluation and reward management. Through this course, learners will learn how to implement effective Talent Management strategies to attract, retain and develop top talent, resulting in a competitive advantage for their organization. After the successful completion of the course, you will be able to learn about the following, The concept, purpose and benefits of Talent Management. The Financial Value of Talent Management. The Talent Management Process.   The course aims to provide a comprehensive understanding of Talent Management by exploring the concept, purpose, and benefits of Talent Management. The course will highlight the importance of Talent Management in driving organizational performance and the financial value of Talent Management. The financial aspects of Talent Management will be examined, and the impact of effective Talent Management practices on an organization's bottom line will be discussed. Additionally, the Talent Management Process will be analyzed, including talent sourcing and retention, performance and rewards management, and employee development. By the end of the course, participants will have gained an understanding of the critical role of Talent Management in an organization's success, as well as the key practices necessary to effectively manage talent. The course aims to provide a comprehensive understanding of Talent Management, including its concept, purpose, and benefits. It aims to explore the financial value of Talent Management, with an emphasis on how effective Talent Management can improve a company's bottom line. The course also aims to analyze the Talent Management Process, from talent acquisition and development to performance evaluation and reward management. Through this course, learners will learn how to implement effective Talent Management strategies to attract, retain and develop top talent, resulting in a competitive advantage for their organization. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Introduction to Talent Management Self-paced pre-recorded learning content on this topic. Introduction to Talent Management Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Talent Acquisition Specialist HR Generalist Recruitment Coordinator Learning and Development Specialist Talent Management Coordinator HR Assistant Talent Acquisition Coordinator Human Capital Analyst HR Consultant Talent Acquisition Consultant Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

In the vast world of logistics and supply chain management, the Warehousing and Inventory Management Diploma bundle stands as a beacon of knowledge and expertise. Step into a realm where efficiency and organisation reign supreme and discover the secrets to optimising warehouse operations. In a world driven by commerce and e-commerce, effective warehouse management and inventory control are vital. This bundle empowers learners to streamline processes, minimise costs, and maximise productivity. And understanding supply chain management is essential for businesses looking to stay competitive in today's fast-paced market. Unlock the knowledge to optimise your supply chain, enhance customer satisfaction, and propel your business towards success. So, Don't wait, Unleash your potential and conquer the world of warehouse and inventory management today! This Warehousing And Inventory Management Diploma Bundle Consists of the following Premium courses: Course 01: Warehouse Course 02: Warehouse Safety Course 03: Inventory Management Training Course 04: Forklift Training - Online Course Course 05: Supply Chain Management Course 06: Operations Management Course 07: Logistic Management Course 08: Commercial Law Course 09: Ladder Safety Course 10: Manual Handling Level 2 Course 11: Emergency First Aid and Incident Management at Work Learning Outcomes: Understand the fundamentals of warehouse management and the various types of warehouses Learn about inventory management techniques and how to control the flow of processing Gain insight into supply chain management concepts and their impact on warehouse operations Understand the importance of warehouse safety and emergency incident management Learn about forklift training and how to operate a forklift safely and efficiently Develop knowledge of logistics and supply chain management and their role in warehouse operations Analyse warehouse costs and implement strategies to reduce them Develop skills in commercial law and how it applies to warehouse operations Course Curriculum: Warehouse Fundamentals Warehousing: Function, Benefits and Types of Warehousing Core Functions Of A Warehouse Management System Challenges Of Warehouse Management Technology In The Warehouse Supply Chain Management Concepts Warehouse Management Technologies to Adopt Order Picking in the Warehouse Managing Inventory Organize the Storage of Inventory Inventory Management Techniques Inventory Control Flow of Processing Logistics and Supply Chain In A Warehouse Inventory Classification In The Warehouse The Role Of Human Resource management In A Warehouse Safety Cost Management Improve Warehouse Efficiency and Reduce Costs CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Logistics and supply chain professionals looking to enhance their knowledge and skills Warehouse managers and supervisors looking to optimise warehouse operations Entrepreneurs looking to establish and operate their own warehouse facilities Anyone interested in a career in logistics and supply chain management Individuals looking to supplement their studies with useful knowledge of warehouse and inventory management Requirements This Warehousing And Inventory Management Diploma course has been designed to be fully compatible with tablets and smartphones. Career path Warehouse Manager - £25,000 to £60,000 per year Logistics Coordinator - £20,000 to £40,000 per year Supply Chain Analyst - £25,000 to £45,000 per year Operations Manager - £30,000 to £70,000 per year Forklift Operator - £18,000 to £28,000 per year Commercial Lawyer - £40,000 to £150,000 per year Inventory Control Manager - £30,000 to £60,000 per year Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - £10 You will get the Hard Copy certificate for the Warehouse course absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Lean Six Sigma Training Develop the skills and expertise of Six Sigma to set up a plier for a promising career. The Six Sigma 11-in-1 exclusive bundle will equip you with valuable Six Sigma skills and provide you with a valuable certificate to elevate your resume. Throughout the Six Sigma Training, it stresses how to improve your competency as a person in your profession while also outlining essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of Six Sigma, you can equip yourself with the essentials to keep you afloat in the competition. Along with this Six Sigma course, you will get 10 other premium courses. Also, you will get an Lean Six Sigma White Belt course original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This 11 in 1 Six Sigma Bundle Consists of the following Premium courses: Course 01: Lean Six Sigma White Belt course Course 02: Complete Lean Six Sigma Green Belt Course for Service Industry Course 03: Advance Lean Six Sigma Black Belt Course Course 04: Lean Six Sigma: Toolkit Course 05: Professional Lean Management: Service Industry Course 06: Project Management Essential Skills Level 3 Course 07: Supply Chain Management Course 08: Quality Management Course 09: RCA: Root Cause Analysis Course 10: Quality Tools and Problem-Solving Methods Course 11: Leadership & Management Diploma Key features: This Six Sigma bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Six Sigma is entirely online 24/7 Learner support So, enrol now In this Six Sigma Training to advance your career!! The Six Sigma bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Six Sigma expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Six Sigma from any place in your own time without travelling for classes. Curriculum of the Six Sigma Bundle Course 01: Lean Six Sigma White Belt course Unit 01: Introduction Unit 02: Quality Unit 03: Lean Unit 05: The customer Unit 06: The tools of quality Unit 07: Closeout How will I get my Six Sigma Certificate? After successfully completing the Lean Six Sigma course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously, it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Six Sigma bundle is for everyone. Requirements No Requirements to enrol this Six Sigma bundle Career path Having these Six Sigma expertise will increase the value in your CV and open you up to multiple job such as: Business Process Analyst Operating System Specialist Project Manager Quality Assurance Engineering Lean Six Sigma Manufacturing Managers Entrepreneurs Certificates Certificate of completion Digital certificate - Included Certificate of completion is included in course price. Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Lean Six Sigma White Belt course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Microsoft Office Specialist (MOS) is the world's most admired suite of business productivity tools. Its Word, Excel, and PowerPoint products set the standard for word processing, spreadsheet and data use and business presentations, respectively. Microsoft Office is required for about 40% of all job postings. This Microsoft Office Specialist (MOS) course teaches learners all they need to know about word, Excel, PowerPoint, Outlook, and Access. Business operations and office support positions are among the fastest-growing career areas in the current economy. From administrative assistants to specialists in business presentations, data analysis and document publishing, many of today's most promising career areas involve expertise in Microsoft Office products. Microsoft Office Specialist (MOS) is most valuable to students, teachers, schools and office systems. For students, the Microsoft Office Specialist (MOS) course boosts academic performance and preps them for college and careers. For educators, the Microsoft Office Specialist (MOS) course provides targeted training and support with every step of the way. For Administrators, the Microsoft Office Specialist (MOS) course improves institutional results. Courses are included in this Microsoft Office Specialist (MOS) Bundle: Course 01: MS Word Diploma Course 02: Microsoft Excel Level 3 Course 03: PowerPoint Diploma Course 04: Microsoft Teams Course 05: Financial Modeling Using Excel Course 06: Office Skills and Administration Management Diploma Course 07:Team Management Course 08: Touch Typing Essentials Course 09: Minute Taking Essentials Level 2 Course 10: Document Control Course 11: Data Protection and Data Security Level 2 Along with this Microsoft Office Specialist (MOS) course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. Key features of this Microsoft Office Specialist (MOS) course: This Microsoft Office Specialist (MOS) bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Microsoft Office Specialist (MOS) is entirely online 24/7 Learner support So, enrol now in this Microsoft Office Specialist (MOS) to advance your career! The Microsoft Office Specialist (MOS) bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Office Specialist (MOS) expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Microsoft Office Specialist (MOS) from any place in your own time without travelling for classes. How will I get my Microsoft Office Specialist (MOS) Certificate? After successfully completing the Microsoft Office Specialist (MOS) course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Microsoft Office Specialist (MOS) bundle. Requirements Our Microsoft Office Specialist (MOS) course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Microsoft Office Specialist (MOS) help qualify you for a variety of positions, including: Office Manager. Executive Assistant. Administrative Assistant. IT Support Technician. SharePoint Specialist. Database Specialist. Workbook Developer. Research Analyst. These jobs, on average, pay between £22,000 to £80,000. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (MS Word Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Our Computer Forensic Investigator (CFI) course is designed for both beginners and seasoned professionals, equipping you with the expertise to uncover and analyze electronic evidence, transforming you into a skilled Forensic Investigator. Our comprehensive curriculum begins with the basics of digital forensics, guiding you through the preparation phase of investigations and essential pre-investigation procedures. As you progress, you will master the art of data collection, handling both live and static data from various sources. Delve into the intricacies of different file systems and hard disk structures, uncovering crucial information hidden within them. Computer is an integral part of our curriculum, ensuring you are well-versed in the latest techniques and strategies. Join our Computer Forensic Investigator (CFI) course to access unparalleled content and expert guidance, ensuring you are well-prepared for the dynamic field of computer forensics. Elevate your skills, increase your job opportunities, and start a journey to become a top-notch Forensic Investigator. Don't miss this chance to advance your career-enroll in our Computer Forensic Investigator (CFI) course today. Key Features: CPD Certified Computer Forensic Investigator (CFI) course Free Certificate This Computer Forensic Investigator (CFI)course is Developed by Specialist Lifetime Access The Computer Forensic Investigator (CFI) course is meticulously divided into easy-to-follow sections, ensuring a seamless learning experience. Gain hands-on experience in tackling real-world challenges, including those encountered during Computer investigations. Learn advanced techniques to counter anti-forensics measures and implement effective countermeasures to safeguard your investigations. By the end of the Computer Forensic Investigator (CFI) course, you will possess the skills and confidence to conduct thorough digital investigations, addressing the complexities of cybercrime with proficiency. Start your journey to becoming a leading Forensic Investigator today. Enroll in our Computer Forensic Investigator (CFI) course now and transform your career in digital investigations. Why Choose Our Course? By choosing our Computer Forensic Investigator (CFI)course is a smart investment in your professional future. Our Computer Forensic Investigator (CFI) course is designed by industry professionals to stay ahead of trends, offering the most current and relevant content. This Computer Forensic Investigator (CFI) course provides you with the tools and knowledge needed to excel in today's competitive landscape. With flexible learning options and a commitment to your success, our Computer Forensic Investigator (CFI) course is the key to unlocking your potential and advancing your professional journey. Computer Forensic Investigator (CFI Course Curriculum Module 1: Forensics Introduction Forensics Introduction - Part 1 Forensics Introduction - Part 2 Forensics Introduction - Part 3 Module 2: Forensic Readiness Forensic Readiness - Part 1 Forensic Readiness - Part 2 Forensic Readiness - Part 3 Module 3: Before the Investigation Before the Investigation - Part 1 Before the Investigation - Part 2 Before the Investigation - Part 3 Module 4: Data Acquisition Data Acquisition - Part 1 Data Acquisition - Part 2 Data Acquisition - Part 3 Module 5: Live Acquisition Live Acquisition - Part 1 Live Acquisition - Part 2 Live Acquisition - Part 3 Module 6: Static Acquisition Static Acquisition - Part 1 Static Acquisition - Part 2 Static Acquisition - Part 3 Module 7: Techniques Techniques - Part 1 Techniques - Part 2 Techniques - Part 3 Module 8: Booting Booting - Part 1 Booting - Part 2 Booting - Part 3 Module 9: File Systems File Systems - Part 1 File Systems - Part 2 File Systems - Part 3 Module 10: Hard Disks Hard Disks - Part 1 Hard Disks - Part 2 Hard Disks - Part 3 Module 11: During the Investigation During the Investigation - Part 1 During the Investigation - Part 2 During the Investigation - Part 3 Module 12: After the Investigation After the Investigation - Part 1 After the Investigation - Part 2 After the Investigation - Part 3 Module 13: Anti-Forensics Anti-Forensics - Part 1 Anti-Forensics - Part 2 Anti-Forensics - Part 3 Module 14: Countermeasures Countermeasures - Part 1 Countermeasures - Part 2 Countermeasures - Part 3 Module 15: Specialized Topics FIBCT02B FIBCT02F FIBCT02L Learning Outcomes After completing this Computer Forensic Investigator (CFI) course you will be able to : Understand foundational concepts in Computer Forensic Investigator and digital evidence handling. Develop readiness strategies for effective Forensic Investigator tasks. Prepare systematically for Computer Forensic Investigator with the CFI approach. Master CFI techniques for data acquisition from various sources. Differentiate between live and static data acquisition for Computer Forensic Investigator cases. Counter anti-forensics measures and implement CFI countermeasures as a Forensic Investigator. Certification After completing this Computer Forensic Investigator (CFI) Course, you will get a free Certificate. Accreditation This Computer Forensic Investigator (CFI) course is fully accredited by the CPD QS , giving you updated knowledge and skills to help you improve your expertise and effectiveness in your line of work. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Computer Forensic Investigator (CFI) course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Computer Forensic Investigator (CFI). Moreover, this course is ideal for: IT professionals seeking Forensic Investigator skills in Computer. Cybersecurity enthusiasts aiming to specialise in CFI forensics. Law enforcement officers interested in Computer Forensic Investigator. Students pursuing a career as a Forensic Investigator. Individuals fascinated by Computer Forensic Investigator. Requirements There are no requirements needed to enrol into this Computer Forensic Investigator (CFI) course. We welcome individuals from all backgrounds and levels of experience to enrol into this Computer Forensic Investigator (CFI) course. Career path After finishing this Computer Forensic Investigator (CFI) course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Computer Forensic Investigator (CFI) are. Digital Forensics Analyst specialising Forensic Investigator in cybercrime units Information Security Analyst with CFI certification IT Forensic Consultant Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

A Business Continuity Plan (BCP) is a key organizational tool for ensuring operational continuity during emergencies, encompassing strategies for risk management and timely response. Several courses are available to equip individuals with the necessary skills for effective business continuity management. This course provides a comprehensive exploration of Business Continuity Planning (BCP), emphasizing its critical role in ensuring organizational resilience and preparedness for potential disruptions. Participants will gain valuable insights into the importance of BCP and its impact on organizational stability. The course covers key aspects, including risk assessment, recovery strategies, and communication protocols, enabling participants to develop a robust and effective business continuity plan. After the successful completion of this course, you will be able to: Understand the vital role of BCP in ensuring organizational resilience. Identify crucial elements such as risk assessment, recovery strategies, and communication protocols. Gain insights into the entire BCP process, from risk identification to plan development and testing. Recognize the concept of organizational vulnerability and its significance in assessing potential disruptions. Identify various factors exposing organizations to risks and threats. Analyze and assess business continuity vulnerabilities specific to the organization's operations and industry. Identify the most common risks faced by organizations and understand their potential consequences. Understand the broad impacts of vulnerabilities on business operations, reputation, and financial stability. Learn the importance of conducting a business impact analysis to prioritize critical functions during disruptions. Develop effective strategies for responding to risk vulnerabilities through proactive planning and preparation. Business Continuity Planning equips participants with the knowledge and skills to navigate the complexities of ensuring organizational resilience. From identifying vulnerabilities to developing robust plans, this course empowers individuals to play a key role in maintaining operational continuity, safeguarding reputation, and securing financial stability in the face of disruptions. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Business Continuity Planning Self-paced pre-recorded learning content on this topic. Business Continuity Planning Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Business Continuity Manager Disaster Recovery Specialist Crisis Management Coordinator Risk Assessment Analyst Emergency Response Planner Resilience Strategist Continuity Planning Consultant Crisis Communication Specialist Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Criminal Psychology Diploma In recent news, the importance of criminal psychology in solving complex criminal cases has once again come to the forefront. The remarkable contributions of criminal profilers and forensic psychologists in helping law enforcement agencies understand the minds of criminals have led to breakthroughs in criminal investigations. This highlights the significance of delving into the intriguing world of criminal psychology. Take the first step towards unravelling the mysteries of criminal psychology. Enrol in our Criminal Psychology Diploma bundle today and embark on an enlightening educational journey that will equip you with the knowledge to unravel the enigmatic workings of criminal behaviour. Your role in shaping a safer future awaits. This Criminal Psychology Diploma Bundle Consists of the following Premium courses: Course 01: Criminal Intelligence and Crime Analysis Complete Diploma Course 02: Criminology and Forensic Profiling - Level 4 Course 03: Online Training on Forensic Science Course 04: Accident Investigation Course 05: Interrogations And Confessions Psychology Course 06: Criminal Law Course 07: Addiction and Mental Health - Dual Diagnosis Course 08: Emotional Intelligence and Human Behaviour Course 09: English Law and Legal System Level 3 Course 10: Forensic Accounting Course Course 11: Financial Investigator Learning Outcomes of Criminal Psychology: Understanding of criminal psychology, research methods in crime analysis and decision-making in criminal intelligence analysis Knowledge of criminal law and the criminal justice system in England and Wales Proficiency in intelligence-led policing, counterterrorism, and criminal intelligence analysis Skills in forensic science and accident investigation Awareness of ethical considerations in criminal psychology research Benefits you'll get choosing Apex Learning for Criminal Psychology: One payment, but lifetime access to 11 CPD courses of this Criminal Psychology Bundle Certificates, student ID for the title (Criminal Psychology) course are included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Learn about Criminal Psychology at your ease - anytime, from anywhere Study the Criminal Psychology course from your computer, tablet or mobile device CPD accredited Criminal Psychology course - improve the chance of gaining professional skills So enrol now in this Criminal Psychology Diploma to advance your career! Criminal Psychology Diploma The Criminal Psychology Diploma bundle offers comprehensive training in criminal intelligence and analysis, criminology, forensic science, and criminal law. With courses covering topics such as addiction and mental health, dual diagnosis, emotional intelligence, and financial investigation, this bundle is an excellent choice for anyone interested in pursuing a career in criminal psychology. Criminal Intelligence and Crime Analysis Complete Diploma Curriculum Introduction to Intelligence Analysis Criminal Intelligence Analysis Criminal Intelligence Analyst - Skills and Competencies Understanding Criminal Psychology Research Methods in Crime Analysis Decision-Making in Criminal Intelligence Analysis Intelligence-Led Policing Counterterrorism and Criminal Intelligence Analysis Technology in Criminal Intelligence Analysis The Criminal Justice System in England and Wales CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Criminal Psychology Diploma course is perfect for anyone looking to pursue a career in criminal psychology or criminology, including law enforcement professionals, forensic scientists, social workers, and mental health practitioners. Our Criminal Psychology Diploma is also suitable for anyone interested in gaining a deeper understanding of criminal behaviour and its impact on society. Requirements Criminal Psychology Diploma This Criminal Psychology Diploma course has been designed to be fully compatible with tablets and smartphones. Career path Criminal Psychology Diploma Criminal Psychologist Criminologist Forensic Psychologist Police Officer Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - £10 You will get the Hard Copy certificate for the Criminal Intelligence and Crime Analysis Complete Diploma course absolutely Free! Other Hard Copy certificates are available for £10 each.