3190 Courses

The Level 2 Intelligence Analyst Certification course provides a comprehensive understanding of intelligence analysis, covering the development of intelligence, the intelligence cycle, critical thinking, analysis process, best practices, legal issues, ethics, and the role and responsibilities of an intelligence analyst. Learning Outcomes: Define intelligence analysis and understand its significance in various contexts. Gain insights into the development of intelligence analysis over time and its evolution. Comprehend the intelligence cycle and its essential phases for effective analysis. Apply critical thinking skills to structure and analyze intelligence data efficiently. Learn about best practices in intelligence analysis to ensure accuracy and relevance. Understand legal and ethical considerations in intelligence work to maintain integrity. Identify the roles, responsibilities, and functions of an intelligence analyst within an organization or agency. Complete an assignment as an intelligence analyst to demonstrate practical skills and knowledge. Why buy this Level 2 Intelligence Analyst Certification? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Level 2 Intelligence Analyst Certification there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Level 2 Intelligence Analyst Certification is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Level 2 Intelligence Analyst Certification does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Level 2 Intelligence Analyst Certification was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Level 2 Intelligence Analyst Certification is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Defining Intelligence Analysis Defining Intelligence Analysis 00:46:00 Module 02: Development of Intelligence Analysis Development of Intelligence Analysis 00:26:00 Module 03: The Intelligence Cycle The Intelligence Cycle 00:35:00 Module 04: Critical Thinking and Structuring Critical Thinking and Structuring 00:39:00 Module 05: Analysis Process and Best Practice Intelligence and National Security 00:42:00 Module 06: Intelligence and National Security Legal Issues and Ethics 00:45:00 Module 07: Legal Issues and Ethics Your Role, Responsibilities, and Functions as an Analyst 01:00:00 Module 08: Your Role, Responsibilities, and Functions as an Analyst Analysis Process and Best Practice 00:45:00 Assignment Assignment - Level 2 Intelligence Analyst Certification 00:00:00

Are you someone wishing to learn the skills to analyze data professionally using Power BI? Do you want to learn to create impressive reports? Then this is the right course for you! Learn the complete workflow in Power BI from A-to-Z and advanced analytics with DAX-calculated columns and measures, forecasting, and advanced analytics.

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

Small Animal Abdominal Ultrasound An online, on demand course

Why AGRC’s Certificate in Risk Management? Here are the main benefits delivered by our Certificate in Risk Management programme: Comprehensive knowledge of risk management, including in-depth coverage of the risk management frameworks, risk assessment, risk treatment, and the reporting, monitoring, recording, review and communication of risk. Its heavy reliance on practical case studies offers you a practical and hands-on approach to learning about risk management and what is required to curtail or prevent risk from impacting your organisation. The necessary tools, information, practices, and skills to transform you into an in-demand professional for financial institutions and other organizations looking to strengthen their departments dedicated to risk management and risk assessment. Year-round registration with the option to complete the 30-hour online interactive Certificate in Risk Management programme at your own pace and schedule within 3 months, plus two attempts to pass the one-hour final exam consisting of 50 multiple choice questions. Free one-year membership to AGRC, where you can exchange knowledge and share experiences with GRC professionals worldwide. Use of the AGRC’s professional designation as a compliance professional. The AGRC Certificate in Risk Management Curriculum AGRC’s Certificate in Risk Management covers the following specific topics: The main Principles and Definitions of Risk Management ISO 31000 Risk Management framework and processes The Risk and Opportunity Matrix Costs and Benefits of Risk Management Uncertainty in Risk Management and its dimensions The Limitations of Risk Management Developing a Risk-Aware Culture in organisations The Aims of Risk Management in organisations Influences on Risk Culture Historical Foundations of Risk Management The COSO ERM Integrated Framework And plenty more! Expected Learning Outcomes Here’s what you can expect to achieve following the completion of this Certificate in Risk Management: Understand what involves risk management and risk assessment Define, implement and manage appropriate risk management controls for your company Gain a solid understanding of the historical foundations of risk management and the different frameworks involved Understand risk culture and how to build a risk-aware organisation Develop an efficient and comprehensive risk management programme and policy for your company Learn how to use the risk and opportunity matrix Target Audience AGRC’s programme has been designed for professionals looking to build a career in risk management, either at an organizational or governmental level. This might include staff working in or aspiring to work in risk management, new graduates from any discipline, employees involved in risk, financial crime prevention, AML and/or compliance functions, or those wanting to build a career in risk management in the fields of Banking, Insurance, Asset Management, Funds, and other financial services.

