1965 Testing courses delivered Online

LPIC-1 training course description This five day hands on course provides a comprehensive coverage of core Linux administration tasks. The course covers generic Linux and is available for any Linux distribution required. It closely follows the LPIC curriculum allowing delegates to achieve the relevant certification if required. What will you learn Administer & configure Linux systems. Maintain Linux by handling disk space and taking regular backups. Manage software packages. Perform basic troubleshooting. Maintain a secure Linux system. Describe the organisation and implementation of the filesystem. LPIC-1 training course details Who will benefit: System administrators. Network administrators. Prerequisites: Linux fundamentals (LPI 010) Duration 5 days LPIC-1 training course contents Part I Exam 101 Exploring Linux Command-Line Tools Using a Shell, Shell Configuration, Environment Variables, Getting Help, Streams, Redirection and Pipes, Processing Text Using Filters, Manipulating files, Regular Expressions, grep,sed. Managing Software Package Concepts, Comparison of package formats, RPM, rpm Commands, Yum, Debian Packages, dpkg, apt-cache, apt-get, dselect, aptitude, Converting Between Package Formats, Dependencies and Conflicts, Startup Script Problems, Shared Libraries, Library Management, Managing Processes, the Kernel: The First Process, Process Lists, Foreground & Background Processes, Process Priorities, Killing Processes. Configuring Hardware Configuring Firmware and Hardware, IRQs, I/O Addresses, DMA Addresses, Boot Disks, Coldplug and Hotplug Devices, Configuring Expansion Cards and PCI Cards, Kernel Modules, USB Devices, Linux USB Drivers, Configuring Hard Disks, Partitioning Systems, LVM, Common Layouts, Creating Partitions and Filesystems, Maintaining Filesystem Health, Tuning, Journals, Checking Filesystems, Monitoring Disk Use, Mounting and Unmounting Filesystems. Managing Files File Management Commands, File Naming and Wildcards, File Archiving, Links, Directory Commands, File Ownership and Group, File access control, Permissions, chmod, Defaults, File Attributes, Disk Quotas, Enabling and setting Quotas, Locating Files, The FHS. Booting Linux and Editing Files Installing Boot Loaders, GRUB Legacy, GRUB 2, Alternative Boot Loaders, the Boot Process, Boot Messages, Runlevels and the Initialization Process, Runlevel Functions, Runlevel Services, Alternative Boot Systems , Upstart, system. Part II Exam 102 265 Securing the X Window System Localization, Configuring Basic X Features, X Server Options, Methods of Configuring X, X Display Information, X Fonts, The X GUI Login System, XDMCP Server, Using X for Remote Access, Screen Display Settings, Setting Your Time Zone, Your Locale, Configuring Printing, Conceptualizing the Linux Printing Architecture, Understanding PostScript and Ghostscript, Running a Printing System, Configuring CUPS, Monitoring and Controlling the Print Queue. Administering the System Managing Users and Groups, Tuning User and System Environments, Using System Log Files, Understanding syslogd , Setting Logging Options, Manually Logging Data, Rotating Log Files, Reviewing Log File Contents, Maintaining the System Time, Linux Time Concepts, Manually Setting the Time, Using NTP, Running Jobs in the Future, Understanding the Role of cron, Creating System cron Jobs, Creating User cron Jobs, Using anacron, Using at. Configuring Basic Networking TCP/IP, Network Hardware, Network Addresses, Hostnames, Network Ports, Configuring Linux for a Local Network, Configuring with DHCP, Static IP Address, Configuring Routing, Using GUI Configuration Tools, ifup and ifdown, Diagnosing Network Connections, Testing Connectivity, Tracing a Route, Checking Network Status , Examining Network Traffic, Additional Tools. Writing Scripts, Configuring Email, and Using Databases The Shell Environment, Aliases, Shell Configuration Files, Writing Scripts, Commands, Variables, Conditional Expressions, Loops, Functions, Managing Email, Choosing Email Software, Securing Your Email Server, Managing Data with SQL, Picking a SQL Package, Understanding SQL Basics, Using MySQL Securing Your System Administering Network Security, Super Server Restrictions, Disabling Unused Servers, Administering Local Security, Securing Passwords, Limiting root Access, Setting Login, Process, SUID/SGID Files, Configuring SSH, Using GPG, Generating, Importing and Revoking Keys, Encrypting and Decrypting Data, Signing Messages and Verifying Signatures.

