1062 Numbers courses

Overview This comprehensive course on HTML and CSS Coding: Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This HTML and CSS Coding: Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this HTML and CSS Coding: Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our HTML and CSS Coding: Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 127 lectures • 11:50:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:07:00 •How to Get Course requirements: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:02:00 •How to ask a Great Questions: 00:01:00 •FAQ's: 00:01:00 •Introduction: 00:05:00 •Choosing Code Editor: 00:06:00 •Installing Code Editor (Sublime Text): 00:04:00 •Overview of a Webpage: 00:05:00 •Full HTML Code Page: 00:07:00 •First Hello World! Webpage: 00:09:00 •Introduction: 00:03:00 •Heading: 00:09:00 •Paragraph: 00:08:00 •Formatting Text: 00:12:00 •List Items Unordered: 00:05:00 •List Items Ordered: 00:04:00 •Classes: 00:09:00 •ID's in CSS: 00:06:00 •Comments in HTML: 00:04:00 •Summary: 00:04:00 •Introduction: 00:02:00 •Images: 00:12:00 •Forms: 00:05:00 •Form Actions: 00:04:00 •Br tag: 00:03:00 •Marquee: 00:06:00 •Text area: 00:06:00 •Tables: 00:06:00 •Links: 00:07:00 •Navbar - Menu: 00:04:00 •HTML Entities: 00:05:00 •Div tag: 00:06:00 •Google Maps: 00:07:00 •Summary: 00:02:00 •Introduction: 00:02:00 •HTML5 Audio: 00:07:00 •HTML5 Video: 00:05:00 •Progress Bar: 00:04:00 •Drag and Drop: 00:18:00 •Canvas: 00:06:00 •I frames: 00:05:00 •Input Types: 00:04:00 •Input Attributes: 00:06:00 •YouTube Video Linking: 00:04:00 •Creating Responsive Page: 00:05:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Registration Form: 00:04:00 •Login Form: 00:04:00 •About Us Form: 00:02:00 •Contact Us Form: 00:10:00 •Footer Form: 00:03:00 •Integrate All Together: 00:07:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:02:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Challenge - HTML 5 Clock Face with Numbers: 00:05:00 •Project overview: 00:03:00 •Conclusion on Project: 00:01:00 •Summary: 00:02:00 •Introduction: 00:03:00 •CSS Syntax: 00:05:00 •Creating a first page with CSS Style: 00:13:00 •Inline CSS: 00:06:00 •Internal CSS: 00:05:00 •CSS External: 00:10:00 •CSS Classes: 00:09:00 •CSS IDs: 00:06:00 •Colors: 00:08:00 •Backgrounds: 00:04:00 •Floating: 00:09:00 •Positioning: 00:06:00 •Margins: 00:07:00 •Padding: 00:04:00 •Borders: 00:03:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Styling Text: 00:07:00 •Aligning Text: 00:04:00 •Styling Links: 00:10:00 •Font Family: 00:07:00 •Font Styles: 00:03:00 •Applying Google Fonts: 00:07:00 •Box Model: 00:09:00 •Icons: 00:09:00 •Tables: 00:16:00 •Navigation-Menu: 00:11:00 •Dropdowns: 00:15:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Advanced Selectors: 00:05:00 •Forms: 00:17:00 •Website Layout: 00:21:00 •Rounded Corners: 00:08:00 •Color Keywords: 00:06:00 •Animations: 00:08:00 •Pseudo Classes: 00:03:00 •Gradients: 00:03:00 •Shadows: 00:03:00 •Calculations: 00:05:00 •Creating Responsive Page: 00:06:00 •Summary: 00:02:00 •Introduction: 00:01:00 •Button Styles: 00:06:00 •Flexbox: 00:14:00 •CSS Grid: 00:15:00 •Pagination: 00:07:00 •Multiple Columns: 00:06:00 •Image Reflection: 00:03:00 •UI - UX Design: 00:09:00 •Social Media Icons: 00:08:00 •External CSS Style adding: 00:06:00 •Coding Exercise: 00:01:00 •Solution for Coding Exercise: 00:03:00 •Summary: 00:02:00 •Introduction: 00:01:00 •CSS Project Getting: 00:05:00 •CSS Project Overview: 00:08:00 •Summary: 00:01:00 •Introduction: 00:02:00 •Installing Free FTP Solution (FileZilla): 00:04:00 •Setting Up FTP (File Transfer Protocol): 00:03:00 •Publish Website to Hosting Server: 00:04:00 •Summary: 00:01:00

