4526 Security courses delivered Online

Access Introduction generally navigate through Access Database, get data fast, update data records by entering, update data and delete data. Run available report, use available forms, create simple forms and reports via wizards. This style tuition helps to maximise the value that you get from the day.

Do you experience sudden slowdowns in your computer's performance, notwithstanding when you just have maybe a couple programs running? Have you seen a slack in your web surfing, despite the fact that you have a fast broadband connection? This is most likely because spyware or adware is taxing your framework, backing things off for you while sending data you may not need to be sent to places you probably don't need it sent to. The terrible news is that this stuff is everywhere now, including coming from sites of reputable companies that you have chosen to do business with. The best news is that our PC Safety Diploma helps you to malware-proof your PC. Course Highlights Certified PC Safety Diploma is an award winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified PC Safety Diploma into 5 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 4 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified PC Safety Diploma Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified PC Safety Diploma is CPD Qualification Standards and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified PC Safety Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume.   Why You Need To Worry About 'Malware' 01:00:00 Viruses 01:00:00 Spyware/Adware 01:00:00 Safety & Security at the Browser Level 00:30:00 Glossary of Terms 01:00:00 Mock Exam Final Exam

This course is a complete course on Microsoft Azure storage service. The course is intended to help people learn Azure concepts quickly and give enough practice exercises to get them started with their cloud journey with a specific focus on Microsoft Azure.

Fast-track your career with our comprehensive 5-day Linux course. Master Linux in just a few days, boosting your expertise and job prospects.

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

Overview This comprehensive course on CompTIA IT Fundamentals ITF+ (FCO-U61) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CompTIA IT Fundamentals ITF+ (FCO-U61) 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 CompTIA IT Fundamentals ITF+ (FCO-U61). It is available to all students, of all academic backgrounds. Requirements Our CompTIA IT Fundamentals ITF+ (FCO-U61) 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 15 sections • 64 lectures • 04:55:00 total length •Introduction to IT Fundamentals: 00:03:00 •The Case for Computer Literacy: 00:03:00 •Features Common to Every Computing Device: 00:02:00 •Common General-Purpose Computing Devices: 00:02:00 •Networks of Computing Devices: 00:04:00 •Remotely-Accessed Computer Systems: 00:04:00 •Specialized Computer Systems: 00:02:00 •Specialty I/O Devices: 00:01:00 •CPUs: 00:03:00 •Passive and Active Cooling: 00:03:00 •RAM and Active Memory: 00:05:00 •Motherboards: 00:03:00 •Power Supplies: 00:03:00 •AMA - Ask Me Anything about System Hardware: 00:07:00 •Ports and Connectors: 00:03:00 •General Use I/O Devices: 00:02:00 •AMA - Ask Me Anything about I/O, Ports and Peripherals: 00:07:00 •Basics of Binary: 00:04:00 •Storage Technologies: 00:04:00 •Mass Storage Variation: 00:03:00 •AMA - Ask Me Anything about Data Storage and Sharing: 00:07:00 •Operating System Functions: 00:04:00 •Operating System Interfaces: 00:05:00 •AMA - Ask Me Anything about Understanding OS's: 00:05:00 •Preparing the Work Area: 00:02:00 •Setting up a Desktop PC: 00:01:00 •Completing PC Setup: 00:04:00 •AMA - Ask Me Anything about Setting up and Configuring a PC: 00:09:00 •Personalizing a Tablet: 00:08:00 •AMA - Ask Me Anything about Mobile Devices Part 1: 00:07:00 •AMA - Ask Me Anything about Mobile Devices Part 2: 00:07:00 •File Management Tools: 00:02:00 •File Manipulation: 00:06:00 •Backups: 00:03:00 •AMA - Ask Me Anything about Managing Files: 00:08:00 •Walking Survey of Applications: 00:03:00 •Managing Applications: 00:03:00 •Applications and Extensions: 00:04:00 •AMA - Ask Me Anything about Working with Applications: 00:07:00 •Wi-Fi Setup: 00:06:00 •Going High Speed: 00:03:00 •Setting Up and Sharing Printers: 00:05:00 •AMA - Ask Me Anything about Networks and Internet Connectivity Part 1: 00:07:00 •AMA - Ask Me Anything about Networks and Internet Connectivity Part 2: 00:05:00 •Physical Security: 00:05:00 •Dealing with Malware: 00:03:00 •Password Management: 00:03:00 •Clickworthy: 00:03:00 •Perils of Public Internet: 00:02:00 •AMA - Ask Me Anything about IT Threat Mitigation Part 1: 00:07:00 •AMA - Ask Me Anything about IT Threat Mitigation Part 2: 00:08:00 •Power Management: 00:02:00 •Cleaning and Maintaining Computers: 00:02:00 •Trash it or Stash it?: 00:02:00 •AMA - Ask Me Anything about Computer Maintenance and Management: 00:11:00 •Troubleshooting 101: 00:03:00 •AMA - Ask Me Anything about Troubleshooting Computers Part 1: 00:10:00 •AMA - Ask Me Anything about Troubleshooting Computers Part 2: 00:11:00 •Introduction to Databases: 00:06:00 •Database Details: 00:06:00 •AMA - Ask Me Anything about Databases: 00:06:00 •Introduction to Programming: 00:04:00 •Programming with a PBJ Sandwich: 00:08:00 •AMA - Ask Me Anything about Programming: 00:04:00

