• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

320 Algorithms courses delivered Online

MySQL for developers

5.0(3)

By Systems & Network Training

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

MySQL for developers
Delivered in Internationally or OnlineFlexible Dates
£2,797

Big Data Analysis and Visualization Strategies

4.9(27)

By Apex Learning

Tired of browsing and searching for a Big Data course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Big Data bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Big Data course that will enhance your skills and prepare you for the competitive job market. so, ourexperts are available for answering your queries on Big Data and help you along your learning journey. Advanced audio-visual learning modules of these Big Data courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Big Data, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Big Data Bundle Consists of the following Premium courses: Course 01: SQL NoSQL Big Data and Hadoop Course 02: Complete Microsoft Power BI 2021 Course 03: Introduction to Data Analysis Course 04: Python for Data Analysis Course 05: Statistical Analysis Course 06: Data Analytics with Tableau Course 07: Basic Google Data Studio Course 08: Fundamentals of Business Analysis Course 09: Complete Introduction to Business Data Analysis Level 3 Course 10: Business Intelligence and Data Mining Masterclass Course 11: Research Methods in Business Course 12: Basic Graph Theory Algorithms Course 13: Data Protection and Data Security Level 2 Course 14: Data Analysis in Excel Level 3 Course Enrol now in Big Data to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Big Data expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. CPD 165 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Big Data bundle. Requirements Our Big Data course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Big Data expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (SQL NoSQL Big Data and Hadoop) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (SQL NoSQL Big Data and Hadoop) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Big Data Analysis and Visualization Strategies
Delivered Online On Demand
£79

Bioinformatics

4.9(27)

By Apex Learning

Overview This comprehensive course on Bioinformatics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Bioinformatics comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Bioinformatics. It is available to all students, of all academic backgrounds. Requirements Our Bioinformatics is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 6 lectures • 00:50:00 total length •Introduction to Bioinformatics: 00:10:00 •Topics in Computational Genomics: 00:10:00 •Algorithms in Computational Biology: 00:10:00 •Applied Bioinformatics Tools: 00:10:00 •Structure and Function of Proteins: 00:10:00 •Assignment - Bioinformatics: 00:00:00

Bioinformatics
Delivered Online On Demand50 minutes
£12

CertNexus Certified Artificial Intelligence Practitioner CAIP (AIP-210)

By Nexus Human

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

CertNexus Certified Artificial Intelligence Practitioner CAIP (AIP-210)
Delivered OnlineFlexible Dates
Price on Enquiry

Tiktok to Star Pipeline - Short Form Content for Facebook,Instagram, and YouTube

By Compete High

🌟 Unleash Your Social Media Stardom with 'TikTok to Star Pipeline' Course! 🌟     Ready to transform your social media game and skyrocket your online presence across Facebook, Instagram, and YouTube? Dive into our comprehensive course designed to turn your TikTok content into a powerful pipeline for success on multiple platforms!   🚀 Elevate Your Content Creation Skills: Unlock the secrets of crafting compelling short-form content that captivates audiences on Facebook, Instagram, and YouTube. Learn the art of adapting your TikTok brilliance into formats optimized for these platforms, maximizing your reach and engagement.   📈 Dominate Multiple Platforms: Harness the potential of each platform with tailored strategies. Discover the nuances of content adaptation, algorithmic understanding, and audience targeting specific to Facebook, Instagram, and YouTube. Amplify your impact and widen your fanbase across the social media landscape. 💡 Expert Guidance & Proven Techniques: Led by industry experts with a track record of viral content creation, this course provides actionable insights, real-life case studies, and step-by-step guidance. Gain access to cutting-edge tips, tools, and strategies that industry insiders use to stand out in the digital realm. 🎯 What You'll Learn:     Content adaptation techniques for different platforms Strategies to optimize reach and engagement Understanding platform algorithms and trends Leveraging insights and analytics for growth Building a cohesive brand presence across platforms And much more!   🌐 Join the TikTok to Star Pipeline Course Today: Unlock the door to a dynamic world of social media success! Embrace the power of cross-platform content creation and transform your online presence. Don't miss this opportunity to supercharge your social media journey. Course Curriculum

Tiktok to Star Pipeline - Short Form Content for Facebook,Instagram, and YouTube
Delivered Online On Demand1 hour
£4.99

Building Modern Distributed Systems with Java

By Packt

This course brings together all the important topics related to modern distributed applications and systems in one place. Explore the common challenges that appear while designing and implementing large-scale distributed systems, and how big-tech companies solve those problems. Throughout the course, we are going to build a distributed URL shortening service.

Building Modern Distributed Systems with Java
Delivered Online On Demand3 hours 54 minutes
£33.99

The Complete Blockchain Professional Course

By Packt

Master Blockchain fundamentals, the Blockchain architecture, and various Blockchain use cases.

The Complete Blockchain Professional Course
Delivered Online On Demand6 hours 2 minutes
£135.99

Data Science: Basics, Data Mining, Excel, Python, SQL, Machine Learning & Tableau

By Imperial Academy

Data Is The Language Of The Powerholders | Designed By Industry Specialists | Level 7 QLS Endorsed Career Objective Driven Data Science Courses | 10 QLS Endorsed Hard Copy Certificates Included | Lifetime Access | Installment Payment | Tutor Support

Data Science: Basics, Data Mining, Excel, Python, SQL, Machine Learning & Tableau
Delivered Online On Demand
£599

Statistics & Probability for Data Science & Machine Learning

By Course Cloud

Course Overview Discover how to become a data scientist, prove hypotheses, and build complex algorithms with this advanced course on Statistics & Probability for Data Science & Machine Learning. This intuitive training will empower you to manipulate records and understand how to break down the most complex processes in this fascinating field. This comprehensive Data Science tutorial delivers the ideal way to learn the methodology and principles needed to excel in this sector. You will be given expert tuition in using all the relevant concepts for analysing information, gain a genuine understanding of these concepts, and attain the skills to excel in appropriate IT commercial industries. Complete this training, and you will have a unique advantage to work in such areas as automobile design, banking service, media forecasting, and much more. This best selling Statistics & Probability for Data Science & Machine Learning has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Statistics & Probability for Data Science & Machine Learning is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Statistics & Probability for Data Science & Machine Learning is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Statistics & Probability for Data Science & Machine Learning is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Statistics & Probability for Data Science & Machine Learning, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Statistics & Probability for Data Science & Machine Learning will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Statistics & Probability for Data Science & Machine Learning to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Statistics & Probability for Data Science & Machine Learning
Delivered Online On Demand
£25

SSL Complete Guide 2021: HTTP to HTTPS

By Packt

This course will teach you everything from scratch right from simple setups to complex solutions. If you want to master SSL and HTTPS in-depth, this course is for you! No prior knowledge of computer networks, encryption, or configuring web servers is required.

SSL Complete Guide 2021: HTTP to HTTPS
Delivered Online On Demand10 hours 54 minutes
£97.99