171 Courses

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The English language has become a global lingua franca, with millions of people across the world seeking to learn and improve their English proficiency. In the United Kingdom, the demand for skilled English language teachers remains high, with the British Council reporting a significant increase in the number of students pursuing English language courses. Are you passionate about language education and interested in embarking on a rewarding career as an English language teacher? This Advanced Diploma in TEFL (TESOL) at QLS Level 7 course is endorsed by The Quality Licence Scheme (with 180 CPD Points) Main Course: Advanced Diploma in TEFL (TESOL) at QLS Level 7 Additionally, we are offering 3 more courses related to TEFL (TESOL and ESOL) absolutely free. Bonus Course 1: Functional Skills English at QLS Level 2 Bonus Course 2: British English Pronunciation and Accent Course Bonus Course 3: English Spelling, Punctuation, and Grammar Training Teaching English as a Second or Foreign Language (TESOL) is a programme that provides equal educational opportunities for students who have a primary or home language other than English. So, if you are looking for a way to improve your English fluency and punctuation, whether you are writing emails at work or essays at university, then this TEFL (TESOL/ESOL) course is the right one for you! Whether you're an expert or a beginner, this TEFL (TESOL/ESOL) course covers everything you need to know. So, enrol now and start thriving. What will I learn from this TEFL (TESOL) course? An overview of English language teaching and learning Improve linguistics, pronunciation, grammar, and vocabulary Understand language teaching methodologies Various teaching receptive and productive skills How to plan lessons and determine course materials The importance of using different and fun teaching approaches Familiarise yourself with classroom management and student motivation Fundamentals of teaching English: A Situational Approach Deepen knowledge of personal development and employment Why Choose Us? Get a Free CPD Accredited Certificate upon completion of TEFL (TESOL) Get a free student ID card with TEFL (TESOL) Training The TEFL (TESOL) is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the TEFL (TESOL) course materials The TEFL (TESOL) comes with 24/7 tutor support Take a step towards a brighter future with our TTEFL (TESOL/ESOL) course. *** Course Curriculum of TEFL (TESOL/ESOL) *** Here is the curriculum breakdown for the Advanced Diploma in TEFL (TESOL) at QLS Level 7: Introduction to English Language Teaching and Learning Linguistics English Pronunciation Teaching Grammar and Vocabulary Language Teaching Methodologies Teaching Receptive Skills: Reading Teaching Productive Skills: Writing Teaching Receptive Skills: Listening Teaching Productive Skills: Speaking Lesson Planning and Creating Materials Use of Games and Activities Technology in Second Language Teaching and Learning Classroom Management and Student Motivation Teaching English: Situational Approach Professional Development and Employment 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*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This TEFL (TESOL/ESOL) course is ideal for: Aspiring English language teachers Current English language teachers looking to upskill Individuals interested in teaching English abroad Individuals who wish to gain a better understanding of English language teaching methodologies Requirements You will not need any prior background or expertise to enrol in this TEFL (TESOL) course. Career path TEFL (TESOL/ESOL) Online Training Enrolling in this TEFL (TESOL) course can lead you to the following career paths: ESOL Tutor Sessional Tutor Main Grade Lecturer Specialist Practitioner Teaching Assistant Employability Trainer And many more! Certificates CPDQS Accredited Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee. Advanced Diploma in TEFL (TESOL) at QLS Level 7 Hard copy certificate - £139

