Name: Data Analyst Training Course
Price: 69 GBP
Availability: InStock

<strong>This video course takes a step-by-step and systematic approach to make you familiar with the bash shell scripting. You'll learn how to use the Linux command-line and commands to write and execute shell scripts for automating repetitive computing tasks.</strong>
        <p>Do you want to learn bash shell scripting for automating repetitive tasks, running multiple commands simultaneously, and customizing administrative tasks? This video course will help you to achieve the above goals by making you a master in bash shell scripting.

The course starts with the basics of bash shell scripting, explaining the use of variables, functions, and operators. Next, you'll customize the shell environment and understand the role of flow control statements in shell scripting. Moving along, you'll explore the techniques of file processing and learn how to parse command-line arguments.  Next, you'll learn how to run, schedule, and debug scripts. Towards the end, you'll get a quick tour of Linux commands and standard I/O concepts, and get an overview of projects that you'll be working on to encapsulate your learning.

By the end of this course, you'll gain a solid understanding of bash shell scripting and develop the skills needed to automate your daily computing tasks.

The code files and all related files are placed on GitHub at  https://github.com/PacktPublishing/Mastering-Bash-Shell-Scripting-Automate-your-daily-tasks</p>
        <h2>What You Will Learn</h2><p>Understand the special variables of bash shell in-depth<br>Uncover techniques to use conditions and loops effectively<br>Use shell scripting to read files and process them line-by-line<br>Write loops directly in the command-line for disposable scripts<br>Become familiar with bash brace expansion<br>Find out how to process command-line arguments swiftly</p>
        <h2>Audience</h2><p>If you are a DevOps engineer, DevOps architect, or a data science student who works with the Linux system and is interested in learning bash shell scripting, this course is for you. A basic understanding of the Linux command-line and commands is needed to get started with this course.</p>
        <h2>Approach</h2><p>With the help of real-world sample scripts, Linux labs, assignments, and interesting projects, this video course will help you to master bash shell scripting.</p>
        <h2>Key Features</h2><p>Get to grips with the features of a bash shell * Learn the best practices for running, scheduling, and debugging shell scripts * Get ready to write flawless scripts to automate repetitive tasks</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Mastering-Bash-Shell-Scripting-Automate-your-daily-tasks</p>
        <h2>About the Author</h2><h3>Coding Gears | Train Your Brain</h3><p>GlobalETraining (brand name - CodingGears) offers self-paced technical courses and makes them easy to learn.

They have been in the IT training business for many years, offering training courses in Unix, Windows, C#, Java, Python programming, SQL server, manual testing, automation, and so on. Their instructors have 20+ years of experience in various technical areas such as software development, software testing, Windows systems, and network administration, Unix/Linux systems and network administration, virtualization technologies, storage, shell scripting, database management systems (MS SQL Server, MySQL, IBM DB2, Cassandra), containerization (Dockers), Mesos, Marathon, Jenkins, Jira, Elastic Cloud Storage (ECS), Gluster file system, CoreOS, Ansible, and other areas.

CodingGears/GlobalETraining has mentored thousands of students for over a decade and has extensive experience in delivering training-both in-class and online.</p>
        <h2>Course Outline</h2><h4>1. Ground - ZERO</h4><p></p><br><h4>2. Getting Started - The Basics</h4><p></p><br><h4>3. Understanding  Variables</h4><p></p><br><h4>4. Operators </h4><p></p><br><h4>5. Customizing Shell Environment</h4><p></p><br><h4>6. Shell Parameter Expansion</h4><p></p><br><h4>7. Flow Control</h4><p></p><br><h4>8. File Processing</h4><p></p><br><h4>9. Functions - Revisited</h4><p></p><br><h4>10. Parsing Command Line Arguments</h4><p></p><br><h4>11. Process Handling and Running Scripts</h4><p></p><br><h4>12. Scheduling Scripts</h4><p></p><br><h4>13. Debugging Scripts</h4><p></p><br><h4>14. Scripting @ The Command-line</h4><p></p><br><h4>15. Linux Commands - Quick Refresher</h4><p></p><br><h4>16. Standard I/O Concepts</h4><p></p>

Packt

Shell Scripting

Bash

Automation

This video course takes a step-by-step and systematic approach to make you familiar with the bash shell scripting. You'll learn how to use the Linux command-line and commands to write and execute shell scripts for automating repetitive computing tasks.

Mastering Bash Shell Scripting: Automate your daily tasks [Updated for 2021]

General Admission

<p>Picture a world of endless possibilities; a realm where knowledge is power, and data reigns supreme. In today's digital age, the ability to decipher complex data sets and extract valuable insights has become an invaluable skill. With the Data Analysis with Data Science &amp; Machine Learning bundle, you're one step closer to harnessing the full potential of data and unlocking a brighter future.</p><p>The age of data is upon us, and the UK is no exception. As businesses and organisations increasingly rely on data to inform strategic decisions, professionals skilled in data analysis and machine learning are in high demand. By acquiring expertise in these fields, you'll not only enhance your career prospects but also contribute to the growth and success of the nation.</p><p>Don't miss out on this opportunity to take your career to the next level. Enrol in the Data Analysis with Data Science &amp; Machine Learning bundle today and unlock the power of data for your business.</p><p><strong>This Data Analysis with Data Science &amp; Machine Learning Bundle Consists of the following Premium courses: </strong></p><ul><li> Course 01: Introduction to Data Analysis</li><li> Course 02: Data Analytics with Tableau</li><li> Course 03: Complete Google Analytics Course</li><li> Course 04: Python for Data Analysis</li><li> Course 05: Quick Data Science Approach from Scratch</li><li> Course 06: R Programming for Data Science</li><li> Course 07: Learn MySQL from Scratch for Data Science and Analytics</li><li> Course 08: Master JavaScript with Data Visualization</li><li> Course 09: Excel Data Analysis</li><li> Course 10: Statistics &amp; Probability for Data Science &amp; Machine Learning</li><li> Course 11: Root Cause Analysis</li><li> Course 12: Google Data Studio: Data Analytics</li><li> Course 13: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li> Course 14: Business Intelligence and Data Mining Masterclass</li></ul><p>Learning Outcomes:</p><ul><li>Develop a solid understanding of data analysis techniques.</li><li>Learn how to collect, manage, and manipulate data effectively.</li><li>Gain knowledge in the programming languages commonly used in data analysis, such as Python and R.</li><li>Become proficient in data visualisation and presentation.</li><li>Develop an understanding of machine learning algorithms and their application in data analysis.</li><li>Learn how to use various data analysis software, including Tableau and Google Analytics.</li></ul><p>The Data Analysis with Data Science &amp; Machine Learning bundle includes a variety of courses aimed at providing theoretical knowledge in the field of data analysis. The bundle covers a wide range of topics, starting with the basics of data analysis such as data cleaning, exploration, and visualisation. With courses such as Introduction to Data Analysis, Data Analytics with Tableau, Complete Google Analytics Course, Python for Data Analysis, Quick Data Science Approach from Scratch, R Programming for Data Science, Learn MySQL from Scratch for Data Science and Analytics, and Master JavaScript with Data Visualization, learners can get a comprehensive understanding of data analysis concepts.</p><p>The course material is presented in a theoretical format to help learners gain a deep understanding of the topics. Learners can engage with the material at their own pace. The course content is presented in a way that is easy to understand, making it ideal for those who are new to the field of data analysis.</p><p><strong>Course Curriculum: Data Analysis with Data Science &amp; Machine Learning</strong></p><ul><li>Module 01: Introduction</li><li>Module 02: Agenda and Principles of Process Management</li><li>Module 03: The Voice of the Process</li><li>Module 04: Working as One Team for Improvement</li><li>Module 05: Exercise: The Voice of the Customer</li><li>Module 06: Tools for Data Analysis</li><li>Module 07: The Pareto Chart</li><li>Module 08: The Histogram</li><li>Module 09: The Run Chart</li><li>Module 10: Exercise: Presenting Performance Data</li><li>Module 11: Understanding Variation</li><li>Module 12: The Control Chart</li><li>Module 13: Control Chart Example</li><li>Module 14: Control Chart Special Cases</li><li>Module 15: Interpreting the Control Chart</li><li>Module 16: Control Chart Exercise</li><li>Module 17: Strategies to Deal with Variation</li><li>Module 18: Using Data to Drive Improvement</li><li>Module 19: A Structure for Performance Measurement</li><li>Module 20: Data Analysis Exercise</li><li>Module 21: Course Project</li><li>Module 22: Test your Understanding</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        140 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Professionals seeking to upskill and enhance their data analysis knowledge and abilities.</li><li>Individuals interested in pursuing a career in data analysis, data science or machine learning.</li><li>Business owners or entrepreneurs looking to gain insights into their data and make data-driven decisions.</li><li>Students or recent graduates seeking to gain valuable experience and knowledge in data analysis.</li><li>Anyone looking to expand their knowledge and understanding of data analysis and its useful applications.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Data Analysis with Data Science &amp; Machine Learning course has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Data Analyst: £24k-£42k per annum.</li><li>Business Intelligence Analyst: £25k-£60k per annum.</li><li>Data Scientist: £27k-£65k per annum.</li><li>Machine Learning Engineer: £28k-£80k per annum.</li><li>Business Analyst: £24k-£52k per annum.</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            £10
        </p>
            <div> <p>You will get the Hard Copy certificate for the <strong>Data Analysis with Data Science &amp; Machine Learning</strong> course absolutely Free! Other Hard Copy certificates are available for £10 each.</p><p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Apex Learning

