572 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.

CPCS A44 Concrete Pump Trailer Mounted

About this Training Course In the oil & gas industry, it is common knowledge that operators and main contractors, contract or sub-contract a wide range of their activities. The service contract is the tool used to share the risk of a service between the operator and contractor. It is also an approach adopted by the operator to control the efficiency of his contractor. This course allows all parties involved, company, contractors and subcontractors, to better understand the contractual relationship, their rights and obligations. It gives a detailed review of the contract and its main features. This course will particularly focus on the services contracts that are put in place to support a drilling campaign, covering all specificities of the various contracts. Training Objectives At the end of this course, participants will: Get a thorough understanding of the service contract clauses Be able to administer the contract and optimise the relationship with the company or contractor Target Audience This course will be useful and applicable for the following professionals: contract engineers, contracts administrators, any party involved in the relationship between the company and the contractors of a service contract Drillers and logisticians may also have interest in this course as it covers the contractual aspects of their operational activity: They are the 'Owners' of these services contracts Trainer Your expert course leader has 25 years of experience in management positions in Contracting, Procurement and Logistics, mainly in the Oil & Gas Industry. During his Oil & Gas industry experience, he has worked on major Oil and Gas development projects like the Yadana project in Myanmar, Akpo project in Nigeria and YLNG in Yemen. His international experience allows him to adapt very easily and integrate the multicultural specificities of the Oil & Gas industry in his teaching. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

NPORS Piling Rig Attendant (N022)

Take our part-time online “Conversion Course into Pharmaceutical Manufacturing“ NO Previous Industry Experience or Science Qualifications Required