Master essential leadership skills and discover what it takes to become a great team manager or supervisor with the Team Management Skills course. This comprehensive course examines the characteristics and principles of effective leadership, from goal setting and providing feedback, to resolving conflict and managing your time. Our instructor-led training units are ideal for those who are new to their role and wish to fine tune their management style and approach to boos ttheir professional development. Master the art of public speaking, learn how to engage your audience and get your point across effectively with the Communication and Public Speaking Diploma. This training program will help you boost your confidence in delivering presentations and improve your body language to project confidence. This skills-based diploma also provides guidance on how to work with visual aids, plan your notes and overcome your fears and self-doubts. This course is ideal for those in customer or client-facing roles. Your Learning Goals: Develop your skills in time management, leadership and communication Understand how to provide constructive feedback and delegate work effectively Learn how to motivate teams and bring out the best in your employees Be able to resolve conflict and disagreements with professionalism Define your management style and understand which approach works for you Master the art of body language and learn how to project confidence in the workplace Improve your delivery in presentations and public speaking Know how to keep your audience engaged and use visual aids effectively Learn how to get your point across and express your ideas with conviction Discover practical mental exercises to help you remember your lines Who is this Course for? This course is ideal for line managers, supervisors and team leaders who are new to their role and wish to enhance their skillset. This masterclass is also suitable for anyone who wants to improve their public speaking and confidence in working with teams. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have the practical skills and knowledge to kickstart their career and explore opportunities in the following roles: Team Manager Team Leader/Supervisor Entrepreneur Motivational Speaker Coach/Mentor Course Curriculum **Team Management** Introduction Getting Started 00:01:00 Setting Expectations Setting Expectations 00:03:00 Setting Expectations Case Study 00:01:00 Setting Goals Setting Goals 00:06:00 Setting Goals Case Study 00:01:00 Assigning Work Assigning Work 00:04:00 Assigning Work Case Study 00:01:00 Degrees of Delegation Degrees of Delegation 00:03:00 Degrees of Delegation Case Study 00:01:00 Implementing Delegation Implementing Delegation 00:07:00 Implementing Delegation Case Study 00:01:00 Providing Feedback Providing Feedback 00:05:00 Providing Feedback Case Study 00:01:00 Managing Your Time Managing Your Time 00:05:00 Managing Your Time Case Study 00:01:00 Resolving Conflict Resolving Conflict 00:04:00 Resolving Conflict Case Study 00:01:00 Tips for Special Situations Tips for Special Situations 00:05:00 Tips for Special Situations Case Stud 00:01:00 A Survival Guide for the New Supervisor A Survival Guide For The New Supervisor 00:03:00 A Survival Guide For The New Supervisor Case Study 00:01:00 Wrapping Up Wrapping Up 00:01:00 **Effective Communication** Working on Basics 101 Skill Of The Mouth 00:09:00 Communication 00:04:00 It's In The Eyes 00:05:00 You Have 40 Seconds 00:02:00 Body Language 00:06:00 Art Of Speaking 00:06:00 Working On It 102 Putting It Together 00:05:00 Content Is Key 00:06:00 To Joke Or Not To Joke 00:02:00 Learn Your Lines 00:06:00 Visual Aids 00:03:00 Working On Me 103 Walk The Talk 00:05:00 What Gives You The Edge 00:05:00 It's The Heart That Counts 00:04:00 Mirror Time 00:05:00 How To Deal With Stress 00:04:00 Fake it Till You Make It 00:07:00 Preparation On The Day 00:05:00 Working On Them 104 People Don't Care How much you know until they know how much you care 00:04:00 They Really Are Naked 00:03:00 Sing The Right Song 00:06:00 Know Your Venue 00:04:00 Public Speaking - Why Do It? 00:04:00 Conclusion Hello and Goodbye 00:02:00 Goodbye HD Final Online 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Learn Project Benefits Management Step-by-Step A comprehensive process that covers every stage of Project and Program Benefits Management

