26305 Courses delivered Online

Duration 4 Days 24 CPD hours This course is intended for This course is geared for experienced skilled Java developers, software developers, data scientists, machine learning experts or others who wish to transtion their coding skills to Scala, learning how to code in Scala and apply it in a practical way. This is not a basic class. Overview Working in a hands-on learning environment led by our expert instructor you'll: Get comfortable with Scala's core principles and unique features, helping you navigate the language confidently and boosting your programming skills. Discover the power of functional programming and learn techniques that will make your code more efficient, maintainable, and enjoyable to write. Become proficient in creating dynamic web applications using the Play Framework, and easily connect to databases with the user-friendly Slick library. Master concurrency programming with Akka, empowering you to build scalable and fault-tolerant applications that excel in performance. Enhance your testing skills using ScalaTest and ScalaCheck, ensuring the reliability and quality of your Scala applications, while having fun in the process. Explore the fascinating world of generative AI and GPT technologies, and learn how to integrate them into your projects, adding a touch of innovation and intelligence to your Scala solutions. If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals. Discover the power of Scala programming in our comprehensive, hands-on technical training course designed specifically for experienced object-oriented (OO) developers. Scala is a versatile programming language that combines the best of both OO and functional programming paradigms, making it ideal for a wide range of projects, from web applications to big data processing and machine learning. By mastering Scala, you'll be able to develop more efficient, scalable, and maintainable applications. Fast Track to Scala Programming for OO / Java Developers is a four day hands-on course covers the core principles of Scala, functional programming, web application development, database connectivity, concurrency programming, testing, and interoperability between Scala and Java. Additionally, you'll explore cutting-edge generative AI and GPT technologies, learning how to integrate them into your Scala applications for intelligent suggestions or automation. Throughout the course you?ll explore the latest tools and best practices in the Scala ecosystem, gaining valuable knowledge and experience that can be directly applied to your day-to-day work. With 50% of the course content dedicated to hands-on labs, you'll gain practical experience applying the concepts you've learned across various projects, such as building functional web applications, connecting to databases, designing modular components, and implementing concurrency. Upon completing the course, you'll have a solid understanding of the language and its features, empowering you to confidently apply your new skills in data science and machine learning projects. You'll exit well-prepared to create efficient, scalable, and maintainable Scala applications, regardless of the complexity of your projects. Introduction to Scala Scala features and benefits Comparing Scala with Java and other OO languages Installing Scala and setting up the development environment Object-Oriented Programming in Scala Classes and objects Traits, mixins, and inheritance Companion objects and factories Encapsulation and polymorphism Functional Programming Basics Pure functions and referential transparency Higher-order functions and currying Immutability and persistent data structures Pattern matching and recursion Having Fun with Functional Data Structures Lists, sets, and maps in Scala Folding and reducing operations Stream processing and lazy evaluation For-comprehensions Building Web Applications in Functional Style Introduction to Play Framework Functional web routing and request handling JSON handling with Play-JSON Middleware and functional composition Connecting to a Database Introduction to Slick library Database configuration and setup Querying and updating with Slick Transactions and error handling Building Scalable and Extensible Components Modular architecture and design patterns Dependency injection with MacWire Type classes and type-level programming Implicit parameters and conversions Concurrency Programming & Akka Introduction to Akka framework and Actor model Actor systems and message passing Futures and Promises Supervision and fault tolerance Building Confidence with Testing Introduction to ScalaTest and ScalaCheck Unit testing and property-based testing Test-driven development in Scala Mocking and integration testing Interoperability between Scala and Java Calling Java code from Scala Using Java libraries in Scala projects Converting Java collections to Scala collections Writing Scala code that can be called from Java Using Generative AI and GPT Technologies in Scala Programming Overview of GPT and generative AI Integrating GPT with Scala applications Use cases and practical examples Additional course details: Nexus Humans Fast Track to Scala Programming Essentials for OO / Java Developers (TTSCL2104) 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 Fast Track to Scala Programming Essentials for OO / Java Developers (TTSCL2104) 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.