Accelerate Your Web Developer Career: Fast-Track Program with Exams, TOTUM Card & 5-Year Support. Enrol Today! Study methodOnline Duration9 months · Self-paced Access to content5 years CertificationsCompTIA IT Fundamentals CertificationPearson IT Specialist HTML5 Application DevelopmentPearson IT Specialist HTML and CSSPearson IT Specialist PythonPearson IT Specialist AI (Artificial Intelligence)Pearson IT Specialist JavaScriptAdobe Certified Professional PhotoshopAdobe Certified Professional IllustratorAdobe Certified Professional Premier Pro Additional info Exam(s) / assessment(s) is included in price Tutor is available to students TOTUM card included in price Job guarantee programme is included in this course Overview Learn the most in-demand digital skills in the world today with the Nuyew Tech Academy If you have an eye for detail and enjoy being creative, this could be the career for you. Web professionals plan create and code web pages that meet a specification for a client or an employer. You may be involved with the technical and graphical aspects of the website, playing a vital part of the overall look and feel as well as determining the logic of how the website functions to meet the websites intended goal. Certifications CompTIA IT Fundamentals Certification Awarded by CompTIA Pearson IT Specialist HTML5 Application Development Pearson IT Specialist HTML and CSS Pearson IT Specialist Python Pearson IT Specialist AI (Artificial Intelligence) Pearson IT Specialist JavaScript Awarded by Pearson Adobe Certified Professional Photoshop Adobe Certified Professional Illustrator Adobe Certified Professional Premier Pro Awarded by Adobe Description With a national shortage of Web Developers, starting salaries of up to £25,000 per annum (average UK Salary £37,500) and amazing future employed and self-employed career prospects, take the next step today with our Fast Track Web DeveloperProgramme. What you can expect from our Fast Track Programme: World Class Education Energetic and unlimited 24/7 Student Support Real, tangible Career Outcomes 5 Years Career Support and Course Access What our programme includes: Foundation Awards CompTIA ITF+ (IT Fundamentals) Industry Recognised Qualifications Pearson IT Specialist HTML5 Application Development Pearson IT Specialist HTML and CSS Pearson IT Specialist JavaScript Pearson IT Specialist Python Pearson IT Specialist AI (Artificial Intelligence) Adobe Certified Professional Photoshop Adobe Certified Professional Illustrator Adobe Certified Professional Premier PRO Exams Includes all Exams and Unlimited Re-Sits 5 Years Career Support Guarantee As part of our unique Support Guarantee, our Career Support Team will assist you with: CV writing Expert careers advice Interview preparation Identifying and applying for the best opportunities in your area As a student in the Nuyew Tech Academy you will also be given exclusive access to our Career Skills Academy which includes advanced courses on Employability, CV Preparation, Interview Skills and Technique and everything else you need to get ready for your new Career. Who is this course for? This course is open to anyone interested in pursuing a Career in Web Development. Our Foundation Level provides the flexibility for us to accommodate students with any level of previous knowledge and experience. Requirements This course is open to all and has no pre-requisites All you need is a passion for technology and a strong desire to succeed. Career path Our programme is designed to enable you to achieve an Entry Level/Helpdesk role during training (£18k-£24K) ensuring that you also have the vital work experience required to enter the Tech Industry at a higher level (Av Salary £37.5K). Our Career Support Guarantee gives you exclusive access to our dedicated Career Support Team and Advanced Career Skills Academy for 5 Years following Graduation.

