25510 Courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

The Customer Service Manager course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with an acknowledged certificate. This Customer Service Manager course consists of several modules that take around 3 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn a free e-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 materials Mock exams Multiple-choice assessment Certificate of Achievement CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Method of Assessment 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. Course Content Customer Service Manager WHY Customer Service Is CRITICAL To Your Business! 00:05:00 Good Isn't Good Enough! 00:03:00 We Are ALL in the 'Helping Field' 00:10:00 Providing 'Concierge' Level Of Service 00:06:00 The 5 Tenets Of TQM 00:03:00 How To Boost Customer Satisfaction 00:08:00 How To Avoid The 10 Deadly Sins Of Customer Service! 00:15:00 More Money $$$ - Through Customer Retention 00:05:00 How Much Is A Customer Worth? $$$ 00:08:00 Do You Understand Your Customer? 00:07:00 Dealing With Difficult Customers 00:19:00 'LEAP' Into Customer Service! 00:18:00 Exceptional Phone Service 00:17:00 WHY Customers Buy From YOU! $$$ 00:17:00 BONUS LECTURE!!! FINAL TIPS!!! 00:07:00 BONUS LECTURE!!! FINAL TIPS!!! 00:17:00 Assignment Assignment - Customer Service Manager 6 days, 3 hours Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Generating Trust for Global Virtual Teams Within and Outside Our Teams Co-locating teams in a Global Organisation is becoming more and more challenging. Large companies now have a global footprint working across multiple time zones and multiple languages to deliver complex projects. There is an increasing need for effective virtual working, utilising modern technologies to drive decision making and project delivery. It is even more important as leaders, through all this virtuality, to build strong relationships and trust within and outside our teams, whilst continuing to develop our people to deliver our projects. 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. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Intentionally Strategic Many organizations struggle to focus. Dr. Zeitoun finds this to be the case regardless of industries, geographies, complexity, or even their level of operational maturity. Being intentionally strategic requires courage; systems view capacity; and immense appetite for true listening and learning. In this presentation, Dr. Zeitoun will share his insights for maturing the dialogue amongst executives and organizational leaders, intentionally developing their strategic mindset, adn for creating the culture of passionate willingness to have the tough crucial discussions. 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. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Generating Trust for Global Virtual Teams Within and Outside Our Teams Co-locating teams in a Global Organisation is becoming more and more challenging. Large companies now have a global footprint working across multiple time zones and multiple languages to deliver complex projects. There is an increasing need for effective virtual working, utilising modern technologies to drive decision making and project delivery. It is even more important as leaders, through all this virtuality, to build strong relationships and trust within and outside our teams, whilst continuing to develop our people to deliver our projects. 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. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Leading and Managing Change Change moves people out of their comfort zones. It is essential for growth, but it also causes disruptions that can diminish our ability to envision a clear and positive future. To effectively lead organizational change, you must understand both the dynamics of change and the emotional impact it has on everyone it touches. This presentation introduces an Integrated Change Leadership model that equips you to move people in a new direction, providing ongoing support and guidance in the face of uncertainty. 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. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

