11 NOS courses in Cardiff

Essential SDN training course description Software Defined Networking (SDN) has become one of the industries most talked technologies. This training course cuts through the hype and looks at the technology, architecture and products available for SDN along with looking at the impact it may have on your network. What will you learn Explain how SDN works. Describe the architecture of SDN. Explain the relationship between SDN and OpenFlow. Recognise the impact SDN will have on existing networks. Essential SDN training course details Who will benefit: Anyone wishing to know more about SDN. Prerequisites: None. Duration 2 days Essential SDN training course contents Introduction What is SDN? What is OpenFlow? SDN benefits. The SDN stack and architecture. SDN architecture SDN applications, SDN switches, SDN controllers, Network Operating Systems. Control plane, data plane. Control to Data Plane Interface (CDPI), Northbound interfaces. SDN components, control and data plane abstractions. Network Operating Systems Finding the topology, Global view, control program, configuration based on views, graph algorithm. OpenFlow Just one part of SDN. Open Networking Foundation, OpenFlow ports, Flow tables, OpenFlow Channels. The OpenFlow protocol, OpenFlow header, OpenFlow operations. OpenFlow versus OpFlex. SDN and open source OpenDaylight, OpenVSwitch, Open Networking Forum, Open Network Operating System. OpenStack Neutron. SDN implications Separation of control and data plane, NOS running on servers, Emphasis on edge complexity, core simplicity, OpenvSwitch, Incremental migration, importance of software. SDN vs NVF.

Security+ training course description A hands on course aimed at getting delegates successfully through the CompTia Security+ examination. What will you learn Explain general security concepts. Describe the security concepts in communications. Describe how to secure an infrastructure. Recognise the role of cryptography. Describe operational/organisational security. Security+ training course details Who will benefit: Those wishing to pass the Security+ exam. Prerequisites: TCP/IP foundation for engineers Duration 5 days Security+ training course contents General security concepts Non-essential services and protocols. Access control: MAC, DAC, RBAC. Security attacks: DOS, DDOS, back doors, spoofing, man in the middle, replay, hijacking, weak keys, social engineering, mathematical, password guessing, brute force, dictionary, software exploitation. Authentication: Kerberos, CHAP, certificates, usernames/ passwords, tokens, biometrics. Malicious code: Viruses, trojan horses, logic bombs, worms. Auditing, logging, scanning. Communication security Remote access: 802.1x, VPNs, L2TP, PPTP, IPsec, RADIUS, TACACS, SSH. Email: S/MIME, PGP, spam, hoaxes. Internet: SSL, TLS, HTTPS, IM, packet sniffing, privacy, Javascript, ActiveX, buffer overflows, cookies, signed applets, CGI, SMTP relay. LDAP. sftp, anon ftp, file sharing, sniffing, 8.3 names. Wireless: WTLS, 802.11, 802.11x, WEP/WAP. Infrastructure security Firewalls, routers, switches, wireless, modems, RAS, PBX, VPN, IDS, networking monitoring, workstations, servers, mobile devices. Media security: Coax, UTP, STP, fibre. Removable media. Topologies: Security zones, DMZ, Intranet, Extranet, VLANs, NAT, Tunnelling. IDS: Active/ passive, network/host based, honey pots, incident response. Security baselines: Hardening OS/NOS, networks and applications. Cryptography basics Integrity, confidentiality, access control, authentication, non-repudiation. Standards and protocols. Hashing, symmetric, asymmetric. PKI: Certificates, policies, practice statements, revocation, trust models. Key management and certificate lifecycles. Storage: h/w, s/w, private key protection. Escrow, expiration, revocation, suspension, recovery, destruction, key usage. Operational/Organisation security Physical security: Access control, social engineering, environment. Disaster recovery: Backups, secure disaster recovery plans. Business continuity: Utilities, high availability, backups. Security policies: AU, due care, privacy, separation of duties, need to know, password management, SLAs, disposal, destruction, HR policies. Incident response policy. Privilege management: Users, groups, roles, single sign on, centralised/decentralised. Auditing. Forensics: Chain of custody, preserving and collecting evidence. Identifying risks: Assets, risks, threats, vulnerabilities. Role of education/training. Security documentation.

