27731 Development courses delivered Online

SQL programming is the programming that manages data in the Relational Database Management System. The Mastering SQL Programming course aims to teach you how to optimise the accessibility and maintenance of data with the Structured Query Language SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This SQL Programming course will provide you the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Learn what SQL is and how to create, manipulate, and create reports from database tables from the best SQL courses. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Enrol Now to start boosting your SQL skills! Key topics to be covered Stored Procedures Returning Data Testing and Debugging SQL CLR Code Dynamic SQL Column sets Learning Outcomes Know the tools for creating views with examples, columns and indexed views, creating stored procedures, testing and debugging. Learn how to create triggers, execute with result sets, use inline table valued functions, and use the multi statement function. Learn about transaction concepts, explicit transactions, and structured error handling. Understanding of different functions, data tools, database management, comparing database schemas, offline database management and much more. Master partitioning, managing partitions, querying partitions, complex querying, table expressions, efficient queries and complex queries. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and expert skills in SQL programming. Those who have an interest in production planning. Students from any academic backgrounds

Discover the art of manufacturing with Good Manufacturing Practices and Safety Regulations. Learn how to prevent contamination, maintain hygiene, and adhere to industry-specific guidelines for pharmaceuticals, food, and cosmetics. Explore the impact of IT on GMP and elevate your knowledge with this theoretical course. Learning outcomes: Understand the basics of GMP and safety regulations Identify good and bad manufacturing practices Learn to prevent and control contamination Implement maintenance and hygiene protocols Apply GMP principles to pharmaceuticals, food, and cosmetics Explore the role of IT in GMP compliance Good Manufacturing Practice and Safety Regulations course will help you to learn the theoretical foundations of GMP, including its basic concepts and the regulations governing manufacturing processes. You'll delve into the world of contamination prevention and control, exploring the importance of maintenance and hygiene in adhering to GMP standards. This course covers industry-specific guidelines for the pharmaceutical, food, and cosmetics industries. You'll learn how to implement GMP principles in these sectors, gaining an understanding of the best practices and regulations unique to each industry. Additionally, you'll explore the impact of IT on GMP compliance, discovering how technology is changing the face of manufacturing and improving adherence to regulations. This course is perfect for anyone looking to build a foundation in manufacturing or further their knowledge of GMP and safety regulations. By completing this course, you'll gain an in-depth understanding of GMP principles, making you a valuable asset in any manufacturing setting. Enrol today and discover the power of Good Manufacturing Practices. Certification Upon completion of the Good Manufacturing Practice and Safety Regulations course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course will be especially helpful for the following: Individuals looking to build a career in manufacturing Professionals seeking to expand their knowledge of GMP and safety regulations Individuals interested in the pharmaceutical, food, or cosmetics industries Anyone looking to gain a theoretical understanding of GMP and safety regulations Career path This course is ideal for the following: Quality control technician: £17,000 - £30,000 per year Production supervisor: £22,000 - £40,000 per year Quality assurance manager: £30,000 - £55,000 per year Compliance Specialist: £35,000 - £70,000 per year Manufacturing director: £65,000 - £120,000 per year Chief operating officer: £120,000 - £250,000 per year

Showing Up to Be Your Best Every Day Your Organization is Agile...YAY! You are working in a prescribed framework (Scrum, Kanban, etc.) YAY! You are a part of a Dynamic team...YAY! You are all set and running as a defined High Performing team NO! So, what is in the way? Erin will help answer that, it isn't just a team problem. Through her experience in Agile environments, Erin realized many organizations check all the boxes for implementing agile, but forget the most important which are the behaviors. Over the years, Erin has started to focus on the behaviors needed in an agile environment. In this session you will look at questions like: what gets you excited? What makes you frustrated? What motivates you? How are you showing up? Are you owning your day or renting it? And why reflecting on these matters! Erin will provide tools that we will use to identify personal behaviors and statements that you will be able to use not only within your profession, your team, your organization, but also in your daily life outside of the office. Are you ready to show up to be your best? Learning Outcomes Uncover behaviors needed in an Agile environment. Tools that can be applied immediately after the session to help uncover challenges, strengths and possibilities Taking time to be introspective. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs.

What is Disciplined Agile? Where did it come from? Where is it going? How can it help me? In your organization, you are very likely using a variety of approaches to deliver solutions to your stakeholders. You might be using traditional waterfall, agile, or hybrid approaches. If you are applying agile methods or frameworks, you might be using Scrum, SAFe®, Lean Kanban, or 'roll your own' techniques. Regardless of what methods you are using, the Disciplined Agile (DA) tool kit can help you to be more effective. It is an agnostic, comprehensive library of strategies and practices, with practical advice for which ones work for in different contexts. Many organizations struggle to evolve an agile way of working (WoW) that makes sense for their unique situations. The good news is that you don't need to figure it out on your own. The DA tool kit leverages the experiences of thousands of teams who have already struggled through the very issues that our teams currently face. By referencing these strategies, you can accelerate your journey to project delivery success using a technique we call Guided Continuous Improvement (GCI). Learning Objectives This presentation explains the value of the Disciplined Agile tool kit and how to use it in practice with GCI across your entire organization, putting you on a path to true business agility. Learn what DA is and where it came from Learn about where DA is moving next Understand how DA can help you with your projects

