485 Developer courses in Nottingham delivered Live Online

Duration 4 Days 24 CPD hours This course is intended for The audience includes System administrators, IT administrators, Maintenance personnel, Procurement personnel, Inventory personnel, Asset managers and work managers. The audience also includes consultants that are looking to gain an understanding of Maximo Asset Management 7.6.x. Overview After completing this course, you should be able to perform the following tasks: Describe the Asset Management Lifecycle in Maximo Query and Retrieve Data Describe options available for various applications Describe and use the different Maximo applications and functions as they relate to business processes Enter core data elements and data structures This course helps clients to make informed business decisions with the design and planning of their implementation. Consultants gain a foundation on which to build their product knowledge and skill set. The foundation also helps in working with clients to obtain optimal value from the product. It provides the fundamental concepts and setup considerations of the various business areas that Maximo supports and, as a bonus section, the new Work Center functionality. This course consists of lectures, demonstrations, and labs that cover applications, processes and interrelationships within Maximo. IBM Maximo Asset Management Overview This unit provides a high-level overview of IBM Maximo Asset Management framework architecture and its key element and components. You learn about strategic asset management with IBM Maximo Asset Management to manage assets through their life cycle. You also discuss implementation considerations and system configuration as they pertain to integrations, reporting, and business processes. Item Planning and Setup This unit focuses on the planning and setup of inventory item and asset configurations. You use the applications to set up inventory items and asset configurations in Maximo. Assets This unit focuses on the creation of assets and how they are used in Maximo Asset Management. You will learn the applications that can create assets, associate assets to people and locations and learn how to move assets between locations. Work Management This unit focuses on learning to use Maximo for work management with the generation and processing of work orders to completion. This unit will include the new Work Centers that came available in Maximo 7.6.0.5. Work Centers are made available for Business Analyst, Supervisors and Workers complete the work order tasks. We will also look at the new Inspection Form tool. Purchasing This unit focuses on learning to use Maximo for procurement, starting with generating purchase requests, then processing them, and completing them. Developer and System Administration Each lesson in this unit focuses on different aspects of entering records into the database. This unit is also an overview of the different applications and setup options that are available with IBM Maximo Asset Management. The focus is on using applications that are primarily used for building (setting up) the database. Additional course details: Nexus Humans U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x 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 U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x 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 Technical leaders Overview This course provides general overview of Blockchain technology and is specifically designed to answer the following questions:What is Blockchain? (What exactly is it?)Non-Technical Technology Overview (How does it work?)Benefits of Blockchain (Why should anyone consider this?)Use Cases (Where and for what apps is it appropriate?)Adoption (Who is using it and for what?)Implementation (How do I get started?)Future of Blockchain (What is its future?) This instructor-led 1 day Blockchain Architecture training is for technical leaders who need to make decisions about architecture, environment, and development platforms. What is Blockchain? A record keeping system Trust Decentralization Trustless environment How does Blockchain work? Announcements Blocks Nodes Chaining Verification Consensus Scalability Privacy Crypto Hashing Digital Fingerprinting PoW vs PoS Types of Blockchains Public vs Private Open vs closed Smart Contracts Blockchain as History Tokens / Coins Gas How is Blockchain different from what we have today? Decentralized Peer-to-peer architecture Software vs Firmware Database vs Blockchain Distributed database or other technology? Data Sovereignty Group Consensus What are Use Cases for Blockchain? Use Case Examples Currency Banking Services Voting Medical Records Supply Chain / Value Chain Content Distribution Verification of Software Updates (cars, planes, trains, etc) Law Enforcement Title and Ownership Records Social Media and Online Credibility Fractional asset ownership Cable Television billing High fault tolerance DDoS-proof Public or Private Blockchain? Who are the participants? What does a Blockchain app look like? DApp Resembles typical full stack web application Any internal state changes and all transactions are written to the blockchain Node.js IDE Public Blockchain visibility Private Blockchain solutions Oracles How do I design a Blockchain app? What does this solution need to let users do? Will the proposed solution reduce or remove the problems and pain points currently felt by users? What should this solution prevent users from doing? Do you need a solution ready for heavy use on day 1? Is your solution idea enhanced by the use of Blockchain? Does the use of Blockchain create a better end-user experience? If so, how? Has your business developed custom software solutions before? What level of support are you going to need? How big is the developer community? Does your vision of the future align with the project or platform's vision of the future? Does the platform aim to make new and significant contributions to the development space, or is it an efficiency / cost play? Should the solution be a public or private Blockchain? Should the solution be an open or closed Blockchain? Create a plan for contract updates and changes! Hybrid solutions Monetary exchanges? How do I develop a Blockchain app? AGILE approach pre-release Define guiding principles up front Software vs Firmware Announcements, not transactions! Classes, not contracts Link contracts to share functions Use calling contracts to keep contract address the same Hyperledger vs Ethereum CONSIDER No of Users * Avg No of Transactions (state changes) per User Should a Blockless solution be applied? Performance Security Anonymity Security Monolithic vs Modular Sandwich complexity model How do I test a Blockchain app? Recommend 5x to 10x traditional application testing time Security Networks Additional course details: Nexus Humans Blockchain - An Overview for Business Professionals 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 Blockchain - An Overview for Business Professionals 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 The skills covered in this course converge on four areas-software development, IT operations, applied math and statistics, and business analysis. Target students for this course should be looking to build upon their knowledge of the data science process so that they can apply AI systems, particularly machine learning models, to business problems. So, the target student is likely a data science practitioner, software developer, or business analyst looking to expand their knowledge of machine learning algorithms and how they can help create intelligent decisionmaking products that bring value to the business. A typical student in this course should have several years of experience with computing technology, including some aptitude in computer programming. This course is also designed to assist students in preparing for the CertNexus Certified Artificial Intelligence (AI) Practitioner (Exam AIP-210) certification Overview In this course, you will develop AI solutions for business problems. You will: Solve a given business problem using AI and ML. Prepare data for use in machine learning. Train, evaluate, and tune a machine learning model. Build linear regression models. Build forecasting models. Build classification models using logistic regression and k -nearest neighbor. Build clustering models. Build classification and regression models using decision trees and random forests. Build classification and regression models using support-vector machines (SVMs). Build artificial neural networks for deep learning. Put machine learning models into operation using automated processes. Maintain machine learning pipelines and models while they are in production Artificial intelligence (AI) and machine learning (ML) have become essential parts of the toolset for many organizations. When used effectively, these tools provide actionable insights that drive critical decisions and enable organizations to create exciting, new, and innovative products and services. This course shows you how to apply various approaches and algorithms to solve business problems through AI and ML, all while following a methodical workflow for developing data-driven solutions. Solving Business Problems Using AI and ML Topic A: Identify AI and ML Solutions for Business Problems Topic B: Formulate a Machine Learning Problem Topic C: Select Approaches to Machine Learning Preparing Data Topic A: Collect Data Topic B: Transform Data Topic C: Engineer Features Topic D: Work with Unstructured Data Training, Evaluating, and Tuning a Machine Learning Model Topic A: Train a Machine Learning Model Topic B: Evaluate and Tune a Machine Learning Model Building Linear Regression Models Topic A: Build Regression Models Using Linear Algebra Topic B: Build Regularized Linear Regression Models Topic C: Build Iterative Linear Regression Models Building Forecasting Models Topic A: Build Univariate Time Series Models Topic B: Build Multivariate Time Series Models Building Classification Models Using Logistic Regression and k-Nearest Neighbor Topic A: Train Binary Classification Models Using Logistic Regression Topic B: Train Binary Classification Models Using k-Nearest Neighbor Topic C: Train Multi-Class Classification Models Topic D: Evaluate Classification Models Topic E: Tune Classification Models Building Clustering Models Topic A: Build k-Means Clustering Models Topic B: Build Hierarchical Clustering Models Building Decision Trees and Random Forests Topic A: Build Decision Tree Models Topic B: Build Random Forest Models Building Support-Vector Machines Topic A: Build SVM Models for Classification Topic B: Build SVM Models for Regression Building Artificial Neural Networks Topic A: Build Multi-Layer Perceptrons (MLP) Topic B: Build Convolutional Neural Networks (CNN) Topic C: Build Recurrent Neural Networks (RNN) Operationalizing Machine Learning Models Topic A: Deploy Machine Learning Models Topic B: Automate the Machine Learning Process with MLOps Topic C: Integrate Models into Machine Learning Systems Maintaining Machine Learning Operations Topic A: Secure Machine Learning Pipelines Topic B: Maintain Models in Production

