1955 Running courses

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Enhance your expertise in petroleum geomechanics with Energy Edge's advanced course. Gain practical skills and knowledge to tackle complex geomechanical challenges.

Unlock the secrets to entrepreneurial success with our 'Start Up' course. Dive into the world of startups and discover how institutions, tasks, stakeholders, and more shape these ventures.

Dive deep into well integrity management with EnergyEdge's classroom training. Take your skills to the next level today!

Are you an ambitious, entrepreneurial business owner with a collaborative mindset? You are? Good! You're in the right place. Running your own business can be tough and the odds are against you - but don't worry! The support you need is on your doorstep - at next to no cost!

PADI Speciality Scuba Diving BCD regulator drysuit

Learn to create cushions for your home, we will cover a basic cushion and also piping, ruffles and zip insertion.

Description Learn how to train animals, walk them safely, look after them and start your own pet business! This Pet Business Certificate starts with the basics of first aid and find out how to administer pills, liquid medications, and injections to an uncooperative cat or dog. You will explore pet care, including nutrition, exercise, first aid, and identification of common diseases. You'll also explore sticky situations that can arise, such as lost pets, pets that die unexpectedly, and pets that need immediate veterinary care. You will learn about finances and explore start-up costs, accounting, fee-setting, business plans, and low-cost marketing. You'll learn how to obtain required insurance, hire employees as your business expands, and entice financial institutions to loan you money.  By the end of this course, you'll have all the knowledge you need to become a professional pet sitter. In addition, you'll see how your pet sitting business can grow to continually challenge and satisfy you. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is This Pet Business Certificate Course for? Pet Business Certificate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Pet Business Certificate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction 00:06:00 Legal Requirements Legal Requirements 00:37:00 Running Your Own Business Running Your Own Business 00:16:00 Marketing Marketing 00:16:00 Setting Your Prices Setting Your Prices 00:11:00 Business Costs Business Costs 00:08:00 Forms & Record Keeping Forms & Record Keeping 00:15:00 Pre-Service Visit Pre-Service Visit 00:07:00 Difficulties & Challenges Difficulties & Challenges 00:17:00 Assessment Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

If you’re a beginner bag maker, this Retreat is perfect for you. A whole weekend to immerse yourself in fabrics, stabiliser, professional techniques and tips to boost your confidence and your skills. Hopefully, there’ll be a lot of chat and laughter too! **This retreat is a little different from many others in that making a bag isn’t the point of the weekend, although you will indeed make one. The focus is on learning new transferable techniques and skills that you will be able to use on so many bags you make in the future. We have our own ‘Retreat Suite’ of rooms, including a spacious, light and airy sewing room which is equipped with a display screen so everyone can easily see demonstrations from a working viewpoint. We also have our own bathroom and kitchen facilities. If you wish, you are free to continue work after dinner and until as late (or early!) as you like. You will need to bring your own sewing machine, fabric scissors and any other favourite sewing tools, but everything else is provided. Come and join us in the exclusive Facebook group Bag Makers Retreat at https://www.facebook.com/groups/bagmakersretreat/ for all the latest retreat info, chat, gossip and more, plus a chance to meet other like-minded folks.  If you have dietary requirements, please tell me before you book, so I can be sure we can meet your needs. All meal main courses are included in the retreat fee, as are Saturday and Sunday lunches and breakfasts. Starters, desserts and drinks with meals are not included but the meals are so huge you probably won’t want starters and desserts anyway!! Tea and coffee is available whenever you need, but you do have to make it yourself!  If you’d like to stay an extra night or two, maybe to arrive on Thursday or leave on Monday if you have a long drive, let me know and I’ll check availability with our host. If you’d prefer to travel by train, we are happy to ferry you to and from the station, just ask. Please aim to arrive no later than 2pm as we have a lot of pattern cutting and fabric choosing to get through on Friday! Friday The fun starts here as you arrive at your weekend home-from-home – a beautifully refurbished, 4-star 18th century coaching inn with all the comforts you would expect. You’ll have time to settle into your own delightfully comfortable en-suite room which has all the anticipated little luxuries, before an introductory get-together with me and your companions in the sewing room at 2pm. You’ll be given your own copy of the bag pattern, which is very beginner- and domestic machine-friendly but which will incorporate a lot of features and techniques that are also in much more complex designs, making this an excellent springboard to any bag you want to make. Then you can wallow in the plentiful stash of fabrics to choose from, including some of my exclusive feature panel prints which aren’t available anywhere else. All the materials, interfacing, stabiliser, threads and bag hardware you need are supplied. As soon as you’re ready, you can start preparing and cutting out your pattern and some of the bag pieces so we can hit the ground running in the morning. After a superbly-cooked and substantial evening meal at around 6pm or so, you are welcome to continue working in the sewing room or to simply relax and chat there before bed. Saturday After an excellent breakfast, we can really start work adding to and adapting your bag pattern. You’ll work at your own pace from around 9am with no pressure – I want your weekend to be fun and not stressful! We will walk through the techniques together and I will be there the whole time to answer questions and troubleshoot any tricky bits. You’ll also have the chance to try sewing with faux leather , if you haven’t already, and we’ll explore ways and techniques to use and apply rivets.  Refreshments are freely available all day and you can take a break whenever you wish. A light lunch (with homemade cake!!) is also provided and we’ll have a short break in the middle of the day. The rest of the day will be similar to Friday – sewing, dinner at 6ish and more sewing if you wish to before bed. Do feel free to have a walk or just sit outside for a breather if the weather is kind. Sunday How can it be Sunday already?? Breakfast over, we’ll get back to work. You will need to allow a few minutes to pack and check out of your room, as it has to be made ready for Monday’s guests. Apart from that, it’s uninterrupted sewing (with refreshments and lunch breaks!) until your bag is finished. We’ll be heading off for lunch at 12.30pm or so. We have the sewing room for the rest of the day. If you don’t quite get done, there’s absolutely no need to worry as you’ll easily be able to complete your bag at home. If you finish earlier feel free to head home whenever you’re ready. Amongst loads of other hints and tips, you’ll learn – Interfacings – what to use and not to use Using stabilisers – which is best and why How to create a zipped pocket the pro way Adding a recessed zipper main closure to almost any bag Installing hardware Incorporating a built-in key fob Installing a rectangular base Sewing the bag together and topstitching A sneaky way of getting your bag right-sides-out without ugly seams! An easy way to add a zipper pull without tools Working with different types of rivet machine Faux leather on a domestic machine You’ll have handouts on all the techniques to take home. And I hope you have a lot of fun and make new friends while you learn!!  I never abandon my students at the end of the course so if you get stuck on anything at home, you are welcome to give me a shout on Messenger and we’ll sort out your problem together. The not-so-small print Book your place using the simple booking system below – just click on your choice of dates and go from there. The full price is £395.00. The deposit of £60 is non-refundable if you cancel but can, however, be credited towards a future retreat booked within the next 6 months. It is completely refundable if I or the venue cancel. The booking page only shows the Friday, but the course is running until Sunday. The balance of £335.00 is payable by approx 6 weeks before the retreat date and payment instructions will be sent to you in good time. Cancellations 4 weeks or less before the retreat date can only be refunded if someone on the waiting list can come instead. *Don’t worry that your booking confirmation may be headed Unicorn Studios – it’s just the site that I’ve run my booking system from for years… it’s not a scam!! *