Duration 3 Days 18 CPD hours This course is intended for This course is geared for attendees with solid Python skills who wish to learn and use basic machine learning algorithms and concepts Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, with extensive practical exercises designed to reinforce fundamental skills, concepts and best practices taught throughout the course. Topics Covered: This is a high-level list of topics covered in this course. Please see the detailed Agenda below Getting Started & Optional Python Quick Refresher Statistics and Probability Refresher and Python Practice Probability Density Function; Probability Mass Function; Naive Bayes Predictive Models Machine Learning with Python Recommender Systems KNN and PCA Reinforcement Learning Dealing with Real-World Data Experimental Design / ML in the Real World Time Permitting: Deep Learning and Neural Networks Machine Learning Essentials with Python is a foundation-level, three-day hands-on course that teaches students core skills and concepts in modern machine learning practices. This course is geared for attendees experienced with Python, but new to machine learning, who need introductory level coverage of these topics, rather than a deep dive of the math and statistics behind Machine Learning. Students will learn basic algorithms from scratch. For each machine learning concept, students will first learn about and discuss the foundations, its applicability and limitations, and then explore the implementation and use, reviewing and working with specific use casesWorking in a hands-on learning environment, led by our Machine Learning expert instructor, students will learn about and explore:Popular machine learning algorithms, their applicability and limitationsPractical application of these methods in a machine learning environmentPractical use cases and limitations of algorithms Getting Started Installation: Getting Started and Overview LINUX jump start: Installing and Using Anaconda & Course Materials (or reference the default container) Python Refresher Introducing the Pandas, NumPy and Scikit-Learn Library Statistics and Probability Refresher and Python Practice Types of Data Mean, Median, Mode Using mean, median, and mode in Python Variation and Standard Deviation Probability Density Function; Probability Mass Function; Naive Bayes Common Data Distributions Percentiles and Moments A Crash Course in matplotlib Advanced Visualization with Seaborn Covariance and Correlation Conditional Probability Naive Bayes: Concepts Bayes? Theorem Naive Bayes Spam Classifier with Naive Bayes Predictive Models Linear Regression Polynomial Regression Multiple Regression, and Predicting Car Prices Logistic Regression Logistic Regression Machine Learning with Python Supervised vs. Unsupervised Learning, and Train/Test Using Train/Test to Prevent Overfitting Understanding a Confusion Matrix Measuring Classifiers (Precision, Recall, F1, AUC, ROC) K-Means Clustering K-Means: Clustering People Based on Age and Income Measuring Entropy LINUX: Installing GraphViz Decision Trees: Concepts Decision Trees: Predicting Hiring Decisions Ensemble Learning Support Vector Machines (SVM) Overview Using SVM to Cluster People using scikit-learn Recommender Systems User-Based Collaborative Filtering Item-Based Collaborative Filtering Finding Similar Movie Better Accuracy for Similar Movies Recommending movies to People Improving your recommendations KNN and PCA K-Nearest-Neighbors: Concepts Using KNN to Predict a Rating for a Movie Dimensionality Reduction; Principal Component Analysis (PCA) PCA with the Iris Data Set Reinforcement Learning Reinforcement Learning with Q-Learning and Gym Dealing with Real-World Data Bias / Variance Tradeoff K-Fold Cross-Validation Data Cleaning and Normalization Cleaning Web Log Data Normalizing Numerical Data Detecting Outliers Feature Engineering and the Curse of Dimensionality Imputation Techniques for Missing Data Handling Unbalanced Data: Oversampling, Undersampling, and SMOTE Binning, Transforming, Encoding, Scaling, and Shuffling Experimental Design / ML in the Real World Deploying Models to Real-Time Systems A/B Testing Concepts T-Tests and P-Values Hands-on With T-Tests Determining How Long to Run an Experiment A/B Test Gotchas Capstone Project Group Project & Presentation or Review Deep Learning and Neural Networks Deep Learning Prerequisites The History of Artificial Neural Networks Deep Learning in the TensorFlow Playground Deep Learning Details Introducing TensorFlow Using TensorFlow Introducing Keras Using Keras to Predict Political Affiliations Convolutional Neural Networks (CNN?s) Using CNN?s for Handwriting Recognition Recurrent Neural Networks (RNN?s) Using an RNN for Sentiment Analysis Transfer Learning Tuning Neural Networks: Learning Rate and Batch Size Hyperparameters Deep Learning Regularization with Dropout and Early Stopping The Ethics of Deep Learning Learning More about Deep Learning Additional course details: Nexus Humans Machine Learning Essentials with Python (TTML5506-P) 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 Machine Learning Essentials with Python (TTML5506-P) 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.

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. 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, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) 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 Introduction to MongoDB for DBAs (TTDB4680) 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.

Duration 2 Days 12 CPD hours Overview This skills-focused course combines expert instructor-led discussions with practical hands-on labs that emphasize useful, current techniques, best practices and standards. Working in this hands-on lab environment, guided by our expert practitioner, you'll learn about and explore: Review of the File System Introduction to Shells: sh, bash, and ksh Shell Programming Advanced Shell Features Text Manipulation Utilities File Processing Utilities Multitasking and Batch Processing Regular Expressions Intermediate Linux: Shell, Bash, Text Manipulation, Multitasking & More is a two-day course designed to provide you with hands on experience using standard Linux commands and utilities used for day-to-day tasks including file manipulation, program execution and control, and effective use of the shell and desktop environments. Throughout the course you?ll explore key concepts to Linux core functionality, while learning the system's most commonly used commands. You?ll also learn the Bourne shell, Bash shell and Korn shell programming techniques you?ll need to read and modify existing shell scripts, and create your own. Data manipulation utilities and shell syntax for synthesizing command pipelines are also emphasized throughout the course. Review of the File System File System Organization File Types File and Directory Naming Rules and Conventions Commands for Navigating the File System Introduction to Inodes Ownership, Permissions, and Dates Manipulating Files and Links Manipulating Directories Determining Disk Usage Other File System Utilities Introduction to Shells: sh, bash, and ksh Shell Functions I/O Redirection and Pipes Command Separation and Grouping Background Execution Filename Expansion Shell Variables Command Substitution Quoting and Escaping Metacharacters Bash Shell Features Korn Shell Features Command Execution Startup Files Customizing the User Environment Shell Programming Shell Script Features and Capabilities Creating and Running a Script Working With Variables Environment Variables Working With Data Types Formatting Base Conversion Setting Special Attributes Input/Output Techniques Conditional Constructs if/then else/elif Looping Constructs for, while, until Math Operators Advanced Shell Features Manipulating Strings Writing and Calling Functions Controlling Process Priorities Interpreting Command Line Arguments Making Scripts Interactive Special Shell Variables Advanced I/O with Streams Improving Performance of Scripts Text Manipulation Utilities Editing a File from a Script Scripting with ed or sed UNIX and Linux Utilities to Manipulate Files Regular Expressions grep and egrep The Stream Editor sed Sorting in Scripts Generating Reports with awk Splitting Large Files Counting Words, Lines, and Characters Transforming File Contents File Processing Utilities Examining and Comparing Files Reporting Differences Between Files Comparing Files of Any Format Displaying Data in Octal and Hex Compressing Data Converting File Formats Extracting Text Strings Multitasking and Batch Processing Multitasking Scheduled Execution Using cron The at and batch Commands Regular Expressions Regular Expression Overview Regular Expression Implementations Regular Expressions RE Character Classes Regex Quantifiers RE Parenthesis Additional course details: Nexus Humans Intermediate Linux (TTLX2104) 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 Intermediate Linux (TTLX2104) 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.

