UdemyMySQL

MySQL High Performance Tuning Guide

التصنيف الكامل: IT & Software > Other IT & Software > MySQL

MySQL High Performance Tuning Guide

عن هذا الكورس

MySQL Performance Tuning Online Course Curriculum:MySQL ArchitectureView the steps involved in Query Execution How the Cient/Server Protocol affects MySQLUnderstand how the Query Optimizer does its jobHow the Storage Engine Layer makes MySQL uniqueFinding Candidates for Query OptimizationsMaking use of The Performance Schema, which is a gold mine for spotting querying for optimization because it allows us to measure where the time goesFinding the few queries that are responsible for most of the load on the system. Checking to the top 1000 queries it’s usually not worth your time to optimize.How to find the relevant information out of the plethora of performance views and metrics available in MySQLUnderstand why UPDATE and DELETE statements are also reads even though they are primarily write statements. This will have an impact on I/O, and therefore to the response time.Analyzing the QueriesUnderstand why MySQL creates a query plan, before each query requestHow to read query plans, and understand how each of the underlying node types works on MySQLA series of examples, to show how the EXPLAIN output can be used, to identify where MySQL spends time on your query, and whyWhich are the important pieces of information, to look for in order to spot performance issuesThe Clustered Index and Choosing the Primary KeyWhen we work with index-organized tables, as the ones in MySQL, the choice of the primary index, is very important.We'll see how the primary key, can impact the amount of random, or sequential I/O, the size of secondary inde

تعلم أونلاين 100%

شاهد الدروس في أي وقت ومن أي مكان

محتوى معتمد

مقدم من منصة Udemy

رابط موثوق ومباشر

ينقلك لصفحة التسجيل الرسمية

سعر الكورس
$59.99
المنصة:Udemy
الانتقال للكورس / التسجيل الآن
🔒 عند النقر، سيتم فتح صفحة الكورس الرسمية على منصة Udemy في نافذة جديدة.

كورسات مقترحة في نفس المجال

عرض كل الكورسات ←
Linux+ XK0-004 Certification Prep: Realistic Practice Tests
Udemy
CompTIA Linux+

Linux+ XK0-004 Certification Prep: Realistic Practice Tests

The Linux+ XK0-004 Certification Prep: Realistic Practice Tests course is an intensive, hands-on training program designed to help you prepare for the CompTIA Linux+ XK0-004 certification exam. Whether you are an aspiring Linux administrator or an experienced professional looking to validate your Linux skills, this course provides the tools you need to succeed.Through a series of carefully curated practice tests that mirror the actual certification exam format, this course covers all the key domains tested in the Linux+ certification. These include system architecture, Linux installation, package management, GNU and Unix commands, device management, Linux file systems, and security. The practice tests are designed to simulate real-world scenarios, allowing you to interact with Linux systems in ways that closely resemble tasks you'll face on the exam.In addition to the multiple-choice questions, the course includes performance-based tasks to ensure that you can apply your theoretical knowledge to real-world environments. This blended approach helps you build both practical skills and exam-taking strategies, ensuring you are well-prepared for both the technical challenges and the time constraints of the exam.Throughout the course, you'll receive feedback and detailed explanations for each question, allowing you to identify areas where you may need further study and improvement. The realistic nature of the practice exams will help you become more familiar with the content, boost your confidence, and enhance your problem-solving abilities under pressure.Key features of the course:Comprehensive Coverage: Focuses on all key objectives of the Linux+ XK0-004 exam.Realistic Practice Tests: Includes multiple-choice and performance-based questions, closely simulating the real exam experience.Detailed Explanations: Clear, in-depth feedback for each practice test question to reinforce learn

Mastering Apache Web Server and NGINX
Udemy
Apache Web Server

Mastering Apache Web Server and NGINX

IntroductionWelcome to the "Mastering Apache Web Server and NGINX" course! This comprehensive course is designed to take you from a beginner to an advanced user in web server management. Throughout this course, you will gain hands-on experience with Apache Web Server and NGINX, two of the most popular and powerful web servers used in the industry today.The course is divided into four sections, each focusing on different aspects of web server management and application development. Starting with the basics of Apache Web Server, you will learn how to set up and configure your server, create dynamic web pages with PHP, and manage user directories and permissions. You will also dive into advanced topics such as virtual hosting, log management, and using .htaccess files for configuration.In the later sections, you will explore NGINX, learning how to manage this powerful web server and compare it with Apache. The course includes real-world projects that will help you apply your knowledge and develop practical skills. By the end of this course, you will be well-equipped to manage and configure web servers for professional web development tasks.Section 1: Learning Apache Web Server with a ProjectIn this section, students will embark on a hands-on project to learn the fundamentals of the Apache Web Server using the XAMPP server. Starting with an introduction to the project, students will set up and configure their environment. They will then dive into creating a structured website, learning how to build and customize various components, including headers, footers, and multiple pages such as the index, about, services, and contact pages. By the end of this section, students will have a fully functional website and a solid understanding of Apache Web Server basics.Section 2: Apache Web Server Management and NGINXThis section transitions from basic Apache Web Server usage to advanced management techniques and introduces NGI

NestJS Unleashed: Develop Robust and Maintainable Backends
Udemy
NestJS

NestJS Unleashed: Develop Robust and Maintainable Backends

