27757 Courses

Unlock the mysteries of the unknown with our comprehensive course on Introduction to Parapsychology and Paranormal. Delve into fascinating realms where science meets the supernatural, exploring a range of intriguing topics that will expand your understanding of the paranormal world. Key Features: CPD Certified Developed by Specialist Lifetime Access In this course, learners explore fascinating topics related to parapsychology and the paranormal. They delve into the mysteries surrounding UFOs and aliens, learning about investigations and different cultural beliefs. They also study astrology and its historical significance. The course examines the placebo effect, exploring how belief can influence health outcomes. Learners explore the concepts of probability and coincidence, gaining insights into how events may seem connected without being so. They investigate physical manifestations and reactions related to paranormal phenomena, and how these can affect people.The course also covers the influence of conscious and subconscious minds on paranormal experiences, and the practice of meditation as a tool for exploring these phenomena. Learners critically analyze theories related to parapsychology, and study the psychology behind claims of psychic fraud, understanding the complexities involved in such phenomena. Course Curriculum Module 01: Introduction to Parapsychology and Paranormal Module 02: Investigating Aliens and UFOs Module 03: The Origin and Legends in Different Cultures Module 04: Astrology Module 05: Placebo Effect Module 06: Probability and Coincidence Module 07: Physical Manifestations and Reactions Module 08: Manifestation on the Conscious & Subconscious Mind Module 09: Meditation Module 10: Exploring the Theories Module 11: The Psychology of Psychic Fraud Learning Outcomes: Understand Parapsychology theories and their relevance in modern society. Analyze cultural perspectives on paranormal phenomena and their historical context. Evaluate the scientific basis behind phenomena like astrology and placebo effects. Examine the psychological and physiological reactions to paranormal experiences. Discuss the ethical implications surrounding psychic phenomena and related practices. Apply meditation techniques to enhance understanding of consciousness and subconsciousness. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals curious about paranormal phenomena and its scientific explanations. Students of psychology and sociology interested in unconventional human experiences. Researchers exploring cultural beliefs and their impact on paranormal studies. Those seeking to understand the intersection of psychology and metaphysics. Enthusiasts of meditation and its applications in paranormal exploration. Career path Paranormal Researcher Cultural Anthropologist Astrologer Ethical Psychologist Meditation Instructor Psychological Researcher Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Unlock the mysteries of the unknown with our comprehensive course on Introduction to Parapsychology and Paranormal. Delve into fascinating realms where science meets the supernatural, exploring a range of intriguing topics that will expand your understanding of the paranormal world. Key Features: CPD Certified Developed by Specialist Lifetime Access In this course, learners explore fascinating topics related to parapsychology and the paranormal. They delve into the mysteries surrounding UFOs and aliens, learning about investigations and different cultural beliefs. They also study astrology and its historical significance. The course examines the placebo effect, exploring how belief can influence health outcomes. Learners explore the concepts of probability and coincidence, gaining insights into how events may seem connected without being so. They investigate physical manifestations and reactions related to paranormal phenomena, and how these can affect people.The course also covers the influence of conscious and subconscious minds on paranormal experiences, and the practice of meditation as a tool for exploring these phenomena. Learners critically analyze theories related to parapsychology, and study the psychology behind claims of psychic fraud, understanding the complexities involved in such phenomena. Course Curriculum Module 01: Introduction to Parapsychology and Paranormal Module 02: Investigating Aliens and UFOs Module 03: The Origin and Legends in Different Cultures Module 04: Astrology Module 05: Placebo Effect Module 06: Probability and Coincidence Module 07: Physical Manifestations and Reactions Module 08: Manifestation on the Conscious & Subconscious Mind Module 09: Meditation Module 10: Exploring the Theories Module 11: The Psychology of Psychic Fraud Learning Outcomes: Understand Parapsychology theories and their relevance in modern society. Analyze cultural perspectives on paranormal phenomena and their historical context. Evaluate the scientific basis behind phenomena like astrology and placebo effects. Examine the psychological and physiological reactions to paranormal experiences. Discuss the ethical implications surrounding psychic phenomena and related practices. Apply meditation techniques to enhance understanding of consciousness and subconsciousness. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals curious about paranormal phenomena and its scientific explanations. Students of psychology and sociology interested in unconventional human experiences. Researchers exploring cultural beliefs and their impact on paranormal studies. Those seeking to understand the intersection of psychology and metaphysics. Enthusiasts of meditation and its applications in paranormal exploration. Career path Paranormal Researcher Cultural Anthropologist Astrologer Ethical Psychologist Meditation Instructor Psychological Researcher Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

