20314 Courses

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.

The objective of Level 5 Diploma in Tourism and Hospitality Management qualification (accredited by Othm) is to enable learners' development as managers within the tourism and hospitality industry, with a lifelong-learning orientation. This Diploma in Tourism and Hospitality Management - Level 5 enables learners to critically apply contemporary knowledge and theories to the management of complex problems. Successful completion of this qualification will equip learners with the specialist skills and technical terminology to develop their management skills and to progress to further study or employment. Program Overview: Diploma in Tourism and Hospitality Management - Level 5 Key Highlights of Diploma in Tourism and Hospitality Management - Level 5 are: Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Final Year of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Who is this course for? Working Professionals, A-Level / Level 4 / Year 1 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.

Whether you’re a board member or just curious about corporate governance, this AGRC certificate is for you! Learn what it takes for any firm to build and maintain a robust, dependable, and responsible corporate governance backbone with this self-paced, online certificate delivered by LGCA. The concept of corporate governance has featured regularly in discussions, both within the professional and academic community, since the 1990s and has become even more prominent following significant cases of corporate failure that had adverse effects on the global interconnected economy. Additionally, the Certificate places emphasis on how internal control mechanisms need to be designed and underlines how helpful the three lines of defence model may be. The certificate also covers the importance of maintaining strong and productive relations within the Board, ones that are based on trust and which allow for effective meetings and interaction to be achieved. Lastly, emphasis is placed on the modern concepts of Corporate Social Responsibility (CSR), Environmental Social Governance (ESG), and Sustainability, and how the Board needs to respond to these trends as they gain increased relevance and importance for the corporate world. Overall, the knowledge obtained by undertaking this Certificate is an invaluable asset for professionals looking to enhance their career prospects in Corporate Governance. The link between poor corporate governance practices and the excessive taking of risks that led to the downfall or bail-out of important financial institutions necessitated a discussion on how to strengthen corporate governance and protect the economy against similar cases in the future. Effectively, new regulatory requirements have been established, while existing codes of governance have been revised. Such efforts aim to focus on requirements that should be fulfilled by an organisation’s management body and enhance three areas of governance: remuneration, risk management, and internal control. In this programme, participants will review key definitions of corporate governance and the benefits associated with the implementation of good corporate governance practices. More specifically, participants will look in greater detail at the Board of Directors, covering the duties and responsibilities of Directors, the composition of the Board, the role of key post-holders, the many Board committees and how they are structured, and how a Board’s performance can be evaluated. Study method Online, self-paced Course format What's this? Reading material - PDF/e-book, slides, article/plain text Duration 15 hours Access to content 365 days Certification Certificate in Corporate Governance CPD 15 CPD hours / points Certificates AGRC Certificate in Corporate Governance - Free Additional info Exam(s) / assessment(s) is included in price Description The AGRC Certificate in Corporate Governance provides participants with a thorough understanding of a topic that has gained increasing significance and attention amongst corporations, regulators, and researchers. At the same, the Certificate offers guidance as to how corporations can best prepare in creating solid governance structures that will help them deal with the myriad of modern-day corporate challenges and risks. Syllabus: Introduction to Corporate Governance Definition of Corporate Governance Ethics and Governance Key Relevant Governance Theories Agency Theory Stakeholder Theory The Benefits of Corporate Governance Board of Directors Duties and Responsibilities of Directors Specific Requirements for Financial Institutions Board Appointments and Composition Independent and Non-Executive Directors (INEDs) The Importance of Diversity in a Board Committee Structure Board Committees Committee Structure Audit Committee Risk Committee Nominations Committee Remuneration Committees Key Post-Holders in a Board Chair of the Board Senior Independent Director (SID) CEO (Ex-Officio Board Member) Evaluation & Continuous Development Knowledge of Industry and OrganisationInternal Control Mechanisms Internal Controls and Risk Management Three-Lines of Defence model Intra-Board Relations Effective Meetings CSR, ESG and Sustainability Definitions of Relevant Terms Corporate Social Responsibility (CSR) Environmental Social Governance (ESG) Sustainability The Business Case for CSR, ESG, and Sustainability ESG, Sustainability, and the Role of the Board Format • Register at any time for this online, open Certificate • Study in your own time and at your own pace (you have up to 3 months to complete) • Assessed by online multiple-choice exam What is included • 15 hours of self-paced online interactive learning including analysis of 7 practical case studies • 1-year free AGRC membership • Online Exam and AGRC Certificate Who is this course for? This course is ideal for anyone wishing to be introduced to the main regulatory provisions in financial services and trends in corporate governance. Professionals carrying out the roles of directors, members of the Board, senior managers, lawyers, company secretaries, compliance and risk officers, and consultants may benefit from this course. It is also suitable for professionals pursuing regulatory CPDs in financial regulation. Requirements No previous knowledge or experience is required, although it is assumed that participants have good knowledge of English and sound educational background. Certificates AGRC Certificate in Corporate Governance Digital certificate - Included The certificate is issued upon successful passing of the final exam.