Description: The 70-680 - Configuring Microsoft Windows 7 Training course is for the users who use Microsoft Windows 7 as a desktop operating system in an enterprise environment. However, you should have at least one year of experience in the IT field, as well as experience implementing and administering any Windows client operating system in a networked environment. Another pre-requisite of the course is to able to install, deploy, and upgrade to Windows 7, including ensuring hardware and software compatibility. Apart from these, you should also be able to configure pre-installation and post-installation system settings, Windows security features, network connectivity applications included with Windows, and mobile computing. You should also require maintaining systems, including monitoring for and resolving performance and reliability issues. Finally, you should know the basic concept of Windows PowerShell syntax. The course will teach you about Windows PowerShell 2.0, the ways of remoting with Windows PowerShell 2.0, and configuring group policy with PowerShell 2.0. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. 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 £39 or in PDF format at a cost of £24. Who is this Course for? 70-680 - Configuring Microsoft Windows 7 Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-680 - Configuring Microsoft Windows 7 Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. 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. Basic Windows 7 Installation Installation Options FREE 00:17:00 Choosing To Do the Clean Install 00:13:00 Advanced Windows 7 Installation Performing an Image Installation 00:15:00 Doing an Upgrade or Migration to Windows 7 00:10:00 Planning for Application Compatibility 00:08:00 Understanding Disk Types and File Systems Windows 7 Disk Types and Formats 00:14:00 Managing Hard Drives with Volumes 00:25:00 Hard Drive Maintenance 00:14:00 Network Configuration IP Addressing 00:45:00 Auto IP Configuration 00:09:00 Troubleshooting Networking 00:17:00 Introducing Wireless Networks 00:09:00 Connecting Windows 7 to the Wireless Network 00:09:00 Sharing Files, Folders, and Printers Planning for Authentication and Authorization 00:14:00 Securing File Access 00:25:00 Compressing Files 00:12:00 Sharing Folders and Printers 00:20:00 Working with Windows 7 Client Performance Installing and Configuring Device Drivers 00:19:00 Windows 7 Performance Monitoring Tools 00:18:00 Monitoring Reliability of Windows 7 00:08:00 Basic Desktop Security Discussion of Security Management in Windows 7 00:11:00 Using Windows Defender 00:15:00 How does UAC Work 00:20:00 Using Windows Firewall 00:28:00 Advanced Desktop Security Using Local Policies to Secure Windows 7 00:18:00 How EFS and BitLocker Secure Your Data 00:15:00 Security With Application Restrictions 00:22:00 IE Version 8 Privacy Features 00:16:00 Disaster Recovery & Prevention Backing Up and Restore Options with Windows 7 00:10:00 How System Restore Works 00:09:00 Using the Windows Update 00:08:00 Remote Access Options Configuring Windows 7 for Mobility 00:10:00 Remote Access Solutions 00:04:00 Understanding VPN Connections 00:12:00 What is BranchCache 00:09:00 Introducing Windows PowerShell 2.0 What is Windows PowerShell 2.0 00:11:00 Remoting With Windows PowerShell 2.0 00:04:00 Configuring Group Policy with PowerShell 2.0 00:03:00 Mock Exam Mock Exam- 70-680 - Configuring Microsoft Windows 7 Training 00:20:00 Final Exam Final Exam- 70-680 - Configuring Microsoft Windows 7 Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Airport management covers a vast area and a wide range of tasks; therefore, it requires a great deal of experience to become a part of the airport management industry. The Airport Management Basics course is created by industry experts to help you grasp the key skills and knowledge to pursue a career in this sector.  Through this Airport Management Basics course, you will get introduced to the crucial departments of airport management. The course will teach you how to provide quality customer service in airports. This step by step learning program will instruct you on cargo management and airport components. You will acquire the skills and expertise for security management. The modules will also educate you on airline scheduling, aviation noise control, weather control etc. This Airport Management Basics course is loaded with valuable information and insights into airport management. Enroll in the course and prepare yourself for a promising career in the airport management sector. Learning Outcomes Learn the fundamentals of airport management Get quality training on airport customer service Familiarize yourself with airline scheduling Build essential skills for passenger terminal management and cargo management Enrich your knowledge of aviation noise control Become competent in airport security management Who is this course for? The Airport Management Basics is suitable for anyone interested to pursue a career in airport management  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. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. 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 recognized 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 The Airport Management Basics course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Airport manager Airport security director Aviation manager Operations site manager Airport Management Basics Module 01: Introduction to Airport Management 00:16:00 Module 02: Airport Customer Service 00:12:00 Module 03: Passenger Terminal Management 00:16:00 Module 04: Airport Components 00:17:00 Module 05: Airport Peaks and Airline Scheduling 00:18:00 Module 06: Cargo Management 00:19:00 Module 07: Aviation Noise Control 00:11:00 Module 08: Weather Control 00:16:00 Module 09: Sustainable Airport Management 00:17:00 Module 10: Security Management 00:17:00 Module 11: Innovation and Growth 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: If you are a non-techie interested in learning about computer networks or an aspiring IT professional who wish to better understand how networks work then get all the information you need here. This course has been designed to equip students with a wide range of software, technical and ICT skills required by the industry. By the end of this program, the students will have the ability to develop an IT solution to a practical business problem using a technological approach. Who is the course for? Non-Techies interested in Learning About Computer Networks Business & IT Managers Need to better understand how network works Aspiring & Inexperienced IT Professionals 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 you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. 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: This course would be beneficial for the following careers: Entry level technician at Telephone/ Internet Service Providers Computer sales and service technician Entry-level IT/ network technician at banks Entry-level IT/ network support technician at insurance companies Entry-level IT/ network support technician at utility companies Entry-level IT/ network support technician at energy based companies Entry-level IT/ network technician at universities Entry-level IT/ network technician at broadcast houses Entry-level IT/ network technician in the government Owner/Manager small computer business Other Entrepreneurial activity. Computer Fundamentals Basic Computer Terms 00:15:00 Advanced Terms 00:15:00 Networking Basics 00:15:00 Basic Internet Concepts 00:30:00 Internet Security 00:30:00 Computers in the Workplace 00:15:00 Tele-Commuting 00:15:00 The Electronic World 00:15:00 Ergonomics 00:15:00 Safety and the Environment 00:15:00 Being Proactive 00:15:00 Identifying Yourself 00:15:00 Protecting your Data 00:15:00 Understanding Malware 00:15:00 Protecting Against Malware 00:15:00 Computer Networking Basics Introduction to Computer Networking 00:30:00 Types of Computer Networks 01:00:00 Types of Network Equipment 00:30:00 Ethernet 00:30:00 Wireless Local Area Networking 01:00:00 Internet Service 01:00:00 TCP/IP and Other Internet Protocols 01:00:00 Network Routing, Switching and Bridging 01:00:00 IPv4 & IPv6 01:00:00 Computer Networking Concepts Basics of computer networking 00:30:00 Computer networking design and solutions 00:30:00 Getting the right computer network hardware. 01:00:00 Setting up your Computer Network 00:30:00 Wireless vs wired 01:00:00 Cable management for wired computer network 01:00:00 Managing your network with network monitoring tools 01:00:00 Computer network maintenance and repair 01:00:00 Troubleshooting computer network 01:00:00 Mock Exam Mock Exam- Level 2 Certificate in Computer Networking 00:20:00 Final Exam Final Exam- Level 2 Certificate in Computer Networking 00:20:00 Certificate and Transcript 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