Description MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields. The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Excel 2016 Introduction is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our MS Excel 2016 Introduction 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Getting Started with Excel What is Excel 00:02:00 Opening Excel 00:04:00 Navigating the Excel User Interface 00:07:00 Using the Excel Ribbon 00:03:00 Understanding Excel Work Components 00:04:00 Using the Backstage View 00:03:00 Creating Workbooks and Using Templates Creating a New Workbook 00:03:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using Convert and Checking Compatiblity 00:02:00 Entering Data Navigating a Worksheet by Mouse or Keyboard 00:05:00 Excel Data Types 00:03:00 Cell and Range Addressing 00:02:00 Data Selection Techniques 00:05:00 Common Excel Commands 00:07:00 Using the Autofill Handle 00:03:00 Excel Formula Basics Data What are Formulas and Functions 00:02:00 Components of a Formula 00:06:00 Calculation Hierarchy Using the Order of Operations_Revise 00:02:00 Creating Basic Formulas 00:08:00 Working with Basic Functions and Autosum 00:04:00 Using Cell References 00:04:00 Using the Quick Analysis Tool 00:01:00 Adjusting a Worksheet Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:03:00 Formatting and Aligning Worksheet Data Formatting and Aligning Data 00:06:00 Merging Data 00:03:00 Wrapping Text Orientation 00:02:00 Formatting Numbers 00:03:00 Using Borders and Shading 00:03:00 Using the Format Painter 00:01:00 Removing Formatting Quickly 00:01:00 Using Cell Styles and Themes Understanding Cell Styles 00:02:00 Applying Cell Styles 00:04:00 Applying Themes 00:03:00 Inserting Objects and Graphics Inserting and Formatting Images 00:03:00 Inserting and Formatting Shapes 00:04:00 Inserting and Formatting Smart Art 00:04:00 Inserting Screenshots 00:02:00 Inserting Hyperlinks 00:03:00 Inserting Symbols and Equations 00:03:00 Inserting Word Art Or Text Boxes 00:04:00 Inserting Other Excel Objects 00:04:00 Arranging Objects 00:04:00 Proofing a Workbook Using Find and Replace 00:04:00 Finding and Replacing Formatting 00:01:00 Using Got to and Go to Special 00:02:00 Using the Spell Checker 00:03:00 Using the Theasaurus and Translation Feature 00:03:00 Printing an Excel File Printing and Previewing Excel Files 00:03:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:04:00 Formatting a Page with the Page Layout Tab 00:03:00 Printing Titles and Specific Worksheet Areas 00:05:00 Exporting to PDF and XPs 00:02:00 Managing Worksheets Renaming and Coloring Worksheet Tabs 00:03:00 Adding, Deleting, and Navigating Worksheets 00:03:00 Moving and Copying Worksheets 00:04:00 Hiding and Unhiding Worksheets 00:02:00 Navigating and Viewing Excel Files Viewing Workbooks 00:03:00 Using Zoom Tools 00:02:00 Configure Sheet Options 00:02:00 Using Freeze Panes and Split Commands 00:05:00 Working with Window Commands 00:04:00 Adjusting Workbook Properties 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview From automation to complex data analysis, Python is used in a wide range of tasks. Thus, to become a high-demand professional in the IT industry, you must build a solid foundation in this programming language. Our Python for Beginners is the perfect place to start enhancing your knowledge and skills in this area. Through the comprehensive course, you will get a primary understanding of Python. The informative modules will help you understand the data types and data structure. You will receive detailed lessons on control flow and operators. After that, the modules will equate you to the basics of Python arrays, iterators and generators. Finally, you will get a clear understanding of the functions and file manipulation. After the completion of the course, you will receive a certificate of achievement. This certificate will help you elevate your resume. Course Preview Learning Outcomes Introduce yourself to the basics of Python Familiarise yourself with the data types and operators Enhance your understanding of data structures and control flow Explore the vital areas of Python arrays, iterators and generators Develop a clear understanding of functions and file manipulation Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Python Who Should Take This Python for Beginners Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Python for Beginners is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Python for Beginners will equip you with effective skills and abilities and help you explore career paths such as  Web Developer Data Analyst Software Developer Game Developer Course Introduction Python for Beginners Introduction 00:01:00 Module 01: Getting Started with Python Why Learn Coding 00:05:00 Why Learn Python 00:04:00 Gearing Up Linux Machine For Python Programming 00:15:00 Gearing Up Windows For Python 00:13:00 Integrate Python And Git Bash With Vscode 00:03:00 Gearing Up The Macos For Python Programming 00:06:00 Installing Jupyter Notebook In Windows 00:06:00 Hello World In Jupyter Notebook 00:11:00 Module 02: Data Types and Operators Arithmetic Operators 00:14:00 Order Of Evaluation 00:09:00 Variable And Assignment Operators 00:12:00 Correct Variable Names 00:08:00 Integer Float And Complex Numbers In Python 00:11:00 Boolean Comparison Operator And Logical Operator 00:20:00 Strings In Python 00:07:00 Type And Type Casting 00:10:00 String Methods In Python 00:09:00 Taking Input From User 00:05:00 Exercise 1 00:09:00 Module 03: Data Structures Lists In Python 00:16:00 Necessitites In List 00:14:00 List Methods 00:19:00 Tuples In Python 00:14:00 Sets In Python 00:14:00 Dictionary, Mutable, Accessing Items 00:08:00 Dublicates, Constructor And Data Types In Dictionary 00:06:00 Access And Add Items In Dictionaries 00:06:00 Nested Dictionaries And Dictionary Methods 00:10:00 Exercise 2 00:12:00 Module 04: Control Flow Introduction 00:01:00 Conditional Statements 00:10:00 Short Hand If Else 00:10:00 Nested If 00:05:00 For Loops 00:13:00 While Loops In Python 00:07:00 While Vs For Loop 00:07:00 Break Continue Statment 00:07:00 Try And Except 00:07:00 Exercise 3 00:07:00 Module 05: Functions Intro To Functions 00:05:00 Arguments, Parameters And Multiple Arguments 00:09:00 Arbitrary Arguments, Keyword Arguments, Arbitrary Keyword Arguments 00:10:00 Default Parameter Value And Passing A List As Parameters 00:09:00 Return Values And Pass Statements 00:06:00 Exercise 4 00:09:00 Module 06: Python Arrays, Iterators and Generators Array, Length Of Array, Accessing Elements Of Array 00:10:00 Adding, Removing Elements In Array, Array Methods 00:12:00 Iterator In Python 00:14:00 Generators In Python 00:07:00 Exercise 5 00:07:00 Module 07: File Manipulation File Hancdling And Syntax 00:05:00 Reading The File, Line Extraction And Parsing 00:11:00 Appending And Writing The Files In Python 00:06:00 Create And Delete A File 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This SQL course will unlock your full potential and will show you how to excel in a career in SQL. So upskill now and reach your full potential. Everything you need to get started in SQL is available in this course. Learning and progressing are the hallmarks of personal development. This SQL will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your SQL skills to help you advance your career. Acquire a comprehensive understanding of various SQL topics and tips from industry experts. Learn in-demand SQL skills that are in high demand among UK employers, which will help you to kickstart your career. This SQL course covers everything you must know to stand against the tough competition in the SQL field.  The future is truly yours to seize with this SQL. Enrol today and complete the course to achieve a SQL certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the SQL course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the SQL course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the SQL course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This SQL is suitable for anyone aspiring to start a career in SQL; even if you are new to this and have no prior knowledge on SQL, this course is going to be very easy for you to understand.  And if you are already working in the SQL field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this SQL course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This SQL course has no prerequisite.  You don't need any educational qualification or experience to enrol in the SQL course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online SQL course. Course Curriculum Unit 01: Course and Instructor Introduction Course and Instructor Introduction 00:05:00 Unit 02: Laying out the foundation - Overview & Installation Pre-requisites & Different Editions of SQL Server 00:06:00 Downloading Express Edition & sample database 00:03:00 Installing the downloads & Configuration 00:19:00 The sa Login 00:04:00 Wrap up - what we went over! 00:01:00 Unit 03: Core concepts - Taming the RDBMS beast! What is RDBMS? 00:12:00 Where does SQL Server fit in? 00:02:00 Basic database objects 00:16:00 Different Files that got installed - MDF & LDF 00:03:00 Wrap up - what we went over! 00:01:00 Unit 04: Tool of the trade - SQL Server Management Studio Getting started with SSMS 00:07:00 Getting around Object Explorer 00:05:00 Query Window 00:06:00 Pre-built DB - system database 00:04:00 Wrap up - what we went over! 00:01:00 Unit 05: Simple SELECT Bare Minimum: SELECTING a literal 00:05:00 Retrieving / querying data from a table - using FROM clause 00:06:00 Playing with Column Names 00:03:00 Rearranging columns to your liking 00:01:00 Wrap up - what we went over! 00:01:00 Unit 06: Filtering out unwanted data Narrowing down and ordering result set - WHERE and ORDER clause 00:17:00 Narrowing down result set - BETWEEN / NOT BETWEEN 00:09:00 Narrowing down result set - IN and NOT IN operator 00:05:00 Narrowing down result set - Pattern Matching: LIKE and Wildcards 00:11:00 Wrap up - what we went over! 00:01:00 Unit 07: Expressions and Functions Dealing with nothing: NULL 00:06:00 Working with strings: Concatenation and other string functions 00:15:00 Working with dates: Date Functions 00:07:00 Some System Functions 00:05:00 Wrap up - what we went over! 00:02:00 Unit 08: Getting data out of multiple tables Joining multiple tables - INNER JOIN 00:09:00 Join types - OUTER JOIN - LEFT / RIGHT / FULL 00:08:00 Join types - CROSS JOIN 00:02:00 Holy UNION! 00:03:00 Subqueries 00:04:00 Wrap up - what we went over! 00:02:00 Unit 09: Summarizing and Grouping data DISTINCT and ALL Predicates 00:02:00 Aggregate Functions 00:03:00 GROUP BY clause / HAVING clause 00:04:00 WHERE and ORDER BY in aggregate queries 00:04:00 Wrap up - what we went over! 00:01:00 Unit 10: Bonus Bonus_Section 00:01:00