UNIX system administration training course description This five day hands on course provides a comprehensive coverage of core UNIX administration tasks. The course covers generic UNIX and is available for any UNIX distribution required. What will you learn Administer & configure UNIX systems. Maintain UNIX by handling disk space and taking regular backups. Manage software packages. Perform basic troubleshooting. Maintain a secure UNIX system. Describe the organisation and implementation of the filesystem. UNIX system administration training course details Who will benefit: System administrators Network administrators. Prerequisites: UNIX fundamentals. Duration 5 days UNIX system administration training course contents Part 1 Exploring UNIX command-line tools Using a shell, shell configuration, environment variables, getting help, streams, redirection and pipes, processing text using filters, manipulating files, regular expressions, grep, sed. Managing software Package concepts, comparison of package formats, RPM, rpm commands, yum, dpkg, apt-cache, apt-get, dselect, aptitude, converting between package formats, dependencies and conflicts, startup script problems, shared libraries, library management, managing processes, the kernel: the first process, process lists, foreground & background processes, process priorities, killing processes. Configuring hardware Configuring firmware and hardware, RQs, I/O addresses, DMA addresses, Boot disks, coldplug and hotplug devices, configuring expansion cards and PCI cards, kernel modules, USB devices, UNIX USB crivers, configuring hard disks, partitioning systems, LVM, common layouts, creating partitions and filesystems, maintaining filesystem health, tuning, journals, checking filesystems, monitoring disk use, mounting and unmounting filesystems. Managing files File management commands, file naming and wildcards, file archiving, links, directory commands, file ownership and group, file access control, permissions, chmod, defaults, file attributes, disk quotas, enabling and setting quotas, locating files, the FHS. Booting UNIX and editing files Installing boot loaders, GRUB legacy, GRUB 2, alternative boot loaders, the boot process, boot messages, runlevels and the initialization process, runlevel functions, runlevel services, alternative boot systems, upstart, system. Part 2 Configuring the X window system Localization, configuring basic X features, X server options, methods of configuring X, X display information, X fonts, the X GUI login system, XDMCP server, using X for remote access, screen display settings, setting your time zone, your locale, configuring printing, conceptualizing the UNIX printing architecture, understanding PostScript and ghostscript, running a printing system, configuring CUPS, monitoring and controlling the print queue. Administering the system Managing users and groups, tuning user and system environments, using system log files, understanding syslogd, setting logging options, manually logging data, rotating l;og files, reviewing log file contents, maintaining the system time, UNIX time concepts, manually setting the time, using NTP, running jobs in the future, understanding the role of cron, creating system cron jobs, creating user cron jobs, using anacron, using at. Configuring basic networking TCP/IP, network hardware, network addresses, hostnames, network ports, configuring UNIX for a local network, configuring with DHCP, static IP address, configuring routing, using GUI configuration tools, ifup and ifdown, diagnosing network connections, testing connectivity, tracing a route, checking network status , examining network traffic, additional tools. Writing scripts, configuring email, and using databases The shell environment, aliases, shell configuration files, writing scripts, commands, variables, conditional expressions, loops, functions, managing email, choosing email software, securing your email server, managing data with SQL, picking a SQL package, understanding SQL basics, using MySQL. Securing your system Administering network security, super server restrictions, disabling unused servers, administering local security, securing passwords, limiting root access, setting login, process, SUID/SGID files, configuring SSH, using GPG, generating, importing and revoking keys, encrypting and decrypting data, signing messages and verifying signatures.

Learning how to have a better relationship Introspection test Learn where you are going wrong Love language testing Learn about boundaries Establishing your relationship needs Address past negative relationship patterns Learn about boundaries Relationship facets relationship course 2-hour session relationship training and 1 phone call 30 mins Coaching and relationship skills education https://relationshipsmdd.com/product/relationship-course-express-package/