Duration 3 Days 18 CPD hours PostgreSQL is a powerful, open-source, object-relational database system known for being reliable, secure, and flexible. For administrators, learning PostgreSQL equips you with the skills needed to handle complex and high-performance databases in our data-driven world. Big-name companies like Apple, Cisco, Fujitsu, and IBM trust PostgreSQL for their critical applications, which highlights its significance and broad industry adoption. By getting the hang of PostgreSQL, administrators can boost their career opportunities and play a key role in the success of data-focused businesses. PostgreSQL Server Administration is a three-day hands-on course geared for administrators seeking to sharpen their skills and elevate their database management capabilities. Throughout the course you?ll explore a wide range of essential topics, from server architecture and user accounts to monitoring and routine maintenance. Throughout the course, you'll gain invaluable insights and practical techniques that will empower you to optimize, secure, and manage your PostgreSQL environment effectively. As you navigate through server configuration, database reporting, backup and restore procedures and more, you'll have the opportunity to apply your newfound knowledge to real-world scenarios. By the end of the course, you'll be equipped with the confidence and skillset required to tackle a wide array of administrative challenges and to effectively manage your PostgreSQL databases. Additional course details: Nexus Humans PostgreSQL Server Administration (TTDB7020) 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 PostgreSQL Server Administration (TTDB7020) 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.

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.

Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is ideal for project managers, team leaders, and collaboration-focused roles who are already familiar with Jira and are looking to integrate Confluence into their project workflows. Overview Throughout the course you will learn to: Master the fundamentals of Confluence, including understanding its history, navigation, and the distinction between pages and blogs. Gain proficiency in creating, editing, copying, moving, and deleting pages, along with managing file directories and executing advanced editing features. Develop the ability to use and create blueprints and templates, aiding in the standardization and productivity enhancement of your team's work. Understand the collaborative features of Confluence such as sharing links, commenting, mentioning, liking, and watching content to promote a culture of teamwork and collaboration in your organization. Learn how to effectively integrate Confluence with Jira, linking issues and filters, and using auto-links for smoother project management. OPTIONAL: Acquire skills in Confluence administration, including managing notifications and watchers, linking to other applications, customizing the look and feel of your workspace, and creating various types of spaces (public, private, team, etc.) Boost your project management and team collaboration skills with our hands-on, interactive course, Getting Started with Confluence (with Jira). Confluence, as a powerful project collaboration tool, seamlessly integrates with Jira, allowing you to create, share, and collaborate on projects in a more efficient and visually appealing way. This course will equip you with the skills to manage projects, improve workflow efficiency, and promote transparency in your organization. You will gain practical knowledge about Confluence's core features such as creating and editing pages, managing file directories, using tasks, macros, and gadgets, and differentiating between pages and blogs.Working in a hands-on learning environment guided by our expert instructor, you?ll gain experience with Confluence's unique features like using and creating blueprints and templates, enhancing standardization and productivity in your team. The program includes a deep dive into collaborative features of Confluence and its integration with Jira, which will enhance your ability to foster a collaborative environment. Administrative aspects like managing notifications, watchers, linking to other applications, and creating various types of spaces will also be covered.You?ll leave the course with the skills to apply Confluence within your existing Jira environment effectively, ready to use its collaborative tools and features to streamline workflows and boost project productivity. Introduction History Navigation Space Directory Shortcuts Pages VS Blogs Pages Creating Pages Editing Pages File Directory Advanced Editing (Markup, Undefined links, etc.) Copying and Moving Pages Deleting Pages Tasks Macros/Gadgets Macro overview and use Using JIRA Gadgets Editing Existing Macros Blueprints/Templates Working with Blueprints Creating/Using Templates Collaboration Sharing Links Commenting Mentioning 'Liking' Content 'Watching' Content JIRA Integration Linking your JIRA and Confluence Instances Linking Issues and Filters Auto Links Administration Page vs Space vs System Admin Notifications Watchers Linking to Other Applications Workbox Notifications Look and Feel Creating Spaces Public Space Private Space Team Space Technical Documentation Meeting Minutes Blog Additional course details: Nexus Humans Introduction to Confluence (TTDV7545) 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 Introduction to Confluence (TTDV7545) 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.