7108 Systems courses in Cardiff delivered Online

Exclusive to AutoCAD subscribers, the AutoCAD Electrical toolset simplifies electrical system creation. Click here for more info: Website Our course provides a strong foundation in 2D electrical design, covering essential tools. Flexible one-on-one sessions from 9 a.m. to 7 p.m., Monday to Saturday. Call 02077202581 or book online. The 16-hour course offers flexibility, divide hours across days. Benefit from individualized attention and tailored content. Enroll for in-person or Zoom sessions to excel in AutoCAD Electrical. AutoCAD Electrical Course Content: Introduction to AutoCAD Electrical Software: Overview and features of AutoCAD Electrical Understanding the software interface and tools Project file structure and management Layout and Navigation: Navigating the AutoCAD Electrical workspace Creating new project files and using attribute editors Understanding WDD, WDX, and WDF project files Exploring the Project Manager interface and attribute editors Electrical Diagram Drawing: Numbering and titling wires in diagrams Labelling components Utilizing diagram symbol libraries Creating and editing Electrical Control Circuits (ECC) Component dialog box and Circuit Scale dialog box Introduction to Programmable Logic Controllers (PLCs) and Integrated Systems: PLC Symbols and Concepts Inserting Programmable Logic Controllers (PLCs) into diagrams Adding PLC Units to diagrams Working with PLC Input and Output points and circuits Understanding PLC-based classification Using the Spreadsheet to PLC Input and Output Points utility Custom and Bespoke Symbols: Creating custom symbols for Switches, Wires, Contactors, Motors, Transformers, etc. Specifying symbol conventions and standards Offline and online usage of AutoCAD Electrical databases Drawing for Terminals and Plans: Implementing Terminal symbols in diagrams Handling terminal plans and locations Working with compound level terminals and locations Utilizing the Component command for single and multiple components Managing Jumpers and wiring Modifying Terminal Strips and Dual In-Line Packages (DIP) Understanding DIN Rail, Electrical Enclosure, Circuit Breakers, and Electrical Equipment Generating PDFs and Reports: Exporting drawings to PDF format Organizing report templates Automating the generation of reports Creating Electrical Audit Reports This AutoCAD Electrical course provides comprehensive knowledge of the software, focusing on electrical diagram drawing, symbol creation, PLC integration, terminal planning, and report generation. Participants will gain the skills needed to efficiently design electrical systems using AutoCAD Electrical software. Upon completion, participants will proficiently use AutoCAD Electrical to create precise electrical diagrams, integrate PLCs, design custom symbols, plan terminals, and generate reports efficiently. They will possess the skills needed to confidently design electrical systems and enhance their expertise in electrical design and drawing. AutoCAD Electrical Training Course: Master precision in specialized electrical design skills. Optimize your design process with streamlined workflows. Ensure compliance with industry standards consistently. Boost productivity in electrical design tasks. Facilitate seamless collaboration with fellow professionals. Benefit from recorded lessons for convenient review. Enjoy continuous support with lifetime email assistance. Unleash the complete power of AutoCAD for your electrical design needs. Enroll today and craft precise, professional electrical drawings confidently. Select between in-person and live online sessions to suit your preference. Flexible Evening Sessions: Learn AutoCAD at your own pace with evening sessions designed for busy individuals. Boost your career opportunities in computer-aided design. Comprehensive Skill Development: Gain a strong foundation in AutoCAD's core features and advance to 3D modeling and rendering techniques, enhancing your design capabilities. Industry-Standard Knowledge: Become proficient in AutoCAD, a widely used CAD software in architecture, engineering, and construction fields, making you highly sought after by employers. Practical Application: Apply AutoCAD skills to real-world design scenarios, creating detailed plans for professional projects in architecture, engineering, and mechanical fields. Recorded Lessons for Review: Access lesson recordings to reinforce learning and review specific topics or techniques whenever needed. Lifetime Email Support: Enjoy ongoing support with lifetime email assistance, even after completing the course, for guidance and clarification.