Duration 4 Days 24 CPD hours This course is intended for Collaboration Communications Systems Engineers are responsible for planning, deploying, configuring, maintaining, and troubleshooting Microsoft Teams Phone, meetings, and personal and shared space devices, including Microsoft Teams Rooms and Surface Hub. Collaboration Communications Systems Engineers have a fundamental understanding ofÿnetworking, telecommunications, audio/visual and meeting room technologies, identity and access management. They are proficient in managing and monitoring Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. They deploy and configure Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing. Collaboration Communications Systems Engineers work with Teams Administrators, Microsoft Identity and Access Administrators, and Microsoft 365ÿAdministrators. In addition, they may work with owners of other workloads, including facilitiesÿmanagers, network engineers, security engineers, device manufacturers, telephony providers, and Microsoft Certified solutions providers. This training course is designed to give participants the knowledge and skills to become a Collaboration Communications Systems Engineer. Participants should understand the fundamentals of networking, telecommunications, audio/visual and meeting room technologies, identity and access management, and Microsoft Teams. They will gain hands-on experience configuring and deploying Microsoft Teams Phone, meetings and certified devices including Microsoft Teams Rooms and Surface Hub. The course will also cover how to manage and monitor Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. In addition, the course will cover configuring and deploying Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing. Prerequisites Microsoft 365 and Microsoft Teams Networking, telecommunications, and audio/visual basics Identity and access management basics 1 - Introduction to Teams meetings and calling Overview of Teams meetings and events Overview of Teams Phone Overview of auto attendants and call queues Overview of Teams devices 2 - Plan for Teams Phone Plan to deploy Teams Phone Plan for Teams Phone PSTN connectivity Determine license requirements Plan for Teams Phone devices Plan and design Teams Phone features Plan for voicemail 3 - Plan for Microsoft Teams Rooms and Surface Hub Determine license requirements for Microsoft Teams Rooms and shared devices Understand differences between Microsoft Teams Rooms on Android and Windows Understand Microsoft Teams Rooms on Surface Hub 2S Understand and plan Teams Room accessories, components, and peripherals Understand Teams Rooms management options 4 - Plan and optimize network performance for Teams media Understand Teams network requirements Design network for media optimization Design and implement QoS 5 - Configure and deploy Teams Phone Configure emergency calling for Teams Calling Plans Manage and configure Microsoft PSTN numbers Configure Operator Connect and Teams Phone Mobile Configure Teams Phone policies Create and manage Teams policies Configure Audio Conferencing 6 - Configure and deploy Teams Phone with Direct Routing Design Direct Routing call flows Implement SIP trunking with Direct Routing Configure Emergency Calling for Direct Routing Extend Teams Direct Routing infrastructure Deploy and maintain a survivable branch appliance 7 - Extend Teams Phone with additional services Understand how Teams interacts with additional services Configure compliance recording in Teams Configure and integrate a certified contact center in Teams Design and deploy voice bots in Teams 8 - Manage meetings and events experiences Explore meetings and events in Microsoft Teams Configure meeting settings Create and manage meeting policies Configure audio conferencing Create and manage meeting templates and template policies Create and manage meetings customization policies Configure live events settings Create and manage live events policies Examine live events across Microsoft 365 9 - Guided project - Create and assign Teams policies to meet business requirements in Microsoft Teams Prepare 10 - Configure and manage voice users Enable users for Teams Phone Enable users for Direct Routing with Teams Phone Enable additional calling features for Teams Phone Enable users for Teams Phone Mobile 11 - Configure auto attendants and call queues Design call flows for auto attendants and call queues Configure auto attendants and call queues Deploy a channel-based call queue Configure resource accounts Configure Microsoft 365 groups for voicemail Interpret call queue conference modes Interpret call queue routing methods Configure holidays for auto attendants and call queues Configure custom music on hold 12 - Configure, deploy, and manage Teams devices Manage Microsoft Teams Phones Manage Microsoft Teams Room Systems Microsoft Teams Rooms management options Manage Surface Hub 2S devices Configure Microsoft Teams SIP gateway Manage Microsoft Teams displays Remote provisioning and sign in for Teams Phones Update Microsoft Teams devices remotely Manage Microsoft Teams device tags 13 - Guided project - Prepare meeting room experiences Prepare 14 - Monitor and troubleshoot Teams collaboration communications systems Diagnose and troubleshoot phone number assignment Diagnose and troubleshoot Teams client issues Diagnose and troubleshoot call failure and call quality issues Report on and troubleshoot Teams calls with Call Quality Dashboard Diagnose and troubleshoot Direct Routing issues Troubleshoot and monitor Teams devices Troubleshoot Teams meetings and calling Troubleshoot Teams Rooms devices

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever wondered how safe your local shops and streets are? The UK has one of the most comprehensive CCTV networks in the world, with an estimated 4-5 million cameras keeping an eye on public spaces. But who monitors these cameras, and how can they be used to prevent crime? This CCTV Operation & Security Management bundle equips you with the knowledge and skills to launch a rewarding career in CCTV operation and surveillance. Our CCTV Operation & Security Management bundle goes beyond just CCTV operation. You'll gain a well-rounded foundation in security with courses on close protection, security guard training, and risk management. Learn to identify suspicious activity, deter criminal behaviour, and handle emergencies. Additionally, the bundle covers essential security topics like counter-terrorism awareness, data protection, and even first aid. Courses Are Included In this CCTV Operation & Security Management Training: Course 01: CCTV Operator Course Course 02: Basic Security Guard Training Course 03: Close Protection Course 04: DOOR SUPERVISOR Course 05: Lifeguard Training Course 06: Security Management Course 07: Risk Management Course 08: Extremism & Terrorism Awareness Course 09: Functional Skills - Fitness Course 10: Self Defense: Martial Arts Course 11: Criminology Course 12: Public Health and Safety Course 13: Fraud Detection & Prevention: Safeguarding Against Deception Course 14: IT Security Basics Course 15: Network Security and Risk Management Course 16: Cyber Security Awareness Training Course 17: Functional Skills IT Course 18: Data Protection and Data Security (GDPR) Course 19: Workplace First Aid Course 20: Human Rights Learning Outcomes of CCTV Operation & Security Management Develop comprehensive skills in operating CCTV systems and surveillance techniques. Gain knowledge in basic security guard procedures and door supervision. Learn close protection tactics and lifeguarding for ensuring public safety. Understand risk management principles and extremism/terrorism awareness for security. Acquire self-defence techniques, including martial arts, for personal protection. Explore criminology, fraud detection, cyber security, and data protection laws. Whether you're looking to become a CCTV operator, security guard, or want to enhance your security knowledge for any profession, this bundle is the perfect place to start. Enrol now! Why Choose Our CCTV Operation Bundle? Get a Free CPD Accredited Certificate upon completion of CCTV Operation Get a free student ID card with CCTV Operation Training The CCTV Operation is affordable and simple to understand Lifetime access to the CCTV Operation course materials The CCTV Operation comes with 24/7 tutor support Start your learning journey straightaway with our CCTV Operation & Security Management! *** Course Curriculum *** Course 01: CCTV Operator Course Module 01: Operational Requirement Module 02: CCTV Operator Skills And Ability Module 03: Basics Of CCTV Module 04: Technical Guidance Module 05: Monitoring CCTV Cameras Module 06: Watch Surveillance Module 07: Data Protection Regulations Module 08: Job Requirements Of A CCTV Operator Course 02: Basic Security Guard Training Module 01: Definition And Importance Of Security Module 02: Career Prospect Of Security Guard In The UK Module 03: Security Risk Analysis And Risk Reduction Module 04: Physical And Information Security Protection Module 05: Response To Immediate Crisis Module 06: The Use Of Technology For Managing Security Module 07: General Patrol Tactics And Techniques Module 08: Public Relations And Traffic Control Module 09: Violence In The Workplace Module 10: Laws And Regulations Course 03: Close Protection Module 01: Introduction To Close Protection Module 02: The Close Protection Team Module 03: The Planning Module 04: Threat Assessment Module 05: Vehicle Drills: Embus And Debus Module 06: Route Selection And Reconnaissance Module 07: Legislation Regarding Close Protection =========>>>>> And 17 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*20 = £260) CPD Hard Copy Certificate: Free ( For The Title Course: Previously it was £29.99) CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this CCTV Operation & Security Management bundle. This bundle is ideal for: Aspiring CCTV Operators Security Professionals Career Changers Requirements You will not need any prior background or expertise to enrol in this CCTV Operation & Security Management bundle. Career path After completing this CCTV Operation & Security Management bundle, you are to start your career or begin the next phase of your career. CCTV Operator Security officer Loss prevention Risk assessor Security consultant Surveillance specialist Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this CCTV Operation & Security Management bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Having the right certification if you're working in the Private Security Industry is more than a requirement. Take a look at this Award in CCTV Operations at Knight Trainin https://knight.training/products/level-2-award-in-cctv-operations