Data Analysis with Data Science & Machine Learning

<p>Tired of browsing and searching for a <strong>Web Development </strong>course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed.</p><p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in<strong>-</strong>one Web Development bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Web Development course that will enhance your skills and prepare you for the competitive job market.</p><p>Also, our experts are available for answering your queries on Web Development and help you along your learning journey. Advanced audio-visual learning modules of these Web Development courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p><p>Furthermore, to help you showcase your expertise in Web Development, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.</p><p><strong>This Web Development Bundle Consists of the following Premium courses: </strong></p><ul><li><strong>Course 01: </strong>Diploma in PHP Web Development</li><li><strong>Course 02: </strong>HTML Web Development for Beginners</li><li><strong>Course 03: </strong>Ultimate PHP &amp; MySQL Web Development Course &amp; OOP Coding<strong><br /></strong></li><li><strong>Course 04: </strong>WordPress Website Creation and Hosting System with Affiliate Marketing!</li><li><strong>Course 05: </strong>Computer Science With Python</li><li><strong>Course 06: </strong>Python Programming for Everybody</li><li><strong>Course 07: </strong>Complete Web Application Penetration Testing &amp; Security</li><li><strong>Course 08: </strong>Cloud Computing / CompTIA Cloud+ (CV0-002)</li><li><strong>Course 09: </strong>Web Design in Affinity Designer</li><li><strong>Course 10: </strong>Advanced Diploma in User Experience UI/UX Design<strong><br /></strong></li><li><strong>Course 11: </strong>Level 2 Adobe Graphics Design Course</li><li><strong>Course 12: </strong>Diploma in Animation Design</li><li><strong>Course 13: </strong>Cyber Security Incident Handling and Incident Response</li><li><strong>Course 14:</strong> Decision Making and Critical Thinking</li></ul><p><strong>Benefits you'll get choosing Apex Learning:</strong></p><ul><li>Pay once and get lifetime access to 14 CPD courses</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules designed by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul><p><strong>How will I get my Certificate?</strong></p><p>After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul><li><strong>PDF Certificate: Free (For The Title Course)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul><p><strong>Curriculum:</strong></p><p><strong>Course 01: Diploma in PHP Web Development</strong></p><ul><li>Introduction</li><li>Environment Configuration</li><li>PHP Basics and Syntax</li><li>PHP Forms and MySQL and User Authentication</li></ul><p><strong>Course 02: HTML Web Development for Beginners</strong></p><ul><li>Setup and Overview</li><li>Basic Tags</li><li>Headings</li><li>Lists</li><li>Links</li><li>Images</li><li>Tables</li><li>Advanced Tables</li><li>Meta Tags</li><li>Description Lists</li><li>Presentation</li><li>Iframe</li><li>Video</li><li>Audio</li><li>Forms</li><li>CSS</li><li>JavaScript</li></ul><p><strong>Course 03: Create Your First Responsive Website</strong></p><ul><li>Introduction</li><li>Project Files</li><li>Project Setup</li><li>Website Structure Part-1</li><li>Website Structure Part-2</li><li>Chrome Dev Tools</li><li>Top Menu</li><li>Image Area</li><li>Service</li><li>Responsive Page</li><li>Conclusion</li></ul><p><strong>Course 04: WordPress Website Creation and Hosting System with Affiliate Marketing!</strong></p><p><strong>Section 01:</strong></p><ul><li>I Wish this Class Was Available for me When I Started My Business Online!</li><li>Executive Summary of My Website with WordPress</li></ul><p><strong>Section 02:</strong></p><ul><li>Introduction Part 1: Best WordPress Website Creation and Hosting System with Affiliate Marketing!</li><li>How to Build the Website, Hire Help, and Earn Money Making Websites on Upwork</li><li>Affiliate Marketing Setup with Footer Links Plus a Bitly Custom Short Domain</li><li>What Email Marketing Provider Do I Use?</li><li>The System I Used to Get 400 Blog Posts on My Website Fast in My Voice</li><li>WordPress Plugins, Collecting Emails, Consistency, and More Questions</li></ul><p><strong>Section 03:</strong></p><ul><li>Introduction Part 2: Why I Switched to the Google Cloud Platform Managed by Kinsta</li><li>With My Faster Website Hosting, I have Improved my Website Rapidly!</li><li>Why I Deleted My Email List!</li></ul><p><strong>Section 04:</strong></p><ul><li>Thank You for Watching!</li></ul><p><strong>Course 05: Computer Science With Python<br /></strong></p><ul><li>Module 01: Introduction</li><li>Module 02: Getting Started</li><li>Module 03: Procedures and Loops</li><li>Module 04: How to Manage Data</li></ul><p><strong>Course 06: </strong>Python Programming for Everybody</p><p><strong>Course 07: </strong>Complete Web Application Penetration Testing &amp; Security</p><p><strong>Course 08: </strong>Cloud Computing / CompTIA Cloud+ (CV0-002)</p><p><strong>Course 09: </strong>Web Design in Affinity Designer</p><p><strong>Course 10: </strong>Advanced Diploma in User Experience UI/UX Design<strong><br /></strong></p><p><strong>Course 11: </strong>Level 2 Adobe Graphics Design Course</p><p><strong>Course 12: </strong>Diploma in Animation Design</p><p><strong>Course 13: </strong>Cyber Security Incident Handling and Incident Response</p><p><strong>Course 14: </strong></p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        150 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone from any background can enrol in this Web Development bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Our Web Development course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this Web Development expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Web Development Courses

