2203 Success courses delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics 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. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 SQL Programming Basics (TTSQL002) 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 Power of Creativity Course Overview: The Power of Creativity course offers an in-depth exploration of the creative process and its application in various professional fields. Learners will gain a solid understanding of how creativity fuels innovation, problem-solving, and decision-making across industries. This course covers essential creative thinking strategies, fostering the ability to approach challenges with fresh perspectives and innovative solutions. By the end, participants will have the confidence to apply their creativity in a range of contexts, from business environments to personal projects, enhancing their ability to think outside the box and contribute meaningfully in their respective fields. Course Description: This course delves deeper into the power of creativity, covering a wide range of topics designed to enhance cognitive flexibility and encourage new ways of thinking. Learners will explore techniques such as brainstorming, mind mapping, and lateral thinking, which promote original idea generation. Key subjects include the role of creativity in leadership, overcoming creative blocks, and cultivating a creative mindset. Throughout the course, participants will engage with real-world examples and case studies that demonstrate the impact of creativity in driving success. By the end of the course, learners will be equipped with the knowledge and skills needed to unlock their creative potential and apply it effectively in their professional and personal lives. The Power of Creativity Curriculum: Module 01: Power Of Creativity Module 02: Understanding the Creative Process Module 03: Techniques for Idea Generation Module 04: Creative Problem Solving Module 05: Overcoming Creative Blocks Module 06: Creativity in Leadership Module 07: Cultivating a Creative Mindset Module 08: The Role of Creativity in Innovation Module 09: Applying Creativity in the Workplace Module 10: Case Studies in Creative Success (See full curriculum) Who is this course for? Individuals seeking to enhance their creative thinking skills. Professionals aiming to drive innovation in their roles. Beginners with an interest in developing their creative potential. Anyone looking to foster a creative approach in personal or professional life. Career Path Creative Director Innovation Specialist Product Development Manager Marketing Strategist Entrepreneur Design Consultant

Marketing Strategies for Business Course Overview This course offers a comprehensive exploration of marketing strategies essential for business growth and competitive advantage. Learners will gain insight into analysing current market positions, defining strategic goals, and developing effective go-to-market plans. Emphasising the integration of theory and strategic planning, the course equips participants with the ability to design and implement marketing initiatives that drive success. Through structured learning, individuals will develop critical thinking skills to evaluate market opportunities, understand customer needs, and align marketing efforts with broader business objectives. This course is designed to empower learners with the knowledge and confidence to contribute meaningfully to marketing strategy development in various business contexts. Course Description Delving deeper into core marketing concepts, this course covers strategic analysis of the current market environment, goal setting for future positioning, and detailed approaches to launching marketing campaigns. Learners will engage with topics such as market segmentation, competitive analysis, brand positioning, and the execution of marketing plans that ensure measurable outcomes. The learning experience emphasises strategic decision-making, fostering skills in assessing market trends and consumer behaviour. Participants will be equipped to formulate coherent marketing strategies that align with organisational aims, enhancing business growth and sustainability. Throughout, the course maintains a professional and informative tone, suitable for those seeking to develop expertise in marketing within diverse industries. Marketing Strategies for Business Curriculum Module 01: Welcome Module 02: Strategic Outline: Where Are We Now? Module 03: Strategic Outline: Where Do We Want to Be? Module 04: It’s Time to Go to Market Module 05: Ensure Success (See full curriculum) Who Is This Course For? Individuals seeking to understand core marketing strategy principles Professionals aiming to enhance strategic marketing skills for career progression Beginners with an interest in marketing and business development Entrepreneurs looking to improve market positioning and customer engagement Career Path Marketing Coordinator Business Development Executive Brand Strategist Market Research Analyst Marketing Consultant