Lean Six Sigma Green Belt Certification Program: Virtual In-House Training This learning series is designed to enable participants to fulfill the important role of a Lean Six Sigma Green Belt and to incorporate the Lean Six Sigma mindset into their leadership skills. Green Belt is not just a role, it is also a competency required for leadership positions at many top companies. This learning series is designed to enable participants to fulfill the important role of a Lean Six Sigma Green Belt and to incorporate the Lean Six Sigma mindset into their leadership skills. With a real-world project focus, the series will teach the fundamental methodology, tools, and techniques of the Define, Measure, Analyze, Improve and Control Process Improvement Methodology. This course is delivered through sixteen 3-hour online sessions. What you Will Learn At the end of this program, you will be able to: Identify strategies for effectively leading high performing process improvement teams Analyze whether projects align with business strategy Apply process improvement methodologies to DMAIC steps, based on real world scenarios Explain ways to appropriately respond to process variation Distinguish among best practice problem solving methodologies Evaluate and effectively communicate data-driven decisions, based on real world scenarios Introduction Lean Six Sigma & quality The vision The methodologies The metric Project Selection Why Projects Random idea generation Targeted idea generation CTQs (Critical to Quality) & projects Project screening criteria Quick improvements Introduction to Define Project Planning Developing the core charter Developing a project charter Facilitation Process Management Business process management Top-down process mapping Voice of the Customer Voice of Customer Stakeholder analysis Communication planning Kicking off the project Define Summary Introduction to Measure Data Collection Fact-based decision making Data sampling Operations definitions Data collection plan Measurement system analysis Graphical Statistics for Continuous Data Meet Six SigmaXL Graphical & statistical tools Data stratification Graphical Statistics for Discrete Data Pareto analysis Dot plots Plotting data over time: Looking for patterns Variation Concepts Variation is reality Special Cause and Common Cause variation Example of standard business reporting Individuals Control Chart Process Capability Genesis of process capability Calculating the metrics of Six Sigma Yield metrics: Measuring process efficiency Cost of Poor Quality The Cost of Poor Quality (COPQ) Cost of Quality categories Calculating the Cost of Poor Quality Measure Summary Introduction to Analyze Process Analysis Introduction to process analysis Value-added analysis Cycle time analysis WIP & pull systems Analyzing bottlenecks and constraints Cause & Effect Analysis Fishbone/Ishikawa diagram 5-Whys analysis Graphical & statistical tools Advanced Analysis Why use hypothesis rests? Hypothesis tests Correlation and regression analysis Analyze Summary Introduction to Improve Solutions Creativity techniques Generating alternative solutions Solution selection techniques Introduction to Design of Experiments Introduction to DOE DOE activity Error Proofing Failure mode & effect analysis Poka-Yoke Project Management Fundamentals Successful teams Project roles Conflict management Standardization Standardization The Visual Workplace 5S Piloting & Verifying Results What is a pilot? Evaluating results Improve Summary Introduction to Control Statistical Process Control Review of Special & Common Cause variation Review of Individual Control Chart P-Chart for discrete proportion data Transition Planning Control plan Project closure Control Summary Summary and Next Steps

Classroom based, instructor led workshop with proctor at home exam. The lab-intensive Certified SOC Analyst (CSA) program emphasizes the holistic approach to deliver the advanced knowledge of how to identify, validate and defend against cyber-attacks.

Level 3 & 4 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Flash Sale | 20-in-1 Mega Bundle | CPD QS Certified | 220 CPD Points | Free Hardcopy + PDF Certificates + Exam | Customer Support | Lifetime Access | Enrol Now

This is a comprehensive course for using HashiCorp Packer in your organization. The course teaches you about using HCL2 to create your Packer templates, the new standard moving forward. Explore the core HashiCorp Packer components and access hands-on labs you can perform in your environment.