<p>Embark on a digital crafting odyssey, diving into the intricate world of web creation with our '<strong>PHP Web Development with MySQL; GitHub &amp; Heroku</strong>' course. Visualise your first step into this digital tapestry with the 'Introduction' unit, an inviting prelude that demystifies the realm of server-side scripting. As learners unfurl the sails of their developmental journey, they'll configure their coding environment, laying the robust groundwork for a future in web architecture.</p>
<p>Advancing into the heart of PHP, our syllabus navigates through the crucial syntax and fundamentals that form the bedrock of dynamic website construction. Engage with the creation of interactive forms, delve into database manipulation using MySQL, and master user authentication processes. This course promises a transformative learning expedition, from first principles to deploying live web applications, all while ensuring each participant garners the confidence to stitch together the seams of secure, responsive online experiences.</p>
<p><strong>Learning Outcomes</strong></p>
<ul>
<li>Comprehend PHP fundamentals and create robust web applications.</li>
<li>Configure environments for PHP development with precision.</li>
<li>Integrate MySQL databases for dynamic content management.</li>
<li>Construct and handle secure PHP forms for data collection.</li>
<li>Implement user authentication to safeguard web applications.</li>
</ul>
<h3><b>Why choose this PHP Web Development with MySQL; GitHub &amp; Heroku<span> course</span>?</b></h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the <b>CPD Quality Standards</b> and <b>CIQ </b>after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li>
<li>Unlock career resources for CV improvement, interview readiness, and job success.</li>
</ol>
<h3><b>Who is this PHP Web Development with MySQL; GitHub &amp; Heroku<span> </span></b><b><span>course </span></b><b>for?</b></h3>
<ul>
<li>Novices embarking on web development careers.</li>
<li>Technologists eager to learn server-side scripting.</li>
<li>Data managers focusing on MySQL database integration.</li>
<li>Coders looking to understand PHP in web applications.</li>
<li>Developers aiming to utilise GitHub and Heroku for deployment.</li>
</ul>
<h3><b>Career path</b></h3>
<ul>
<li><strong>Web Developer</strong>: £25,000 - £50,000</li>
<li><strong>PHP Developer</strong>: £24,000 - £45,000</li>
<li><strong>MySQL Database Administrator</strong>: £30,000 - £60,000</li>
<li><strong>User Authentication Specialist</strong>: £35,000 - £55,000</li>
<li><strong>Back-End Developer</strong>: £28,000 - £53,000</li>
<li><strong>DevOps Engineer</strong>: £40,000 - £70,000</li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>PHP Web Development with MySQL; GitHub &amp; Heroku</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>PHP Web Development with MySQL; GitHub &amp; Heroku</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Unit 01: Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 02: Environment Configuration</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 01: Setup a PHP Environment using XAMPP</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 02: Install Composer Package Manager</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 03: Visual Studio Code - Web Development Add ons</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 04: Create a GitHub Account</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 05: Create a Heroku Account</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 03: PHP Basics and Syntax</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 01: How PHP Works</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 02: IFELSE Statements</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 03: Switch Statements</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 04: FOR Loop</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 05: WHILE AND DOWHILE Loops</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 06: PHP Arrays and Manipulation</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 07: String Manipulation Functions</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 08: Date and Time Manipulation Functions</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 09: User Defined Functions</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 10: PHP Include and Require</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 11: PHP Website Layout - With Bootstrap</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 12: Add Project to Github</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 13: Publish Website to Heroku</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 04: PHP Forms and MySQL and User Authentication</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 01: Project and Website Setup</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 02: Create a Bootstrap 4 Form</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 03: PHP Form - $_GET Action</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 04: PHP Form - $_POST Action</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 05: Design Database with phpMyAdmin</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 06: Connect to Database using PHP PDO</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 07: Save Records to Database</td>
					<td> </td>
					<td><span><i></i> 00:38:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 08: View Database Records</td>
					<td> </td>
					<td><span><i></i> 00:36:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 09: View One Record's Details</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 10: Update Database Records</td>
					<td> </td>
					<td><span><i></i> 00:34:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 11: Delete Database Records</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 12: Final Touches: Form Validation, Error Messages, Success Messages</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 13: Create Heroku App and Remote Database</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 14: Setup Authentication Tables in Database</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 15: Setup Login and Authentication</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 16: Control User Access</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 17: Sending Confirmation Emails</td>
					<td> </td>
					<td><span><i></i> 00:31:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 18: Upload Profile Pictures</td>
					<td> </td>
					<td><span><i></i> 00:31:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 19: Final Touches</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Resources</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Resources - PHP Web Development w/ MySQL GitHub &amp; Heroku</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - PHP Web Development with MySQL; GitHub &amp; Heroku</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Online Course Marketing

Online Course Creation

Web Development

Trainers Course

Back End Web Development

PHP Web Development with MySQL; GitHub & Heroku

<p>In the modern world, proficiency in MySQL and statistics is paramount for data analysis roles across industries. The <strong>Diploma in MySQL and Statistics for Data Analysis</strong> course equips individuals with essential skills vital for interpreting and managing vast datasets. Through comprehensive modules such as SQL Environment Setup, GROUP BY Statements, and Correlation and Regression Analysis, learners gain proficiency in MySQL, a fundamental database management system. </p><p>Furthermore, <strong>understanding statistics</strong>, including measures of central tendency, probability, and hypothesis testing, provides a robust foundation for making data-driven decisions. In the UK job market, proficiency in MySQL significantly enhances job prospects, <strong>with salaries ranging from £30,000 to £60,000 per annum</strong>, depending on experience and expertise.</p><p> The <strong>increasing demand for skilled data analysts</strong> underscores the importance of this Diploma in MySQL and Statistics for Data Analysis course, <strong>with job opportunities projected to grow by 15% over the next decade</strong>, reflecting the ever-expanding reliance on data-driven insights in various sectors.</p><p><strong>Key Features:</strong></p><ul><li>CPD Certified</li><li>Instant e-certificate and hard copy dispatch by next working day</li><li>Fully online, interactive course with audio voiceover</li><li>Developed by qualified professionals in the field</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>The Complete MySQL Server from Scratch: Bootcamp</strong></p><ul><li><strong>Module 01:</strong> Course Introduction</li><li><strong>Module 02:</strong> SQL Environment Setup</li><li><strong>Module 03:</strong> SQL Statement Basics</li><li><strong>Module 04:</strong> GROUP BY Statements</li><li><strong>Module 05:</strong> JOINS</li><li><strong>Module 06:</strong> Advanced SQL Commands / Statements</li><li><strong>Module 07:</strong> Creating Database and Tables</li><li><strong>Module 08:</strong> Databases and Tables</li></ul><p><strong>Statistics Analyst</strong></p><ul><li><strong>Module 01:</strong> Introduction to Statistics</li><li><strong>Module 02:</strong> Measuring Central Tendency</li><li><strong>Module 03:</strong> Measures of Dispersion</li><li><strong>Module 04:</strong> Correlation and Regression Analysis</li><li><strong>Module 05:</strong> Probability</li><li><strong>Module 06:</strong> Sampling</li><li><strong>Module 07:</strong> Charts and Graphs</li><li><strong>Module 08:</strong> Hypothesis Testing</li><li><strong>Module 09:</strong> Business Processes</li><li><strong>Module 10:</strong> Business Analysis Planning and Monitoring</li><li><strong>Module 11:</strong> Strategic Analysis and Product Scope</li><li><strong>Module 12:</strong> Ratio Analysis</li><li><strong>Module 13:</strong> Planning &amp; Forecasting Operations</li><li><strong>Module 14:</strong> Ten Common Statistical Mistakes</li></ul><p><strong>Learning Outcomes:</strong></p><ul><li>Master SQL statement fundamentals for robust database querying.</li><li>Analyse data effectively using advanced SQL commands and functions.</li><li>Apply statistical measures to uncover patterns and trends in data.</li><li>Interpret correlation and regression analyses for informed decision-making.</li><li>Demonstrate proficiency in hypothesis testing and probability theory.</li><li>Utilise charts, graphs, and ratio analysis for impactful data visualisation.</li></ul><p><strong>Accreditation</strong></p><p>All of our courses are fully accredited, including this Diploma in MySQL and Statistics for Data Analysis Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in MySQL and Statistics for Data Analysis.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Diploma in MySQL and Statistics for Data Analysis Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Diploma in MySQL and Statistics for Data Analysis Course certification has no expiry dates, although we do recommend that you renew them every 12 months.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        20 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Diploma in MySQL and Statistics for Data Analysis Course can be taken by anyone who wants to understand more about the topic. With the aid of this Diploma in MySQL and Statistics for Data Analysis course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Diploma in MySQL and Statistics for Data Analysis Course is ideal for:</p><ul><li>Aspiring data analysts seeking foundational knowledge in SQL and statistics.</li><li>Database administrators aiming to enhance their MySQL server skills.</li><li>Professionals transitioning into data-related roles within diverse industries.</li><li>Individuals keen on leveraging data for strategic decision-making in business.</li><li>Students aspiring to kickstart a career in data analysis or database management.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Learners do not require any prior qualifications to enrol on this Diploma in MySQL and Statistics for Data Analysis Course. You just need to have an interest in Diploma in MySQL and Statistics for Data Analysis Course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After completing this Diploma in MySQL and Statistics for Data Analysis Course you will have a variety of careers to choose from. The following job sectors of Diploma in MySQL and Statistics for Data Analysis Course are:</p><ul><li>Data Analyst - £25K to 45K/year</li><li>Database Administrator - £30K to 55K/year</li><li>Business Analyst - £35K to 60K/year</li><li>Statistician - £30K to 50K/year</li><li>Financial Analyst - £30K to 55K/year</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Once you've successfully completed your course, you will immediately be sent a FREE digital certificate.</p></div>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK).<br />For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.<br />Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p></div>

                        </div>