Register on the Machine Learning in Flutter today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Machine Learning in Flutter course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Machine Learning in Flutter Course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Machine Learning in Flutter course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Unit 01: Introduction Module 01: Course Curriculum 00:02:00 Unit 02: Image Picker and Camera Libraries Module 01: Image Picker Library for Flutter App Development 00:13:00 Module 02: Flutter Image Picker Application Testing 00:01:00 Module 03: Camera Package Setup for Flutter 00:04:00 Module 04: Flutter Camera Package Code 00:08:00 Unit 03: Firebase ML Kit Module 01: Firebase ML kit section Introduction 00:01:00 Module 02: Firebase ML Kit introduction 00:02:00 Unit 04: Image Labeling using ML Kit Module 01: Flutter Image Labeling Section Introduction 00:02:00 Module 02: Importing Starter code for image labeling 00:03:00 Module 03: Image labeling starter code explanation 00:06:00 Module 04: Creating firebase project for image labeling 00:06:00 Module 05: Adding Firebase ML Vision library in Flutter Application 00:10:00 Module 06: Testing Firebase Image labeling application 00:01:00 Module 07: Importing Image Labeling live feed application starter code 00:03:00 Module 08: Flutter Camera Package Code 00:06:00 Module 09: Flutter Image Labeling live feed application code 00:08:00 Module 10: Flutter Image labeling live feed application testing 00:01:00 Unit 05: Section Barcode Scanning Module 01: Flutter Barcode Scanning Section Introduction 00:02:00 Module 02: Importing Starter code for Flutter Barcode Scanning 00:03:00 Module 03: Flutter Barcode Scanning code 00:11:00 Module 04: Flutter Barcode Scanning Application Testing 00:01:00 Module 05: Flutter Barcode Scanning Live Feed Application code 00:08:00 Module 06: Flutter Barcode Scanning Live feed Application Testing 00:01:00 Unit 06: Section Text Recognition Module 01: Flutter Text Recognition Section Introduction 00:01:00 Module 02: Importing Starter code for Flutter Text Recognition 00:03:00 Module 03: Writing Flutter Text Recognition Code 00:09:00 Module 04: Testing Flutter Text Recognition Application 00:01:00 Unit 07: Section Face Detection Module 01: Flutter Face Detection Section Introduction 00:02:00 Module 02: Flutter Face Detection Application Flow 00:01:00 Module 03: Flutter Face Detection code 00:06:00 Module 04: Flutter drawing rectangles around detected faces 00:05:00 Unit 08: Pretrained Tensorflow lite models Module 01: Pretrained Tensorflow lite models Section Introduction 00:02:00 Unit 09: Section Image Classification Module 01: Flutter Image classification Section introduction 00:02:00 Module 02: Importing Starter code for Flutter Image classification application 00:03:00 Module 03: Starter code explanation for Flutter Image classification 00:06:00 Module 04: Writing flutter image classification code 00:13:00 Module 05: Testing flutter image classification application 00:02:00 Module 06: Importing Flutter live feed Image classification application starter code 00:03:00 Module 07: Starter code explanation of Flutter Live feed Image classification application 00:05:00 Module 08: Writing Flutter Image classification code 00:11:00 Module 09: Testing live feed image classification flutter application 00:01:00 Unit 10: Section object detection Module 01: Flutter Object detection section introduction 00:02:00 Module 02: Importing Application code object detection flutter 00:05:00 Module 03: Flutter Object detection code 00:13:00 Module 04: Flutter Drawing Rectangles around detected objects 00:04:00 Module 05: Importing the code for live feed object detection flutter application 00:02:00 Module 06: Testing object detection live feed flutter application 00:01:00 Module 07: Flutter Live feed object detection application code 00:10:00 Unit 11: Section human pose estimation Module 01: Flutter Pose estimation section introduction 00:02:00 Module 02: Importing Flutter Pose estimation Application code 00:04:00 Module 03: Flutter Pose estimation code 00:10:00 Module 04: Importing pose estimation live feed flutter application code 00:02:00 Module 05: Flutter Live feed pose estimation application demo 00:09:00 Module 06: Using PoseNet model for Flutter Live feed pose estimation application 00:08:00 Unit 12: Image segmentation section Module 01: Flutter Image Segmentation Section Introduction 00:02:00 Module 02: Importing Flutter Image Segmentation Application code 00:03:00 Module 03: Flutter using DeepLab model for image segmentation 00:09:00 Unit 13: Section Training Image Classification Models Module 01: Section Introduction 00:02:00 Module 02: Machine Learning and Image classification 00:02:00 Unit 14: Dog Breed Classification Module 01: Flutter getting the dataset for model training 00:05:00 Module 02: Flutter Training the model 00:06:00 Module 03: Flutter Dog Breed Classification Application 00:18:00 Module 04: Flutter Live feed dog breed classification application 00:03:00 Module 05: Testing live feed dog breed classification application 00:01:00 Unit 15: Fruits Recognition using Transfer Learning Module 01: Transfer learning introduction 00:02:00 Module 02: Flutter getting the dataset for model training 00:05:00 Module 03: Flutter Training fruit recognition model 00:09:00 Module 04: Flutter Testing Live feed fruits recognition application 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Face to Face training customised and bespoke. One to One Online or Face to Face

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Social Media Marketing Course is designed to teach the right way to do social media marketing. It covers all the main social media platforms. Get a glimpse on the key skills you need to know about social media marketing and after finishing, you will be the master of social media marketing. Learn the exact effective way to do social media marketing from the experts. This Complete Social Media Marketing Course will give you all the key skills you have to know to do marketing using social media. Get the benefit from an awesome overview of social media marketing. Learn how to make the maximum profit with less investment. Knowing key skills might help you to become a successful Social media marketer. When you learned social media marketing, your potential income will be limitless! This course is one of the trending courses in the UK. You will gain the necessary skills to perform well in this field. Specific modules in this course are designed to teach you the whole thing you need to know to become a successful professional in this sector. You can study this course at your own pace. Within a few hours, you will get an accredited certificate in this course. You can access the course easily from anywhere at any time. This course is designed for students, professionals and for those who have a keen interest to know about this topic. To design this course, we have selected a professional an experienced tutor. The tutor will guide you throughout the course and will help you out with all your queries. You will get 24/7 support from our customer support team as well. What you will learn? Learn how to shape astonishing income-generating funnel Learn how to generate conversion from social media Know the proper way to do social media marketing with less costing Learn how to do effective Facebook, youtube, Pinterest, LinkedIn, Instagram marketing Know the marketing techniques and methods How to get the best results from your social media marketing AB testing to increase their profit Who this course is for: Internet Marketers Internet Influencers Business Owners Entrepreneurs Salespeople Career Path: If you complete the course, you will be able to know the strategies and secrets of Social Media Marketing. You will get all the essential skills for getting more views on Social Media Marketing which help you to get more subscribers, followers. You able to create more views, impressions, and ultimately you can generate more income. After completing this course, you will be able to gain the necessary knowledge and skills required to succeed in this sector. All our courses are IAO accredited. You will be able to do affiliate marketing and can generate more income from different online markets. You will be able to earn more by completing this course. Learn to EARN more!!! Get Started NOW! Social Media Marketing Social Marketing Intro FREE 00:01:00 Marketing On Facebook & Instagram FREE 00:19:00 Marketing On Twitter & YouTube 00:14:00 Intro To Pintrest Marketing 00:01:00 Pintrest Marketing - Part 1 00:07:00 Pintrest Marketing - Part 2 00:16:00 Pintrest Marketing - Part 3 00:11:00 LinkedIn Marketing Intro 00:01:00 LinkedIn Marketing - Part 1 00:06:00 LinkedIn Marketing - Part 2 00:07:00 LinkedIn Marketing - Part 3 00:05:00 Intro To Split Testing 00:01:00 Split Testing - Part 1 00:10:00 Split Testing - Part 2 00:05:00 Split Testing - Part 3 00:09:00 Intro To Funnel Building 00:01:00 Funnel Building - Part 1 00:04:00 Funnel Building - Part 2 00:07:00 Funnel Building - Part 3 00:09:00

  After mastering all the necessary concepts of Disaster Recovery processes, you can sit for the exam and gain the "Certified Lead Disaster Recovery Manager' credential. By holding this Certificate, you will be able to demonstrate that you have the practical knowledge and professional capabilities to support and lead Disaster Recovery teams in implementing Disaster Recovery strategies based on best practices.  About This Course   Learning objectives   Acknowledge the correlation between Disaster Recovery, Business Continuity Management, Information Security and other IT areas and frameworks Master the concepts, approaches, methods and techniques used for the implementation and effective management of a Disaster Recovery Plan Learn how to interpret the ICT Disaster Recovery strategies in the specific context of an organization Learn how to support an organization to effectively plan, implement, manage, monitor and maintain DR services based on best practices Acquire the expertise to advise an organization in implementing an effective Disaster Recovery Plan based on best practices   Educational approach   This training is based on both theory and best practices used in the implementation and management of a DR plan Lecture sessions are illustrated with examples based on case studies Practical exercises are based on a case study which includes role playing and discussions Practice tests are similar to the Certification Exam   Course Content   Day 1: Introduction to Disaster Recovery and initiation of a DR plan Day 2: Risk Mitigation Strategies and Disaster Recovery Planning Day 3: Disaster Recovery facilities, services, recovery sites, response and activation Day 4: DRP testing, monitoring, measurement and continuous improvement; the examination Accreditation Prerequisites   A foundational understanding of Disaster Recovery Services and knowledge of management principles, concepts and strategies. Assessment   The exam for this course consists of 12 essay type questions, to be completed within the 150 minute timeframe and achieving the 70% pass mark. Exam results are provided within 24 hours. What's Included?   Certification fees are included on the exam price Training material containing over 450 pages of information and practical examples will be distributed A participation certificate of 31 CPD (Continuing Professional Development) credits will be issued In case of exam failure, you can retake the exam within 12 months for free Provided by   This course is Accredited by NACS and Administered by the IECB. Who Should Attend?   Information Security Managers Incident Managers Helpdesk Managers Executives with Governance concerns  