Duration 3 Days 18 CPD hours This course is intended for This in an intermediate and beyond-level course is geared for experienced Python developers looking to delve into the exciting field of Natural Language Processing. It is ideally suited for roles such as data analysts, data scientists, machine learning engineers, or anyone working with text data and seeking to extract valuable insights from it. If you're in a role where you're tasked with analyzing customer sentiment, building chatbots, or dealing with large volumes of text data, this course will provide you with practical, hands on skills that you can apply right away. Overview This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll: Master the fundamentals of Natural Language Processing (NLP) and understand how it can help in making sense of text data for valuable insights. Develop the ability to transform raw text into a structured format that machines can understand and analyze. Discover how to collect data from the web and navigate through semi-structured data, opening up a wealth of data sources for your projects. Learn how to implement sentiment analysis and topic modeling to extract meaning from text data and identify trends. Gain proficiency in applying machine learning and deep learning techniques to text data for tasks such as classification and prediction. Learn to analyze text sentiment, train emotion detectors, and interpret the results, providing a way to gauge public opinion or understand customer feedback. The Hands-on Natural Language Processing (NLP) Boot Camp is an immersive, three-day course that serves as your guide to building machines that can read and interpret human language. NLP is a unique interdisciplinary field, blending computational linguistics with artificial intelligence to help machines understand, interpret, and generate human language. In an increasingly data-driven world, NLP skills provide a competitive edge, enabling the development of sophisticated projects such as voice assistants, text analyzers, chatbots, and so much more. Our comprehensive curriculum covers a broad spectrum of NLP topics. Beginning with an introduction to NLP and feature extraction, the course moves to the hands-on development of text classifiers, exploration of web scraping and APIs, before delving into topic modeling, vector representations, text manipulation, and sentiment analysis. Half of your time is dedicated to hands-on labs, where you'll experience the practical application of your knowledge, from creating pipelines and text classifiers to web scraping and analyzing sentiment. These labs serve as a microcosm of real-world scenarios, equipping you with the skills to efficiently process and analyze text data. Time permitting, you?ll also explore modern tools like Python libraries, the OpenAI GPT-3 API, and TensorFlow, using them in a series of engaging exercises. By the end of the course, you'll have a well-rounded understanding of NLP, and will leave equipped with the practical skills and insights that you can immediately put to use, helping your organization gain valuable insights from text data, streamline business processes, and improve user interactions with automated text-based systems. You?ll be able to process and analyze text data effectively, implement advanced text representations, apply machine learning algorithms for text data, and build simple chatbots. Launch into the Universe of Natural Language Processing The journey begins: Unravel the layers of NLP Navigating through the history of NLP Merging paths: Text Analytics and NLP Decoding language: Word Sense Disambiguation and Sentence Boundary Detection First steps towards an NLP Project Unleashing the Power of Feature Extraction Dive into the vast ocean of Data Types Purification process: Cleaning Text Data Excavating knowledge: Extracting features from Texts Drawing connections: Finding Text Similarity through Feature Extraction Engineer Your Text Classifier The new era of Machine Learning and Supervised Learning Architecting a Text Classifier Constructing efficient workflows: Building Pipelines for NLP Projects Ensuring continuity: Saving and Loading Models Master the Art of Web Scraping and API Usage Stepping into the digital world: Introduction to Web Scraping and APIs The great heist: Collecting Data by Scraping Web Pages Navigating through the maze of Semi-Structured Data Unearth Hidden Themes with Topic Modeling Embark on the path of Topic Discovery Decoding algorithms: Understanding Topic-Modeling Algorithms Dialing the right numbers: Key Input Parameters for LSA Topic Modeling Tackling complexity with Hierarchical Dirichlet Process (HDP) Delving Deep into Vector Representations The Geometry of Language: Introduction to Vectors in NLP Text Manipulation: Generation and Summarization Playing the creator: Generating Text with Markov Chains Distilling knowledge: Understanding Text Summarization and Key Input Parameters for TextRank Peering into the future: Recent Developments in Text Generation and Summarization Solving real-world problems: Addressing Challenges in Extractive Summarization Riding the Wave of Sentiment Analysis Unveiling emotions: Introduction to Sentiment Analysis Tools Demystifying the Textblob library Preparing the canvas: Understanding Data for Sentiment Analysis Training your own emotion detectors: Building Sentiment Models Optional: Capstone Project Apply the skills learned throughout the course. Define the problem and gather the data. Conduct exploratory data analysis for text data. Carry out preprocessing and feature extraction. Select and train a model. ? Evaluate the model and interpret the results. Bonus Chapter: Generative AI and NLP Introduction to Generative AI and its role in NLP. Overview of Generative Pretrained Transformer (GPT) models. Using GPT models for text generation and completion. Applying GPT models for improving autocomplete features. Use cases of GPT in question answering systems and chatbots. Bonus Chapter: Advanced Applications of NLP with GPT Fine-tuning GPT models for specific NLP tasks. Using GPT for sentiment analysis and text classification. Role of GPT in Named Entity Recognition (NER). Application of GPT in developing advanced chatbots. Ethics and limitations of GPT and generative AI technologies.