Training Express

Diploma in MySQL and Statistics for Data Analysis Course

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p><span>Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making.</span></p><p><b id="docs-internal-guid-6a582f22-7fff-d807-19e0-b5dad8f04cd9"><br /></b></p><p><span>Learning Outcomes:</span></p><ul><li><p><span>Establish a strong foundation in SQL and MySQL.</span></p></li><li><p><span>Set up and configure SQL Server for efficient data handling.</span></p></li><li><p><span>Master SQL's Data Manipulation, Definition, and Control Language.</span></p></li><li><p><span>Create and optimize SQL queries for data analysis.</span></p></li><li><p><span>Perform advanced data analytics using SQL.</span></p></li><li><p><span>Understand the power of GROUP BY and JOIN statements.</span></p></li><li><p><span>Implement data constraints and views for data integrity and security.</span></p></li><li><p><span>Develop proficiency in stored procedures, data import/export, and database backup/restore.</span></p></li></ul><p><b><br /></b></p><p><span>Why buy this Learn MySQL from Scratch for Data Science and Analytics?</span><span> </span></p><ul><li><p><span>Unlimited access to the course for forever</span></p></li><li><p><span>Digital Certificate, Transcript, student ID all included in the price</span></p></li><li><p><span>Absolutely no hidden fees</span></p></li><li><p><span>Directly receive CPD accredited qualifications after course completion</span></p></li><li><p><span>Receive one to one assistance on every weekday from professionals</span></p></li><li><p><span>Immediately receive the PDF certificate after passing</span></p></li><li><p><span>Receive the original copies of your certificate and transcript on the next working day</span></p></li><li><p><span>Easily learn the skills and knowledge from the comfort of your home</span></p></li></ul><p><b><br /></b></p><p><span>Certification</span></p><p><span>After studying the course materials of the </span><span>Learn MySQL from Scratch for Data Science and Analytics</span><span> you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</span></p><p><b><br /></b></p><p><span>Who is this course for?</span></p><p><span>This </span><span>Learn MySQL from Scratch for Data Science and Analytics</span><span> course is ideal for</span></p><ul><li><p><span>Aspiring Data Scientists and Analysts.</span></p></li><li><p><span>Database Administrators and Developers.</span></p></li><li><p><span>Students and professionals seeking to enter the field of Data Science.</span></p></li><li><p><span>Anyone looking to enhance their SQL and MySQL skills for data-related roles.</span></p></li></ul><p><b><br /></b></p><p><span>Prerequisites</span></p><p><span>This </span><span>Learn MySQL from Scratch for Data Science and Analytics</span><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p><p><b><br /></b></p><p><span>Career path</span></p><p></p><ul><li><p><span>Data Analyst: £25,000 - £50,000 per year.</span></p></li><li><p><span>Database Administrator: £30,000 - £60,000 per year.</span></p></li><li><p><span>SQL Developer: £30,000 - £60,000 per year.</span></p></li><li><p><span>Data Scientist: £40,000 - £80,000 per year.</span></p></li><li><p><span>Business Intelligence Analyst: £35,000 - £65,000 per year.</span></p></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Learn MySQL from Scratch for Data Science and Analytics</td>
				</tr>
								<tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to get course requirements</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting started on Windows, Linux or Mac</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FAQ's</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is Source Code?</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 02: SQL Server setting up</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MySQL Server Installation</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Connect MySQL Server Instance</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MySQL Workbench overview</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download and Restore Sample Database</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 03: SQL Database basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Databases</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Database</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Data Types</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column Data Types on Workbench</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Table</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Primary and Foreign Key</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Primary Key</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Foreign Key</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Temporary tables</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>EER - Enhanced Entity Relationship Diagrams</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 04: SQL DML (Data Manipulation Language)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert statement</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update statement</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 05: SQL DDL (Data Definition Language)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CREATE table statement</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DROP statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>ALTER statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>TRUNCATE statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>COMMENT in query</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>RENAME table</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 06: SQL DCL (Data Control Language)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Database user</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>GRANT permissions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>REVOKE permissions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 07: SQL Statement Basic</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Statement basic</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT Statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT DISTINCT</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT with column headings</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Column AS statement</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DASHBOARD Analytics</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Filtering Data rows</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - theory</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT WHERE Clause - practical</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Aggregate functions for Data Analysis</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sum()</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Min()-Max()</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 10: SQL Data Analyticstatements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order By statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT TOP 3 records</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BETWEEN command</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IN operator</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search Data usingLIKE cards</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 11: SQL Group by statement</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Group by - theory</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Analytics with Group By</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>HAVING statement</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 12: JOINS</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview of Joins</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Joins</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inner join</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Left outer join</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Right outer join</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Union</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CERTESIAN Product or Cross Join</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Exercise</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Solution for Query Exercise</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 13: SQL Constraints</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Check constraint</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>NOT NULL constraint</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>UNIQUE constraint</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 14: Views</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Views</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Analytic Views from multiple tables</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Advanced SQL Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Timestamp</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Extract from timestamp</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mathematical scalar functions</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>String functions3</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced functions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sub Queries</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SELECT with calculations</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 16: SQL Stored procedures</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create stored procedure</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stored procedure with parameter</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Drop Procedure</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 17: Import &amp; Export data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import .csv file</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Export Data to .csv file</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Section 18: Backup and Restore Database</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section Introduction</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Database backup</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restoring Database backup</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Learning & Development

Data Engineering

Microsoft SQL

AWS Certified Database

Data Skills

Learn MySQL from Scratch for Data Science and Analytics

<p>Dive into the UK's booming digital landscape with Coding &amp; SQL Masterclass!</p><p>The UK's digital sector is on fire, with jobs for coders and data analysts soaring 17% year-on-year!  This Masterclass is your gateway to this exciting world, equipping you with the in-demand skills to thrive.</p><p>Whether you're a curious beginner or a code enthusiast, our immersive curriculum, packed with real-world examples and fresh UK stats, will take you from zero to hero.  Master sought-after coding languages like Python and JavaScript, then unlock the power of SQL to transform data into valuable insights.</p><p>Don't just watch the digital revolution unfold - be a part of it! Enrol in Coding &amp; SQL Masterclass today and unlock your coding and SQL potential</p><p><strong>Learning Outcomes:</strong></p><ul><li>Master SQL Server fundamentals for effective database management and manipulation.</li><li>Develop advanced PHP web applications with MySQL, GitHub, and Heroku integration.</li><li>Acquire proficiency in Python, JavaScript, and Microsoft SQL for data science applications.</li><li>Build browser extensions using JavaScript and enhance web browsing experiences.</li><li>Attain a complete understanding of C++ development through comprehensive coding guidance.</li></ul><p>Embark on a comprehensive learning journey with our "Coding &amp; SQL Masterclass" that covers essential SQL training, MySQL mastery, and advanced web development in PHP, integrating GitHub and Heroku. Delve into Python, JavaScript, and Microsoft SQL for a holistic understanding of data science. From mastering SAS programming to C++ development, this course ensures a well-rounded education in coding essentials for beginners and enthusiasts alike.</p><p><strong>This CPDQS Accredited Coding &amp; SQL Masterclass consists of the following 11 courses:</strong></p><ul><li>SQL Server for Beginners</li><li>SQL Training</li><li>MySql Masterclass</li><li>Microsoft SQL Server Development for Everyone</li><li>Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku</li><li>Advanced SAS Programming Using MacrosSQL</li><li>Ultimate PHP &amp; MySQL Web Development &amp; OOP Coding</li><li>Learn Python, JavaScript, and Microsoft SQL for Data science</li><li>Coding with Python 3</li><li>Start Coding Browser Extensions Using JavaScript!</li><li>C++ Development: The Complete Coding Guide</li></ul><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        35 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course caters to beginners and enthusiasts eager to grasp coding and SQL intricacies. Ideal for:</p><ul><li>Aspiring Developers</li><li>Data Science Enthusiasts</li><li>Tech Enthusiasts</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No formal prerequisites! Open to all, embark on your coding journey now.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>SQL Database Administrator - £40,000 to £60,000</li><li>PHP Web Developer - £35,000 to £50,000</li><li>Python Data Scientist - £45,000 to £70,000</li><li>JavaScript Developer - £40,000 to £55,000</li><li>C++ Software Engineer - £50,000 to £75,000.</li></ul>
                        </div>

