169 Binary courses

Number Theory Basics is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Number Theory Basics and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 9 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Introduction What is Number Theory 00:08:00 Basics of Number Theory Number Theory 00:07:00 Number Sets 00:09:00 Number Patterns 00:10:00 Even & Odd Numbers 00:11:00 Number Properties 00:10:00 Proofs 00:11:00 Number Bases Number Bases 00:12:00 Binary Base 00:12:00 Binary Arithmetics 00:15:00 Hexadecimal Base 00:13:00 Hexadecimal Arithmetics 00:14:00 Factorials Factorial 00:05:00 Double Factorial 00:09:00 Super Factorial 00:03:00 Exponential Factorial 00:03:00 Factorion 00:05:00 Stirling's Formula 00:03:00 Number of Digits 00:03:00 Divisibility Divisibility 00:07:00 Divisibility Rules 00:04:00 Euclidean Division Theorem 00:08:00 GCD & LCM 00:11:00 Bézout's Identity 00:08:00 Perfect Numbers 00:04:00 Practical Numbers 00:05:00 Amicable Numbers 00:04:00 Fibonacci Sequence 00:09:00 Tribonacci Sequence 00:05:00 Golden Ratio 00:11:00 Primes Prime Numbers 00:09:00 Fundamental Theorem of Arithmetics (FTA) 00:10:00 Almost Primes 00:07:00 Prime Powers 00:02:00 Factorial Prime 00:03:00 Euclid's Theorems 00:09:00 The Prime Number Theorem 00:04:00 Unsolved Problems 00:06:00 Number Empire 00:07:00 Modular Arithmetic Modular Arithmetics 00:09:00 Congruence 00:13:00 Congruence Class 00:12:00 Residue Systems 00:04:00 Quadratic Residues 00:04:00 Modular Operations 00:06:00 Inverses 00:07:00 Modular Exponentiation 00:10:00 Wilson's Theorem 00:05:00 Chinese Remainder Theorem 00:09:00 Fermat's Little Theorem 00:05:00 Euler's Totient Function 00:07:00 Euler-Fermat Theorem 00:04:00 Continued Fractions Continued Fractions 00:08:00 Negative Continued Fractions 00:11:00 Finite Continued Fractions 00:14:00 Infinite Continued Fractions 00:17:00 Periodic Continued Fractions 00:10:00 Convergent 00:12:00 Cryptography Cryptography 00:09:00 Early Ciphers 00:11:00 Public Key Cryptography 00:13:00 RSA Encryption 00:11:00 Diffie-Hellman Protocol 00:04:00 Resources Resource - An Introduction to Number Theory 00:05:00

This online course will educate you on the safety concerns of electrical devices and the main concerns in maintenance and servicing. You will understand how to test a fuse, a bulb or lamp, a transformer, or a resistance. This Course At A Glance Accredited by CPD UK Understand voltage current and resistance Know types of current, circuits, and digital multi-meter DMM Learn how to measure DC voltage Understand how to test resistors Know the basics of circuit diagrams and symbols Get introduced to inductors Understand how to test and measure coils Learn how to test a diode Get introduced to diode, Zener diode, and LED Understand power dissipation, parallel and series resistors Learn Ohm's Law Digital Electric Circuits & Electrical Devices Course Overview This extensive course is designed to take you on a captivating journey into the world of digital electronics. This course will give you a broad knowledge of electronic and electrical maintenance repair, tools needed such as multimeters, wire cutter and stripper, and electrical components such as passive electronic components, active electronic component transistor, and common electrical components. Through hands-on simulatons and experiments, you will gain practical experience in designing and troubleshooting digital circuits. By the end of the course, you will have deep knowledge of counters and shift registers, flip-flops, logic gates, binary arithmetic, and numbering systems. Who should take this course? This comprehensive course is beneficial for those who want to have a deep understanding of electronic and electrical maintenance repair, tools needed, electronic components, and testing. It is ideal for those who wish to pursue their career in digital electric circuits and electrical devices. Entry Requirement There are no academic entry requirements for this Digital Electric Circuits & Electrical Devices course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This digital electric circuits & electrical devices course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction Introduction Numbering Systems Binary Arithmetic Logic Gates Flip-Flops Counters & Shift Registers Adders Assessment Assessment - Digital Electric Circuits & Electrical Devices Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

This course shows you how to apply various approaches and algorithms to solve business problems through AI and ML, follow a methodical workflow to develop sound solutions, use open-source, off-the-shelf tools to develop, test, and deploy those solutions, and ensure that they protect the privacy of users. This course includes hands-on activities for each topic area.