Description: Windows Server 2016 is a server operating system that is designed to handle corporate networking, Internet/intranet hosting, databases, enterprise-scale messaging and similar functions more efficiently. Developed by Microsoft, it is a part of the Windows NT family of operating systems. With the proper knowledge of Windows Server 2016, you can able to handle your office environment proficiently. The Windows Server 2016 Complete Video Training course is for you if you want to master the features and functions of Windows Server 2016. Apart from this, the bundled video course will help you to prepare for the various exam of Microsoft Windows Server 2016 MCSA certification. The course is divided into four sections where each section helps you with a specific exam and the practical use of Windows Server. The 70-740 Exam section teaches you the methods of installing Windows Server in Host and Compute Environments along with the other features such as storage. On the other hand, the 70-741 series teaches you how to do networking with Windows server including implementing Domain Name system, etc. Next, you will learn about the functionality of Windows Server in the 70-742 section that focuses on the Web Application proxy implementations, Microsoft Azure AD and Directory Synchronization, etc. Finally, in the 70-744 part, you will know how to secure your Windows server. In short, the Windows Server 2016 Complete Video Training course helps you to understand all the necessary information skills if you want to use Windows Server 2016. 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? Windows Server 2016 Complete Video 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 Windows Server 2016 Complete Video 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. Installing Windows Servers in Host and Computer Environments Determining Windows Server 2016 Installation FREE 00:54:00 Installing Windows Server 2016 Core and Nano Editions 01:35:00 Managing Windows Installations with Windows PowerShell 00:01:00 Create, Manage, and Maintain Windows Images to Deploy 00:33:00 Implementing Local and Enterprise Storage Solutions Managing Disks and Volumes in Windows Server 2016 01:00:00 Implementing and Managing Storage Spaces 00:45:00 Configuring Data Deduplication 00:39:00 Understanding Various Types of Storage 00:15:00 Fibre Channel, iSCSI, and Fibre Channel over Ethernet 00:18:00 Understanding iSNS, DCB, and MPIO 00:09:00 Configuring File and Folder Sharing in Windows Server 2016 00:21:00 Implementing Hyper-V Virtualization Installing Hyper-V Virtualization 00:26:00 Configuring Storage and Networking on Hyper-V Hosts 00:38:00 Configuring and Managing Virtual Machines 00:34:00 Implementing Windows Containers Understanding Windows Server and Hyper-V Containers 00:17:00 Deploying Windows Server and Hyper-V Containers 00:08:00 Using Docker to Install, Configure, and Manage Containers 00:12:00 Implementing High Availability Overview of High Availability and Disaster Recovery 00:55:00 Implementing Network Load Balancing 00:25:00 Planning and Configuring Failover Clustering 01:10:00 Maintaining a Failover Cluster 00:15:00 Troubleshooting Failover Clustering 00:11:00 Integrating Failover Clustering and Hyper-V 00:23:00 Configuring Site Availability 00:12:00 Maintaining and Monitoring Server Environments Windows Server Update Services 00:33:00 Windows PowerShell Desired State Configuration (DSC) 00:10:00 Windows Server 2016 Monitoring Tools 00:43:00 Plan and Implement IPv4 and IPv6 Networks Plan and Implement IP Addressing Schemes for IPv4 Networks FREE 01:31:00 Configuring IPv4 Hosts 00:18:00 Managing and Troubleshooting IPv4 Connectivity 00:35:00 Implementing IPv6 for Network Hosts 00:20:00 Implementing IPv6 Transitioning and Coexistence 00:16:00 Installing and Configuring DHCP Overview of the DHCP Server Role 00:16:00 Managing and Troubleshooting DHCP 00:48:00 Installing and Configuring DNS Implementing DNS Servers 00:27:00 Creating and Configuring DNS Zones 00:52:00 Understanding Active Directory Integration 00:23:00 Configuring Advanced DNS Settings 00:41:00 Implementing and Managing IP Address Management Overview of IPAM 00:15:00 IPAM Deployment 00:49:00 Implementing Remote Access Remote Access Overview 00:27:00 Implementing the Web Application Proxy 00:08:00 Planning and Implementing VPNs 00:31:00 Overview of DirectAccess 00:21:00 Implementing DirectAccess 00:27:00 Installing and Configuring Branch Office Networking Configuring Networking for Branch Offices 00:39:00 Implementing Distributed File Systems 00:44:00 Implementing BranchCache 00:19:00 Implementing Advanced Networking Features Implementing Networking Features for High Performance 00:23:00 Implementing Hyper-V Advanced Networking Features 00:13:00 Introduction to Software-Defined Networking 00:10:00 Overview of Network Virtualization 00:06:00 Installing and Configuring Domain Controllers Overview of Active Directory Domain Services FREE 01:00:00 Overview of Domain Controllers 00:30:00 Deploying Domain Controllers 1 01:00:00 Managing Active Directory Objects Overview of AD DS Object Management 00:23:00 Managing User Accounts 01:07:00 Managing Groups 01:06:00 Managing Computer Accounts 00:20:00 Managing Organizational Units 00:41:00 Securing Active Directory Domain Services Securing Domain Controllers 00:33:00 Implementing Account Security 00:48:00 Auditing AD DS 00:26:00 Configuring Managed Service Accounts 00:14:00 Working with Complex AD DS Infrastructures Overview of Advanced AD DS Deployments 00:20:00 Deploying a Distributed AD DS Environment 00:45:00 Overview of AD DS Replication 00:12:00 Configuring AD DS Sites 00:38:00 Implementing Group Policy Overview of Group Policy 00:39:00 Creating and Configuring GPOs 00:56:00 Monitoring and Troubleshooting Group Policy 00:18:00 Security Management Using Group Policy 00:54:00 Managing User Environments 00:22:00 Understanding Microsoft Azure AD and Directory Synchronization Planning Directory Synchronization 00:24:00 Implementing Azure AD Connect 00:12:00 Managing Identities with Directory Synchronization 00:14:00 Monitoring and Recovering AD DS Monitoring AD DS 00:27:00 Database Management 00:07:00 Backup and Recovery in AD DS 00:21:00 Implementing Active Directory Certificate Services Overview of Public Key Infrastructure and AD CS 00:17:00 Deploying Certificate Authority Hierarchy 00:19:00 Administering Certificate Authorities 00:13:00 Deploying and Managing Certificates 00:26:00 Managing Revocation and Distribution 00:07:00 Configuring Certificate Recovery 00:08:00 Implementing Active Directory Federation Services (AD FS) Overview of AD FS 00:17:00 Planning and Deploying AD FS 00:35:00 Overview of Web Application Proxy 00:08:00 Implementing Active Directory Rights Management Services Overview of AD RMS 00:14:00 Deploying AD RMS 00:14:00 Protecting Content with AD RMS 00:09:00 Introduction to Attacks, Breaches, and Detection Understanding Types of Attacks FREE 00:33:00 Detecting Security Breaches 00:06:00 Using Sysinternals Tools 00:30:00 Protecting Users and Workstations User Rights and Privileges 01:28:00 Working with Computer and Service Accounts 00:19:00 Protecting User Credentials 00:20:00 Using Privileged Access Workstations 00:12:00 Managing Administrative Access Understanding and Deploying JEA 00:32:00 Using Enhanced Security Administrative Environments (ESAE) Forests 00:12:00 Using Microsoft Identity Manager 00:08:00 Using JIT Administration and PAM 00:16:00 Configuring Anti-Malware and Patch Management Configuring and Managing Windows Defender 00:18:00 Restricting Software 00:28:00 Using Device Guard 00:12:00 Patch Management with WSUS 00:29:00 Auditing and Advanced Threat Analytics Configuring Auditing for Windows Server 2016 00:21:00 Advanced Auditing and Management 00:42:00 Deploying and Configuring ATA 00:15:00 Deploying and Configuring Operations Management Suite 00:07:00 Securing the Infrastructure Secure the Virtualization Infrastructure 00:15:00 Deploying Security Baselines 00:20:00 Deploying Nano Server 00:08:00 Configuring Data Protection Planning and Implementing File Encryption 00:29:00 Planning and Implementing BitLocker 00:32:00 Advanced File Server Management Using File Server Resource Manager 00:58:00 Implementing Classification and File Management Tasks 00:16:00 Working with Dynamic Access Control 00:39:00 Securing the Network Infrastructure Using the Windows Firewall with Advanced Security 00:33:00 Datacenter Firewall 00:08:00 Utilizing IP Security 00:29:00 Configuring Advanced DNS Settings 00:42:00 Monitoring Network Traffic 00:09:00 Securing SMB Traffic 00:07:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Step into the future with our 'Cyber Security Law & Ethical Hacking' bundle. This comprehensive package includes three QLS-endorsed courses: 'Cyber Security Advanced Training', 'Cyber Security Law Online Course', and 'Cyber Security & Ethical Hacking To The Next Level'. Each course comes with a hardcopy certificate, offering you recognised credentials in this vital field. This bundle is further enriched by five CPD QS accredited courses: 'Cyber Intelligence Officer', 'Cyber Security Incident Handling and Incident Response', 'Linux Security and Hardening', 'Cyber Security Awareness Training', and 'Computer Networks Security from Scratch to Advanced'. Key Features of the Cyber Security Law & Ethical hacking- 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Cyber Security Law & Ethical hacking- 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Cyber Intelligence Officer QLS Course 02: Cyber Security Incident Handling and Incident Response QLS Course 03: Linux Security and Hardening 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Cyber Intelligence Officer Course 02: Cyber Security Incident Handling and Incident Response Course 03: Linux Security and Hardening Course 04: Cyber Security Awareness Training Course 05: Computer Networks Security from Scratch to Advanced In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Cyber Security Law & Ethical hacking- 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Secure your career in the cyber realm by mastering the legal landscape, advanced protection techniques, and ethical hacking principles through this immersive learning experience. Learning Outcomes: Grasp advanced cyber security concepts and strategies. Gain a comprehensive understanding of Cyber Security Law. Learn and apply ethical hacking principles. Become proficient in cyber intelligence and incident response. Understand Linux security and hardening techniques. Enhance awareness of cyber security threats and countermeasures. Learn about computer network security from scratch to advanced. The 'Cyber Security Law & Ethical Hacking' bundle delivers an extensive theoretical foundation in critical areas of cyber security. With the three QLS-endorsed courses, you'll delve into advanced cyber security practices, the legal framework surrounding cyber security, and ethical hacking principles. The five additional CPD QS accredited courses cover a broad spectrum of vital cyber security topics, from intelligence and incident response, to Linux security and cyber security awareness. This knowledge allows you to understand and navigate the increasingly complex digital security landscape and protect vital information and systems. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring professionals in the field of cyber security. Law students interested in specialising in cyber security law. IT professionals aiming to broaden their skill set with cyber security knowledge. Anyone interested in understanding the foundations of ethical hacking. Career path Cyber Security Analyst: Implement security measures to protect systems (£26,000 - £60,000). Cyber Security Lawyer: Advise on legal aspects of cyber threats (£40,000 - £80,000). Ethical Hacker: Identify vulnerabilities in systems using hacking techniques (£30,000 - £70,000). Cyber Intelligence Officer: Monitor and analyse cyber threats (£35,000 - £65,000). Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Immerse yourself in a journey through the heart of our planet with the "Environment Management, Conservation and Ecology - 3 QLS Course" bundle. Unpack the intricate layers of three QLS-endorsed courses - Environment Management, Conservation Diploma Course, and Ecology - providing a thorough theoretical grounding in these critical disciplines. Beyond that, expand your perspective with five additional CPD QS accredited courses encompassing Environment Management: Environment & Ecology, Genetics: DNA and Genealogy, Environmental Law, Renewable Energy, and Marine Biology. Each one offers a unique angle to enhance your understanding of our natural world and our place within it. With our QLS-endorsed courses, you will receive hardcopy certificates, recognising your knowledge and commitment. Harness this powerful tool to deepen your understanding of Earth's complex systems, how we manage them, and our ongoing commitment to their preservation. Start your journey today! Key Features of the Environment Management, Conservation and Ecology - 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Environment Management, Conservation and Ecology - 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Environment Management QLS Course 02: Conservation Diploma Course QLS Course 03: Ecology 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Environment Management : Environment & Ecology Course 02: Genetics : DNA and Genealogy Course 03: Environmental Law Course 04: Renewable Energy Course 05: Marine Biology Course In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Environment Management, Conservation and Ecology - 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of the Environment Management, Conservation and Ecology - 3 QLS Course Bundle: Understand the principles of Environment Management, Conservation, and Ecology. Develop a deeper understanding of environment and ecology. Gain a fundamental knowledge of genetics, DNA, and genealogy. Comprehend the complexities of environmental law. Grasp the essentials of renewable energy sources. Understand the basics of marine biology. Learn how to apply theoretical knowledge in a professional setting. The "Environment Management, Conservation and Ecology - 3 QLS Course" bundle is a comprehensive theoretical package designed for those passionate about understanding and preserving our natural world. This bundle combines three QLS-endorsed courses with five relevant CPD QS accredited courses, providing a broad, cohesive learning experience. Delve into the multi-faceted world of environment management, the pressing issue of conservation, the broad science of ecology, and gain insights into related areas like genetics, environmental law, renewable energy, and marine biology. Enhance your understanding and immerse yourself in the comprehensive study of our planet's complex systems. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals passionate about environmental conservation and management. Students pursuing further academic study in related fields. Professionals seeking to enhance their theoretical understanding. Anyone interested in broadening their knowledge about our planet's intricate systems. Career path Environmental Manager: £22,000 - £60,000 per year. Conservation Officer: £20,000 - £40,000 per year. Ecologist: £22,000 - £50,000 per year. Genetic Counsellor: £26,000 - £50,000 per year. Renewable Energy Consultant: £20,000 - £45,000 per year. Marine Biologist: £20,000 - £55,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

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.