Equip yourself with the knowledge and skills to develop, utilise, and review financial models effectively, ensuring they can be used to support strategic decision-making and financial analysis with confidence. What is Inside the manual? M&A Strategies This section introduces the core concepts of M&A, explaining the goals of acquisitions, including the pursuit of synergies through scale, scope, and diversification. It also covers acquisition and disposal strategies, providing a foundation for understanding the strategic rationale behind M&As. Acquiring Private Companies Offering a process overview from the early stages through to post-completion, this section is crucial for understanding the nuances involved in private company acquisitions. It includes detailed steps such as target analysis, due diligence, and the finalization of sale and purchase agreements. Selling Private Companies This part parallels the acquisition process but from the perspective of selling private companies. It details disposal strategies, preparation for sale, and different approaches to achieving a sale, such as demergers, auctions, and the 'rifleshot' approach.  Public Company Takeovers Focusing on the regulatory environment, the takeover process (both friendly and hostile), and defence tactics, this section is key for anyone involved in or studying public company takeovers.  Successful M&A Concluding with what determines success and failure in acquisitions, this section emphasizes the importance of planning, implementation, and integration.  Financial Modelling The guide covers everything from basic model structure, naming conventions, and sheet consistency, to more advanced topics like data consolidation, the use of arrays, and handling date series. It also delves into the nuances of Excel, such as relative vs. absolute references, using logical functions, and managing volatile functions.