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.
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 MYSQL database
✔ Understand the role of MYSQL in the Industry
✔ Different versions of MY SQL
✔ Understanding Relational Database Management systems
✔ Comparing MYSQL with other relational databases
✔ What is a module
✔ Interaction of core modules
✔ 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
✔ 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
✔ The Error Log
✔ The General Query Log
✔ The Binary Log
✔ The Slow Query Log
✔ Key Buffer
✔ Buffer Cache
✔ Mysql Query Cache
✔ 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
✔ General guidelines for maintaining security
✔ Password security
✔ Privileges provided by MY SQL DBA
✔ Adding user accounts
✔ Specifying connection for users to databases in MYSQL
✔ Setting account resource limits
✔ Assigning account passwords
✔ 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
✔ 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
✔ 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|
|Live Recorded Videos Access|
|Study Material Provided|
My SQL DBA Training - Upcoming Batches
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
Complete set of live-online training sessions recorded videos.
Learn technology at your own pace.
Get access for lifetime.
Learn As A Full Day Schedule With Discussions, Exercises,
Practical Use Cases
Design Your Own Syllabus Based
My SQL DBA Training FAQ'S
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
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.
Choose from, where, group by, and order by.
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.
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.