The aim of the Level 2 Diploma in Care - fast track mode (Accredited by Qualifi, UK) is to confirm occupational competence for Adult Care Workers or Healthcare Support Workers. This Level 2 Diploma in Care (fast track mode) qualification offers the opportunity for learners to demonstrate their knowledge, understanding and practical skills required to be an Adult Care Worker in an adult care setting or a Healthcare Assistant; Support Worker or Personal Assistant in a healthcare support environment. At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care (fast track mode) qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant The Level 2 Diploma in Care (fast track) will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding The Level 2 Diploma in Care qualification links with the requirements for the National Occupational Standards (NOS) for Health and Social Care. Program Overview: Level 2 Diploma in Care Key Highlights of Level 2 Diploma in Care qualification are: Program Duration: 9 Months (Fast track mode available) Program Credits: 46 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. Alumni Status No Cost EMI Option Mandatory units (Total Credits: 24) The Qualifi Level 2 Diploma in Care qualification consists of 9 mandatory units for a combined total of 24 credits Communication in Care Settings (3 credits) Duty of Care (1 credits) Equality, Diversity and Inclusion in Care Settings (2 credits) Handle Information in Care Settings (1 credits) Health, Safety and Well-being in Care Settings (4 credits) Implement Person-Centred Approaches (5 credits) Personal Development in Care Settings (3 credits) Responsibilities of a Care Worker (2 credits) Safeguarding and Protection in Care Settings (3 credits) Optional Units (Total Credits: 22) The learner must also achieve a minimum of 22 credits from these units. Introductory Awareness of Autistic Spectrum Conditions (2 credits) Understand the Context of Supporting People with Learning Disabilities (4 credits) Assist in the Administration of Medication (4 credits) Contribute to Support Positive Risk-Taking of Individuals (3 credits) Contribute to Support Learning Disabilities to Access Healthcare (3 credits) Promote Positive Behaviour Support (6 credits) Awareness of the Mental Capacity Act 2005 (3 credits) Understand Mental Health Problems (3 credits) Understand Mental Well-Being and Mental Health Promotion (3 credits) Enable Individuals to Develop Strategies to Manage their Behaviour (8 credits) Support Independence in the Tasks of Daily Living (5 credits) Understand how to Support Individuals to be part of a Community (3 credits) Understand the Impact of Acquired Brain Injury on Individuals (3 credits) Who is this course for? At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant Requirements The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding Career path Achievement of Level 2 Diploma in Care qualification confirms the learner has gained the knowledge and skills required to: Gain employment as a Healthcare Assistant / Support Worker or Adult Care Worker / Personal Assistant Progress onto the Qualifi Level 3 Diploma in Health and Social Care Progress onto the Level 3 Lead Adult Care Worker Apprenticeship.