PHP and MySQL Training Masterclass 2023 Course Overview This PHP and MySQL Training Masterclass 2023 offers a comprehensive guide to mastering dynamic web development using PHP and MySQL. Learners will explore essential programming concepts, database integration, and application building through progressive projects designed to enhance their coding capabilities. The course covers core skills such as user authentication, comment systems, ratings, and interactive applications, equipping students with the confidence to develop fully functional web solutions. By the end, participants will have the knowledge to build, customise, and manage robust web applications, boosting their employability and technical proficiency in today’s digital marketplace. Course Description This masterclass delves into key aspects of PHP programming and MySQL database management, providing learners with a structured learning experience. Starting with installation and configuration, it progresses through multiple project-based modules focusing on real-world applications such as authentication systems, comment and rating features, weather apps, and live search functionality. Each module deepens understanding of server-side scripting and database queries, enhancing problem-solving and coding fluency. Participants will gain expertise in integrating PHP scripts with MySQL databases, optimising application performance, and managing data securely. The course is designed to develop both foundational and advanced skills essential for web development careers, delivered in clear, concise UK English. PHP and MySQL Training Masterclass 2023 Curriculum Module 01: Introduction Module 02: Installation Module 03: First Project: Building an Authentication System Module 04: Second Project: Building a Comments System Module 05: Third Project: Creating a Rating System Module 06: Fourth Project: Creating a Weather App Module 07: Fifth Project: Build a Cool Like and Dislike System Module 08: Sixth Project: Building a Simple CV Builder Module 09: Seventh Project: QR Codes Generator Module 10: Eighth Project: Build a Full Live Search System (See full curriculum) Who Is This Course For? Individuals seeking to develop skills in dynamic web development. Professionals aiming to enhance their web programming career. Beginners with an interest in server-side scripting and databases. Web developers wanting to expand their expertise in PHP and MySQL. Career Path Web Developer Backend Developer PHP Developer Database Administrator Full-Stack Developer Software Engineer Digital Solutions Specialist