🌬️ Unlock a Breath of Safety with Our Respiratory Protection and Safety Interactive Training Course! 🌬️   Are you committed to ensuring a safe and healthy workplace for your team? Introducing our comprehensive 'Respiratory Protection and Safety Interactive Training' course - a vital resource for organizations and individuals keen on fortifying their knowledge and practices in respiratory protection.   🔍 Course Overview:   Module 1: Introduction to Respiratory Protection and Types Dive into the fundamentals of respiratory protection. Understand the various types of respirators and their applications. Lay a strong foundation for effective respiratory safety.   Module 2: Respirator Use and Fit Testing Procedures Learn the correct procedures for donning and doffing respirators. Master the art of fit testing to ensure a snug and effective seal. Equip yourself with the skills needed for day-to-day respirator use.   Module 3: Respirator Training and Respiratory Hazard Assessments Gain insights into the importance of ongoing training. Perform respiratory hazard assessments for a thorough risk analysis. Develop strategies to mitigate respiratory hazards in the workplace.   Module 4: Storage Equipment Fit Checks and Seal Checks Explore proper storage practices to maintain respirator integrity. Conduct fit checks and seal checks to guarantee optimal performance. Enhance your proficiency in ensuring the longevity of respiratory equipment.   Module 5: Inspection and Removal of Disposal Respiratory Equipment Learn to inspect and evaluate respiratory equipment for wear and tear. Understand the safe disposal procedures for respiratory gear. Stay abreast of industry best practices for equipment management.   Module 6: Emergency Response and Respiratory Protection Program Evaluation Prepare for emergency scenarios requiring respiratory protection. Develop and refine your respiratory protection program. Learn to evaluate and continuously improve your safety protocols.   🎓 Key Features: Interactive simulations for hands-on learning. Expert-led video lectures for a dynamic learning experience. Real-world case studies to apply theoretical knowledge. Comprehensive assessments to gauge your understanding.   🌟 Why Choose Our Course? Developed by industry experts with extensive experience. Tailored for all levels of expertise, from beginners to seasoned professionals. Accessible anytime, anywhere - learn at your own pace. Stay compliant with the latest industry standards and regulations.   💡 Invest in the Safety of Tomorrow! Enroll now in our 'Respiratory Protection and Safety Interactive Training' course and empower yourself or your team with the knowledge and skills needed to create a safer, healthier work environment. Breathe easy, work safely! 🌐🛡️ Course Curriculum Module 1- Introduction to Respiratory Protection and Types Introduction to Respiratory Protection and Types 00:00 Module 2- Respirator Use and Fit Testing Procedures Respirator Use and Fit Testing Procedures 00:00 Module 3- Respirator Training and Respiratory Hazard Assessments Respirator Training and Respiratory Hazard Assessments 00:00 Module 4- Storage Equipment Fit Checks and Seal Checks Storage Equipment Fit Checks and Seal Checks 00:00 Module 5- Inspection and Removal of Disposal Respiratory Equipment Inspection and Removal of Disposal Respiratory Equipment 00:00 Module 6- Emergency Response and Respiratory Protection Program Evaluation Emergency Response and Respiratory Protection Program Evaluation 00:00

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.