52312 Courses in Leicester delivered Online

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Food Safety, Education and Social Care Training Courses  What You Need To Know About Food Allergies CPD Accredited, Interactive Short Course 2 hr session Do you serve food, or have people with known allergies in your school or on your team? In this webinar we will explain what food allergies are, and why it is vital for you to understand, for the health and safety, and indeed life, of the person involved Course Contents: What is a food allergy The 14 Allergens The Immune System Consequences of Food Allergies The importance of good food hygiene Benefits of this Short Course: More than 20% of the population in industrialized countries suffer from food intolerance or food allergy About two million people live with a diagnosed food allergy in the UK, and 32 million in the US 600,000 people in the UK have coeliac disease This course will teach you the importance of ensuring food is safe to eat for all, without causing significant pain or even death

Are you someone who is struggling with your financial needs? Or are you a professional who helps people who are struggling because of financial instability? If this is you, then you will be interested in this course and learn how financial empowerment works! Description: Can you tell if you're currently stable regarding your financial status? Do you know someone who has it or how do you know if someone is suffering because of debts and other financial issues? Then you should learn through this course to help yourself, or other people learn how to keep their financial status on track. You have to be able to empower yourself and other people to have their financial capacity at its maximum. You will then know the concept of financial empowerment in this course. Moreover, this course will contain the topic on the ability or action in relation with financial empowerment. You will be able to learn the concept of assets and how you could understand it and learn how to build your own. Then this course will discuss how education is one of the best investment to become financially empowered. Who is the course for? Professionals who are helping people cope up with their financial struggles and issues Individuals who have the interest to learn the ways to keep their financial capacity stable Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Financial Empowerment Course is a useful qualification to possess, and would be beneficial for the following careers: Account Manager Career Coach Financial Advisor Financial Mentors Investment Specialist Savings Manager. Financial Empowerment Course Introduction 00:30:00 Different Between Ability And Action 00:15:00 The Four Fundamentals Of Financial Empowerment 00:30:00 The Sum of Five State 00:15:00 Understanding the Concept of Assets 00:15:00 Building Your Assets 00:30:00 Investing in Education for Your Financial Empowerment 00:30:00 How Does Recreation Help In Building Your Financial Value 00:30:00 The Long Haul 00:30:00 Staying Upwardly Mobile 00:15:00 Conclusion 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Windows server 2019 administration course description This five-day instructor-led course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server 2019, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server 2019. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server 2019 in most organizations. What will you learn Administrate Windows Server 2019. Configure file servers and storage. Manage Hyper-V virtualization and containers. Implement HA and disaster recovery solutions. Implement service monitoring and performance monitoring, and apply troubleshooting. Perform upgrades and migration related to AD DS, and storage. Windows server 2019 administration course details Who will benefit: Technical staff working with Windows server 2019. Prerequisites: TCP/IP foundation for engineers. Some Windows experience. Duration 5 days Windows server 2019 administration course contents Windows server administration overview Windows server administration principles and tools, Introducing Windows Server 2019, Windows Server Core Overview. Lab: Deploying and configuring Server Core, Implementing and using remote server administration. Identity Services in Windows server AD DS, Windows Server domain controllers, Azure AD, Group Policy, Active Directory Certificate Services. Lab: Deploying a new domain controller on Server Core, Configuring Group Policy, Deploying and using certificate services. Network Infrastructure services in Windows server DHCP, DNS services, IPAM. Lab: Deploying and configuring DHCP, Deploying and configuring DNS. File Servers and Storage management Volumes and file systems, sharing in Windows Server, Storage Spaces in Windows Server, Data Deduplication, Iscsi, Distributed File System. Lab: Implementing Data Deduplication, Configuring iSCSI storage, Configuring redundant storage spaces, Implementing Storage Spaces Direct. Hyper-V virtualization and containers Hyper-V in Windows Server, Configuring VMs, Securing virtualization in Windows Server, Containers in Windows Server, Overview of Kubernetes. Lab: Creating and configuring VMs, Installing and configuring containers. High Availability in Windows Server Planning for failover clustering implementation, Creating and configuring failover cluster, stretch clusters, High availability and disaster recovery solutions with Hyper-V VMs. Lab: Configuring iSCSI storage, Configuring a failover cluster, Deploying and configuring a highly available file server, Validating the highly available file server deployment. Disaster recovery in Windows Server Hyper-V Replica, Backup and restore infrastructure in Windows Server. Lab: Implementing Hyper-V Replica, Implementing backup and restore with Windows Server Backup. Windows Server security Credentials and privileged access protection, Hardening Windows Server, Just Enough Administration in Windows Server, Securing and analyzing SMB traffic, Windows Server update management. Lab: Configuring Windows Defender Credential Guard, Locating problematic accounts, Implementing LAPS. Remote Desktop Services in Windows Server Remote Desktop Services, session-based desktop deployment, personal and pooled virtual desktops. Lab: Implementing RDS, Configuring RemoteApp collection settings, Configuring a virtual desktop template. Remote access and web services in Windows Server Overview of RAS in Windows Server, Implementing VPNs, Implementing NPS, Implementing Always On VPN, Implementing Web Server in Windows Server. Lab: Implementing Web Application Proxy, Implementing VPN in Windows Server, Deploying and Configuring Web Server. Monitoring, performance, and troubleshooting Windows Server monitoring tools, Performance Monitor, Monitoring event logs for troubleshooting. Lab: Establishing a performance baseline, Identifying the source of a performance problem, Viewing and configuring centralized event logs, Identifying the source of a performance problem, Describe monitoring tools and performance monitoring in Windows Server, Describe event logging and perform event logging monitoring for troubleshooting purposes. Upgrade and migration in Windows Server AD DS migration, Storage Migration Service, Windows Server migration tools. Lab: Selecting a process to migrate server workloads, Planning how to migrate files by using Storage Migration Service.