Course Overview: The demand for User Experience (UX) and User Interface (UI) designers is skyrocketing. Our Advanced Diploma in User Experience UI/UX Design is a comprehensive program that equips you with the knowledge and skills to craft seamless and user-centric designs that leave a lasting impact.Through a series of thoughtfully designed modules, learners will not only gain an understanding of UX/UI but also the dynamics of the Web Industry, Graphic Design implications, and the intricate details of UX Design, followed by an extensive dive into UI Design and Optimization techniques. Ultimately, the course incorporates a holistic understanding of the Careers in UX/UI, empowering students to venture confidently into this promising field.Enrol in this Advanced Diploma in User Experience UI/UX Design course today and start your journey to a successful career in UX or UI design! Key Features of the Course: CPD Certification 24/7 Learning Assistance Interesting Learning Materials Who is This Course For? This Advanced Diploma in User Experience UI/UX Design course is ideal for aspiring UX/UI designers, web developers, graphic designers, product managers, and professionals looking to enhance their design skills. Whether you are a beginner or have some experience in design, this course will help you develop a solid foundation and master the intricacies of UX/UI design. What You Will Learn: In the first part of the Advanced Diploma in User Experience UI/UX Design course, you will dive into the fundamentals, including the difference between UX and UI, the roles and responsibilities of designers in a team, and an overview of the web development process. You will also explore the psychology of colour, working with fonts and icons, and the essential tools and techniques used in graphic design. Moving forward, you will uncover the core principles of UX design, learn how to analyse user profiles, identify pain points, and create user personas. You will gain insights into customer journeys, sales funnels, and the principles of influence. Through hands-on projects, you will develop skills in creating storyboards, mood boards, and information architecture. In the latter part of the course, you will focus on wireframing, prototyping, and testing, ensuring your designs are user-friendly and intuitive. You will learn about usability reports, the "Above the Fold" rule, and optimisation using analytics and heat maps. The course also provides valuable guidance on launching a UX/UI design career, including freelancing, personal branding, and building a professional website. Why Enrol in This Course: Join thousands of satisfied learners who highly rated this Advanced Diploma in User Experience UI/UX Design course for its comprehensive curriculum and effective approach. Benefit from up-to-date industry insights and the latest design trends, ensuring you stay ahead of the curve. UX/UI design is one of the fastest-growing fields, offering abundant job opportunities and career growth potential. Develop your design thinking and problem-solving skills, unleashing your creative potential to craft extraordinary user experiences. Requirements: Enrolling in this Advanced Diploma in User Experience UI/UX Design course requires a basic understanding of design concepts and access to a computer with an internet connection. No prior coding or design experience is required. Career Path: Upon completing this Advanced Diploma in User Experience UI/UX Design course, you will be well-prepared for a range of exciting career opportunities, including: UX/UI Designer (£35,000 - £55,000 per annum) Web Developer (£30,000 - £45,000 per annum) Graphic Designer (£25,000 - £40,000 per annum) Product Manager (£40,000 - £70,000 per annum) UX Researcher (£35,000 - £50,000 per annum) Interaction Designer (£35,000 - £60,000 per annum) User Experience Architect (£45,000 - £75,000 per annum) Certification: Upon completing the Advanced Diploma in User Experience UI/UX Design course, you will receive a CPD certificate, widely recognised as a mark of excellence in the professional development of individuals. Enrol today and join the ranks of successful designers who have harnessed the power of user-centric design to create remarkable digital experiences. Course Curriculum 9 sections • 112 lectures • 12:52:00 total length •Learn UX/UI Course Overview: 00:05:00 •Section Overview: 00:04:00 •UX vs UI: 00:04:00 •UX/UI Designer Marketplace: 00:05:00 •Overview of UX Roles: 00:06:00 •Web Industry Section Overview: 00:03:00 •The Phases of Web Development: 00:13:00 •Designer Responsibilities (working in a team): 00:09:00 •Roles & Descriptions (working in a team): 00:05:00 •Agile Approach To Project Management: 00:12:00 •Scrum - Flexible Framework: 00:06:00 •Project Management Apps: 00:13:00 •XD Lesson - Introduction: 00:13:00 •Graphic Design Section Overview: 00:02:00 •The Psychology of Color: 00:13:00 •Color Wheel & Color Schemes: 00:06:00 •Working with Fonts: 00:10:00 •Working With Icons: 00:04:00 •XD Lesson - Tools, Object Manipulation and Components: 00:13:00 •XD Lesson - Font Styles and Artboard Settings: 00:07:00 •Graphic Design Software Tools: 00:03:00 •Adobe XD lesson 4 - Icons & Vector Graphics: 00:14:00 •UX Design Section Overview: 00:04:00 •What is User Experience Design? (UX): 00:09:00 •UX Design Process: 00:03:00 •The UX Analysis Process: 00:08:00 •Working with User Profiles: 00:03:00 •Understanding User Pain Points: 00:03:00 •XD Lesson 5 Class Project: Сompetitive Analysis: 00:10:00 •Developing a Persona Part 1: 00:05:00 •Developing a Persona Part 2: 00:05:00 •Customer Journey: 00:04:00 •Customer Journey vs Sales Funnel: 00:04:00 •3 Phases of a Sales Funnel: 00:07:00 •4 Stages of a Sales Funnel: 00:06:00 •Macro/Micro Conversions: 00:05:00 •Stages of Market Sophistication: 00:06:00 •Lead Generation Funnel: 00:06:00 •Digital Product Sales Funnel: 00:05:00 •7 Principles of Influence: 00:12:00 •Age Based Influence Triggers: 00:06:00 •Gender Influence Triggers: 00:06:00 •Interest Based Marketing: 00:04:00 •Understanding User Flow: 00:08:00 •XD Lesson 6 Class Project: Userflow - Your first UX deliverable: 00:07:00 •Working with Story Boards: 00:05:00 •XD Lesson 7 Class Project: Crafting a Story board: 00:09:00 •Working with Moodboards: 00:04:00 •XD Lesson 8 Class Project: Creating Moodboard: 00:11:00 •Sitemap & Information Architecture: 00:07:00 •XD Lesson - Class Project: App Architecture: 00:09:00 •Low and Hi Fidelity Wireframes: 00:03:00 •XD Lesson - Class Project: Login Screen Wireframe Using Material Design: 00:08:00 •Working with Prototypes: 00:04:00 •XD Lesson - Class Project: Home Screen Wireframe and Linking: 00:07:00 •XD Lesson - Class Project: Adding Interaction to Wireframes: 00:10:00 •Testing and Evaluating: 00:11:00 •UX Deliverables: 00:03:00 •UX Design Conclusion: 00:01:00 •UI Design Section Overview: 00:03:00 •UI Design Overview: 00:03:00 •Types of Interfaces: 00:10:00 •Landing Pages Overview: 00:10:00 •XD Lesson - Using Grids in XD: 00:08:00 •XD Lesson - Single Card design: 00:13:00 •UI Controls: 00:07:00 •UI Components: 00:12:00 •Navigational Components: 00:12:00 •Header Design Overview: 00:07:00 •XD Lesson - Mobile & Desktop: Header Design: 00:10:00 •XD Lesson - Mobile & Desktop: Dropdown Design: 00:06:00 •Common Layouts Overview: 00:08:00 •XD Lesson - Common Layouts: 00:07:00 •Mobile & Desktop Footer Design Overview: 00:07:00 •XD Lesson - Mobile & Desktop: Footer Design: 00:06:00 •Mobile & Desktop Button Design Overview: 00:05:00 •XD Lesson - Mobile & Desktop: Button Design: 00:10:00 •XD Lesson - Mobile & Desktop: Input Design: 00:07:00 •Mobile & Desktop Filter Search Bar Design Overview: 00:06:00 •Adobe XD Lesson - Mobile & Desktop: Filter Design: 00:07:00 •Adobe XD Lesson - Mobile & Desktop: Search Design: 00:03:00 •UI Kit Overview: 00:05:00 •Adobe XD Lesson - Desktop and Mobile: UI Kit: 00:06:00 •Microinteractions Overview: 00:05:00 •Adobe XD lesson - Microinteractions: 00:07:00 •Optimization Section Overview: 00:02:00 •Feedback Review & Getting Referrals: 00:04:00 •'Above the Fold' Rule: 00:04:00 •Adobe XD lesson - Designing a Powerful Above the Fold: 00:08:00 •Using Analytics For Optimization: 00:05:00 •Heat Maps & Element Placements: 00:04:00 •Crafting A Usability Report Overview: 00:08:00 •Adobe XD lesson - Crafting Reports in XD: 00:20:00 •Careers in UX/UI Section Overview: 00:06:00 •Your Daily Productivity Hub: 00:14:00 •How To Start Freelancing: 00:08:00 •Client Consulting: 00:04:00 •Building a Brand: 00:10:00 •Personal Branding: 00:06:00 •The Importance of Having a Website: 00:08:00 •Creating a Logo: 00:05:00 •Step by Step Website Setup: 00:17:00 •UI Templates: 00:06:00 •Logo Templates: 00:04:00 •Creating a Business Email: 00:06:00 •Networking Do's and Don'ts: 00:04:00 •Top Freelance Websites: 00:10:00 •UX/UI Project Scope Questions: 00:10:00 •Laser Focus & Productivity Tools: 00:06:00 •The Places to Find UX Jobs: 00:05:00 •Resources - Advanced Diploma in User Experience UI/UX Design: 00:00:00 •Assignment - Advanced Diploma in User Experience UI/UX Design: 00:00:00

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