One Education

From Zero to Hero: Level Up Your Career with Coding & SQL Course

<p>Forget stock markets and weather trends - the hottest data point right now is you. In a world brimming with information, data analysts are the alchemists, transforming raw numbers into actionable insights that fuel businesses.</p><p>The UK's digital gold rush is in full swing, with demand for skilled analysts surging 32% in the past year alone. This isn't just a trend; it's a tidal wave, and you can ride it to the top. Our Data Analyst Training equips you with the tools and knowledge to navigate this data-driven landscape with confidence.</p><p>From wrangling spreadsheets to crafting compelling visualisations, you'll master the skills that turn data into decisions. Don't just be part of the information age - become its architect. Enroll now and unlock your inner data analyst.</p><p><strong>Learning Outcomes:</strong></p><ul><li>Analyse business data effectively for informed decision-making using diverse tools.</li><li>Develop expertise in utilising Excel for data analysis and forecasting.</li><li>Master the intricacies of Google Analytics and Google Data Studio.</li><li>Acquire proficiency in MySQL Database Development and SQL NoSQL Big Data.</li><li>Apply Python and R Programming for Data Science and Machine Learning applications.</li></ul><p>This comprehensive Data Analyst Training covers the fundamentals of data analysis, business insights, forecasting, database development, and programming, providing a holistic approach to harnessing the power of data. Embrace a versatile skill set that includes Excel, Google Analytics, MySQL, SQL, NoSQL, Big Data, Python, and R Programming. This course caters to aspiring data analysts, professionals seeking to enhance their analytical skills, and individuals venturing into the realm of data science.</p><p>This CPDQS Accredited Data Analyst Training consists of the following 11 courses:</p><ul><li>Diploma in Data Analysis Fundamentals</li><li>Business Data Analysis</li><li>Data Analysis and Forecasting in Excel</li><li>Excel Data Analysis</li><li>Learn Google Analytics-From a Beginner to becoming a Pro</li><li>Google Data Studio</li><li>MySQL Database Development</li><li>SQL NoSQL Big Data and Hadoop</li><li>Data Science &amp; Machine Learning with Python</li><li>R Programming for Data Science</li><li>Quick Data Science Approach from Scratch</li></ul><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.<br /></p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        35 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Embark on this data-driven journey if you are:</p><ul><li>Aspiring Data Analysts</li><li>Professionals aiming to enhance analytical skills</li><li>Individuals entering the field of data science</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This course is open to all, requiring only a passion for data and curiosity to explore its depths. No formal prerequisites are necessary, ensuring accessibility for everyone interested in becoming a data analyst.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Data Analyst - £30,000 to £50,000</li><li>Business Intelligence Analyst - £35,000 to £55,000</li><li>Database Developer - £40,000 to £60,000</li><li>Data Scientist - £45,000 to £70,000</li><li>Machine Learning Engineer - £50,000 to £80,000</li></ul>
                        </div>

Data Analyst Training Course

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The CHFI course will benefit:<br />Police and other laws enforcement personnel<br />Defense and Military personnel<br />e-Business Security professionals<br />Systems administrators<br />Legal professionals<br />Banking, Insurance and other professionals<br />Government agencies</p>Overview<p>At the end of this course, you will possess the skills needed to:<br />Understand the fundamentals of computer forensics<br />Understand the computer forensic investigation process<br />Describe in detail different types of hard disks and file systems<br />Understand data acquisition and duplication<br />Counteract anti-forensic techniques<br />Leverage forensic skills in Windows, Linux, and Mac<br />Investigate web attacks<br />Understand dark web forensics<br />Deploy forensic techniques for databases, cloud, and networks<br />Investigate email crimes including malware<br />Perform forensics in mobile and IoT environments</p><p>Every crime leaves a digital footprint, and you need the skills to track those footprints. In this course, students will learn to unravel these pieces of evidence, decode them and report them. From decoding a hack to taking legal action against the perpetrators, they will become an active respondent in times of cyber-breaches.</p></div><div id="course-pills-2"><h4>Computer Forensics in Today?s World </h4><ul><li>1.1. Understand the Fundamentals of Computer Forensics </li><li>1.2. Understand Cybercrimes and their Investigation Procedures </li><li>1.3. Understand Digital Evidence </li><li>1.4. Understand Forensic Readiness, Incident Response and the Role of SOC (Security </li><li>       Operations Center) in Computer Forensics </li><li>1.5. Identify the Roles and Responsibilities of a Forensic Investigator </li><li>1.6. Understand the Challenges Faced in Investigating Cybercrimes </li><li>1.7. Understand Legal Compliance in Computer Forensics </li><li></li></ul><h4>Computer Forensics Investigation Process </h4><ul><li>2.1. Understand the Forensic Investigation Process and its Importance </li><li>2.2. Understand the Pre-investigation Phase </li><li>2.3. Understand First Response </li><li>2.4. Understand the Investigation Phase </li><li>2.5. Understand the Post-investigation Phase </li><li></li></ul><h4>Understanding Hard Disks and File Systems </h4><ul><li>3.1. Describe Different Types of Disk Drives and their Characteristics </li><li>3.2. Explain the Logical Structure of a Disk </li><li>3.3. Understand Booting Process of Windows, Linux and Mac Operating Systems </li><li>3.4. Understand Various File Systems of Windows, Linux and Mac Operating Systems </li><li>3.5. Examine File System Using Autopsy and The Sleuth Kit Tools </li><li>3.6 Understand Storage Systems</li><li>3.7. Understand Encoding Standards and Hex Editors </li><li>3.8. Analyze Popular File Formats Using Hex Editor </li><li></li></ul><h4>Data Acquisition and Duplication </h4><ul><li>4.1. Understand Data Acquisition Fundamentals</li><li>4.2. Understand Data Acquisition Methodology </li><li>4.3. Prepare an Image File for Examination </li><li></li></ul><h4>Defeating Anti-forensics Techniques </h4><ul><li>5.1. Understand Anti-forensics Techniques </li><li>5.2. Discuss Data Deletion and Recycle Bin Forensics </li><li>5.3. Illustrate File Carving Techniques and Ways to Recover Evidence from Deleted Partitions </li><li>5.4. Explore Password Cracking/Bypassing Techniques </li><li>5.5. Detect Steganography, Hidden Data in File System Structures, Trail Obfuscation, and File Extension Mismatch </li><li>5.6. Understand Techniques of Artifact Wiping, Overwritten Data/Metadata Detection, and Encryption </li><li>5.7. Detect Program Packers and Footprint Minimizing Techniques</li><li>5.8. Understand Anti-forensics Countermeasures </li><li></li></ul><h4>Windows Forensics </h4><ul><li>6.1. Collect Volatile and Non-volatile Information </li><li>6.2. Perform Windows Memory and Registry Analysis </li><li>6.3. Examine the Cache, Cookie and History Recorded in Web Browsers </li><li>6.4. Examine Windows Files and Metadata </li><li>6.5. Understand ShellBags, LNK Files, and Jump Lists </li><li>6.6. Understand Text-based Logs and Windows Event Logs </li><li></li></ul><h4>Linux and Mac Forensics </h4><ul><li>7.1. Understand Volatile and Non-volatile Data in Linux </li><li>7.2. Analyze Filesystem Images Using The Sleuth Kit </li><li>7.3. Demonstrate Memory Forensics Using Volatility &amp; PhotoRec </li><li>7.4. Understand Mac Forensics </li><li></li><li></li></ul><h4>Network Forensics </h4><ul><li>8.1. Understand Network Forensics </li><li>8.2. Explain Logging Fundamentals and Network Forensic Readiness </li><li>8.3. Summarize Event Correlation Concepts </li><li>8.4. Identify Indicators of Compromise (IoCs) from Network Logs </li><li>8.5. Investigate Network Traffic </li><li>8.6. Perform Incident Detection and Examination with SIEM Tools </li><li>8.7. Monitor and Detect Wireless Network Attacks </li><li></li></ul><h4>Investigating Web Attacks </h4><ul><li>9.1. Understand Web Application Forensics </li><li>9.2. Understand Internet Information Services (IIS) Logs </li><li>9.3. Understand Apache Web Server Logs </li><li>9.4. Understand the Functionality of Intrusion Detection System (IDS) </li><li>9.5. Understand the Functionality of Web Application Firewall (WAF) </li><li>9.6. Investigate Web Attacks on Windows-based Servers </li><li>9.7. Detect and Investigate Various Attacks on Web Applications </li><li></li></ul><h4>Dark Web Forensics </h4><ul><li>10.1. Understand the Dark Web </li><li>10.2. Determine How to Identify the Traces of Tor Browser during Investigation </li><li>10.3. Perform Tor Browser Forensics </li><li></li></ul><h4>Database Forensics </h4><ul><li>11.1. Understand Database Forensics and its Importance </li><li>11.2. Determine Data Storage and Database Evidence Repositories in MSSQL Server </li><li>11.3. Collect Evidence Files on MSSQL Server </li><li>11.4. Perform MSSQL Forensics </li><li>11.5. Understand Internal Architecture of MySQL and Structure of Data Directory </li><li>11.6. Understand Information Schema and List MySQL Utilities for Performing Forensic Analysis </li><li>11.7. Perform MySQL Forensics on WordPress Web Application Database </li><li></li></ul><h4>Cloud Forensics </h4><ul><li>12.1. Understand the Basic Cloud Computing Concepts </li><li>12.2. Understand Cloud Forensics </li><li>12.3. Understand the Fundamentals of Amazon Web Services (AWS) </li><li>12.4. Determine How to Investigate Security Incidents in AWS </li><li>12.5. Understand the Fundamentals of Microsoft Azure </li><li>12.6. Determine How to Investigate Security Incidents in Azure  </li><li>12.7. Understand Forensic Methodologies for Containers and Microservices </li><li></li></ul><h4>Investigating Email Crimes </h4><ul><li>13.1. Understand Email Basics </li><li>13.2. Understand Email Crime Investigation and its Steps </li><li>13.3. U.S. Laws Against Email Crime </li><li></li></ul><h4>Malware Forensics </h4><ul><li>14.1. Define Malware and Identify the Common Techniques Attackers Use to Spread Malware </li><li>14.2. Understand Malware Forensics Fundamentals and Recognize Types of Malware Analysis </li><li>14.3. Understand and Perform Static Analysis of Malware </li><li>14.4. Analyze Suspicious Word and PDF Documents </li><li>14.5. Understand Dynamic Malware Analysis Fundamentals and Approaches </li><li>14.6. Analyze Malware Behavior on System Properties in Real-time </li><li>14.7. Analyze Malware Behavior on Network in Real-time </li><li>14.8. Describe Fileless Malware Attacks and How they Happen </li><li>14.9. Perform Fileless Malware Analysis - Emotet </li><li></li></ul><h4>Mobile Forensics </h4><ul><li>15.1. Understand the Importance of Mobile Device Forensics </li><li>15.2. Illustrate Architectural Layers and Boot Processes of Android and iOS Devices </li><li>15.3. Explain the Steps Involved in Mobile Forensics Process </li><li>15.4. Investigate Cellular Network Data </li><li>15.5. Understand SIM File System and its Data Acquisition Method </li><li>15.6. Illustrate Phone Locks and Discuss Rooting of Android and Jailbreaking of iOS Devices </li><li>15.7. Perform Logical Acquisition on Android and iOS Devices </li><li>15.8. Perform Physical Acquisition on Android and iOS Devices </li><li>15.9. Discuss Mobile Forensics Challenges and Prepare Investigation Report </li><li></li></ul><h4>IoT Forensics </h4><ul><li>16.1. Understand IoT and IoT Security Problems </li><li>16.2. Recognize Different Types of IoT Threats </li><li>16.3. Understand IoT Forensics </li><li>16.4. Perform Forensics on IoT Devices </li><li></li></ul></div>