Innovation Project Management: A Practitioners Approach In today's fast-changing world, we need leadership and project management more than ever to increase innovation. Leadership is an important part of innovation project management. Innovation project management is an area that is new in thought and will need to increase awareness in this area as leaders to move the next generation of project leaders and into future success. Project management creates many innovative products and services. The complexity of innovation project management will make it important to continue to educate and train current and future project managers. New thought process needed to innovate A practitioner's experience working in innovation project management Leadership to create innovation in project management

The Grateful Agile Leader Join Susan Parente as she demonstrates that Grateful Leadership is a style of leadership that speaks to the fundamentals of acknowledgment and gratitude for team members, what they do, and how they contribute! And she helps build a persuasive case that Grateful Leadership should be a key part of Agile projects! Key takeaways: How being an Agile Leader is being a Grateful Leader Incorporating an attitude of gratitude with team members and customers Acknowledging team accomplishments, courage, and creativity

Ask & You Shall Achieve! Discover Collaborative Problem Solving to Realize Greater Value in the Agile Framework If you want to succeed in today's economy, the true measure of your success is not in getting people to work; it's not even in getting people to work hard. It's about getting people to work hard TOGETHER, to achieve and create something good... something valuable. To create value, you must know HOW value is measured and HOW to allow your team members to best contribute their talents. The wisdom already exists within your team. It's your job to allow it to flow. Do you know what questions to ask yourself? Do you know what questions to ask your team? Are you asking questions that increase collaboration, co-creation, and co-elevation? In this presentation, we will explore Agile, Axiology, and Asking better questions that lead to better solutions, better results, and greater value. Learning Objectives: Understand the hierarchy of value and impact on leadership Discover the 3 dimensions of Questions Use the principles of axiology to lead and motivate Discover the Collaborative Problem Solving (CPS) Process

Duration 5 Days 30 CPD hours This course is intended for Network engineers and technicians that are working in the enterprise sector. Overview - Describe the factors that led to the development of IPv6 and possible uses of this new IP structure - Describe the structure of the IPv6 address format, how IPv6 interacts with data link layer technologies, and how IPv6 is supported in Cisco IOS Software - Implement IPv6 services and applications - Understand the updates to IPv4 routing protocols needed to support IPv6 topologies - Understand multicast concepts and IPv6 multicast specifics - Evaluate the scenario and desired outcome and identify the best transition mechanism for the situation - Describe security issues, how security for IPv6 is different than for IPv4, and emerging practices for IPv6-enabled networks - Describe the standards bodies that define IPv6 address allocation, in addition to one of the leading IPv6 deployment issuesâ€'multihoming - Describe the deployment strategies that service providers might consider when deploying IPv6 - Describe case studies for enterprise, service provider, and branch networks This course is a five-day course aimed at providing network engineers and technicians that are working in the enterprise sector with the knowledge and skills that are needed to study and configure Cisco IOS Software IPv6 features. Introduction to IPv6 Explaining the Rationale for IPv6 Evaluating IPv6 Features and Benefits Understanding Market Drivers IPv6 Operations Understanding the IPv6 Addressing Architecture Describing the IPv6 Header Format Enabling IPv6 on Hosts Enabling IPv6 on Cisco Routers Using ICMPv6 and Neighbor Discovery IPv6 Services IPv6 Mobility Describing DNS in an IPv6 Environment Understanding DHCPv6 Operations Understanding QoS Support in an IPv6 Environment Using Cisco IOS Software Features IPv6-Enabled Routing Protocols Routing with RIPng Examining OSPFv3 Examining Integrated IS-IS Examining EIGRP for IPv6 Understanding MP-BGP Configuring IPv6 Policy-Based Routing Configuring FHRP for IPv6 Configuring Route Redistribution IPv6 Multicast Services Implementing Multicast in an IPv6 Network Using IPv6 MLD IPv6 Transition Mechanisms Implementing Dual-Stack Describing IPv6 Tunneling Mechanisms IPv6 Security Configuring IPv6 ACLs Using IPsec, IKE, and VPNs Discussing Security Issues in an IPv6 Transition Environment Understanding IPv6 Security Practices Configuring Cisco IOS Firewall for IPv6 Deploying IPv6 Examining IPv6 Address Allocation Understanding the IPv6 Multihoming Issue Identifying IPv6 Enterprise Deployment Strategies IPv6 and Service Providers Identifying IPv6 Service Provider Deployment Understanding Support for IPv6 in MPLS Understanding 6VPE Understanding IPv6 Broadband Access Services IPv6 Case Studies Planning and Implementing IPv6 in Enterprise Networks Planning and Implementing IPv6 in Service Provider Networks Planning and Implementing IPv6 in Branch Networks Lab Exercises Lab 2-1: Enabling IPv6 on Hosts Lab 2-2: Using Neighbor Discovery Lab 3-1: Using Prefix Delegation Lab 4-1: Routing with OSPFv3 Lab 4-2: Routing with IS-IS Lab 4-3: Routing with EIGRP Lab 4-4: Routing with BGP and MP-BGP Lab 5-1: Multicasting Lab 6-1: Implementing Tunnels for IPv6 Lab 7-1: Configuring Advanced ACLs Lab 7-2: Implementing IPsec and IKE Lab 7-3: Configuring Cisco IOS Firewall Lab 9-1: Configuring 6PE and 6VPE Configuration Files Summary Lab Activity Solutions Teardown and Restoration Additional course details: Nexus Humans Cisco IPv6 Fundamentals, Design and Deployment 3.0 (IP6FD) 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 Cisco IPv6 Fundamentals, Design and Deployment 3.0 (IP6FD) 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.