Dive into the revolutionary world of AI image generation with our Mastering Dall-E course. From understanding diffusion models to harnessing Dall-E for creative and commercial use, this course offers a comprehensive guide to mastering this cutting-edge technology.

You will learn how to become a Python developer through this course.

We will help you become an ethical hacker in this course.

Master the essentials of C++ programming with our beginner-friendly course. Learn from local setup to advanced functions, and embark on your journey in software development.

A medical secretary is responsible for ensuring that a doctor's office runs smoothly so that patients receive the best possible care. A medical secretary must understand office organisation and standard procedures to provide this secretarial support. They should also be able to use medical terminologies fluently. This Medical Receptionist & Secretary course will teach you about the medical secretarial profession and the skills needed to do the job successfully. This course will teach you about the roles and responsibilities of a medical secretary. You will also learn various medical secretary skills, including an effective filing system, medical transcription, medical writing, maintaining medical records, an appointment system, and more. Furthermore, this comprehensive Medical Receptionist & Secretary course will teach you the critical concepts of patient confidentiality and other legal aspects of the healthcare industry. Learning Outcomes After completing this course, learner will be able to: Understand the fundamentals of the National Health Service. Understand the roles and responsibilities of a medical secretary. Know how to organise schedules and manage appointment systems. Gain a clear understanding of the Law, Ethics and Medicine. Gain a thorough understanding of the effective filing system in medical offices. Familiarise yourself with the concept of patient confidentiality and its dos and don'ts. Become skilled at controlling and ordering stocks and supplies. Gain in-depth knowledge of Medical Terminology and Clinical Aspects. Know the importance of health and safety in the healthcare sector. Have a solid understanding of Complementary Medicine Why Choose Medical Receptionist & Secretary Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Medical Receptionist & Secretary Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing this course. **Courses are included in this Medical Receptionist & Secretary Course Course 01: Medical Receptionist & Secretary Course 02: Dealing With Difficult People Course 03: Report Writing Course ***Others Included of Medical Receptionist & Secretary Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum of the Medical Receptionist & Secretary Course: Module 1: The National Health Service History Structure of the NHS The NHS Plan Resource Allocation Delivering Care Mental Health Services Public Health The NHS, the Regions and Devolution Module 2: Patient (Customer) Care The Medical Receptionist Putting Patient First Complaints Within the Health Service The Complaints Procedure Patient and Public Involvement Patient's Rights Access to Health Care Total Quality in Medical Practice Customer Care: Involving Patients and the Public Module 3: Communication Report Writing Electronic Mail & Mobile Phones: Text Messages Telephone Skills People Skills - Face to Face Meeting Performance Review & Counselling The Practice Leaflet & Hospital Information Leaflets Networking Module 4: Law, Ethics and Medicine Medical Ethics and Etiquette Doctor's Duties Patient's Right The Regulatory Bodies and Their Role Legal Aspects Certification Health and Safety at Work Module 5: Health & Safety in a Clinical Environment First Aid at Work Hazardous Substances The NHS National Patient Safety Agency (NPSA) Hepatitis & AIDS Fire Precautions Clinical Risk Management Coping With Aggression & Violence Module 6: Practical Reception Skills in General Practice Record Keeping and General Administration Information Technology Module 7: The Hospital Service The Patient's Route Through the Hospital Outpatient Appointments Admissions from the Waiting List Accident and Emergency Admissions Home From Hospital Support Day Cases and Ward Attendees Hospital Team Clinical Audit Star Ratings What is a Medical Record? Cases Notes Master Index Filing Room or Records Library Medical Records Procedure for Departments Retention of Records Destruction of Medical Records The Role of the Secretary in the Hospital Module 8: Private Medicine Private Clinic or Hospital The Secretary In Private Practice Module 9: Forms, Fees and Finances in General Practises Contracting Finance Practice Income Scotland Wales Northern Ireland Module 10: Using Information Technology Computers in General Practice Electronic Medicine Computers in Hospitals Maintaining Security Module 11: Medical Terminology and Clinical Aspects Pathology and X-ray Examinations Prescribing and Drugs Nurse Prescribing New Developments in Pharmacy Module 12: Audit, Health Economics and Ensuring Quality for the Medical Receptionist and Secretary Audit Health Economics and Cost-effective Medicine Private Finance Initiative Clinical Governance National Institute for Clinical Excellence (NICE) National Clinical Assessment Service (NCAS) National Service Framework (NSF) Patient Surveys Module 13: Complementary Medicine Acupuncture Alexander Technique Aromatherapy Chiropractic Homoeopathy Hydrotherapy Hypnotherapy Osteopathy Reflexology ------------------- ***GIFT Courses: ------------------- ***Dealing With Difficult People*** Module 01: Difficult People and Their Difficult Behaviour Module 02: Communicating With Difficult People Module 03: Standing Up to Difficult People Module 04: A Quick Guide to the Seven Classically Difficult Types Module 05: Dealing with Bosses Who Drive You Barmy Module 06: Colleagues to Throttle Module 07: Dealing With Impossible People Module 08: The Temper Tantrum Type ------------------- ***Report Writing Course*** Module 01: Introduction to Report Writing Module 02: The Basics of Business Report Writing Module 03: The Practical Side of Report Writing (Part-1): Preparation & Planning Module 04: The Practical Side of Report Writing (Part-2): Collecting and Handling Information Module 05: The Practical Side of Report Writing (Part-3): Writing and Revising Report Module 06: The Creative Side of Report Writing (Part -1): A Style Guide to Good Report Writing Module 07: The Creative Side of Report Writing (Part -2): Improving the Presentation of Your Report Module 08: Developing Research Skills Module 09: Developing Creativity & Innovation Module 10: Develop Critical Thinking Skills Module 11: Interpersonal Skill Development ------------------ Assessment Method After completing each module of the Medical Receptionist & Secretary, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Medical Receptionist & Secretary course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Medical Receptionist & Secretary course is ideal for Health Care Professionals who work and will be working in healthcare settings such as hospitals, clinics, and healthcare facilities. Requirements There are no specific requirements for this Medical Receptionist & Secretary course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this Medical Receptionist & Secretary, you will have developed a set of skills necessary for career advancement and will be able to pursue a variety of job opportunities, including - Medical Receptionist Medical Secretary Healthcare Administrator GP Receptionist Patient Coordinator Certificates Certificate of completion Digital certificate - Included