Course Summary Elevate Your Diagnostic Skills: Master Orthopedic Special Tests for Common MSK Conditions! Stop guessing and start confidently identifying musculoskeletal issues with this dynamic, practical CPD course. Led by experienced Register Osteopath Becky Tyler, you’ll go beyond basic assessment and gain mastery in performing and interpreting key orthopaedic special tests. This intensive course will equip you with the essential skills to accurately assess a wide range of commonly seen conditions, including Tennis Elbow, Plantar Fasciitis, Rotator Cuff Tears, and more. This is a critical CPD for any manual therapist wanting to refine their diagnostic accuracy and provide more effective treatment. Course Content Comprehensive Review of Common MSK Conditions: An in-depth overview of prevalent musculoskeletal conditions encountered in clinical practice Mastering Upper Limb Special Tests: Practical, hands-on instruction and practice in performing and interpreting key special tests for the shoulder (e.g., Empty Can, Hawkins-Kennedy, Neer’s), elbow (e.g., Jobe’s), wrist and hand (e.g., Phalen’s, Tinel’s, Finkelstein’s), and cervical spine (e.g., Spurling’s) etc. Emphasis will be placed on proper technique, sensitivity, specificity, and clinical relevance. Mastering Lower Limb and Lumbar Spine Special Tests:Practical, hands-on instruction and practice in performing and interpreting key special tests for the lumbar spine (e.g., Straight Leg Raise, Slump Test, Quadrant Test), sacroiliac joint (e.g., FABER), hip (e.g., Trendelenburg, Thomas), knee (e.g., McMurray’s, LCL), ankle and foot (e.g., Anterior Drawer, Windlass) etc. Emphasis will be placed on proper technique, sensitivity, specificity, and clinical relevance. Clinical Reasoning and Interpretation: Developing critical thinking skills to integrate special test findings with patient history and other assessment components to arrive at accurate diagnoses and inform treatment plans. Case studies and real-world scenarios will be utilised. Practical Application and Refinement: Ample opportunity for hands-on practice in pairs, receiving feedback on technique and interpretation to build confidence and proficiency in performing special tests. Understanding Sensitivity, Specificity, and Clinical Relevance:Gaining a deeper understanding of the diagnostic accuracy of various special tests and how to apply this knowledge in clinical decision-making. We only have small numbers on all our courses ensuring you have plenty of time with Becky to really develop your technique and feel confident in offering this technique to your patients. We pride ourselves on always being there ready to help and offer advise not only during the course but after as well, all you need to do is ask! Who can attend Physiotherapists Osteopaths Chiropractors Acupuncturists Manual Therapists Sports Therapists Level 4 Sports Massage Therapists We may ask you to provide a copy of your qualification. Assessment Observation during the course day

Join local artist Lou Davis for a relaxing watercolour painting session at The Arienas Collective in Edinburgh's beautiful Georgian New Town City Centre