Nexus Human

Forensic Science

Certified Cryptocurrency Investigator Course (CCI)

Cyber Security

Certified Ethical Hacker (CEH)

Cyber Security Foundation

Ethical Hacking

EC-Council Computer Hacking Forensic Investigator (CHFI) v10.0

Redhill

<h3><b>MySQL for developers training course description</b></h3>
        <p>  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. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.</li>
<li>Use advanced features of the MySQL Client.</li>
<li>Use advanced data types.</li>
<li>Manage the structure of databases and tables.</li>
<li>Manage and using indexes.</li>
<li>Write complex SQL query statements.</li>
<li>Use advanced SQL expressions.</li>
<li>Use advanced SQL functions.</li>
<li>Perform advanced Insert, Update, Delete, Replace and Truncate Operations.</li>
<li>Use user variable syntax and properties.</li>
<li>Import and export data from within MySQL.</li>
<li>Import and export data from the command line.</li>
<li>Perform complex joins to access multiple tables.</li>
<li>Perform complex subqueries.</li>
<li>Create, manage and us views.</li>
<li>Use prepared statements.</li>
<li>Create and use stored routines.</li>
<li>Create and use triggers.</li>
<li>Obtain database metadata.</li>
<li>Optimize queries.</li>
<li>Work with the main storage engines.</li>
<li>Debug MySQL applications.</li>

                  </ul>
        <h5>
        <b>MySQL for developers training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>MySQL foundation </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL for developers training course contents</b></h3>
      <ul>
        <li>Introduction </li><p>
Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions.

</p><li>Client/server concepts </li><p>
MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options
<br /><span>Hands on</span> Using client/server

</p><li>The MySQL client program </li><p>
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.
<br /><span>Hands on</span> Using the MySQL client program

</p><li>Data types </li><p>
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.
<br /><span>Hands on</span> Using data types 

</p><li>Identifiers </li><p>
Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names
<br /><span>Hands on</span> Using identifiers

</p><li>Databases </li><p>
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
<br /><span>Hands on</span> Using databases

</p><li>Tables and indexes </li><p>
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.
<br /><span>Hands on</span> Creating, altering and dropping tables/indexes

</p><li>Querying for data </li><p>
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.
<br /><span>Hands on</span> Querying for data

</p><li>SQL Expressions and functions </li><p>
Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions.
<br /><span>Hands on</span> Using expressions and functions

</p><li>Updating data </li><p>
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

</p><li>Connectors 	</li><p>
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.

</p><li>Obtaining database metadata </li><p>
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.
<br /><span>Hands on</span> Obtaining database metadata

</p><li>Debugging 	</li><p>
Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility.
<br /><span>Hands on</span> Debugging

</p><li>Joins </li><p>
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.
<br /><span>Hands on</span> Coding joins

</p><li>Subqueries 	</li><p>
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.
<br /><span>Hands on</span> Coding subqueries

</p><li>Views </li><p>
Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views.
<br /><span>Hands on</span> Using views

</p><li>Import and Export </li><p>
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.
<br /><span>Hands on</span> Importing and exporting

</p><li>User variables and prepared statements </li><p>
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.
<br /><span>Hands on</span> Using variables and prepared statements

</p><li>Introduction to stored routines </li><p>
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.
<br /><span>Hands on</span> Writing simple stored routines

</p><li>Stored routines - program logic </li><p>
The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Stored routines - exception handlers and cursors </li><p>
Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Procedures with parameters </li><p>
Creating procedures with parameters, Calling Procedures With Parameters.
<br /><span>Hands on</span> Writing stored routines with parameters

</p><li>Functions 	</li><p>
What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses.
<br /><span>Hands on</span> Writing functions

</p><li>Triggers </li><p>
Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges.
<br /><span>Hands on</span> Writing triggers

</p><li>Basic optimizations </li><p>
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.
<br /><span>Hands on</span> Making use of basic optimizations

</p><li>More about indexes </li><p>
Indexes and joins
<br /><span>Hands on</span> Investigating indexes and joins
				</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

MySQL for developers

<h3><b>MySQL server admins training course description</b></h3>
        <p>This MySQL Server administration course is designed