Build 9 projects to master 2 essential and modern technologies: Python and PostgreSQL

Use deep learning, Computer Vision, and machine learning techniques to build an autonomous car with Python

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

Make your code and programs faster and more efficient by using algorithms

Coding (Computer Programming) Master the knowledge and skills needed to become a good programmer Coding is a cornerstone of the digital age, influencing everything from the technology we use daily to the applications we rely on. Mastering various aspects of coding and computer programming is essential for anyone looking to excel in this field. The Coding (Computer Programming) Diploma provides comprehensive training on crucial programming concepts, including binary systems, algorithm analysis, and data storage. Additionally, you will gain practical skills in arrays, linked lists, stacks, and queues. This diploma course is designed to equip you with the necessary knowledge and technical skills to become proficient in coding. Through detailed modules and hands-on practice, you’ll learn how to tackle complex problems, write efficient code, and understand fundamental computer science principles. This in-depth training ensures you are well-prepared to enter the programming industry with confidence. Embrace the opportunity to advance your coding skills and enhance your career prospects. By enrolling in the Coding (Computer Programming) Diploma, you'll position yourself for success in a competitive job market. Start your journey today and gain the expertise needed to excel as a skilled programmer. This Coding (Computer Programming) Bundle Consists of the following Premium courses: Course 01: Coding with HTML, CSS, & JavaScript Course 02: Computer Science With Python Course 03: Python Programming for Everybody Course 04: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 05: Ethical Hacking Course 06: Complete Web Application Penetration Testing & Security Course 07: Diploma in PHP Web Development Course 08: Front End Web Development Diploma Course 09: SQL Server for Beginners Course 10: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 11: Level 3 Cyber Security Key Features of the Course: FREE Coding (Computer Programming) Diploma CPD-accredited certificate Get a free student ID card with Coding (Computer Programming) Diploma training (£10 applicable for international delivery) Lifetime access to the Coding (Computer Programming) Diploma course materials The Coding (Computer Programming) Diploma program comes with 24/7 tutor support Get instant access to this Coding (Computer Programming) Diploma course Learn Coding (Computer Programming) Diploma training from anywhere in the world The Coding (Computer Programming) Diploma training is affordable and simple to understand The Coding (Computer Programming) Diploma training is entirely online Learning Outcomes of Coding (Computer Programming): Gain the knowledge, skills and guidelines of coding (computer programming) Ability to do coding with HTML, CSS, Javascript & Python Learn how to create your first responsive website Get a comprehensive understanding of ethical hacking and web hacking Explore complete web application penetration testing & security Gain expertise in PHP web development & Front End web development Discover SQL Server and how it is used to manage and store information Become fully aware of Cloud Computing and why it is needed Description The Coding (Computer Programming) Diploma provides an in-depth exploration of essential programming concepts and practices. This comprehensive course covers everything from binary systems and algorithm analysis to data structures such as arrays, linked lists, stacks, and queues. With practical hands-on training, you'll develop the skills needed to tackle complex coding challenges and build efficient, effective programs. Perfect for those seeking to enhance their technical expertise or launch a career in programming, this diploma offers the foundational knowledge and practical experience required to succeed in the dynamic field of computer science. Curriculum of Coding (Computer Programming) Bundle Course 01: Coding with HTML, CSS, & JavaScript Welcome HTML 5 CSS 3 Bootstrap Project 1 - Design a Landing Page Project 2 - Business Website Project 3 - Portfolio ~~~~~Other Courses are included in this Coding (Computer Programming Training) Bundle~~~~~ Course 02: Computer Science With Python Course 03: Python Programming for Everybody Course 04: Create Your First Responsive Website Course 05: Ethical Hacking Course 06: Complete Web Application Penetration Testing & Security Course 07: Diploma in PHP Web Development Course 08: Front End Web Development Diploma Course 09: SQL Server for Beginners Course 10: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 11: Level 3 Cyber Security How will I get my Coding (Computer Programming) Certificate? After successfully completing the Coding (Computer Programming) bundle, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously, it was £6*11 = £66) Hard Copy Certificate: Free ((Previously, it was £10) CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our Coding (Computer Programming) Diploma course is for anyone looking to upskill their career in any IT field. Requirements Our Coding (Computer Programming) is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. Career path Explore diverse career opportunities with our Coding with Scratch course: Junior Software Developer: £25,000 - £35,000 Game Designer: £28,000 - £40,000 Coding Instructor: £22,000 - £30,000 Interactive Media Designer: £30,000 - £45,000 Educational Technologist: £25,000 - £38,000 App Developer: £30,000 - £50,000 Certificates Certificate of completion Digital certificate - Included You will get the Hard Copy certificate for the title course (Coding with HTML, CSS, & JavaScript) 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. Certificate of completion Digital certificate - Included

Description: Are you interested in a career in computer science? Programming is the art of writing useful, maintainable, and extensible source codes which can be read or compiled by a computer system to perform a significant task. Take your first step towards learning core programming concepts and equip yourself with the practical knowledge and skills to resolve complicated problems. Discover all you need to know about programming language with this computer science course. By learning the correct programming theory, you will be able to analyse a problem and identify suitable solutions to those problems, which is a key part of web development. Apart from the theories of Algorithm analysis, this computer programming course also teaches the number system, arrays and their advantages, the process of analysing a problem, nodes and their Importance, and various sorting algorithms and their comparisons. There are no entry requirements for this course and you can study from the comfort of your own home. Enrol in this Diploma in Computer Science and Programming course today and learn to write code like an expert. Who is the course for? Anyone who wants to become a Good Programmer Anyone interested in the Computer Science Discipline Anyone who wants to learn how to problem solve like a Computer Scientist Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £14.99 or in PDF format at a cost of £11.99. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Kurt Anderson - Promo FREE 00:02:00 Kurt Anderson - 1 Introduction 00:01:00 Kurt Anderson - 2 Binary System 00:11:00 Analyzing Algorithms Kurt Anderson - 3 Complexity Introduction 00:02:00 Kurt Anderson - 4 Math Refresher Logarithmic Functions 00:11:00 Kurt Anderson - 5 Math Refresher Factorial Functions.TS 00:03:00 Kurt Anderson - 6 Math Refresher Algebraic Expressions.TS 00:03:00 Kurt Anderson - 7 n-notation 00:18:00 Kurt Anderson - 8 Big O 00:13:00 Kurt Anderson - 9 Big O Real World Example 00:10:00 Arrays Kurt Anderson - 10 How is Data Stored 00:09:00 Kurt Anderson - 11 Fixed Arrays 00:20:00 Kurt Anderson - 12 Circular Arrays 00:08:00 Kurt Anderson - 13 Dynamic Arrays 00:16:00 Kurt Anderson - 14 Array Review 00:08:00 Kurt Anderson - 15 Array Real World Examples 00:06:00 Linked Lists Kurt Anderson - 16 Nodes 00:04:00 Kurt Anderson - 16 Linked List 00:14:00 Kurt Anderson - 17 Linked List Run Times 00:15:00 Kurt Anderson - 18 Doubly Linked Lists 00:08:00 Kurt Anderson - 19 Tail Pointer 00:05:00 Kurt Anderson - 20 Linked List Real World Examples 00:03:00 Kurt Anderson - 21 Linked List Review 00:04:00 Stacks and Queues Kurt Anderson - 22 Stacks 00:10:00 Kurt Anderson - 20 Stack Example 00:11:00 Kurt Anderson - 23 Queues 00:09:00 Kurt Anderson - 24 Queue Examples 00:10:00 Kurt Anderson - 25 Queue and Stack Run Times 00:06:00 Kurt Anderson - 26 Stack and Queues Real World Examples 00:07:00 Sorting Algorithms Kurt Anderson - 27 Sorting Algorithm Introdcution 00:02:00 Kurt Anderson - 28 Bubble Sort 00:10:00 Kurt Anderson - 29 Selection Sort 00:10:00 Kurt Anderson - 30 Insertion Sort 00:09:00 Kurt Anderson - 31 Quick Sort 00:15:00 Kurt Anderson - 32 Quick Sort Run Times 00:10:00 Kurt Anderson - 33 Merge Sort 00:12:00 Kurt Anderson - 34 Merge Sort Run Times 00:08:00 Kurt Anderson - 35 Stable vs Nonstable 00:07:00 Kurt Anderson - 36 Sorting Algorithm Real World Examples 00:04:00 Trees Kurt Anderson - 37 Basics of Trees 00:08:00 Kurt Anderson - 38 Binary Search Tree 00:09:00 Kurt Anderson - 39 BST Run Times 00:08:00 Kurt Anderson - 40 Tree Traversals 00:13:00 Kurt Anderson - 41 Tree Real World Examples 00:05:00 Heaps Kurt Anderson - 42 Heap Introduction 00:04:00 Kurt Anderson - 43 Heap Step by Step 00:12:00 Kurt Anderson - 44 Heap Real World Examples 00:07:00 Conclusion Kurt Anderson - 45 Thank You 00:01:00 Course Certification Order Your Certificates and Transcripts 00:00:00

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