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

Vishnu Gadipudi
Vishnu Gadipudi
2023-08-20
I Enrolled in VISWA Online Trainings for IBM Integration BUS course . Recently I Completed IBM Integration BUS Batch. It was Really Awesome Experience. Best Place To Learn , Experienced Trainer, Gives Us High Level Knowledge....
Navya Biradavolu
Navya Biradavolu
2023-08-20
I was enrolled for looker Bl Tool,it was amazing experience . especially soft skill batch is one of my favourite batch . overall learning process is quite impressive.
Indla sneha
Indla sneha
2023-08-20
I have joined I have joined VISWA Online TRAININGS for Java full stack course and i have completed Advance Java module. I had a good knowledge of Hibernate, spring,spring boot,spring MVC. Tutor has knowledge in depth and is supportive. Srinadh sir solved all our doubts....
bindu hima
bindu hima
2023-08-20
I am recently completed Talend course and trainer is Rajendra very professional and helpful. All the doubts were solved in a precise manner.
Tarunasree Gowra
Tarunasree Gowra
2023-08-20
"I truly enjoyed this course." Chaitanya sir fantastic-very knowledgeable. Sir give us very informative and clear instruction on how to achieve the goal. Thank you!
Tejaswini Kommu
Tejaswini Kommu
2023-08-20
Overall Linux Admin sessions batch was very good. Mr. RAM Krishna teaching was very helpful to remind our basic concepts in linux & networking.
Gopanaboina Mounika
Gopanaboina Mounika
2023-08-20
It was great learning with such a great and experienced staff. Praveen Sir (Oracle EPM Cloud - FCCS) was very helpful and operations team also very helpful in solving any minor problems students go through process.
Jyothi Gutlapalli
Jyothi Gutlapalli
2023-08-20
I like to share my experience which provide lots of courses and one of those I recently completed my Salesforce BA Course and I like to tell you it was a great experience and my knowledge and confidence is really boosted after completing this course.
Harshibandi
Harshibandi
2023-08-20
Good experience and great learning platform for Hyperion Essbase and Planning. The faculty is also well trained and soft spoken.
Chaitu Viswa
Chaitu Viswa
2023-08-20
It was very good session for QlikView. I would like to thank to teacher Mr.Chandu for providing guidance for the required modules. Thanks VISWA Team for giving apportunity to leran new skills.

Quick Links