PHP and MySQL Training 2022: Build 5 Real World Projects Course Overview: "PHP and MySQL Training 2022: Build 5 Real World Projects" offers an in-depth exploration of web development using PHP and MySQL, empowering learners with the skills to create dynamic, database-driven websites. Through five real-world projects, learners will gain a practical understanding of PHP’s functionality, MySQL databases, and how to combine the two to build effective web applications. By the end of the course, participants will have the knowledge to develop robust and scalable systems, such as login and registration systems, CRUD apps, and email-sending features. This course equips learners with essential skills to launch their careers in web development or enhance their existing expertise. Course Description: In this comprehensive training course, learners will delve into core concepts of PHP and MySQL, with a focus on practical application. The course covers key areas such as installation and configuration of PHP, creating user authentication systems, developing CRUD applications, building a URL shortening service, and sending emails with PHP. Each module guides learners through building fully functional projects that address common real-world needs. Along the way, participants will enhance their coding proficiency, understand the importance of secure web applications, and learn the techniques required to build dynamic websites. By the end of this course, learners will be proficient in using PHP and MySQL to develop and manage complex web systems. PHP and MySQL Training 2022: Build 5 Real World Projects Curriculum: Module 01: Introduction Module 02: Installation Module 03: First Project: Login and Registration System Module 04: Second Project: Full Crud App Module 05: Third Project: URL Shortening Service Module 06: Fourth Project: PHP Gallery Module 07: Fifth Project: Sending Emails with PHP (See full curriculum) Who is this course for? Individuals seeking to build a strong foundation in web development. Professionals aiming to expand their knowledge of PHP and MySQL. Beginners with an interest in coding and web development. Aspiring web developers looking to work on real-world projects. Career Path Web Developer PHP Developer Backend Developer Database Administrator Full Stack Developer