Level 4- Two Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

CWISA training course description This CWISA course covers wireless technologies with reference to IoT. It examines from an IoT perspective how wireless works, and is an excellent introduction to IoT for the wireless engineer. Topics range from wireless technologies, RF, to mobile networks, IoT, and security. What will you learn Describe wireless networking and IoT technologies. Explain basic RF communications. Plan wireless solutions. Describe how to implement wireless solutions. Use best practices in implementing wireless solutions. CWISA training course details Who will benefit: Anyone working with IoT technologies. Prerequisites: RF fundamentals. Duration 4 days CWISA training course contents Introduction to wireless technologies History of wireless, radio waves and frequencies, wireless technologies and related components, common components of wireless solutions, LAN networking requirements, Network security, Implementing wireless solutions, staging, documentation, security updates, Industry organizations, IEEE, compatibility and certification groups. Wireless network use cases Wireless BANs, Wireless PANs, Wireless LANs, Wireless MANs, Wireless WANs, Wireless sensor networks, New network driver-Internet of Things, IoT for industry (IIoT), IoT for connected vehicles, Residential environments, Retail, Education (K12), Higher education, Agriculture, Smart cities / Public access, Health care, Office buildings, Hospitality, Industry, Stadiums, arenas, and large public venues. Planning wireless solutions Identifying use cases and applications, common wireless requirements and constraints, performing a wireless system design, selecting and evaluating design parameters. RF communications RF wave characteristics, RF propagation behaviours, RF signal metrics, fundamentals of wireless modulation. other wireless carriers, common frequency bands. Radio frequency hardware Hardware levels, basic RF hardware components (circuit board level), RF link types (use category). RF device types. Mobile communications networks Mobile networks, LTE, 5G, Use cases. Short-range, low-rate, and low-power networks RF and speed, RF and range, RF and power, 802.11, 802.15.4, Bluetooth, LoRa (Long range) / LoRaWAN, ZigBee, 6LoWPAN, NB-IoT and LTE-M. Wireless sensor networks What is a Wireless Sensor Network (WSN)? WSN applications, Sensors and actuators, WSN architectures, Planning a WSN. Internet of Things (IoT) Internet of Things (IoT) defined, IoT history and its definition revisited, one more comment on the definition of IoT, IoT verticals, Oil & Gas, IoT structure/ architecture basics, IoT connected objects. Securing wireless networks Confidentiality, integrity and availability, Privacy, non-repudiation, authenticity & safety, Importance of authentication in wireless networks, Key cryptographic technologies & concepts, Authentication methods, Authorisation, OAuth 2.0 authorisation framework, monitoring. Troubleshooting wireless solutions Proper solutions design, designing and implementing wireless solutions, basic installation procedures, general configuration considerations, troubleshooting and remediation, troubleshoot common problems in wireless solutions. Programming, scripting and automation What is an API? categories of APIs, common API communication methods, choosing a language, why are we integrating systems? Application & integration architectures. Data structures & types, XML, YAML, API types.