The aim of this course is to help the learner appreciate the value of investment analysis and how important it is for people who want to reach their financial objectives. After the successful completion of the course, you will be able to learn about the following; Understand the difference between direct and indirect investments and the advantages and disadvantages of each in terms of risk and return. Learn the key measures of return and risk used in investment analysis, including expected return, standard deviation, and Sharpe ratio, and how to calculate them. Explore the determinants of the required rate of return, including risk-free rate, market risk premium, and beta, and understand how these factors affect investment decisions. Gain a solid understanding of correlation and coefficient of determination, and how they are used to measure the strength and direction of the relationship between two assets. Dive into the concept of returns, including the different types of returns such as capital gains, dividends, and interest, and how they impact investment analysis and decision-making. Discover the effect of diversification on investment risk, and how to construct a diversified portfolio that balances risk and return. Investment analysis is critical for individuals seeking to achieve their financial goals. Whether you are a seasoned investor or just starting out, understanding investment analysis principles can help you make informed decisions and achieve optimal returns on your investments. This course will provide a comprehensive introduction to investment analysis, covering everything from the basics of investment vehicles to the intricacies of portfolio construction and risk management. By the end of this course, you will have a solid foundation in the principles and practices of investment analysis, enabling you to confidently navigate the world of finance and achieve your financial objectives. Join us on this exciting journey to master the art of investment analysis and take control of your financial future! The aim of this course is to make the learner understand the importance of investment analysis which is critical for individuals seeking to achieve their financial goals. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Introduction to Investment Analysis Self-paced pre-recorded learning content on this topic. Introduction to Investment Analysis Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Investment Analyst Portfolio Manager Financial Advisor Financial Planner Trader Wealth Manager Investment Banker Asset Manager Risk Manager Hedge Fund Manager Private Equity Investor Corporate Finance Manager Entrepreneur Regulator Policy Analyst Business Executive Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration. Overview After completing this course, students will gain the skills to: - Understand the architecture of SharePoint Online - Have knowledge of all the components in SharePoint Online - Have on hands on experience configuring the components of SharePoint Online - Have hands on experience configuring the options - Work with Site Collections and storage options - Manage user profiles and social profiling - Understand and configure data connectivity in SharePoint Online - Build a taxonomy structure - Understand and configure Search in SharePoint Online - Configure and deploy apps - Understand and define Enterprise content management and data loss prevention. - Configure additional options and features in SharePoint Online such as Information Rights Management This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online. 1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE Introduction to the Office 365 Administration Center Configure Reporting Accessing SharePoint management tools Accessing security and compliancy Managing Office 365 and SharePoint Online with PowerShell Comparing On Premises SharePoint with SharePoint Online User identity in Office 365 and SharePoint Online Manging user domains Building Hybrid scenarios OneDrive and Sites redirection Yammer redirection Understand hybrid search Hybrid business data connectivity Hybrid taxonomy 2 - WORKING WITH SITE COLLECTIONS Introduction to classic and modern admin centers Creating Site Collections Defining ownership and security for site collections Configuring Storage Configure External Access to site collections Recovering site collections Configure external sharing Managing site collections with PowerShell 3 - MANAGING USER PROFILES Overview of the profile service Defining profile properties Map profile properties to a term store Creating custom profile properties Managing audiences Creating audiences Managing user profile policies Configure trusted my site host locations Configure preferred search center locations Defining read access permission levels Configuring newsfeed options Setup email notifications Configure my site cleanup 4 - WORKING WITH DATA CONNECTIONS Introduction to Data Connections Overview of PowerApps, Flow and PowerBi Overview of the business connectivity service Introduction to BDC definition files Creating BDC definition files Introduction to the secure store service Configuring the secure store service Creating secure store target application settings Configure connections to cloud services Configure connections to on-premises services Tools to build data connections Creating external content types Building external lists using external data 5 - MANAGING THE TERM STORE Overview of the term store Understanding terms and life cycle management Creating term groups Creating the term store Creating Term Sets in the UI Creating Term Sets via importing via a CSV Creating terms in the UI Creating terms via PowerShell and CSOM Manage terms with synonyms and pinning Configure delegated administration 6 - CONFIGURING SEARCH An Introduction to the search service Classic versus Modern search experience Understanding Managed Properties Create Managed Properties Manage Authoritative pages Understand Result sources Create and configure result sources Understand Query rules Promoting results through query rules Remove search results from the index Exporting search configurations Importing search configurations 7 - CONFIGURING APPS An Introduction to Apps Understanding the App Catalog Building the App catalog Adding Apps to the catalog Add Apps to your SharePoint sites Adding Apps via the marketplace store Manage App licensing Configure store access settings Monitoring app usage 8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE An Introduction to ECM in SharePoint Online Components of ECM Office 365 versus classic compliancy Understanding In-Place records management Configure In-Place records management Understanding the records center Build and configure a records center Understanding the compliancy policy center Build a compliancy policy center and configure policies Discover the security and compliancy center Configure an eDiscovery center Build an eDiscovery case Understand data loss prevention Build a data loss prevention policy and query Working with classification and data governance 9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE Configure OneDrive features Configure use of Yammer or Newsfeeds Understand Information Rights Management Configure Information Rights Management Define site classification options Understand early release options for Office 365 Configure Early release options for your Office 365 tenant Manage Access Control Additional course details: Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators 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.