Duration 5 Days 30 CPD hours This course is intended for This class is designed for experienced BizTalk Server Developers who have at least one year of hands-on experience developing BizTalk Server applications. Overview In this 5-day course, you will learn how to apply best practices and design patterns to build smarter BizTalk Server applications. Furthermore, this course provides extensive coverage of BizTalk Server's extensibility, including such topics as: custom functoids, custom pipeline components, and invoking external .NET methods. This course is designed specifically for experienced BizTalk Server developers and focuses on best practices & pattern-based design while pulling back the curtain on some of BizTalk Server's eccentricities. Review of BizTalk Server Fundamentals The BizTalk Server Architecture Inner Workings of the Messaging Engine Messaging Engine Deep Dive Two-way Messaging Without Orchestrations Designing and Testing Schemas Schema Design Enabling Unit Testing for BizTalk Projects Data Translation and Transformation Custom Data Transformation Creating Custom Pipeline Components Working with Message Interchanges Debatching Message Interchanges Advanced Concepts of WCF Adapters Connecting to External Systems Using WCF LOB Adapters in BizTalk Server Publishing and Consuming WCF and RESTful Services Overview of Service Integration Using WCF Implementing WCF Services Preprocessing Messages with IIS Modules Consuming Services Advanced Orchestration Communication Patterns Orchestration Engine Deep Dive Splitting and Aggregating Messages using Orchestrations Orchestration Communication Bridging the Synchronous/Asynchronous Gap Across Multiple Channels Correlating Messages in Orchestration Instances Building Convoy Orchestrations Handling Orchestration Faults and Exceptions Exception Handling in Orchestrations Implementing Transactions and Compensation Creating Transactional Processes Designing Custom Tracking Models for BizTalk Applications Introduction to Business Activity Monitoring Enabling Business Activity Monitoring Extending BAM Beyond BizTalk Building Declarative Logic Using the Business Rules Engine Concepts of Declarative Logic Fundamentals of BizTalk BRE Integrating Policies with BizTalk Advanced Concepts of the Business Rules Engine Advanced Business Rule Concepts Working with Advanced Facts Integrating Across Business Boundaries Using Parties, Roles, and EDI Port Binding Option Review Role-Based Integration What is EDI? Enabling EDI-Based Messaging

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Business Process Architects, Developers, Developer Consultants, System Administrators, System Architects, and Technology Consultants. Overview The participants will learn to configure scenariosUnderstand and configure the different options with which a back-end system can be connected to the SAP Process Integration (formerly known as SAP Exchange Infrastructure). In this course, students gain knowledge in configuring SAP Process Integration and learn how to implement different integration scenarios with SAP and non-SAP applications. SAP Process Integration Architecture Describing SAP Process Integration Architecture Explaining the Functionality and Utilization of SAP Process Integration The System Landscape Directory (SLD) Maintaining Products and Software Components in the System Landscape Directory (SLD) Implementing Technical Systems in the System Landscape Directory Maintaining Business Systems for Use in the Integration Directory Interface Objects in the Enterprise Service Repository (ESR) Listing Options for Navigating the Enterprise Services Repository (ESR) Analyzing Interface Objects in the Enterprise Services Repository (ESR) Maintaining Interface Objects Defining Message Processing Types and Quality of Services Object Mapping in the Enterprise Service Repository (ESR) Creating Message Mapping Objects Mapping Between Service Interfaces Analyzing Asynchronous Integration Scenarios Configuration of Integration Directory Communication Objects Using Configuration Views Creating Communication Channels in the Integration Directory (ID) Configuration of Integration Directory Objects for ABAP Processing Analyzing Objects Used in the Configuration of Integration Engine (IE) Communication Analyzing Routing Objects Used in Integration Engine (IE) Communication Analyzing Multiple Receiver Objects Used in Integration Engine (IE) Communication Configuration of Integration Directory Objects for Java Processing Maintaining Objects for Advanced Adapter Engine (AAE)-Only Processing Maintaining Objects for Advanced Adapter Engine Extended (AEX) Message Processing Creating and Deploying Integration Flows to the Advanced Adapter Engine Extended (AEX) Operations of SAP Process Integration Using the Runtime Workbench Using the Process Integration Monitoring (PIMon) Home Using the SAP NetWeaver Administrator Connectivity Options for SAP Process Integration Analyzing Connectivity Options between Back-End Systems with SAP Process Integration HTTP Connectivity Options Configuring the Simple Object Access Protocol (SOAP) Adapter Using Proxy Technology Checking the HTTP ABAP Adapter Using the HTTP_AAE (Java) Adapter File Adapter Configuration Configuring the Receiver File Adapter Configuring a Sender File Adapter Intermediate Document (IDoc) Connectivity Options Using the Intermediate Document (IDoc) Adapter with the Receiver Intermediate Document Adapter for the ABAP Stack Using the Sender Intermediate Document (IDoc) Adapter Using the Intermediate Document (IDoc) Adapter in the Advanced Adapter Engine (AAE) Configuring a Complete Intermediate Document (IDoc) Scenario Configuration of SAP Business Application Programming Interfaces (BAPIs) Connectivity Configuring the Receiver Remote Function Call (RFC) Adapter Configuring the Sender Remote Function Call (RFC) Scenario Enterprise Services and B2B Connectivity Analyzing Enterprise Services Configuring Business-to-Business (B2B) Connectivity Cross-Component Business Process Management (ccBPM) Integration Processes Analyzing the Runtime of the Cross-Component Business Process Management (ccBPM) Identifying the Steps to Create and Use an Integration Process Additional course details: Nexus Humans BIT400 SAP Process Integration 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 BIT400 SAP Process Integration 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.