This course delves into the dynamic world of social media advertising, offering a comprehensive exploration of platform selection, target audience segmentation, and persona development. From understanding the fundamentals to executing targeted campaigns, participants will gain invaluable insights to maximize their digital impact. After the successful completion of the course, you will be able to learn about the following:⦁ Introduction to social media advertising.⦁ Choosing the right social media platforms (Facebook, Instagram, Twitter, LinkedIn, etc.)⦁ Target audience segmentation and persona development. Navigate the intricate landscape of social media advertising with precision. Learn the nuances of platform selection, including Facebook, Instagram, Twitter, LinkedIn, and more. Dive into advanced strategies for target audience segmentation and persona development, optimizing your campaigns for maximum engagement and ROI.   Explore the realm of social media advertising, mastering the intricacies of platform selection, audience targeting, and campaign optimization. Gain the skills needed to excel in roles such as Social Media Advertising Specialist, Digital Marketing Strategist, or Campaign Optimization Specialist. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Social Media Advertising Self-paced pre-recorded learning content on this topic. Social Media Advertising Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience, Social Media Advertising Specialist Digital Marketing Strategist Social Media Manager Ad Operations Analyst Digital Advertising Coordinator Campaign Optimization Specialist Social Media Content Creator Digital Marketing Consultant Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Unleash your potential in the realm of literacy and numeracy mastery. Discover the art and science behind adult learning, delve into the intricacies of teaching and learning literacy, and unlock the secrets of imparting numeracy with finesse. Our comprehensive programme takes you on a journey through the fascinating landscapes of adult education, blending theory with practical insights. Elevate your teaching prowess and redefine your impact on learners with modules that explore inclusive learning, technology integration, and the nuances of policy and practice. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Immerse yourself in an engaging learning adventure that goes beyond conventional approaches, equipping you with the knowledge and skills to navigate the diverse challenges of adult education. Join us in reshaping the educational landscape, where your passion meets purpose, and your expertise becomes a beacon for adult learners seeking the keys to literacy and numeracy mastery. Course Curriculum Module 1: Overview of Adult Literacy and Numeracy Module 2: Understanding Adult Learning Theories Module 3: Teaching and Learning Literacy Module 4: Teaching and Learning Literacy Writing, Speaking and Listening Module 5: Planning and Assessment Literacy Module 6: Learning Numeracy Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities Module 8: Teaching Numeracy Module 9: Technology in Learning Module 10: Adult Learning Difficulties Module 11: Inclusive Learning Module 12: Policy and Practice Learning Outcomes: Grasp adult learning theories for effective teaching strategies. Hone literacy teaching skills in writing, speaking, and listening. Demonstrate proficiency in planning and assessing literacy education. Acquire a solid foundation in numeracy, including statistical functions. Develop advanced teaching techniques for imparting numeracy concepts. Cultivate inclusive practices and align teaching with educational policies. CPD 10 CPD hours / points Accredited by CPD Quality Standards Literacy and Numeracy Mastery for Adults 3:00:58 1: Module 1: Overview of Adult Literacy and Numeracy 17:41 2: Module 2: Understanding Adult Learning Theories 16:05 3: Module 3: Teaching and Learning Literacy 16:25 4: Module 4: Teaching and Learning Literacy Writing, Speaking and Listening 09:44 5: Module 5: Planning and Assessment Literacy 12:59 6: Module 6: Learning Numeracy 17:51 7: Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities 14:50 8: Module 8 Teaching Numeracy 15:42 9: Module 9: Technology in Learning 13:21 10: Module 10: Adult Learning Difficulties 15:42 11: Module 11: Inclusive Learning 17:14 12: Module 12: Policy and Practice 12:24 13: CPD Certificate - Free 01:00 Who is this course for? Educators seeking advanced adult teaching expertise. Literacy and numeracy enthusiasts passionate about adult education. Professionals eager to enhance their teaching impact. Individuals committed to fostering inclusive learning environments. Aspiring educators ready to embrace the challenges of adult education. Career path Adult Education Coordinator Literacy Outreach Specialist Numeracy Instructor Inclusive Learning Advocate Educational Policy Analyst Technology Integration Facilitator Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Unleash your potential in the realm of literacy and numeracy mastery. Discover the art and science behind adult learning, delve into the intricacies of teaching and learning literacy, and unlock the secrets of imparting numeracy with finesse. Our comprehensive programme takes you on a journey through the fascinating landscapes of adult education, blending theory with practical insights. Elevate your teaching prowess and redefine your impact on learners with modules that explore inclusive learning, technology integration, and the nuances of policy and practice. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Immerse yourself in an engaging learning adventure that goes beyond conventional approaches, equipping you with the knowledge and skills to navigate the diverse challenges of adult education. Join us in reshaping the educational landscape, where your passion meets purpose, and your expertise becomes a beacon for adult learners seeking the keys to literacy and numeracy mastery. Course Curriculum Module 1: Overview of Adult Literacy and Numeracy Module 2: Understanding Adult Learning Theories Module 3: Teaching and Learning Literacy Module 4: Teaching and Learning Literacy Writing, Speaking and Listening Module 5: Planning and Assessment Literacy Module 6: Learning Numeracy Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities Module 8: Teaching Numeracy Module 9: Technology in Learning Module 10: Adult Learning Difficulties Module 11: Inclusive Learning Module 12: Policy and Practice Learning Outcomes: Grasp adult learning theories for effective teaching strategies. Hone literacy teaching skills in writing, speaking, and listening. Demonstrate proficiency in planning and assessing literacy education. Acquire a solid foundation in numeracy, including statistical functions. Develop advanced teaching techniques for imparting numeracy concepts. Cultivate inclusive practices and align teaching with educational policies. CPD 10 CPD hours / points Accredited by CPD Quality Standards Literacy and Numeracy Mastery for Adults 3:00:58 1: Module 1: Overview of Adult Literacy and Numeracy 17:41 2: Module 2: Understanding Adult Learning Theories 16:05 3: Module 3: Teaching and Learning Literacy 16:25 4: Module 4: Teaching and Learning Literacy Writing, Speaking and Listening 09:44 5: Module 5: Planning and Assessment Literacy 12:59 6: Module 6: Learning Numeracy 17:51 7: Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities 14:50 8: Module 8 Teaching Numeracy 15:42 9: Module 9: Technology in Learning 13:21 10: Module 10: Adult Learning Difficulties 15:42 11: Module 11: Inclusive Learning 17:14 12: Module 12: Policy and Practice 12:24 13: CPD Certificate - Free 01:00 Who is this course for? Educators seeking advanced adult teaching expertise. Literacy and numeracy enthusiasts passionate about adult education. Professionals eager to enhance their teaching impact. Individuals committed to fostering inclusive learning environments. Aspiring educators ready to embrace the challenges of adult education. Career path Adult Education Coordinator Literacy Outreach Specialist Numeracy Instructor Inclusive Learning Advocate Educational Policy Analyst Technology Integration Facilitator Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Turn Your Dreams into Reality with the Excel Analyst - Excel Data Analysis and Visualisation Course Training course. This comprehensive Excel Analyst - Excel Data Analysis and Visualisation Course online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you. Key Learning Outcomes: Understanding the core concepts and theories in your field Building your knowledge and skills through practical, hands-on learning Developing the ability to think critically and solve problems effectively Enhancing your communication skills and the ability to work effectively with others Gaining a competitive edge in your career and reaching your full potential With a flexible online format that allows you to learn at your own pace, Excel Analyst - Excel Data Analysis and Visualisation Course training course offers a convenient and accessible way to boost your career prospects. So why wait? Enrol today and take the first step towards success! Vital Component of the Excel Analyst - Excel Data Analysis and Visualisation Course course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Transform your career with the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle now and take the first step towards a successful and fulfilling career! Course Outline: Modifying a Worksheet Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is the perfect fit for anyone seeking to start or advance in the Excel Analyst - Excel Data Analysis and Visualisation Course industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed. Requirements Join the Excitement-With this Excel Analyst - Excel Data Analysis and Visualisation Course course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course. Career path Upon completion, you'll have the opportunity to pursue a variety of in-demand Excel Analyst - Excel Data Analysis and Visualisation Course jobs, with endless possibilities for growth and success. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each