5519 Productivity courses delivered Online

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Oracle Database 12c Admin training course description This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. What will you learn Administer an Oracle database instance. Monitor an Oracle database. Configure the Oracle network environment. Create and manage database storage structures. Manage users, profiles, privileges and roles. Manage undo data and temporary segments. Monitor and resolve lock conflicts. Maintain database security. Implement database auditing. Monitor the performance of the Database. Load and unload data. Use the job scheduler. Configure a database for backup and recovery. Oracle Database 12c Admin training course details Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. Duration 5 days Oracle Database 12c Admin training course contents Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

This course is designed for front line data processors and provides a clear introduction to the main elements of the GDPR, including compliance and the consequences of non-compliance. It explains the roles of key players and covers the main categories of personal data and the lawful basis for data processing. Other topics examined include the main Principles of the GDPR and the Rights for Individuals, along with the importance of your Privacy Policy. Finally, there’s important information on data breaches; how to avoid them, what to do if one is discovered and how to file a breach report.

This course covers the many benefits good employee relations can bring to an business. It explains how to build confidence in management, by sharing the company vision, building strong teams and listening to feedback. It examines how a proactive HR presence benefits employee relations. Then looks at the role of employment contracts and the Employee Handbook. The course discusses Performance Management including motivating employees and how best to show your appreciation of their contribution. Finally, it shows you how to deal effectively with complaints, discipline and negativity.

The course starts with some basic definitions and statistics that outline how important running meetings effectively can be. It examines factors that make meetings great, and some practical steps you can take to ensure everything runs smoothly and successful outcomes are achieved. It also covers some of the ways you can handle any problems that may arise. Finally, it looks at different decision-making approaches you can use and finishes off with some notes on keeping a learning log to help you learn and grow, ultimately becoming a more confident and effective participant or chairperson.

Violence in the workplace was cited as the reason people leave their jobs in 50% of cases and in the UK, 29% of people faced such problems. Do you ever feel distressed, anxious or frustrated facing violence with your coworker or your boss? Or maybe you are a manager who has to address conflict. Violence in the is a common part of work-life, and it does not only affect those who are directly involved, but it also impacts the entire work environment. So, how you or your organisation manage the conflict is what determines the level of productivity and fulfilment. As a fellow or as a manager, workplace violence should be the highest priority issue because it determines the level of productivity of the employees. Understanding effective communication and ways to reduce violence in the workplace will help to bring positive energy to the workplace environment. You'll get a Free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling on the course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the course program. Key Topics: How to contribute to a positive and safe working environment How to reduce and deal with violence Understanding aggression, bullying and harassment Understanding equality, diversity and inclusion and the benefits to individuals and organisations Effective listening and communication techniques Essential problem-solving strategies Understanding common sources of conflict and awareness How to create a psychologically safe work environment Developing harassment policy The risk assessment process Learning Outcomes: Stop feeling distracted, anxious, or frustrated about conflict with your colleagues, or boss Use differences of opinion and conflicts constructively, leading to growth and creativity Use proven strategies and powerful communication skills to prevent and manage violence Identify warning signs and prevent or minimise violence before it gets worse Know your violence management style and how to improve it Create a safe work environment that encourages open communication and trust Know when to intervene and how to approach Implement the steps of conflict resolution Find out the root of conflict and prevent it in the long run Establish guidelines, procedures, and training for your organisation Experts created the Certificate in Workplace Management: Violence course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Skills You Will Gain Techniques to control the workplace environment Psychological understanding Problem-solving Assessment Leadership Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the course program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Here is the curriculum breakdown the course: Certificate in Workplace Management: Violence Course Module One: What Is Workplace Harassment? Module Two: Identifying the Bully Module Three: How to Handle Workplace Violence Module Four: Risk Assessment (I) Module Five: Risk Assessment (II) Module Six: Being the Victim Module Seven: Checklist for Employers Module Eight: Interview Process Module Nine: Investigation Process Module Ten: Developing a Workplace Harassment Policy Assessment Process Once you have completed all the modules in the Certificate in Workplace Management: Violence course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. Showcase Your Accomplishment of New Skills: Get a Certification of Completion The learners have to complete the assessment of this course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? This comprehensive course is designed for anyone who wants to learn how to prevent and solve violence through effective communication techniques and proven strategies. It is ideal for leaders, managers or human resources professionals who want to establish conflict resolution guidelines, procedures, and training for their staff to reduce the violence. Requirements The Certificate in Workplace Management: Violence program does not require any prior knowledge; everyone may participate! This course is open to anyone interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your speed and grow a quality skillset. Career path The course is an essential skills for managerial roles and applies to professionals in any industry, particularly those in the following careers: Businessmen Entrepreneur Human Resource Manager Life Coach Mentor

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.

Free Level 5 QLS Endorsed Certificate | 14 in 1 Bundle with Free Certificates | 150 CPD Points | Installment Payment

Free Level 5 QLS Endorsed Certificate | 14 in 1 Bundle with Free Certificates | 150 CPD Points | Installment Payment

🚀 Unlock Your Success Potential with 'Think Like a Winner - Entrepreneurial Mindset' Course! 🌟 🎯 Ready to supercharge your entrepreneurial journey and unleash your inner winner? Look no further than our cutting-edge online course designed to transform your mindset and amplify your success in the world of entrepreneurship! 🧠Develop the Mindset of a Champion: Discover the key principles and strategies employed by successful entrepreneurs worldwide. Learn to navigate challenges, seize opportunities, and cultivate the winning mindset that sets you apart from the crowd.   🔑 What You'll Gain: Proven techniques to foster a resilient and adaptable mindset Strategies to overcome setbacks and turn obstacles into opportunities Insider insights from industry-leading entrepreneurs Tools to enhance creativity, innovation, and problem-solving skills Actionable steps to maximize productivity and goal achievement   🌐 Course Highlights: Engaging video modules led by seasoned entrepreneurs and experts Interactive exercises to reinforce learning and practical application Access to a supportive community of like-minded individuals Exclusive resources, worksheets, and bonus materials   💡 Who Is This Course For? Whether you're a budding entrepreneur, a seasoned business owner, or someone hungry to unlock their full potential in the business world, this course is tailor-made for you. It's for anyone eager to adopt the mindset that propels winners to success! 🏆 Join Thousands of Successful Entrepreneurs: Our course has empowered countless individuals to think, act, and succeed like winners. Now, it's your turn to step into your full potential and achieve your entrepreneurial goals! 🎁 Limited-Time Offer: Enroll now and take advantage of our special offer! Invest in yourself and your future success today! Don't wait to start thinking like a winner! Seize this opportunity and enroll in 'Think Like a Winner - Entrepreneurial Mindset' now! Course Curriculum Module- 1 00:00 Module- 2 00:00 Module- 3 00:00 Module- 4 00:00 Module- 5 00:00 Module- 6 00:00 Module- 7 00:00 Module- 8 00:00 Module- 9 00:00 Module- 10 00:00