Learning Outcomes Get an introduction to Python programming Know how to do conditional branching with Python Deepen your knowledge of importing external/internal libraries in Python Learn about project rock, paper and scissors as well as strings operation, time and date in Python Acquire more knowledge about data storage structures, tuples, lists and dictionary Enhance your understanding of import tricks, import operating systems and platforms and exception handling in Python Learn how to instal Packages and Scheduling in Python Description Python is a highly multi-purposeful still easy-to-understand programming language, which is why it is more adaptable all over the world. Whether to make a web application in data science, software engineering, mobile app development, or artificial intelligence - every industry uses Python to accomplish its work. Therefore, if you are planning to pursue a career in these sectors, develop your Python skills with the Diploma In Python Programming course. We made this course with an aim of enhancing your programming language skills in Python and making you job ready. Therefore, this course includes some easy-to-digest modules on topics such as - conditional branching with Python, writing user functions in Python, file handling, reading and writing using Python and many more. Moreover, we will introduce you to the procedure of data storage structures, tuples, lists and dictionaries through Python. Further topics will be discussed in the modules for which you need to enrol in our comprehensive course. So, join this course now to acquire the exclusive knowledge of Python and a CPD certificate of achievement after completing this course. Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment After completing this course, you will be provided with some assessment questions. To pass that assessment you need to score at least 60%. Our experts will check your assessment and give you feedback accordingly. Career path After finishing this course you will get the expertise to aim for a career in the following positions: Web Developer Software Engineer Data Scientist Machine Learning Engineer Data Analyst Course Content Unit 01: Introduction to Python Programming Module 01: Course Introduction 00:02:00 Unit 02: Getting Started with Python Module 01: Software Installation 00:02:00 Module 02: Hello World Program 00:06:00 Module 03: Input and Output 00:07:00 Module 04: Calculating Average of 5 Numbers 00:03:00 Unit 03: Conditional Branching with Python Module 01: If Loop In Python 00:06:00 Module 02: Program Using If Else part 1 00:03:00 Module 03: Program Using If Else part 2 00:08:00 Module 04: Program for Calculator 00:02:00 Module 05: Program Using For Loop 00:08:00 Module 06: For Table 00:05:00 Module 07: For loop and Mathematical Operator in Python 00:04:00 Module 08: Factorial of Number Using Python 00:06:00 Module 09: Program Using While 00:05:00 Module 10: While Loop Example 00:07:00 Module 11: Tasks for Practice 00:02:00 Unit 04: Importing external/internal library in python Module 01: Importing Library in Python 00:07:00 Unit 05: Project Rock Paper and Scissors Module 01: Rock Paper and Scissor Game 00:06:00 Unit 06: Strings Operation in Python Module 01: Program Using String part 1 00:05:00 Module 02: Program using String 2 00:06:00 Module 03: Program Using String 3 00:06:00 Module 04: Program Using String part 4 00:03:00 Unit 07: Date and time in Python Module 01: Use of Date and Time part 1 00:05:00 Module 02: Use of Date and Time part 2 00:05:00 Unit 08: File Handling, read and write using Python Module 01: File Handling Part 1 00:08:00 Module 02: File Handling Part 2 00:07:00 Unit 09: Data Storage Structures, Tuple, List and Dictionary Module 01: Tuple in Python Part 1 00:10:00 Module 02: Tuple in Python Part 2 00:07:00 Module 03: Using Lists part 1 00:07:00 Module 04: Using List part 2 00:12:00 Module 05: Using Lists part 3 mm 00:06:00 Module 06: Using Lists part 4 00:08:00 Module 07: Using Lists part 5 00:02:00 Module 08: Use of Dictionary Part 1 00:04:00 Module 09: Use of Dictionary Part 2 00:05:00 Module 10: Use of Dictionary Part 3 00:08:00 Module 11: Use of Dictionary Part 4 00:07:00 Unit 10: Writing user functions in Python Module 01: Function in Python Part 1 00:06:00 Module 02: Function in Python Part 2 00:05:00 Module 03: Function in Python Part 3 00:04:00 Module 04: Function in Python Part 4 00:07:00 Module 05: Function in Python Part 5 00:08:00 Unit 11: Sending mail Module 01: Send Email 00:09:00 Unit 12: Import Tricks in Python Module 01: Import Study part 1 00:07:00 Module 02: Import Study part 2 00:03:00 Unit 13: Import Operating System and Platform Module 01: Importing OS 00:06:00 Module 02: Import Platform 00:05:00 Unit 14: Exceptions handling in python Module 01: Exception in Python part 1 00:11:00 Module 02: Exception in Python part 2 00:07:00 Module 03: Exception in Python part 3 00:05:00 Unit 15: Installing Packages and Scheduling In Python Module 01: Installing Packages using built in package manager 00:08:00 Module 02: Scheduler in Python 00:05:00 Unit 16: Data Base In Python using sqlite Module 01: Data Base 1 00:08:00 Module 02: Data Base 2 00:09:00 Module 03: Data Base 3 00:08:00 Module 04: Data base 4 00:07:00 Module 05: Data Base 5 00:06:00 Unit 17: Running Program from Command Prompt and jupyter Notebook Module 01: IDE_1 00:05:00 Module 02: IDE_2 00:07:00 Unit 18: Conclusion Module 01: Conclusion 00:02:00 Resources Resources - Diploma in Python Programming 00:00:00 Recommended Materials Workbook - Diploma in Python Programming 00:00:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00