PHP for Beginners 2023 Guide: Develop a ECommerce Store Course Overview This course provides a comprehensive introduction to PHP programming through the development of a fully functional eCommerce store. Learners will explore core PHP concepts while building practical features such as product management, user authentication, shopping cart functionality, and payment integration using Stripe. Designed for beginners, the course emphasises clear, step-by-step instruction to equip learners with the skills needed to create dynamic, database-driven web applications. By the end of the course, participants will be confident in setting up a PHP environment, developing user and admin interfaces, and managing eCommerce workflows effectively. This guide is ideal for anyone looking to launch their journey into web development or expand their programming toolkit with essential PHP knowledge relevant to modern online retail solutions. Course Description Delving deeper into PHP fundamentals, this course guides learners through the full lifecycle of building an eCommerce website. It covers everything from installing the necessary tools to implementing secure authentication systems and managing product categories. Participants will learn how to structure their code efficiently, interact with databases, and integrate payment gateways like Stripe to process transactions securely. The curriculum balances foundational theory with project-based learning, ensuring students acquire not only programming syntax but also an understanding of real-world web application workflows. By mastering user-facing and admin panel functionalities, learners develop versatile skills applicable across various web development projects. Throughout the course, the focus remains on building scalable, maintainable code following best practices in PHP development. PHP for Beginners 2023 Guide: Develop a ECommerce Store Curriculum Module 01: Introduction Module 02: Installation Module 03: Getting Started with the Project and Authentication System Module 04: Preparing Products Module 05: Developing Cart and Payment with Stripe Module 06: Categories and Finishing Users Side Module 07: Getting Started with Admin Panel Module 08: Finishing Categories (Admin Side) Module 09: Finishing Products (Admin Side) Module 10: Update: Extra Lectures Module 11: Update - Creating a Wishlist System (See full curriculum) Who Is This Course For? Individuals seeking to learn web development with PHP. Professionals aiming to enhance their programming skills for career growth. Beginners interested in creating eCommerce websites. Anyone wanting to understand backend development and payment integration. Career Path Junior PHP Developer Web Developer (Front and Back End) ECommerce Developer Full Stack Developer Software Engineer in Web Technologies

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

JavaScript Project – Game Development with JS Course Overview: In the "JavaScript Project – Game Development with JS" course, learners will gain a solid foundation in developing games using JavaScript. The course offers a comprehensive look at the game development process, covering key concepts like game mechanics, logic implementation, and interactive design. By the end of the course, learners will be equipped to build functional browser-based games from scratch. This course provides valuable skills for those wishing to enter the game development industry, helping learners not only understand JavaScript in-depth but also apply their knowledge to real-world projects. Course Description: This course delves deep into the world of game development using JavaScript. Learners will explore essential concepts such as creating game loops, handling user input, collision detection, and integrating audio and visuals. By following a structured curriculum, students will work on practical projects, gaining an understanding of how to plan, design, and implement game logic. The course focuses on providing the learners with skills that can be directly applied to creating interactive web-based games, while also enhancing their problem-solving abilities. Upon completion, learners will be prepared to develop simple yet engaging games for both personal and professional use. JavaScript Project – Game Development with JS Curriculum: Module 01: Introduction Module 02: Beware of the Jolly Roger (See full curriculum) Who is this course for? Individuals seeking to develop strong JavaScript programming skills. Professionals aiming to enhance their game development expertise. Beginners with an interest in web development or game creation. Enthusiasts wishing to turn their passion for games into a technical skill. Career Path Web Developer Game Developer Front-End Developer Software Engineer Interactive Media Specialist