The aim of the Level 2 Diploma in Care (Accredited by Qualifi, UK) is to confirm occupational competence for Adult Care Workers or Healthcare Support Workers. This Level 2 Diploma in Care qualification offers the opportunity for learners to demonstrate their knowledge, understanding and practical skills required to be an Adult Care Worker in an adult care setting or a Healthcare Assistant; Support Worker or Personal Assistant in a healthcare support environment. At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding The Level 2 Diploma in Care qualification links with the requirements for the National Occupational Standards (NOS) for Health and Social Care. Program Overview: Level 2 Diploma in Care Key Highlights of Level 2 Diploma in Care qualification are: Program Duration: 9 Months (Fast track mode available) Program Credits: 46 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. Alumni Status No Cost EMI Option Mandatory units (Total Credits: 24) The Qualifi Level 2 Diploma in Care qualification consists of 9 mandatory units for a combined total of 24 credits Communication in Care Settings (3 credits) Duty of Care (1 credits) Equality, Diversity and Inclusion in Care Settings (2 credits) Handle Information in Care Settings (1 credits) Health, Safety and Well-being in Care Settings (4 credits) Implement Person-Centred Approaches (5 credits) Personal Development in Care Settings (3 credits) Responsibilities of a Care Worker (2 credits) Safeguarding and Protection in Care Settings (3 credits) Optional Units (Total Credits: 22) The learner must also achieve a minimum of 22 credits from these units. Introductory Awareness of Autistic Spectrum Conditions (2 credits) Understand the Context of Supporting People with Learning Disabilities (4 credits) Assist in the Administration of Medication (4 credits) Contribute to Support Positive Risk-Taking of Individuals (3 credits) Contribute to Support Learning Disabilities to Access Healthcare (3 credits) Promote Positive Behaviour Support (6 credits) Awareness of the Mental Capacity Act 2005 (3 credits) Understand Mental Health Problems (3 credits) Understand Mental Well-Being and Mental Health Promotion (3 credits) Enable Individuals to Develop Strategies to Manage their Behaviour (8 credits) Support Independence in the Tasks of Daily Living (5 credits) Understand how to Support Individuals to be part of a Community (3 credits) Understand the Impact of Acquired Brain Injury on Individuals (3 credits) Who is this course for? At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant Requirements The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding Career path Achievement of Level 2 Diploma in Care qualification confirms the learner has gained the knowledge and skills required to: Gain employment as a Healthcare Assistant / Support Worker or Adult Care Worker / Personal Assistant Progress onto the Qualifi Level 3 Diploma in Health and Social Care Progress onto the Level 3 Lead Adult Care Worker Apprenticeship.

Make your life easier, learn how to communicate effectively Do you want to be a good communicator? Professional training for salespeople complete with a certificate Learn how to enter into contracts and how to bookkeep including accounting for travel. Learn from the best in the industry An employment law specialist with extensive experience will be leading the course. Test your knowledge Take the tests and practical tasks in the course to consolidate your knowledge and skills. Take the most effective and comprehensive sales training on the Polish Internet. Join the best salespeople in the business and rocket the sales in your company. In this training discover how the most professional salespeople work every day. Learn how they attract their customers, make business connections, arrange meetings, have key conversations and most importantly how they finalize deals and close contracts. You’ll discover all of this and more with concrete real life examples from a TOP salesperson and manager with 12 years of experience in professional sales. By taking this course you will have instant access to the practices of one of the best salespeople in the business who will also show you their sales process from A to Z as well as interviews with real clients. The sales training is done through the National Education Center’s interactive platform and includes invaluable resources such as a hybrid workshop with practical tasks and training for salespeople complete with expert feedback. Parts of the course will require active participation in order to complete the training. You can take the course at your own pace from the comfort of your own home and will have access to the materials on the interactive platform for two years after completing the course Join the communication course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Faustine Parsons Communication expert Faustine is a manager, speaker and communication expert. She has over 14 years of experience in coaching and developing people skills for SMEs and international corporations. As a manager, she saw firsthand the importance of an effective team cooperation and got involved in the field. As a consultant, she specialized in smoothing the information exchange, bringing down barriers and creating a positive atmosphere throughout the organization. She developed skills and techniques which solved many of her clients’ problems. She combines the theory of psychology with down to earth practical approach. Let her guide you during the exciting journey through the dynamics of human interactions. Get ready for an interesting and fun ride, as her passion and positivity is contagious from the very beginning. Overview of the course: Detailed video presentations and training videos Fundamentals of effective communication Emotions and problems Daily communication at work and at home Business environment Advanced subjects Repetitions and tests Five repetitions Five tests Final exam  Exercises and practial tasks Mapping good and bad practices Recognizing styles, behaviors and personalities Troubleshooting and dispute resolving in practice Giving feedback Overcoming challenges in your position All in one simulation Bonus materials Best practices kaizen map Scenarios and phrases for everyday situations Communication no-nos guide Personalities compendium Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: Many professionals encounter communication problems both at home and at work. They manifest themselves in misunderstandings, disputes and tension. It does not have to be this way. It all boils down to communication skills. For people and organizations who master them, everything comes easy.In my career, I have seen tremendous transformations on this front. Join me in this unique course and let me show you many of the best practices and techniques to make your life easier. Believe in yourself and make the most of your opportunities. Invest in your communication skills today!Faustine ParsonsCommunication expert