Instagram Marketing Masterclass Course Overview: This Instagram Marketing Masterclass provides a comprehensive guide to mastering Instagram for business growth. Learners will explore strategies for building a strong brand presence, engaging with followers, and utilising Instagram's various features to drive traffic and sales. The course covers content creation, advertising, analytics, and influencer marketing. By the end, learners will be equipped with the knowledge to enhance their social media marketing skills, enabling them to optimise campaigns, increase visibility, and measure success effectively. Course Description: In this in-depth course, learners will delve into the essential elements of Instagram marketing, covering everything from setting up an effective profile to advanced advertising techniques. Key topics include developing a content strategy, understanding Instagram's algorithm, creating visually appealing posts, and leveraging Instagram Stories and Reels. Learners will also gain insights into performance analytics, helping them to assess campaign success and adjust strategies accordingly. By the end of the course, participants will have a thorough understanding of how to drive engagement and build a loyal following on Instagram, allowing them to make informed decisions that align with their business goals. Instagram Marketing Masterclass Curriculum: Module 01: Introduction to Instagram Marketing Module 02: Creating Engaging Content for Instagram Module 03: Understanding Instagram's Algorithm Module 04: Instagram Advertising and Promotions Module 05: Using Instagram Stories and Reels for Growth Module 06: Analytics and Measuring Instagram Performance Module 07: Building Your Brand and Growing Your Following Module 08: Collaborating with Influencers on Instagram Module 09: Advanced Instagram Marketing Strategies (See full curriculum) Who is this course for? Individuals seeking to enhance their social media marketing skills. Professionals aiming to elevate their brand presence online. Beginners with an interest in social media marketing. Small business owners or marketers looking to leverage Instagram. Digital marketing enthusiasts eager to understand Instagram's full potential. Career Path: Social Media Manager Digital Marketing Specialist Brand Manager Content Creator Influencer Marketing Strategist Online Marketing Consultant Community Manager

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Administrator, Database Administrator, Network Administrator, Systems Administrator. Overview Upon successful completion of this course, students will be able to Configure and use Transparent Data Encryption, Understand and use Oracle Key Vault, Understand Oracle Data Redaction, Understand and use Oracle Data Masking and Subsetting, Understand security risks and identify appropriate Oracle solutions, Configure general authentication and authorization, Understand and implement Global Users, Set up and maintain a simple wallet, Install and use Oracle Database Vault, and Configure and use Transparent Sensitive Data Protection. In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization. In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization. Additional course details: Nexus Humans Oracle Database Security - Preventive Controls 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 Oracle Database Security - Preventive Controls 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 1.625 Days 9.75 CPD hours This course is intended for This course is designed for any business professional that leads or works on teams that identify and develop business solutions. Overview Upon successful completion of this course, students will understand the fundamentals of design thinking and be able to apply principles, methodologies and frameworks and apply them to projects. In this course, students are introduced to design thinking and its application to developing new products, services and the organization of businesses. Design thinking is a human-centric, interdisciplinary approach towards innovation. Understand Design ThinkingWhat is Process Awareness and why is it Key?How to Develop a Good Problem StatementHow to Discover User Needs How to Build Empathy with the User How to Generate IdeasHow to Select Ideas How to Create a Good PrototypeLearn from Failure Additional course details: Nexus Humans Design Thinking for Innovative Problem Solving 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 Design Thinking for Innovative Problem Solving 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 course is suited to marketeers, business analysts, and researchers who are interested in increasing their statistical knowledge. Overview After attending this course, delegates will understand how statistics can be used to provide valuable insight into their business, and be able to apply statistical methods to solve business problems. On returning to work delegates will immediately be able to make a difference to the way that their organisations make decisions. This course covers the statistical methods that analysts need to move from simple reporting on business problems to extracting insight to solve business problems. Course Outline The course will explore the following topics through a series of lectures and workshops: Summary statistics for both continuous data and categorical data Using and reporting confidence intervals Using hypothesis tests to answer business questions Using correlations to explore data relationships Simple prediction models Analysing categorical data Additional course details: Nexus Humans Data-driven Business Using Statistical Analysis 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 Data-driven Business Using Statistical Analysis 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 1 Days 6 CPD hours This course is intended for New administrators, business analysts or report writers who are new to creating reports or dashboards within Salesforce. Overview A student in this class will learn the basic Salesforce object model, and how to create and secure reports and dashboards. The instructor will lead students through exercises to create tabular, summary, matrix and join reports. Students will learn advanced reporting functionality such as charting, report summary fields, bucket fields, conditional highlighting, advanced report filters and building custom report types. Finally, the student will learn how to create and run dashboards and schedule and email reports and dashboards. This course is specifically designed to teach administrators, business analysts or report writers how to utilize the basic and advanced analytic capabilities of Salesforce. Introductions / Login to Training OrgsOverview of Salesforce Object ModelTabular, Summary, Matrix, Join ReportsCharts, Bucket Fields, Report Summary Fields, Conditional HighlightingCustom Report TypesDashboardsReport & Dashboard Scheduling Additional course details: Nexus Humans Introduction to Salesforce.com Analytics - Building Reports and Dashboards 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 Salesforce.com Analytics - Building Reports and Dashboards 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 1 Days 6 CPD hours This course is intended for This basic course is for users and developers familiar with earlier versions of IBM InfoSphere Information Server or IBM InfoSphere MDM who want to learn about new features in V11.3 Overview The objectives of this course are as follows:- Learn about the new features of DataStage V11.3- Learn about the new features of Information Analyzer V11.3- Learn about the new features of Data Click V11.3- Learn about the new features of the Information Governance Catalog V11.3 This course is designed to introduce you to new features in data integration and governance in IBM InfoSphere Information Server V11.3 and IBM InfoSphere MDM V11.3. Outline Unit DS: New Features in IBM InfoSphere DataStage V11.3 Unit DC: New Features in IBM InfoSphere Data Click V11.3 Unit IA: New Features in IBM InfoSphere Information Analyzer V11.3 **All units are accompanied by hands-on lab exercises. Additional course details: Nexus Humans KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3 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 KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3 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 5 Days 30 CPD hours This course is intended for This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database. Overview Implement a DB2 database designUse database utilities to load and reorganize dataDefine and implement a DB2 database recovery strategyControl access to database using DB2 authorization facilities This course provides students with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities, & security considerations. Course Outline Setting up a DB2 database Referential integrity Getting data into and out of DB2 Keeping your DB2 data in good shape Application data recovery basics Program preparation and Bind Security Serialization Additional course details: Nexus Humans CV832 IBM DB2 11 for z/OS Database Administration Workshop Part 1 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 CV832 IBM DB2 11 for z/OS Database Administration Workshop Part 1 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.