My SQL DBA Certification Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  25 Days

About Course

The most well-known open-source SQL database administration system is My SQL, which Oracle Corporation created, distributes, and supports. My SQL was initially released by the My SQL organization and was later purchased by SUN MICROSYSTEMS. Relational database management system (RDBMS) My SQL was made available under the terms of the GNU General Public Licence (GPL). One of the most popular open-source database systems, it may be utilized with a wide range of website applications. Enrol today to earn your certification.

My SQL DBA Training Course Syllabus

Introduction to MY SQL

✔ Introduction to MYSQL database
✔ Understand the role of MYSQL in the Industry
✔ Different versions of MY SQL

MY SQL DBA Architecture

✔ Understanding Relational Database Management systems
✔ Comparing MYSQL with other relational databases
✔ What is a module
✔ Interaction of core modules

Types of Engines In MY SQL DBA

✔ Introduction to the storage engine
✔ Types of storage engines:

✔ MyISAM Engine
✔ MERGE Engine
✔ FEDERATED Engine
✔ ISAM Engine
✔ BERKLEYDB Engine
✔ InnoDB Engine
✔ And many other types of engines are available

Installing MY SQL DBA

✔ Understanding MYSQL open-source license
✔ Install MYSQL on Linux Platform
✔ Tarball installation-linux generic
✔ Different RPMs required to Install MYSQL
✔ Troubleshoot common installation issues
✔ Learn how to use MYSQL command

Logs In My SQL DBA

✔ The Error Log
✔ The General Query Log
✔ The Binary Log
✔ The Slow Query Log

Types of Buffers In MYSQL

✔ Key Buffer
✔ Buffer Cache
✔ Mysql Query Cache

MYSQL Administration

✔ Introduction to MySQL
✔ Using system variables
✔ Connection to MySQL database
✔ Creating database in MYSQL
✔ Creation of tables and load data
✔ Different data types available in MYSQL

Security In MYSQL

✔ General guidelines for maintaining security
✔ Password security
✔ Privileges provided by MY SQL DBA

User Administration

✔ Adding user accounts
✔ Specifying connection for users to databases in MYSQL
✔ Setting account resource limits
✔ Assigning account passwords

Backup and Recovery

✔ Physical versus Logical Backups
✔ Online Versus Offline Backups
✔ Local versus Remote Backups
✔ Full versus Incremental Backups
✔ Different backup methods
✔ Using mysqlhotcopy, mysqldump, mysqlimport methods
✔ Myisam table Maintenance
✔ To check MyISAM tables for errors
✔ Repair MyISAM tables

Locking In MYSQL

✔ MYSQL table locking
✔ MYSQL row locking
✔ Compare table and row locking
✔ Advantages and disadvantages of locking
✔ Replication in Mysql
✔ Master to slave replication
✔ Master to salve to salve replication
✔ Master master replication
✔ Troubleshooting replication
✔ Replication methods

Performance Tuning in My SQL DBA

✔ Discussing the different area of performance problems
✔ Operating system, application, database instance, queries performance
✔ Instance tuning
✔ Using top commands and checking users’ information

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

My SQL DBA Training - Upcoming Batches

7th NOV 2022

8 AM IST

Weekday

Coming Soon

AM IST

Weekday

5th NOV 2022

8 AM IST

Weekend

Coming Soon

AM IST

Weekend

Don't find suitable time ?

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

My SQL DBA Training FAQ'S

What is the default port for MySQL server?

The default port for MySQL Server is 3306. Aside from this, the SQL Server’s TCP/IP default standard port number is 1433.

Get ahead in your career by learning My SQL DBA through VISWA Online Trainings

Can you tell what are the different set operations available in MySQL?

The various set operations available in MySQL are as follows:

  • UNION – This operation returns all the distinct rows selected by a query
  • UNION ALL – This operation returns all the rows selected by a query and also includes all duplicate rows.
  • MINUS – This operation returns all the distinct rows selected by the first query but does not select the rows selected by the second query.
Can you tell the order of SQL SELECT statement?

Choose from, where, group by, and order by.

What is Database White Box Testing?

The tables, data model, schema, and referential integrity guidelines are all covered by the database white box testing. Triggers, logical views with database consistency, and ACID features are also covered.

What is Database Black Box Testing?

Data mapping, data storing, and data retrieval are all covered by database black box testing. Techniques like Equivalence Partitioning and Boundary Value Analysis use Database Black Box Testing.

Reviews

Quick Links