You don’t need a pinstripe suit to make sense of the numbers. The Investment Banking Mini Bundle focuses on core concepts in banking, finance, business analysis, financial analysis, and the Sage software suite—all explained without the need for financial jargon translations. If your goal is clarity, this bundle keeps it simple. Whether you're peeking into spreadsheets or analysing business health, you’ll move from finance basics to structured analysis with calm precision. Think of it as your numbers-first toolkit—minus the financial drama. Learning Outcomes: Understand core banking structures and financial institution processes. Learn essential finance principles relevant to financial operations. Explore techniques used in financial analysis and review. Study business analysis methods used for internal decisions. Use Sage for financial tracking and basic reporting operations. Connect finance concepts across banking and business analysis. Who is this Course For: Aspiring finance professionals learning early-stage industry concepts. Students preparing for roles in banking or business finance. Business support staff managing data and reporting operations. Administrative workers using Sage for accounts-based tasks. Analysts seeking to develop structured financial thinking. Small business staff working across finance and planning. Beginners exploring banking without the financial jargon flood. Those supporting decision-makers with financial reports or analysis. Career Path: Investment Banking Assistant – £34,000/year Financial Analyst (Junior) – £35,000/year Business Analyst (Entry-Level) – £33,000/year Sage Accounts Administrator – £27,000/year Banking Operations Coordinator – £30,500/year Finance Assistant (Corporate Sector) – £29,000/year

What you will learn from this course? Gain comprehensive knowledge about business administration and business management Understand the core competencies and principles of business administration and business management Explore the various areas of business administration and business management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert business manager or entrepreneur Course Highlights Course Type: Self-paced online course Duration: 2 hours 10 minutes Tutor Support: Full tutor support is included Customer Support: 24/7 customer support is available Small Business Management and Fundamentals Crash Course Master the skills you need to propel your career forward in business administration and business management. This course will equip you with the essential knowledge and skillset that will make you a confident business manager or entrepreneur and take your career to the next level. This comprehensive small business management and fundamentals crash course course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this small business management and fundamentals crash course course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective business administration and business management practice and equip you with the essential skills, confidence and competence to assist you in the business administration and business management industry. You'll gain a solid understanding of the core competencies required to drive a successful career in business administration and business management. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for business manager or entrepreneur or for people who are aspiring to specialise in business administration and business management. Enrol in this small business management and fundamentals crash course course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive small business management and fundamentals crash course course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this business administration and business management can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This small business management and fundamentals crash course course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This small business management and fundamentals crash course course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This small business management and fundamentals crash course course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Study Plex Subscription Study plex also provides a subscription option that allows you unlimited access to more than 700+ CPD courses for learning. You only need to spend £79 to take advantage of this fantastic offer, and you'll get an unlimited subscription for a full year. Additionally, you can cancel your membership from your account at any time by getting in touch with our friendly and devoted customer care team. Visit our subscriptions page for more details if you're interested. Why you should train with Study Plex? At Study Plex, you will have the chance to build social, technical and personal skills through a combination of extensive subjects tailored according to your interest. Along with receiving comprehensive knowledge and transferable skills, there are even more reasons o be involved with us, which include: Incredible Customer Support: We offer active customer service in the form of live chat, which you can access 24/7 Expert Tutor Support: You'll have access to our devoted and dedicated tutor support with all of our courses whenever you need it. Price Justified by Quality: We ensure that you will have the best experience possible for the price you are paying for the course. Money-back Guarantee: We provide a money-back guarantee if you are not satisfied with the course's quality. There is a 14-day time limit on this option (according to the terms and conditions). Instalment Facility: If your course costs more than £50, you can pay in three instalments using the instalment option. Satisfaction Guarantee: Our courses are designed to meet your demands and expectations by all means. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Plan Your Business Defining Your Personal Goals 00:07:00 Find Your Customers 00:12:00 Research Your business Analyze Your Market 00:11:00 Finding Your Suppliers 00:09:00 Planning For Your Operational Process 00:07:00 Execute Your Business Building Your Team 00:08:00 Know Your Numbers 00:17:00 Planning For Marketing, Positioning And Sales 00:25:00 Bonus: Express your Business Design Your Visuals 00:07:00 Capture Your Products Photography 00:03:00 Congrats, You Made It To The End 00:01:00 Supplementary Resources Supplementary Resources - Small Business Fundamentals Crash Course 00:00:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Strengthen your command over C language

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00

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

Create a vision for your life in 2025 with writer, artist and mentor Eugenia Rosa exclusively at The Arienas Collective in Edinburgh City Centre