Welcome to NestJS Unleashed! In this section, I will explain the problem this course aims to address, its purpose, and finally its structure.ProblemNode.js is a backend JavaScript runtime environment that gained high popularity in recent years, and one of the reasons for it is because it allows for using the same programming language (JavaScript) for both frontend and backend development, amongst others. Even then, if used by itself, it is a quite "crude" environment for development as you are responsible for:Libraries configurationCode architectureRoutingAmong other thingsTo develop robust systems, in a professional fashion, it may not be so interesting to write code in pure Node.js. Many times, you may find yourself "reinventing the wheel" when there are already established and refined solutions, and it may become increasingly harder to maintain the system over time. In summary, this is the problem that this course aims to solve.PurposeThe main intention of this course is to show how to harness most of the potential of the NestJS framework, which arose quickly in recent years. We'll do so while focusing on elegant architectural solutions, while learning everything in an intuitive and pleasing manner.Here, all the lessons will be taught using a completely practical approach, and we will study theory only when necessary to solve problems that arise during our journey. The course is also incremental, meaning that we will start developing our backend system from scratch and improve it with more functionalities and upgrades along the course.An important note, the approach to the architecture and code design used here is akin to a proposal. There is no completely perfect and flawless way of deve

Power BI Essential Training
Udemy
Microsoft Power BI

Power BI Essential Training

Knowledge is Power. Learn how to use it.We all are surrounded by data and data is everywhere, but problem is to handle chaotic data to turn into the reports to take business decisions.WHAT IS POWER BIPower BI is a collection of software services that work together to turn your unrelated sources of data into interactive insights.Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.BIG DATA IS EVERYWHEREThe term “big data” has been around since the 1990s, yet the explosion of data in the past few years has driven home its relevance and importance. The world is already generating an estimated 2.5 exabytes of data every day. That’s expected to rise to 463 exabytes daily by 2025.Learn Microsoft Power BI (Business Intelligence) which creates useful report quickly and let you improve your Data Analysis techniques. There are many programs you can use to prepare reports and analyze data, but Power BI is the leader in market of business intelligence and easy to acquire the necessary skills. WHY USE POWER BIStarts from Free and then minimal upfront cotsBig Data connectivity, live query connectionAutomation of tasks and create reports onceView Power BI reports across multiple platforms and devicesConsolidate multiple data sources through Power BIDrag-and-drop functionalityQuick sharing of DashboardsDrill-down functionalityNatural Query LanguageGrowing Power BI online communityWHAT YOU WILL LEARN

SAP Fiori- Learn MM in SAP Fiori from Scratch
Udemy
SAP Fiori

SAP Fiori- Learn MM in SAP Fiori from Scratch

This course is designed on the concept of SAP Fiori by SAP S/4 HANA system. SAP Fiori is evolving rapidly in the market and companies are using its applications for their business tasks. To comprehend the need of SAP Fiori, I want to create a course which will be based on SAP Fiori application. This course will benefit any person who wants to learn Material Management in SAP Fiori launchpad instead of SAP GUI. Besides this, it will also cover the customization, personalization, integration and formation of groups in tiles and links.If you want to become a SAP MM Consultant or an End User in SAP MM than this course will help you to work in any SAP based firm as it will cover all aspects of MM. By the end of this course, you will be confident enough to apply your knowledge in the real world.As this course is only based on SAP Fiori, so it will not cover SAP GUI. This will only teach you SAP MM transactions and how to work with Fiori apps particularly transactional apps. Moreover, it has a plus point as in near future, companies will start moving towards mobile computing and they will hire employees who have knowledge of using SAP Fiori apps for procurement process on their mobile devices instead of using company computers to post small business transactions.In SAP MM, I will teach you how to maintain business partner by creating vendor in the SAP Fiori, create material, purchase requisition, RFQs, different types of purchase orders, service master data, manage stock, create goods receipt, transfer posting, create supplier invoice, post outgoing payments and many other concepts. Throughout the whole course, my intention is to clear your concepts about each term and if I missed anything as MM is a vast field, you can highlight that, and I will try my best to update you with information.*Disclaimer*SAP is a registered trademark of SAP AG in Germany and many other countries. Neither Udemy nor I am authorized to provide SAP Access. SAP Fiori Launchpad URL access can be provided to y

JCL - Job Control Language [ Mainframe ]
Udemy
Job Control Language (JCL)

JCL - Job Control Language [ Mainframe ]

Course Topics with DescriptionsIntroduction to JCLLearn what JCL (Job Control Language) is and why it's essential in mainframe environments. Understand its role in submitting and managing jobs.JCL StatementsOverview of different JCL statements and their structure. Learn how they control job execution flow.JOB StatementDetailed explanation of the JOB statement and its key parameters. Understand how it defines a job to the operating system.EXEC StatementLearn how to execute programs using the EXEC statement. Understand its syntax and common parameters.DD StatementExplore the Data Definition (DD) statement used to define datasets. Learn how to allocate files and pass data to programs.Writing JCL Programs and Fixing ErrorsStep-by-step guidance on writing complete JCL programs. Understand how to debug and fix common JCL errors.JCL UtilitiesIntroduction to commonly used JCL utilities. Understand how to perform file operations like copy, delete, and more.IEFBR14, IEBGENER, IEBCOPY UtilitiesDemos on how to use system utilities like IEFBR14, IEBGENER, and IEBCOPY. Learn their real-time use cases.SORT / DFSORT Utility (Basic to Advanced)Learn to sort and manipulate data using DFSORT. Start from basic sorting and move to advanced features.ICETOOL Utility (Basic to Advanced)Understand ICETOOL's powerful data processing capabilities. Learn with practical demos from basic to complex tasks.JCL Procedures – Instream and CatalogedLearn how to reuse JCL code using procedures. Understand the difference between instream and cataloged procedures.Procedure Parameters – Symbolic and Override