NPORS Piling Rig (N221)

Remember how incredibly Tom Cruise managed to get past the security in Mission: Impossible? Well, you may not have encountered such a creative burglar in real life, but we cannot ignore the possibility of unlawful activities in our everyday life. Our CCTV Surveillance and Security Management Program bundle allows you to develop the knowledge needed to become a proficient CCTV operator and a trusted safety guardian. In the UK, the starting income in this field is £17K, but depending on the region and your expertise, you might make up to £50K annually. We include essential courses in this specially crafted bundle - CCTV Operator and Security Management Diploma. Whether you're seeking to enter the security industry or looking to upgrade your existing skills, this bundle is your gateway to a world where vigilance meets innovation. Embark on a fulfilling career path that combines responsibility, professionalism, and the chance to make a real impact. Each courses in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This CCTV Surveillance and Security Management Program bundle promises education and an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Immerse yourself in these diverse, enthralling subjects, each designed to fuel your curiosity and enhance your knowledge. Dive in now! The courses in this bundle include: Course 1: CCTV Operator Course Course 2: Security Management Diploma Learning Outcomes: Understand the operational requirements of a CCTV system and demonstrate proficient CCTV operator skills and abilities. Monitor CCTV cameras proficiently and conduct watch surveillance activities to ensure safety, protection, and incident management. Follow data protection regulations and legal considerations such as privacy laws, consent requirements, and data handling best practices. Understand the principles and practices of security management, including risk analysis, physical and information & cyber security, and fraud prevention. Apply effective security management strategies and measures, such as implementing security policies and risk reduction techniques. Demonstrate knowledge and their practical applications in security investigations, threat awareness and emergency response procedures. The CCTV Operator course teaches you how to operate CCTV cameras and other relevant systems. We describe effective ways a CCTV operator can monitor CCTV cameras and demonstrate how such video surveillance systems uphold safety and security. In addition, we go over the General Data Protection Regulation (GDPR) in the UK and explain how it influences CCTV operators. Finally, we outline the employment criteria of a CCTV operator to assist you in getting started in this sector. This bundle will guide you to analyse the risks, implement protective measures, and navigate the ever-evolving landscape of cyber security and fraud prevention. With our well-designed modules on physical and information security protection, business resilience, and crisis management, you'll gain the understanding to safeguard assets and ensure the continuity of operations. Don't miss this opportunity to gain a competitive edge and establish yourself in the realm of security. Secure your spot in the CCTV Surveillance and Security Management Program today to elevate your career prospects and contribute to a safer world. Enhance your watchful eye, and protect what matters most! Quality Licence Scheme Endorsed Certificate of Achievement: Upon successful completion of the course, you will be eligible to order an original hardcopy certificate of achievement. This prestigious certificate, endorsed by the Quality Licence Scheme, will be titled 'Diploma in Security Management at QLS Level 5'. Your certificate will be delivered directly to your home. The pricing scheme for the certificate is as follows: £109 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. Please Note: NextGen Learning is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for the following: Aspiring CCTV operators who want to acquire the knowledge and skills to operate and manage CCTV systems effectively. Security professionals like security personnel, security guards, or individuals already working in the security industry. Facility managers are responsible for overseeing the security and surveillance operations of various facilities. Law enforcement and public safety personnel, such as police officers, security officers, or other law enforcement professionals. Security consultants provide services like risk assessment, design of the system, and implementation. Individuals seeking career advancement wish to broaden their knowledge to explore new job opportunities. Career path People can pursue careers: CCTV Operator - £22,000 to £24,000 per year Control Room Operator - £17,000 to £49,000 per year Surveillance Operator - £19,000 to £36,000 per year Security Officer - £18,000 to £32,000 per year Security Supervisor/Manager - £25,000 to £38,000 per year Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - £9.99 QLS Endorsed Certificate Hard copy certificate - £109