for MySQL Server administrators who have a basic
understanding of a MySQL database and a good
working knowledge of SQL commands.
The course provides an understanding of MySQL
Architecture and practical experience in setting up,
configuring and maintaining a MySQL server, backing
up and recovering data and optimising query
performance. This MySQL Server administration course
also covers MySQL replication and its role in high
availability and scalability.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Use MySQL Workbench.</li>
 <li>Install and configure a MySQL Server .</li>
 <li>Administer and tune a MySQL server.</li>
 <li>Configure log files and interpret error messages..</li>
 <li>Secure the Server.</li>
 <li>Administer a replication topology.</li>
                  </ul>
        <h5>
        <b>MySQL server admin training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Database administrators, Database developers and
Technical consultants.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Introduction to MySQL</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL server admin training course contents</b></h3>
      <ul>
        <li>Introduction to Oracle Application Express </li><p>
APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application

</p><li>SWL Workshop </li><p>
Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries

</p><li>Build a database application </li><p>
Application components Create an application Create an application from a spreadsheet

</p><li>Create reports </li><p>
Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats

</p><li>Using files </li><p>
Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file

</p><li>Pages and regions </li><p>
Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms

</p><li>Creating lists of values </li><p>
Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values

</p><li>Items and buttons </li><p>
Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons

</p><li>Page Processing </li><p>
Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches

</p><li>Shared components </li><p>
Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults

</p><li>Display dynamic content </li><p>
Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees

</p><li>State and debugging </li><p>
Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development

</p><li>Themes and templates </li><p>
Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files

</p><li>Dynamic actions and plug-in components </li><p>
Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action

</p><li>Building website applications </li><p>
Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application

</p><li>Implementing security </li><p>
Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection

</p><li>Deploy an appliction </li><p>
Define supporting objects Package an application Export an application Import an application Install supporting objects

</p><li>Administer Apex workspaces </li><p>
Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace

</p><li>Utility programs </li><p>
Import and export data Generate DDL statements View objects reports</p>
      </ul>

MySQL server administration

<h3><b>MySQL Performance &amp; Tuning training course description</b></h3>
        <p> This MySQL Performance &amp; Tuning course is designed
for Database Administrators, Application Developers and
Technical Consultants who need to monitor and tune the
performance of MySQL servers and databases. The
course provides practical experience in monitoring and
tuning MySQL servers and databases. <br />
<b>Note:</b><br />
This MySQL Performance &amp; Tuning course does not
cover clustering (other than at overview level),
replication or non-standard storage engines such as
Falcon and PBXT. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                       <li>Develop a monitoring and tuning plan</li>
                        <li>Use server configuration and status variables.</li>
                        <li>Identify and improve problem queries.</li>
                        <li>Make efficient use of indexes.</li>
                        <li>Monitor and size memory caches and locks.</li>
                        <li>Tune the MyISAM and InnoDB storage engine.</li>
                        <li>Evaluate the use of partitioning for performance.</li>
                                      
                  </ul>
        <h5>
        <b>MySQL Performance &amp; Tuning training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who wishes to monitor and tune MySQL performance.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Delegates must have a working knowledge of MySQL Database Administration</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL Performance &amp; Tuning training course contents</b></h3>
      <ul>
        <li>Introduction to performance tuning </li><p>
Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals.

				</p><li>MySQL performance tuning tools </li><p>
Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog.
<br /><span>Hands on</span> Obtaining performance information.

</p><li>Schema design </li><p>
Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines.
<br /><span>Hands on</span> effects of design on performance.

</p><li>Statement tuning </li><p>
Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended.
<br /><span>Hands on</span> identifying problem queries and using explain.

</p><li>Indexes </li><p>
Index overview, Types of index, Index tuning, Indexes and joins.
<br /><span>Hands on</span> Indexes and performance.

</p><li>Server configuration and monitoring </li><p>
Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache.
<br /><span>Hands on</span> setting and interpreting server variables and caching.

</p><li>Locking </li><p>
Types of locking, locking and storage engines, effects of locking on performance.
<br /><span>Hands on</span> locking and performance.

</p><li>The InnoDB engine </li><p>
Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files.
<br /><span>Hands on</span> InnoDB configuration and performance.

</p><li>Other storage engines </li><p>
MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines.
<br /><span>Hands on</span> storage engine performance.

</p><li>Overview of clustering and performance </li><p>
Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview.

</p><li>Dumping and loading data </li><p>
SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance.
<br /><span>Hands on</span> dump and load performance.

</p><li>Partitioned tables </li><p>
Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning.
<br /><span>Hands on</span> partitioned table performance.
				</p>
      </ul>

MySQL Performance & Tuning

<h3><b>MySQL foundation training course description</b></h3>
        <p> 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.    </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Create, alter and drop a MySQL database.</li>
						<li>Write SQL statements.</li>
						<li>Use SQL expressions and functions.</li>
                        <li>Create and alter tables, indexes and views.</li>
                        <li>Use transactions.</li>
                        <li>Grant and revoke access privileges.</li>
                        <li>Export and import data.</li>
                  </ul>
        <h5>
        <b>MySQL foundation training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone who needs to access and work with a MySQL Database.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>An understanding of databases and exposure to
information technology in general would be useful.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL foundation training course contents</b></h3>
      <ul>
        <li>Database concepts </li><p>
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.
<br /><span>Hands on</span> using a database.

</p><li>Using the MySQL client </li><p>
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.
<br /><span>Hands on</span> Using the MySQL client.

</p><li>Basic SELECT </li><p>
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.
<br /><span>Hands on</span> querying the sample database.

</p><li>LIMIT, UNION and AGGREGATE functions </li><p>
The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause.
<br /><span>Hands on</span> using limit, union and aggregate functions.

</p><li>Subqueries and joins </li><p>
Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. <br /><span>Hands on</span> using subqueries and joins.

</p><li>Numeric and character functions </li><p>
Function types, testing functions, numeric functions character functions.
<br /><span>Hands on</span> using numeric and character functions.

</p><li>Data, time and other functions </li><p>
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.
<br /><span>Hands on</span> using date, time and other functions.

</p><li>Databases and tables </li><p>
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.
<br /><span>Hands on</span> maintaining databases and tables.

</p><li>Indexes and views </li><p>
What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views.
<br /><span>Hands on</span> maintaining indexes and views.

</p><li>Managing data </li><p>
Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits.
<br /><span>Hands on</span> managing data.

</p><li>Access control </li><p>
Creating users, renaming users, dropping users, granting privileges, revoking privileges. <br /><span>Hands on</span> creating users, granting and revoking.

</p><li>Import and export </li><p>
Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line.
<br /><span>Hands on</span> export and import data.
</p>
      </ul>

MySQL foundation

<h3><b>LPIC-1 training course description</b></h3>
      <p>   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. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	 <li>Administer &amp; configure Linux systems.</li>
                    <li>Maintain Linux by handling disk space and taking
regular backups.</li>
                    <li>Manage software packages.</li>
                    <li>Perform basic troubleshooting.</li>
                    <li>Maintain a secure Linux system.</li>
                    <li>Describe the organisation and implementation of the
filesystem.</li>
                  </ul>
        <h5>
        <b>LPIC-1 training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>System administrators.<br />
                    Network administrators.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Linux fundamentals (LPI 010)
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>LPIC-1 training course contents</b></h3>
      <ul>
				<li><b>Part I Exam 101 </b></li><p>
</p><li>Exploring Linux Command-Line Tools </li><p>
Using a Shell, Shell Configuration, Environment
Variables, Getting Help, Streams, Redirection and Pipes,
Processing Text Using Filters, Manipulating files,
Regular Expressions, grep,sed.
</p><li>Managing Software </li><p>
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 &amp; Background
Processes, Process Priorities, Killing Processes.
</p><li>Configuring Hardware </li><p>
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.
</p><li>Managing Files </li><p>
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.
</p><li>Booting Linux and Editing Files </li><p>
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.
	</p><li><b>Part II Exam 102 265</b> </li><p>
</p><li>Securing the X Window System </li><p>
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.
</p><li>Administering the System </li><p>
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.
</p><li>Configuring Basic Networking </li><p>
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.
</p><li>Writing Scripts, Configuring Email,
and Using Databases </li><p>
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
</p><li>Securing Your System </li><p>
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.
</p>
      </ul>

Linux system administration (LPIC-1)

<h3><b>UNIX system administration training course description</b></h3>
      <p> 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.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			<li>Administer &amp; configure UNIX systems.</li>
					<li>Maintain UNIX by handling disk space and taking