Management of Risk (M_o_R®) Practitioner: Virtual In-House Training The M_o_R® Practitioner course has been designed to provide learners with the opportunity to practice the practical application of the M_o_R method and covers the twelve M_o_R principles: Approach, Process and the basic techniques essential to managing risks using the M_o_R guidance. The purpose of the M_o_R Practitioner qualification is to confirm that the learner has achieved sufficient understanding of how to apply and tailor M_o_R in a scenario situation. What you will Learn At the end of the M_o_R Practitioner course, learners will gain competencies in: M_o_R framework (principles, approach based on risk documentation, process steps, and embedding and reviewing M_o_R principles Outline of M_o_R approach documents (including policy, process guide, and risk communications plan) Risk identification, assessment, and control Embedding and reviewing M_o_R M_o_R organizational perspectives (strategic, program, project, operational) Benefits The M_o_R Practitioner course offers a wide-ranging set of guidelines that will help in the management of risk in a project or program environment. It will help prepare learners for the M_o_R Practitioner Exam. They will feel more confident in approaching risk management after attending the course and will be aware of the use of different techniques that can assist in this task, including: Improved basis for effective strategy formation Reduced time spent fire-fighting and fewer unwelcome surprises Increased likelihood of successful change initiative outcomes Closer internal focus on doing the right things properly Increase in efficient use of resources waste and fraud Better management of contingency resources M_o_R roles and responsibilities M_o_R health check M_o_R maturity model Risk specialisms (including business continuity management) Introduction Introduction to the course What is a risk? What is risk management? Why is risk management so important? Basic risk definitions The development of knowledge about risk management Corporate governance and internal control Where and when should risk management be applied? M_o_R Principles The purpose of M_o_R principles Aligns with objectives Fits the context Engages stakeholders Provides clear guidance Informs decision-making Facilitates continual improvement Creates a supportive culture Achieves measurable value Risk management maturity models M_o_R Approach Relationship between the documents Risk management policy Risk management process guide Risk management strategy Risk register Issue register Risk response plan Risk improvement plan Risk communications plan M_o_R Process Common process barriers Identify - contexts Identify - the risks Assess - estimate Assess - evaluate Plan Implement Communication throughout the process M_o_R Perspectives Strategic perspective Programme perspective Project perspective Operational perspective Risk Specialisms Business continuity management Incident and crisis management Health and Safety management Financial risk management Environmental risk management Reputational risk management Contract risk management

This course covers the important topics needed to pass the AWS Certified Data Analytics-Specialty exam (AWS DAS-C01). You will learn about Kinesis, EMR, DynamoDB, and Redshift, and get ready for the exam by working through quizzes, exercises, and practice exams, along with exploring essential tips and techniques.

Homestay language learning holiday

Comprendre les Exigences de l’ISO 22000:2018 et du protocole de certification FSSC 22000 V6 Formation non officielle en français. Dispensée en ligne (Zoom) en direct par notre partenaire Omar Ksibi de Pro Alimentarius. Frais d'examen et de certificat inclus dans le prix.

Manicure is one of the most widely practiced beauty rituals. This course covers the entire manicure procedure using the Spa Ritual line of products. The course is focused on the natural nail, hand and lower forearm anatomy and physiology for a comprehensive understanding of the manicure process. THE REQUIREMENTS No experience is necessary to attend this course. Salon attire must be worn during the course. Student must have clean nail without enhancements. To ensure maximum practice students will be required to work on each other throughout the day. Student need to bring own model for the day 3. COURSE CONTENT Theoretical part: Day 1 /time 10am-18pm Methods of working safely & hygienically and the principles of avoiding cross-infection. Client consultation / record keeping The structure of the natural nail / Contra indications Nail Diseases / Disorders/ Importance of Sanitising and Sterilising Importance of a professional work area and environment / How to organise a workspace Nail treatment preparation Nail Shapes & shine effect Procedure for Manicure (demonstration) Polish Techniques (French & Dark Colour - demonstration) Hand and Nail Treatment (Spa Ritual, Paraffin Wax, Warm Oil ritual) Home care & aftercare advice Practical Part Day 2 / time 10am – 18pm Tool and Product Introduction Manicure Procedures Hand and Nail Treatment Spa Ritual, Paraffin Wax, Warm Oil ritual Hand Massage Nail Painting Professional Advice and tips on fixing mistakes Common problems Exam Day 3 Students need to come with own model. Practical exam duration is 2 hours. Certificates will be issued after the completion of the exam. Price included Kit for work, upon successful completion an course certificate will be awarded

Who is this course suitable for? Required to undertake asbestos fibre counting as part of their work Considering a career in asbestos analysis Responsible for managing asbestos analysts Prior Knowledge and Understanding Candidates for this course are expected to be aware of HSG 248 Asbestos: The Analysts' Guide (July 2021), and in particular Appendix 1, Fibres in air: sampling and evaluation of by phase contrast microscopy. Candidates will preferably have prior experience of analysing fibre count samples and may already be participating in a quality control scheme. In addition, candidates are expected to have had training to cover the core competencies outlined within the foundation material detailed within Table A9.1 of HSG248 Asbestos: The Analysts' Guide (July 2021). This may be achieved by In -house learning or through the P400 foundation module.

The objective of Level 6 Diploma in Tourism and Hospitality Management qualification (accredited by Othm) is to develop learners' management knowledge and skills within the tourism and hospitality industry. Learners will critically evaluate contemporary knowledge and theories and use these to propose solutions to complex management problems. Successful completion of Level 6 Diploma in Tourism and Hospitality Management qualification will equip learners with the specialist skills and knowledge they need to plan and manage their work areas, to make effective decisions, and to adapt effectively to the needs of a range of tourism and hospitality organisations. Program Overview:Key Highlights of Level 6 Diploma in Tourism and Hospitality Management qualification are: Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme LSBR Alumni Status No Cost EMI Option Who is this course for? Who is this Program For?Working Professionals, Level 5 / Year 2 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.