***Level 5: Accounting & Finance*** Accounting and finance assist businesses in measuring, monitoring, and planning their operations. This Level 5: Accounting & Finance course has been designed to provide a thorough introduction to business Accounting and Finance as both an idea and a profession. This course will equip you with in-demand accounting and finance skills as well as the ability to complete practicable processes while working in an organisation. This could be tricky, especially if this is your first consignment in the accounting and finance sector. Our Level 5: Accounting & Finance course provides a solid understanding of accounting and financial methods, concepts, and duties to properly prepare you for a career in the accounting and finance sector. Learning Outcomes After completing this Level 5: Accounting & Finance course, learner will be able to: Understand the essentials of accounting and finance Understand the types of cost data and cost analysis Gain a thorough understanding of contribution analysis Understand break-even and cost-volume-profit analysis Understand relevant cost and know to make short-term decisions Know how to manage financial assets Understand forecasting cash needs and budgeting Cost control and variance analysis Know how to manage accounts receivable and credit Know how to manage inventory Understand the time value of money Know how to improve managerial performance Understand capital budgeting decisions Understand improve managerial performance Understand sources of short-term financing Know how to consider term loans and leasing Understand long-term debt and equity financing Understand accounting conventions and recording financial data Why Choose Level 5 Accounting & Finance Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] ***Level 5: Accounting & Finance*** Detailed Course Curriculum Module 1: Essentials of Accounting and Finance Identify the Non-Financial Manager's Concern with Finance The Importance of Finance Financial and Operating Environment Module 2: Types of Cost Data and Cost Analysis The Importance of Cost Data Types of Costs How Do Your Costs Behave? Segregating Fixed Cost and Variable Cost Cost Allocation Cost Analysis What You Can Learn from the Japanese? Module 3: Contribution Analysis Should You Accept a Special Order? How Do You Determine a Bid Price? Determining Profit from Year to Year Are You Utilising Capacity? Module 4: Break-Even and Cost-Volume-Profit Analysis What is Cost-Volume-Profit Analysis? What and Why of Break-Even Sales? What is the Margin of Safety? Cash Break-Even Point What is Operating Leverage? Sales Mix Analysis Module 5: Relevant Cost and Making Short-Term Decisions What Costs Are Relevant to You? Accepting or Rejecting a Special Order Pricing Standard Products Determining Whether to Sell or Process Further Adding or Dropping a Product Line Utilising Scarce Resources Don't Forget the Qualitative Factors Module 6: Forecasting Cash Needs and Budgeting Forecasts Using Forecasts Preparing Financial Forecasts Budgets The Sales Budget The Production Budget The Direct Material Budget The Direct Labour Budget The Factory Overhead Budget The Ending Inventory The Selling and Administrative Expense Budget The Cash Budget The Budgeted Income Statement The Budgeted Balance Sheet A Shortcut Approach to Formulating the Budget Module 7: Cost Control and Variance Analysis Defining a Standard The Usefulness of Variance Analysis Setting Standards Determining and Evaluating Sales Variances Cost Variances Labour Variances Overhead Variances The Use of Flexible Budgets in Performance Reports Standards and Variances in Marketing Sales Standards Variances in Warehousing Costs Module 8: Managing Financial Assets Working Capital Financing Assets Managing Cash Properly Getting Money Faster Delaying Cash Payments Opportunity Cost of Foregoing a Cash Discount Volume Discounts Module 9: Managing Accounts Receivable and Credit Credit References Credit Policy Analysing Accounts Receivable Module 10: Managing Inventory Inventory Management Considerations Inventory Analysis Determining the Carrying and Ordering Costs The Economic Order Quantity (EOQ) Avoiding Stock Outs Determining the Reorder Point or Economic Order Point (EOP) The ABC Inventory Control Method Supply Chain Management Module 11: The Time Value of Money Future Values - How Money Grows Future Value of an Annuity Present Value - How Much Money is Worth Now? Present Value of Mixed Streams of Cash Flows Present Value of an Annuity Perpetuities Applications of Future Values and Present Values Module 12: Capital Budgeting Decisions Types of Investment Projects What Are the Features of Investment Projects? Selecting the Best Mix of Projects With a Limited Budget Income Taxes and Investment Decisions Types of Depreciation Methods How Does MACRS Affect Investment Decisions? The Cost of Capital Module 13: Improving Managerial Performance What is Return on Investment (ROI)? What Does ROI Consist of? - Du Pont Formula ROI and Profit Objective ROI and Profit Planning ROI and Return on Equity (ROE) Module 14: Sources of Short-Term Financing Trade Credit Cash Discount When are Bank Loans Advisable? Working with a Bank Issuing Commercial Paper Using Receivables for Financing Using Inventories for Financing Module 15: Considering Term Loans and Leasing Intermediate-Term Bank Loans Using Revolving Credit Insurance Company Term Loans Financing with Equipment Leasing Module 16: Long-Term Debt and Equity Financing Types of Long-Term Debt Equity Securities How Should You Finance? Module 17: Accounting Conventions and Recording Financial Data Double Entry and the Accounting Equation Assessment Method After completing each module of the Level 5: Accounting & Finance course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Level 5: Accounting & Finance course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Level 5: Accounting & Finance This Level 5: Accounting & Finance course is ideal for: Candidates interested to start a career in accountancy Business owners seeking to look after their own accounts Existing accountancy workers in seeking higher positions or promotion Accountancy workers with no formal qualifications Anyone wishing to boost their career prospects. Requirements Level 5: Accounting & Finance There are no specific requirements for Level 5: Accounting & Finance course because it does not require any advanced knowledge or skills. Career path Level 5: Accounting & Finance This Level 5: Accounting & Finance course may lead you to a variety of career opportunities. Accounts Assistant Accounts Payable & Expenses Supervisor Accounts Payable Clerk Audit Trainee Payroll Administrator / Supervisor Tax Assistant / Accountant. Accounting Clerk Auditing Clerk Accounts Receivable Clerk Certificates Certificate of completion Digital certificate - Included