Duration 4 Days 24 CPD hours This course is intended for The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications. This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Prerequisites In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses: AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Prepare to maintain SQL databases on Azure Describe Microsoft Intelligent Data Platform roles Understand SQL Server in an Azure virtual machine Design Azure SQL Database for cloud-native applications Explore Azure SQL Database Managed Instance 2 - Deploy IaaS solutions with Azure SQL Explain IaaS options to deploy SQL Server in Azure Understand hybrid scenarios Explore performance and security Explain high availability and disaster recovery options 3 - Deploy PaaS solutions with Azure SQL Explain PaaS options for deploying SQL Server in Azure Explore single SQL database Deploy SQL database elastic pool Understand SQL database hyperscale Examine SQL managed instance Describe SQL Edge 4 - Evaluate strategies for migrating to Azure SQL Understand compatibility level Understand Azure preview features Describe Azure database migration options 5 - Migrate SQL workloads to Azure SQL databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL Database offline Migrate SQL Server to Azure SQL Database online Load and move data to Azure SQL Database 6 - Migrate SQL workloads to Azure Managed Instances Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed Instance Load and Move data to SQL Database Managed Instance 7 - Configure database authentication and authorization Describe Active Directory and Azure Active Directory Describe authentication and identities Describe Security Principals Describe database and object permissions Identify authentication and authorization failures 8 - Protect data in-transit and at rest Explore Transparent Data Encryption Configure server and database firewall rules Explain object encryption and secure enclaves Enable encrypted connections Describe SQL injection Understand Azure Key Vault 9 - Implement compliance controls for sensitive data Explore data classification Explore server and database audit Implement Dynamic Data Masking Implement Row Level security Understand Microsoft Defender for SQL Explore Azure SQL Database Ledger Implement Azure Purview 10 - Describe performance monitoring Describe performance monitoring tools Describe critical performance metrics Establish baseline metrics Explore extended events Describe Azure SQL Insights Explore Query Performance Insight 11 - Configure SQL Server resources for optimal performance Explain how to optimize Azure storage for SQL Server virtual machines Describe virtual machine resizing Optimize database storage Control SQL Server resources 12 - Configure databases for optimal performance Explore database maintenance checks Describe database scoped configuration options Describe automatic tuning Describe intelligent query processing 13 - Explore query performance optimization Understand query plans Explain estimated and actual query plans Describe dynamic management views and functions Explore Query Store Identify problematic query plans Describe blocking and locking 14 - Evaluate performance improvements Describe wait statistics Tune and maintain indexes Understand query hints 15 - Explore performance-based design Describe normalization Choose appropriate data types Design indexes 16 - Automate deployment of database resources Describe deployment models in Azure Automate deployment by using Azure Resource Manager templates and Bicep Automate deployment by using PowerShell Automate deployment by using Azure CLI 17 - Create and manage SQL Agent jobs Create a SQL Server maintenance plan Describe task status notifications 18 - Manage Azure PaaS tasks using automation Explore Elastic jobs Understand Azure Automation Build an automation runbook Automate database workflows by using Logic Apps Monitor automated tasks 19 - Describe high availability and disaster recovery strategies Describe recovery time objective and recovery point objective Explore high availability and disaster recovery options Describe Azure high availability and disaster recovery features for Azure Virtual Machines Describe high availability and disaster recovery options for PaaS deployments Explore an IaaS high availability and disaster recovery solution Describe hybrid solutions 20 - Explore IaaS and PaaS solutions for high availability and disaster recovery Describe failover clusters in Windows Server Configure Always-on availability groups Describe temporal tables in Azure SQL Database Describe active geo-replication for Azure SQL Database Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance 21 - Back up and restore databases Back up and restore SQL Server running on Azure virtual machines Back up a SQL Server virtual machine Back up and restore a database using Azure SQL Database Additional course details: Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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 DP-300T00: Administering Microsoft Azure SQL Solutions 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.