Recent updates in financial regulations have underscored the critical need for professionals equipped with expertise in Financial Investigator, Tax Accounting & Financial Analysis. With the ever-evolving landscape of finance, the demand for skilled individuals adept at navigating complexities and ensuring compliance is at an all-time high. In light of this, our comprehensive Financial Investigator, Tax Accounting & Financial Analysis QLS Endorsed Diploma bundle offers a strategic blend of theoretical knowledge and practical insights to empower learners in this field. Amidst recent discussions on tax reforms and regulatory frameworks, professionals proficient in Financial Investigator, Tax Accounting & Financial Analysis are in high demand. Our Financial Investigator, Tax Accounting & Financial Analysis bundle caters to this demand by offering a meticulous selection of courses endorsed by the Quality Licence Scheme (QLS), supplemented by CPD QS accredited modules. By amalgamating technical proficiency with personal development initiatives, this Financial Investigator, Tax Accounting & Financial Analysis bundle stands as a beacon for aspiring individuals looking to excel in the realm of finance. Bundle Include includes: QLS Endorsed Courses: Course 01: Certificate in Financial Investigator at QLS Level 3 Course 02: Diploma in Financial Analysis at QLS Level 4 Course 03: Diploma in Advanced Tax Accounting at QLS Level 5 CPD QS Accredited Courses: Course 04: Corporate Finance: Profitability in a Financial Downturn Course 05: Finance: Financial Risk Management Course 06: Understanding Financial Statements and Analysis Course 07: Financial Wellness: Managing Personal Cash Flow Course 08: Internal audit skills Course 09: Anti-Money Laundering (AML) Training Course 10: Financial Accounting Course 11: Passive Income Mastery - Build Financial Security Take your career to the next level with our Financial Investigator, Tax Accounting & Financial Analysis bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive Financial Investigator, Tax Accounting & Financial Analysis bundle, endorsed by the prestigious QLS and accredited by CPD.Financial Investigator, Tax Accounting & Financial Analysis QLS Endorsed Diploma. Learning Outcomes: Develop a comprehensive understanding of financial investigation techniques and methodologies through Financial Investigator, Tax Accounting & Financial Analysis. Master advanced principles of financial analysis to evaluate business performance effectively. Gain proficiency in navigating complex tax accounting principles and regulations. Acquire insights into corporate finance strategies amidst financial downturns by Financial Investigator, Tax Accounting & Financial Analysis courses. Strengthen skills in financial risk management and internal audit procedures. Enhance personal finance management and cash flow optimization techniques. This comprehensive Financial Investigator, Tax Accounting & Financial Analysis bundle delves into the intricacies of Financial Investigator, Tax Accounting & Financial Analysis with a meticulous approach towards theoretical frameworks and practical applications. Through a series of endorsed courses by the Quality Licence Scheme (QLS) and CPD QS accredited modules, learners will embark on a journey of discovery, uncovering the nuances of financial investigation techniques, advanced principles of financial analysis, and the complex landscape of tax accounting. Participants will engage in in-depth explorations of corporate finance strategies amidst financial downturns, mastering the art of financial risk management, and honing their skills in internal audit procedures. Additionally, the curriculum extends beyond traditional finance realms, offering insights into personal finance management and cash flow optimization techniques, equipping learners with a holistic understanding of financial dynamics. With a blend of theoretical knowledge and practical insights, this Financial Investigator, Tax Accounting & Financial Analysis course empowers individuals to navigate the multifaceted world of finance with confidence and competence. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course Financial Investigator, Tax Accounting & Financial Analysis is ideal for: Professionals seeking to enhance their expertise in financial investigation, tax accounting, and financial analysis. Individuals aspiring to pursue careers in forensic accounting, financial consultancy, or tax advisory roles. Finance professionals looking to advance their skills and stay abreast of industry trends across Financial Investigator, Tax Accounting & Financial Analysis courses. Graduates aiming to enter the finance sector with a competitive edge. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of the Financial Investigator, Tax Accounting & Financial Analysis courses, you will be able to: Financial Investigator Forensic Accountant Tax Consultant Financial Analyst Internal Auditor Risk Manager Corporate Finance Advisor Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included

