22257 Courses

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics 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. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to SQL Programming Basics (TTSQL002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This module will cover the function of a contract, the fundamental principles of contract formation, the termination or conclusion of a contract and the various contractual relationships in international trade.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Overview This comprehensive course on the Diploma in Medical Secretary will deepen your understanding of this topic.After successful completion of this course, you can acquire the required skills in this sector. This Diploma in Medical Secretary comes with accredited certification, 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? The Diploma in Medical Secretary program is open to all students, regardless of their prior qualifications or experience. This comprehensive course is specifically designed for individuals aspiring to excel in medical secretarial roles. Whether you have a background in healthcare, administration, or are entirely new to the field, this program is suitable for you.It equips students with the knowledge and skills necessary for success in healthcare administration and medical office management. Requirements Our Diploma in Medical Secretaryhas been designed to be fully compatible with tablets and smartphones. Here are some common requirements you may need: Computer, smartphone, or tablet with internet access. English language proficiency. Required software/tools. (if needed) Commitment to study and participate. There is no time limit for completing this course; it can be studied at your own pace. Career Path Popular Career Paths for a Diploma in Medical Secretary Course: Medical Secretary/Administrative Assistant: £25,000-£35,000 annually. Healthcare Office Manager: £30,000-£45,000 annually. Medical transcriptionist: £20,000-£35,000 annually. Medical Billing Specialist: £25,000-£40,000 annually. Medical Records Technician: £22,000-£35,000. Salary ranges can vary by location and experience. Course Curriculum 2 sections • 11 lectures • 02:53:00 total length •Module 01: Introduction to Medical Secretary: 00:16:00 •Module 2: Organise Schedules: 00:21:00 •Module 3: Maintaining Medical Records: 00:19:00 •Module 4: Effective Filing Systems in Medical Offices: 00:16:00 •Module 5: Confidentiality in a Medical Environment: 00:14:00 •Module 6: Controlling Stocks and Supplies: 00:09:00 •Module 7: Medical Jargon and Terminology: 00:25:00 •Module 8: Maintaining Workplace Safety: 00:20:00 •Module 9: Information Technology in Health Care: 00:14:00 •Module 10: Legal aspects and Ethics: 00:19:00 •Assignment - Diploma in Medical Secretary: 00:00:00

Overview Diabetes is becoming one of the most common medical conditions in the UK, and you can learn to understand and treat the condition.This comprehensive and enlightening Diabetes Care Diploma course thoroughly explains the causes and the impact of Type 2 Diabetes and associated medicinal procedures.The Diabetes Care Diploma course has been written in conjunction with industry professionals. It will deliver all the appropriate knowledge needed to tackle the many issues created by hypoglycaemia and hyperglycaemia in an individual. You will be taught everything about the required dieting, medicines, exercise, and lifestyle changes, along with tips for supervision and emotional support that can help fight the condition. Learning Outcomes Differentiate between Type 1 and Type 2 Diabetes and their causes. Understand the societal impact of diabetes in the UK. Identify various diabetes types and treatments. Manage hypoglycaemia and hyperglycaemia symptoms. Master diabetes terminology through a glossary. 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 Diabetes Care Diploma. It is available to all students, of all academic backgrounds. Requirements To enrol in the Diabetes Care Diploma course, you typically need to meet these requirements: Be 16 years of age or older. Have proficiency in the course's language (usually English). Access to a computer with internet and basic computer skills. Payment of tuition fees, if applicable. Healthcare background, while optional, can be beneficial. Career path Completing the Diabetes Care Diploma can lead to careers like: Diabetes Educator: £35,000-£45,000 per year. Clinical Nurse Specialist: £40,000-£57,000 per year. Registered Dietitian: £30,000-£50,000 per year. Diabetes Researcher: Salary varies by experience and location. These are approximate salary ranges, and actual earnings can vary based on factors such as location, experience, and specific job roles. Course Curriculum 2 sections • 13 lectures • 05:05:00 total length •Module 01: What is Diabetes: 00:20:00 •Module 02: The Diabetes Challenge: 00:30:00 •Module 03: The Cost of Diabetes in Social Care: 00:19:00 •Module 04: Type 1 Diabetes: 00:24:00 •Module 05: Type 2 Diabetes: 00:28:00 •Module 06: Type 2 Diabetes Treatments: 00:26:00 •Module 07: Prediabetes: 00:12:00 •Module 08: Gestational Diabetes: 00:23:00 •Module 09: Other Types of Diabetes: 00:15:00 •Module 10: Hypoglycaemia: 00:18:00 •Module 11: Hyperglycaemia and Hyperosmolar Hyperglycaemic State: 00:32:00 •Module 12: Glossary of Diabetes Terms: 00:58:00 •Assignment - Diabetes Care Diploma: 00:00:00

Overview This comprehensive course on Accounting and Finance will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Accounting and Finance comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enroll 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 Accounting and Finance. It is available to all students, of all academic backgrounds. Requirements Our Accounting and Finance 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 10 sections • 10 lectures • 03:39:00 total length •Introduction to Accounting and Finance: 00:22:00 •The Role of an Accountant: 00:23:00 •Accounting Process and Mechanics: 00:27:00 •Introduction to Financial Statements: 00:15:00 •Financial Statement Analysis: 00:30:00 •Budgeting and Budgetary Control: 00:19:00 •Financial Markets: 00:21:00 •Financial Risk Management: 00:25:00 •Investment Management: 00:19:00 •Auditing: 00:18:00

Gain a solid understanding of corporate finance with our Fundamentals Course. Learn essential concepts such as capital budgeting, risk management, and financial analysis. Master the principles that drive corporate decision-making and financial strategy. Whether you're a finance professional or a business enthusiast, this course provides the foundational knowledge needed for success in the corporate finance world."

Master the art of tax accounting with our comprehensive course. Grasp tax laws, prepare filings, & enhance financial strategy. Your route to becoming a tax guru awaits.

This course will introduce you to the international sales negotiation process, outline the importance of pre-negotiation research, and explain why concession planning is essential to international sales negotiations. This course will introduce you to the international sales negotiation process, outline the importance of pre-negotiation research, and explain why concession planning is essential to international sales negotiations. This course will then explore how to conduct pre-negotiations research by assessing the factors influencing buying decisions, determining the reason for a buyer’s interest in your product, and analyzing competitors to inform your concession planning. Finally, the course will outline how culture influences international sales negotiation, and why all of the above are key components when constructing an international sales negotiation plan.

Microsoft Office Foundation with Minute Taking Masterclass Unlock your potential in office management with the Microsoft Office 7 courses bundle Foundation with Minute Taking Masterclass. Sharpen your Microsoft Office skills with this bundle and become a minute-taking pro. Equip yourself with the Microsoft Office expertise every employer values. Learning Outcomes: Navigate the Excel Interface 2023 using Microsoft Office features. Apply formatting to modern documents through Microsoft Office tools. Develop presentations using Microsoft Office Power Point. Operate Microsoft Access & Database proficiently. Prepare for minute-taking using Microsoft Office utilities. Record meeting decisions and actions effectively. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Microsoft Office Foundation with Minute Taking Masterclass: Excel Interface 2023: Master the intricacies of Excel 2023 to elevate your Microsoft Office proficiency. Formatting Text of a Modern Document: Learn advanced text formatting techniques using Microsoft Office features. Setting up and Managing Presentations: Set up and manage compelling presentations leveraging Microsoft Office tools. Microsoft Access & Database: Gain hands-on experience in Microsoft Access & Database as part of your Microsoft Office skillset. Preparation for Minute Taking: Prepare for efficient minute-taking through the utilisation of Microsoft Office features. Minute Meeting, Decision and Action: Execute accurate minute meeting documentation, decision-making, and action-planning.