30618 TEC courses

Gain essential knowledge and practical skills to accurately monitor and interpret physiological parameters in patients with our "An Understanding of Physiological Observations" course. Learn to conduct and interpret various observations to support informed clinical decision-making.

The aim of this module is to enable delegates to perform entry-type injured person rescue operations, in a Wind Turbine Generator, using industry standard rescue equipment, rescue methods and techniques, exceeding those of GWO Working at Heights. Valid GWO BST Module Working at Heights, GWO First aid and GWO Manual Handling certificates are prerequisites for participation.

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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-080T00 Querying Data with Microsoft Transact-SQL 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.

Why not treat yourself to a deluxe culinary experience? A two week cookery course immersing you in a wonderful world of tastes, techniques and cookery skills to leave you a more confident cook. This course is ideal for the home cook who is looking to get more from their cookery and learn new tricks and techniques as well as discovering a wider range of cuisines and ingredients. Or maybe you are thinking about a career in food and drink? This is the perfect taster as you begin your culinary journey. What’s included on the course? International dishes from India, Thailand, North Africa, China, France, Italy and the Middle East. How to make Fresh Pasta and delicious Ravioli and Tortellini with different sauces to accompany them. A range of pastries including Rough Puff, Shortcrust, Hot Water Crust and Choux. Seafood - Preparing gorgeous local scallops from scratch as well as filleting a Flat Fish, a Round Fish and learning different techniques to cook them. A range of Breads. Farmhouse, Ciabatta, Soda Bread, Flat Breads and Sourdough are all covered. Basic butchery. How to joint a chicken. Ice creams and sorbets. Dairy. How to make your own Butter, Yoghurt and Soft Cheese. Stocks and Sauces. Cover Vegetarian and Vegan Cookery. How to use Herbs to best effect. The importance of Seasoning. A visit to a local Scottish Assured Venison Park and Venison Cookery. And lots more…

Why not treat yourself to a deluxe culinary experience? A two week cookery course immersing you in a wonderful world of tastes, techniques and cookery skills to leave you a more confident cook. This course is ideal for the home cook who is looking to get more from their cookery and learn new tricks and techniques as well as discovering a wider range of cuisines and ingredients. Or maybe you are thinking about a career in food and drink? This is the perfect taster as you begin your culinary journey. What’s included on the course? International dishes from India, Thailand, North Africa, China, France, Italy and the Middle East. How to make Fresh Pasta and delicious Ravioli and Tortellini with different sauces to accompany them. A range of pastries including Rough Puff, Shortcrust, Hot Water Crust and Choux. Seafood - Preparing gorgeous local scallops from scratch as well as filleting a Flat Fish, a Round Fish and learning different techniques to cook them. A range of Breads. Farmhouse, Ciabatta, Soda Bread, Flat Breads and Sourdough are all covered. Basic butchery. How to joint a chicken. Ice creams and sorbets. Dairy. How to make your own Butter, Yoghurt and Soft Cheese. Stocks and Sauces. Cover Vegetarian and Vegan Cookery. How to use Herbs to best effect. The importance of Seasoning. A visit to a local Scottish Assured Venison Park and Venison Cookery. And lots more…

Why not treat yourself to a deluxe culinary experience? A two week cookery course immersing you in a wonderful world of tastes, techniques and cookery skills to leave you a more confident cook. This course is ideal for the home cook who is looking to get more from their cookery and learn new tricks and techniques as well as discovering a wider range of cuisines and ingredients. Or maybe you are thinking about a career in food and drink? This is the perfect taster as you begin your culinary journey. What’s included on the course? International dishes from India, Thailand, North Africa, China, France, Italy and the Middle East. How to make Fresh Pasta and delicious Ravioli and Tortellini with different sauces to accompany them. A range of pastries including Rough Puff, Shortcrust, Hot Water Crust and Choux. Seafood - Preparing gorgeous local scallops from scratch as well as filleting a Flat Fish, a Round Fish and learning different techniques to cook them. Baking a different loaf of Bread every day. Farmhouse, Ciabatta, Soda Bread, Flat Breads and Sourdough are all covered. Basic butchery. How to joint a chicken. Ice creams and sorbets. Dairy. How to make your own Butter, Yoghurt and Soft Cheese. Stocks and Sauces. Cover Vegetarian and Vegan Cookery. How to use Herbs to best effect. The importance of Seasoning. A visit to a local Scottish Assured Venison Park and Venison Cookery. And lots more…

Course Overview: This course provides in-depth knowledge of cinematography and directing, including the use of different cameras, lighting setups, metering techniques, and creative direction. Students will learn to master key elements of production and post-production processes. Hourly Session Breakdown: 8 one-hour sessions on Skype.

The Buccal (Oromucosal) Midazolam Competent Reviewer / Assessor Training is designed to provide participants with comprehensive knowledge and skills necessary to assess and review the administration of buccal (oromucosal) midazolam for the management of acute prolonged and repetitive seizures.

Gain the knowledge and skills to identify acute illness in patients with our "Recognising and Responding to Acutely Unwell Individuals" course. Improve patient outcomes and prevent deterioration in various healthcare settings. Enroll now.

Enhance your respiratory care skills with our comprehensive course. Learn to assess, diagnose, and manage respiratory conditions for better patient outcomes.