Register on the Introduction to Maps in R Shiny and Leaflet today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Introduction to Maps in R Shiny and Leaflet is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Introduction to Maps in R Shiny and Leaflet Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Introduction to Maps in R Shiny and Leaflet, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Section 01: Introduction Introduction 00:09:00 Section 02: Installation and Setup Installation and Setup 00:12:00 Section 03: Creating the Earthquake OSM Map Creating your first map 00:08:00 Creating a menu item 00:10:00 Adding markers 00:06:00 Adding circle markers 00:08:00 Creating a legend 00:07:00 Adding a layers control 00:13:00 Section 04: Creating the Earthquake Dark Map Adding the second menu item 00:06:00 Adding circle markers 00:05:00 Adding a legend 00:03:00 Change map based on zoom level 00:04:00 Section 05: Creating the Heatmap Adding the third menu item 00:06:00 Adding the heatmap data 00:04:00 Section 06: Creating the Choropleth Map Adding the fourth menu item 00:04:00 Downloading and transforming data 00:11:00 Preparing data for styling 00:07:00 Creating and styling the choropleth map 00:11:00 Creating the legend 00:07:00 Section 07: Project Source Code Resource 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

This Professional Certificate Course in Introduction to Requirements Management provides a comprehensive overview of fundamental concepts, including the definition and significance of Requirements Management. Participants will gain insights into the intricacies of requirement management processes, understand the critical importance of effective stakeholder management in gathering requirements, and explore the relationship between requirement gathering and strategic project planning. Through targeted modules, learners will also identify key elements of high-quality requirements, grasp diverse types of requirements in project management, and appreciate the pivotal role of requirement management in ensuring project success. After the successful completion of the course, you will be able to learn about the following: Definition and Explanation of Requirements Management Explain the process of requirement management. Explain importance of requirement management Identify the key elements of a good requirement Discuss the different types of requirements in project management. Explain the importance of stakeholder management in requirement gathering Understand the relationship between requirement gathering and project planning This Professional Certificate Course in Introduction to Requirements Management offers a comprehensive understanding of the fundamentals, encompassing the definition and importance of Requirements Management, key elements of effective requirements, diverse requirement types, stakeholder management significance, and the integral connection between requirement gathering and project planning. Participants will gain essential insights into the entire requirement management process, ensuring a solid foundation for successful project implementation. This Professional Certificate Course in Introduction to Requirements Management provides a comprehensive foundation, covering the definition and process of requirements management, emphasizing the importance of stakeholder engagement, and equipping participants with the skills to identify key elements of good requirements, discuss various types, and understand the pivotal link between requirement gathering and effective project planning. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Introduction to Requirement Management Self-paced pre-recorded learning content on this topic. Introduction To Requirements Management Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience, Project Managers Business Analysts Software Developers System Analysts Quality Assurance Professionals Product Managers Stakeholders involved in Project Planning Anyone Seeking a Foundation in Requirements Management Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