MASTERCLASS 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! On this course, we aim to help you master a technique that will set you apart from most routine cosmetic treatment providers and enable you to step into the future of advanced cosmetic. Training THEORY will enable you to understand: Anatomy Vascular Supply, Nerves on the face Contraindications Patient consultation ONE-TO-ONE Training Nose Job Masterclass You will perform this procedure on live models under the supervision and guidance of highly experienced aesthetic practitioners. You will be trained under ENT specialist. We will give you all the knowledge you need for a safe technique in your practice. A certification of training will be provided upon completion of the course. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL EXPERT | Masterclass Course

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Duration 5 Days 30 CPD hours This course is intended for Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam. This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions. Prerequisites To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces. 1 - Explore Azure App Service Examine Azure App Service Examine Azure App Service plans Deploy to App Service Explore authentication and authorization in App Service Discover App Service networking features 2 - Configure web app settings Configure application settings Configure general settings Configure path mappings Enable diagnostic logging Configure security certificates 3 - Scale apps in Azure App Service Examine autoscale factors Identify autoscale factors Enable autoscale in App Service Explore autoscale best practices 4 - Explore Azure App Service deployment slots Explore staging environments Examine slot swapping Swap deployment slots Route traffic in App Service 5 - Explore Azure Functions Discover Azure Functions Compare Azure Functions hosting options Scale Azure Functions 6 - Develop Azure Functions Explore Azure Functions development Create triggers and bindings Connect functions to Azure services 7 - Explore Azure Blob storage Explore Azure Blob storage Discover Azure Blob storage resource types Explore Azure Storage security features Discover static website hosting in Azure Storage 8 - Manage the Azure Blob storage lifecycle Explore the Azure Blob storage lifecycle Discover Blob storage lifecycle policies Implement Blob storage lifecycle policies Rehydrate blob data from the archive tier 9 - Work with Azure Blob storage Explore Azure Blob storage client library Create a client object Manage container properties and metadata by using .NET Set and retrieve properties and metadata for blob resources by using REST 10 - Explore Azure Cosmos DB Identify key benefits of Azure Cosmos DB Explore the resource hierarchy Explore consistency levels Choose the right consistency level Explore supported APIs Discover request units 11 - Work with Azure Cosmos DB Explore Microsoft .NET SDK v3 for Azure Cosmos DB Create stored procedures Create triggers and user-defined functions Explore change feed in Azure Cosmos DB 12 - Manage container images in Azure Container Registry Discover the Azure Container Registry Explore storage capabilities Build and manage containers with tasks Explore elements of a Dockerfile 13 - Run container images in Azure Container Instances Explore Azure Container Instances Run containerized tasks with restart policies Set environment variables in container instances Mount an Azure file share in Azure Container Instances 14 - Implement Azure Container Apps Explore Azure Container Apps Explore containers in Azure Container Apps Implement authentication and authorization in Azure Container Apps Manage revisions and secrets in Azure Container Apps Explore Dapr integration with Azure Container Apps 15 - Explore the Microsoft identity platform Explore the Microsoft identity platform Explore service principals Discover permissions and consent Discover conditional access 16 - Implement authentication by using the Microsoft Authentication Library Explore the Microsoft Authentication Library Initialize client applications 17 - Implement shared access signatures Discover shared access signatures Choose when to use shared access signatures Explore stored access policies 18 - Explore Microsoft Graph Discover Microsoft Graph Query Microsoft Graph by using REST Query Microsoft Graph by using SDKs Apply best practices to Microsoft Graph 19 - Implement Azure Key Vault Explore Azure Key Vault Discover Azure Key Vault best practices Authenticate to Azure Key Vault 20 - Implement managed identities Explore managed identities Discover the managed identities authentication flow Configure managed identities Acquire an access token 21 - Implement Azure App Configuration Explore the Azure App Configuration service Create paired keys and values Manage application features Secure app configuration data 22 - Explore API Management Discover the API Management service Explore API gateways Explore API Management policies Create advanced policies Secure APIs by using subscriptions Secure APIs by using certificates 23 - Explore Azure Event Grid Explore Azure Event Grid Discover event schemas Explore event delivery durability Control access to events Receive events by using webhooks Filter events 24 - Explore Azure Event Hubs Discover Azure Event Hubs Explore Event Hubs Capture Scale your processing application Control access to events Perform common operations with the Event Hubs client library 25 - Discover Azure message queues Choose a message queue solution Explore Azure Service Bus Discover Service Bus queues, topics, and subscriptions Explore Service Bus message payloads and serialization Explore Azure Queue Storage Create and manage Azure Queue Storage and messages by using .NET 26 - Monitor app performance Explore Application Insights Discover log-based metrics Instrument an app for monitoring Select an availability test Troubleshoot app performance by using Application Map 27 - Develop for Azure Cache for Redis Explore Azure Cache for Redis Configure Azure Cache for Redis Interact with Azure Cache for Redis by using .NET 28 - Develop for storage on CDNs Explore Azure Content Delivery Networks Control cache behavior on Azure Content Delivery Networks Interact with Azure Content Delivery Networks by using .NET

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Duration 3 Days 18 CPD hours This course is intended for The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - Discover data analysis Overview of data analysis Roles in data Tasks of a data analyst 2 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 3 - Get data in Power BI Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors 4 - Clean, transform, and load data in Power BI Shape the initial data Simplify the data structure Evaluate and change column data types Combine multiple tables into a single table Profile data in Power BI Use Advanced Editor to modify M code 5 - Design a semantic model in Power BI Work with tables Create a date table Work with dimensions Define data granularity Work with relationships and cardinality Resolve modeling challenges 6 - Add measures to Power BI Desktop models Create simple measures Create compound measures Create quick measures Compare calculated columns with measures 7 - Add calculated tables and columns to Power BI Desktop models Create calculated columns Learn about row context Choose a technique to add a column 8 - Use DAX time intelligence functions in Power BI Desktop models Use DAX time intelligence functions Additional time intelligence calculations 9 - Optimize a model for performance in Power BI Review performance of measures, relationships, and visuals Use variables to improve performance and troubleshooting Reduce cardinality Optimize DirectQuery models with table level storage Create and manage aggregations 10 - Design Power BI reports Design the analytical report layout Design visually appealing reports Report objects Select report visuals Select report visuals to suit the report layout Format and configure visualizations Work with key performance indicators 11 - Configure Power BI report filters Apply filters to the report structure Apply filters with slicers Design reports with advanced filtering techniques Consumption-time filtering Select report filter techniques Case study - Configure report filters based on feedback 12 - Enhance Power BI report designs for the user experience Design reports to show details Design reports to highlight values Design reports that behave like apps Work with bookmarks Design reports for navigation Work with visual headers Design reports with built-in assistance Tune report performance Optimize reports for mobile use 13 - Perform analytics in Power BI Explore statistical summary Identify outliers with Power BI visuals Group and bin data for analysis Apply clustering techniques Conduct time series analysis Use the Analyze feature Create what-if parameters Use specialized visuals 14 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 15 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method Additional course details: Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.