regular backups.</li>
					<li>Manage software packages.</li>
                    <li>Perform basic troubleshooting.</li>
                    <li>Maintain a secure UNIX system.</li>
                    <li>Describe the organisation and implementation of the
filesystem.</li>                  </ul>
        <h5>
        <b>UNIX system administration training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>System administrators<br /> Network administrators.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>UNIX fundamentals.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>UNIX system administration training course contents</b></h3>
      <ul>
				<li><span>Part 1 </span></li><p>
</p><li>Exploring UNIX command-line tools </li><p>
Using a shell, shell configuration, environment variables, getting help, streams, redirection and pipes, processing text using filters, manipulating files, regular expressions, grep, sed.

			</p><li>Managing software </li><p>
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 &amp; background processes, process priorities, killing processes.

</p><li>Configuring hardware </li><p>
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.

</p><li>Managing files </li><p>
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.

</p><li>	Booting UNIX and editing files </li><p>
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.

</p><li><span>Part 2 </span></li><p>
</p><li>Configuring the X window system </li><p>
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.

</p><li>Administering the system </li><p>
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.

</p><li>Configuring basic networking </li><p>
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.

</p><li>Writing scripts, configuring email, and using databases </li><p>
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.

</p><li>Securing your system 	 </li><p>
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.</p>
      </ul>

UNIX system administration

<h3><b>Advanced Asterisk training course description</b></h3>
      <p> This 2 day hands-on Asterisk training course covers advanced Asterisk configuration including fault tolerant clusters, upgrading and patching Asterisk servers, firewall and NAT transversal, using databases to store Asterisk data. Practical sessions follow each major section to reinforce the theory.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
          <li>Configure advanced Asterisk features.</li>
										   	 <li>Utilise databases from Asterisk</li>
											 <li>Integrate Asterisk with SIP servers.</li>
                    						 <li>Build High Availability Asterisk clusters.</li>
                    						 <li>Maintain and secure Asterisk servers.</li>
                  </ul>
       
        <h5>
        <b>Advanced Asterisk training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with or evaluating Asterisk. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Definitive Asterisk for engineers</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Advanced Asterisk training course contents</b></h3>
      <ul>
				<li>Best Practice</li><p>
Review of basics, Channel best practice, dial plan
best practise.
				</p><li>Call Centre Features</li><p>
GUI, Asterisk Manager Interface, billing, CDR,
advanced IVR, ACD, Vici Dial. <br /><span>Hands on</span> Install
Vici-Dial
</p><li>Asterisk and Databases</li><p>
MySQL, LDAP, ODBC, dial plan from a Database,
storing CDR in a Database, <br /><span>Hands on</span> Dial plan in
MySQL, CDR in MySQL.
</p><li>TDM over Ethernet</li><p>
What is TDMoE, Asterisk to Asterisk TDMoE,
Phone Bridge. <br /><span>Hands on</span> * 2 * via TDMoE.
</p><li>High Availability Asterisk</li><p>
HA Linux - Virtual Servers, Fail-over steps, setting
up HA Linux, configuring Asterisk for fail-over on
HA Linux, <br /><span>Hands on</span> Configure Asterisk HA.
</p><li>Advanced Dial plans</li><p>
Asterisk Gateway Interface, AGI IVR applications,
Multiple switches sharing Dial plans, ENUM,
DUNDI. <br /><span>Hands on</span> Configure DUNDI.
</p><li>Integration</li><p>
Legacy PBX, SIP Proxys, OpenSER. <br /><span>Hands on</span>
Configure SER to work with Asterisk.
</p><li>Asterisk Maintenance</li><p>
Asterisk upgrades, implementing patches,
advanced debugging,
</p><li>Security</li><p>
Firewalls, NAT, Asterisk security issues. <br /><span>Hands on</span> Configure Asterisk to work through a Firewall
and NAT. 
</p>
      </ul>

Advanced Asterisk for Engineers

<h3><b>Total PHP training course description</b></h3>
      <p>   PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                        <li>Create dynamic web sites using PHP.</li>
					<li>Write PHP programs.</li>
                    <li>Debug PHP programs.</li>
                    <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>Total PHP training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone creating dynamic web sites.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Software development fundamentals
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Total PHP training course contents</b></h3>
      <ul>
				<li>What is PHP? </li><p>
PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues.

</p><li>A first PHP web page </li><p>
A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML.

</p><li>PHP forms </li><p>
HTML forms, taking values from forms.

</p><li>PHP and HTML </li><p>
Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript.

</p><li>Variables operators and expressions </li><p>
Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables.

</p><li>Operators </li><p>
Arithmetic, logical, relational, Boolean, others.

</p><li>Control statements </li><p>
Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit.

</p><li>Functions </li><p>
Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name.

</p><li>Arrays </li><p>
Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions.

</p><li>String handling </li><p>
What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs.

</p><li>PHP and databases </li><p>
Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling.

</p><li>File I/O </li><p>
Opening, reading, writing files. Permissions, ownership, locking, directories.

</p><li>PHP, cookies and sessions </li><p> 
State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs.

</p><li>PHP and email </li><p>
Emailing from servers, attachments.

</p><li>Objects </li><p>
OOP, PHP classes, constructors, instances.</p>
			
      </ul>

Total PHP for developers

<h3><b>Samba training course description</b></h3>
      <p>Samba enables UNIX/Linux machines to act as Microsoft File and Print servers. This two day hands on training course progresses from the basics of installing samba and simple configurations through to authentication issues and troubleshooting.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
       <li>Install and configure Samba.</li>
					<li>Administrate file and printer sharing.</li>
					<li>Secure Samba servers.</li>
                    <li>Troubleshoot Samba</li>
                  </ul>
       
        <h5>
        <b>Samba training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with Samba.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p> Intro to UNIX Systems Administration<br />
                    TCP/IP Foundation.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Samba training course contents</b></h3>
      <ul>
				<li>What is Samba?</li><p>
File and print servers, Samba server roles,
Windows networking, NetBIOS, SMB. <br /><span>Hands on</span>
Microsoft File and Print shares, analysing the
network traffic.
</p><li>Installing Samba</li><p>
Source, binaries, where to find samba, building
and compiling Samba. <br /><span>Hands on</span> Download and
install Samba.
</p><li>Controlling Samba</li><p>
Samba daemons, starting and stopping Samba,
smbcontrol, Samba net command, smb.conf.
Viewing Samba status, smbclient. <br /><span>Hands on</span>
Starting and stopping Samba, testing the server.
</p><li>Samba configuration</li><p>
Simple shares, smb.conf variables, configuration
from a web browser, swat, enabling access to
swat. <br /><span>Hands on</span> Configuring samba servers and
clients.
</p><li>File sharing</li><p>
Basic shares, [homes], locking options, UNIX file
permissions, controlling user access, Windows
ACLs, virtual samba servers, browsing. <br /><span>Hands on</span>
File sharing and browsing.
</p><li>Print sharing</li><p>
Sharing printers, UNIX printing, CUPS, printer
drivers, [printers], PRINT$. <br /><span>Hands on</span> Samba print
server.
</p><li>Authentication</li><p>
Workgroups, domains, users and passwords,
Samba domain security, Samba password
backends: smbpasswd, tdbsam, nisplus, mysql,
Active Directory. <br /><span>Hands on</span> Securing samba
shares.
	</p><li>Troubleshooting</li><p>
Logging options, controlling logs, Samba utilities,
network protocols, .SMB/CIFS. Performance
tuning. <br /><span>Hands on</span> Troubleshooting Samba 
</p>
      </ul>

331 Courses delivered Online

Mastering Bash Shell Scripting: Automate your daily tasks [Updated for 2021]

By Packt

Data Analysis with Data Science & Machine Learning

By Apex Learning

Web Development Courses

By Apex Learning

PHP Web Development with MySQL; GitHub & Heroku

By Studyhub UK

Diploma in MySQL and Statistics for Data Analysis Course

By Training Express

Learn MySQL from Scratch for Data Science and Analytics

By Studyhub UK

From Zero to Hero: Level Up Your Career with Coding & SQL Course

By One Education

From Zero to Hero: Level Up Your Career with Coding & SQL Course

By One Education

Data Analyst Training Course

By One Education

Data Analyst Training Course

By One Education