The aim of the Introduction to Commercial Banks course is to provide students with a foundational understanding of commercial banking operations and their role in the economy. The course will equip students with the knowledge and skills to evaluate the risks and opportunities associated with banking, as well as the regulatory framework that governs banks. After the successful completion of the course, you will be able to learn about the following, Identify types of commercial banks and their roles. Analyze the evolution of commercial banks. Evaluate services provided by commercial banks. Assess the relationship between commercial banks and competitors. Evaluate the impact of key trends on banks. Explain the functions of central banks. Compare central banks and commercial banks. Analyze the concept of Central Bank Digital Currency (CBDC). Evaluate the role of commercial banks in CBDCs. Recognize the significance of commercial banks. The Introduction to Commercial Banks course provides an overview of the role of commercial banks in the economy, including their functions, products, and services. Students will learn about the regulatory environment that governs banks, as well as the risks and opportunities involved in banking operations. By the end of the course, students will have a comprehensive understanding of how commercial banks operate and their impact on the financial system. Introduction to Commercial Banks is a comprehensive course designed to provide an understanding of the role and function of commercial banks in the financial system. The course covers the basics of banking, including the types of commercial banks, their operations, and their regulatory framework. Students will gain practical knowledge of banking practices, such as loans, deposits, and investment management. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Introduction to Commercial Banks Self-paced pre-recorded learning content on this topic. Introduction to Commercial Banks Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Bank Teller Personal Banker Loan Officer Credit Analyst Commercial Bank Manager Investment Banker Treasury Analyst Financial Consultant Risk Manager Compliance Officer. Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Learn about all aspects of Digital Board Games and Gamification and: find your ideal role in the Industry.  Gain essential insights into gaming design such as key design features, popular genres, types of producers, target audiences and the best stores to publish.  Learn what features make the best games, understand the range, and find out which genre is right for you. You will also learn how to: Choose the best tutorial for each target audience Find free assets to use in your games, even commercially Fill a basic game design document for your own games Game Design - Introduction to Game Design Theory is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD so you will get a career boost upon completing this course. Our Game Design - Introduction to Game Design Theory is packed with 19 modules and 1 hour, 27 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Lean Six Sigma Green Belt Certification Program: On-Demand This learning series is designed to enable participants to fulfill the important role of a Lean Six Sigma Green Belt and to incorporate the Lean Six Sigma mindset into their leadership skills. Green Belt is not just a role, it is also a competency required for leadership positions at many top companies. This learning series is designed to enable participants to fulfill the important role of a Lean Six Sigma Green Belt and to incorporate the Lean Six Sigma mindset into their leadership skills. With a real-world project focus, the series will teach the fundamental methodology, tools, and techniques of the Define, Measure, Analyze, Improve and Control Process Improvement Methodology. This course is delivered through sixteen 3-hour online sessions. What you Will Learn At the end of this program, you will be able to: Identify strategies for effectively leading high performing process improvement teams Analyze whether projects align with business strategy Apply process improvement methodologies to DMAIC steps, based on real world scenarios Explain ways to appropriately respond to process variation Distinguish among best practice problem solving methodologies Evaluate and effectively communicate data-driven decisions, based on real world scenarios Introduction Lean Six Sigma & quality The vision The methodologies The metric Project Selection Why Projects Random idea generation Targeted idea generation CTQs (Critical to Quality) & projects Project screening criteria Quick improvements Introduction to Define Project Planning Developing the core charter Developing a project charter Facilitation Process Management Business process management Top-down process mapping Voice of the Customer Voice of Customer Stakeholder analysis Communication planning Kicking off the project Define Summary Introduction to Measure Data Collection Fact-based decision making Data sampling Operations definitions Data collection plan Measurement system analysis Graphical Statistics for Continuous Data Meet Six SigmaXL Graphical & statistical tools Data stratification Graphical Statistics for Discrete Data Pareto analysis Dot plots Plotting data over time: Looking for patterns Variation Concepts Variation is reality Special Cause and Common Cause variation Example of standard business reporting Individuals Control Chart Process Capability Genesis of process capability Calculating the metrics of Six Sigma Yield metrics: Measuring process efficiency Cost of Poor Quality The Cost of Poor Quality (COPQ) Cost of Quality categories Calculating the Cost of Poor Quality Measure Summary Introduction to Analyze Process Analysis Introduction to process analysis Value-added analysis Cycle time analysis WIP & pull systems Analyzing bottlenecks and constraints Cause & Effect Analysis Fishbone/Ishikawa diagram 5-Whys analysis Graphical & statistical tools Advanced Analysis Why use hypothesis rests? Hypothesis tests Correlation and regression analysis Analyze Summary Introduction to Improve Solutions Creativity techniques Generating alternative solutions Solution selection techniques Introduction to Design of Experiments Introduction to DOE DOE activity Error Proofing Failure mode & effect analysis Poka-Yoke Project Management Fundamentals Successful teams Project roles Conflict management Standardization Standardization The Visual Workplace 5S Piloting & Verifying Results What is a pilot? Evaluating results Improve Summary Introduction to Control Statistical Process Control Review of Special & Common Cause variation Review of Individual Control Chart P-Chart for discrete proportion data Transition Planning Control plan Project closure Control Summary Summary and Next Steps