Course Overview The comprehensive Azure Administration Course Az-104 has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Azure Administration Course Az-104 today, and learn from the very best the industry has to offer! This best selling Azure Administration Course Az-104 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Azure Administration Course Az-104 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Azure Administration Course Az-104 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Azure Administration Course Az-104 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Azure Administration Course Az-104, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Azure Administration Course Az-104 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Azure Administration Course Az-104 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Overview Every piece of furniture, colour, and wall within a space has a story to tell. Learn how to tell your story through a comforting and beautiful space with our Interior Design Course. Whether you are a newbie or a seasoned professional, our course is the perfect place to work on your skills. In this course, you will get a clear understanding of the principles and elements of interior design. The course will help you explore the colour theory and show you how to use it. You will learn the basics of lighting, furniture and materials. Furthermore, you will develop the ability to design both residential and commercial spaces.  Along with designing skills, the course will teach you the techniques for professional development. Enrol now and take your career to the next level! Course Preview Learning Outcomes Understand the principles and elements of interior design Learn the process of planning the space and layout Familiarise yourself with the basic rule of colour theory Enhance your understanding of lighting design, furniture and materials Develop the skills required for commercial and residential design Get introduced to digital tools and software used in interior design Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Interior Design Residential Design Commercial Design Business Networking Who Should Take This Interior Design Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Interior Design Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Interior Design Course will equip you with effective skills and abilities and help you explore career paths such as  Interior Designer Interior Design Consultant Module 01: Introduction to Interior Design Introduction to Interior Design 00:23:00 Module 02: Space Planning and Layout Space Planning and Layout 00:21:00 Module 03: Colour Theory and Application Colour Theory and Application 00:22:00 Module 04: Materials and Finishes Materials and Finishes 00:21:00 Module 05: Lighting Design Lighting Design 00:19:00 Module 06: Furniture and Furnishings Furniture and Furnishings 00:20:00 Module 07: Sustainable Design Sustainable Design 00:23:00 Module 08: Interior Design for Residential Spaces Interior Design for Residential Spaces 00:20:00 Module 09: Interior Design for Commercial Spaces Interior Design for Commercial Spaces 00:21:00 Module 10: Professional Practice and Business Skills Professional Practice and Business Skills 00:21:00 Module 11: Digital Tools and Software for Interior Design Digital Tools and Software for Interior Design 00:21:00 Module 12: Professional Networking and Industry Engagement Professional Networking and Industry Engagement 00:23:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00