Best Seller | Career Focused 3-in-1 Bundle | CPD Approved | Updated Lesson Plan | FREE PDF Certificate | Tutor Support

This practical training course is designed to provide learners with an in-depth understanding of business analysis, change management and continuous business improvement. It asks the fundamental questions, 'What is the role of a business analyst? 'What skills must you possess to work in this field?', 'What are the steps in successful business analysis?' and much more. Whether you're new to the industry or want to update your skills, our experienced tutor will guide you every step of the way. From the key to successful business planning and monitoring to tips on how to create a winning business strategy, all the valuable industry knowledge you need to fast track your career is packed into this best-selling course. Learning Objectives: Learn about the core competencies and skills required to become a business analyst Identify the different careers in business analysis and explore your opportunities Understand how a business strategy is developed and what should be included in it Familiarise with the core concept model in business analysis planning and monitoring Explore the future of business analysis and business analysis technologies Demonstrate a solid understanding of business analysis tools and techniques Know how to evaluate solution performance in a business environment Have a solid understanding of change management principles in business analysis Be able to identify business analysis performance improvements Who is This Course for? This diploma course in Business Analysis is suitable for aspiring professionals who are looking to take the first steps in their career, who wish to develop the skills to support crucial business change. Our online courses are specially designed for distance learning, offering flexible virtual classroom modules that you can study at your own convenience. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion from Course Gate At the successful completion of the course, the learners may order the Certificate of Completion from Course Gate (soft copy) by paying only £2. For the Printed hard copy of the certificate, the learners have to pay £9. Career Path On successful completion, learners will be equipped with the skills and knowledge to become qualified business analysts, with the opportunity to work in a range of sectors and industries, including finance, tech and project management. The typical salary range for a business analyst is £60-90,000, with the potential to work your way up to chief technology officer or become a consultant. Course Curriculum Module 01: What is Business Analysis? What is Business Analysis? 00:10:00 Assessment Module 1 Module 01 Final Quiz Exam - Business Analysis 00:10:00 Module 02: Breaking Down the Different Levels of Business Analysis Breaking Down the Different Levels of Business Analysis 00:10:00 Assessment Module 2 Module 02 Final Quiz Exam - Business Analysis 00:10:00 Module 03: Business Analysis Key Concepts Business Analysis Key Concepts 00:05:00 Assessment Module 3 Module 03 Final Quiz Exam - Business Analysis 00:10:00 Module 04: Business Analysis Planning and Monitoring Business Analysis Planning and Monitoring 00:10:00 Assessment Module 4 Module 04 Final Quiz Exam - Business Analysis 00:10:00 Module 05: Elicitation and Collaboration Elicitation and Collaboration 00:10:00 Assessment Module 5 Module 05 Final Quiz Exam - Business Analysis 00:10:00 Module 06: Requirements Life Cycle Management Requirements Life Cycle Management 00:15:00 Assessment Module 6 Module 06 Final Quiz Exam - Business Analysis 00:10:00 Module 07: Strategy Analysis Strategy Analysis 00:15:00 Assessment Module 7 Module 07 Final Quiz Exam - Business Analysis 00:10:00 Module 08: Requirements Analysis and Design Definition Requirements Analysis and Design Definition 00:15:00 Assessment Module 8 Module 08 Final Quiz Exam - Business Analysis 00:10:00 Module 09: Solution Evaluation Solution Evaluation 00:10:00 Assessment Module 9 Module 09 Final Quiz Exam - Business Analysis 00:10:00 Module 10: Investigation Techniques Investigation Techniques 00:00:00 Assessment Module 10 Module 10 Final Quiz Exam - Business Analysis 00:10:00 Module 11: Develop Your Business Analysis Skills Develop Your Business Analysis Skills 00:15:00 Assessment Module 11 Module 11 Final Quiz Exam - Business Analysis 00:10:00 Module 12: Future Career Path and Scope of A Business Analyst Future Career Path and Scope of A Business Analyst 00:10:00 Assessment Module 12 Module 12 Final Quiz Exam - Business Analysis 00:10:00 Order Your Certificate