1535 Courses

Indulge in an Inspiration Day creative workshop at Beach Gallery to nurture your soul & awaken your creativity

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who have a basic understanding of Microsoft© Outlook© and want to know how to use its advanced features to manage their email communications, calendar events, contact information, search functions, and other communication tasks. Overview In this course, you will use Outlook?s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings. You will: Insert objects in messages, and modify properties and global options. Organize, search, and manage messages. Protect your mailbox and manage its size. Use rules and Quick Steps to automate message management. Work with advanced calendar settings. Import and forward contacts. Assign delegate permissions and share Outlook items with others. Archive and back up Outlook items using data files. In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you'll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.This course builds upon the foundational knowledge presented in the Microsoft© Outlook© for Office 365? (Desktop or Online): Part 1 course and will help you customize a communication system well-suited to your work style.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 . Modifying Message Properties and Customizing Outlook Topic A: Insert Hyperlinks and Symbols Topic B: Modify Message Properties Topic C: Add Email Accounts to Outlook Topic D: Customize Outlook Options Organizing, Searching, and Managing Messages Topic A: Group and Sort Messages Topic B: Filter and Manage Messages Topic C: Search Outlook Items Managing Your Mailbox Topic A: Manage Junk Email Options Topic B: Manage Your Mailbox Size Automating Message Management Topic A: Use Automatic Replies Topic B: Use Rules to Organize Messages Topic C: Create and Use Quick Steps Working with Calendar Settings Topic A: Set Advanced Calendar Options Topic B: Create and Manage Additional Calendars Topic C: Manage Meeting Responses Managing Contacts Topic A: Import and Export Contacts Topic B: Use Electronic Business Cards Topic C: Forward Contacts Sharing Outlook Items Topic A: Assign and Manage Tasks Topic B: Share Your Calendar Topic C: Share Your Contacts Managing Outlook Data Files Topic A: Use Archiving to Manage Mailbox Size Topic B: Work with Outlook Data Files

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.

Experience the joy of creating with Mokume Gane and make jewellery and small items. It's great fun and you'll love the result.

🚀 Unleash Your Productivity Potential with 'Optimizing Productivity Through Slack Efficiency' 🚀 Are you drowning in a sea of endless Slack messages, struggling to keep your tasks organized and team communication streamlined? It's time to transform the way you work and skyrocket your productivity! Introducing our game-changing online course:   🌟 Optimizing Productivity Through Slack Efficiency 🌟   🚀 Unlock the Power of Slack: Master the Art of Collaboration Discover insider secrets to turn Slack from a communication tool into a productivity powerhouse. Learn how to harness the full potential of channels, threads, and integrations to create a seamless workflow that propels your projects forward. 🔥 Boost Your Team's Efficiency: Strategies for Effective Communication Say goodbye to information overload and hello to clarity! Dive into proven techniques for crafting concise messages, managing notifications, and facilitating focused discussions. Transform your team into a well-oiled machine that accomplishes more in less time. 🎯 Time-Saving Hacks: Work Smarter, Not Harder Explore a treasure trove of time-saving hacks that will revolutionize the way you work in Slack. From keyboard shortcuts to automation tools, we'll teach you how to navigate Slack effortlessly and reclaim precious hours in your day. 🌐 Global Collaboration: Connecting Teams Across Time Zones Crush geographical boundaries and optimize collaboration in a distributed world. Learn strategies for managing time zone differences, scheduling effective meetings, and keeping everyone in the loop, no matter where they are. 🔒 Security and Compliance: Ensure Confidentiality in Every Message Protect sensitive information and maintain compliance effortlessly. Our course covers best practices for secure communication, setting up permissions, and keeping your team's data safe within the Slack ecosystem.   🎓 Why Choose Our Course? ✅ Expert Guidance: Learn from industry experts with years of experience in maximizing productivity through Slack. ✅ Practical Insights: Gain real-world strategies and actionable tips that you can implement immediately. ✅ Interactive Learning: Engage with hands-on exercises, case studies, and live Q&A sessions to solidify your understanding. ✅ Lifetime Access: Enjoy unlimited access to course materials, updates, and a supportive community of fellow learners.   🚨 Don't miss out on the opportunity to revolutionize the way you work! Join 'Optimizing Productivity Through Slack Efficiency' now and take the first step towards a more efficient, collaborative, and successful future. ⏰ Time is of the essence. Enroll today and supercharge your productivity with Slack mastery! ⏰   🚀 Elevate Your Productivity, Transform Your Workflow, Master Slack Efficiency! 🚀 Course Curriculum Basic Overview 00:00 Pricing 00:00 Account Opening 00:00 Profile and Multiple Workspaces 00:00 Desktop and Mobile Software 00:00 Customizing the Workspace - Part 1 00:00 Customizing the Workspace - Part 2 00:00 Settings and Preferences 00:00 Settings and Preferences - Part 2 00:00 Members and User Groups 00:00 Built In Recordings 00:00 Zapier Integrations 00:00 Creating Channels - Part 1 00:00 Creating Channels - Part 2 00:00 Sending Direct Messages 00:00 Creating Message Posts - Part 1 00:00 Creating Message Posts - Part 2 00:00 Analytics 00:00 Search 00:00 Conclusion 00:00 Advance Overview and Skype Integration 00:00 Meeting Live - Zoom Integration 00:00 Sharing Meeting Recordings - YouTube Integration 00:00 Sharing Meeting Recordings - YouTube Integration - Part 2 00:00 Sharing Google Docs - Part 1 00:00 Sharing Google Docs - Part 2 00:00 Sharing Google Calendar 00:00 WordPress Website Updates with Slack - Part 1 00:00 WordPress Website Updates with Slack - Part 2 00:00 Slack Storage - Google Drive 00:00 Slack Storage - Dropbox 00:00 Client and Customer Management - Stripe 00:00 Client and Customer Management - Paypal 00:00 Client and Customer Management - Getresponse 00:00 Client and Customer Management - Mailchimp 00:00 LIve Example - Channel Creation 00:00 Live Example - Team Invitations 00:00 Live Meeting Creation 00:00 Live Meeting Archive 00:00 Conclusion 00:00

Visualize charts and visuals in Tableau Desktop

A fantastic online one-to-one diploma course for those looking to become a successful graphic designer

A complete step by step workshop on how to make a crow character with a top hat. The video is structured so that you can work along with me or pause/fast forward at will. If you have any questions please feel free to send me a message :) The video lasts for two hours. You will need: clay, tools, rolling pin, slip, You could also use air dry clay

I am able to travel to you to help you develop your partnership with your horse. I specialise in developing confidence in both horse and rider both on the flat and over fences. As a list 5 BD Dressage judge I can help you with test riding for BD Intro, Prelim and Novice tests. I can help with BE 90, 100 & Novice tests. As I am training for list 4 I can also help you with Elementary BD and Intermediate BE The times listed are a general guide of my availability. If you would prefer a time that is not listed please select the time that is closest to you preference, the message me via Email, WhatsApp or Facebook to see if we can arrange a better time for you. Instructions Make sure we have access to an arena, with a poop scoop and poles if you want them.

A digital step by step guide showing you how to make a little mouse character. The workshop will be sent to your email address so please make sure that is correct when you check out. I hope you enjoy and please feel free to message for any advice and if you would like to be in the visitors gallery then please feel free to send a picture of your finished sculpture. Enjoy!