Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Monday... 13-11-2017
Search Course Here




Live Chat
Support
MySQL Admin Online Training

MySQL Admin

overview

MySQL is the world's second most widely used open-source relational database management system (RDBMS).It is named after co-founder Michael Widenius's daughter, My. The SQL phrase stands for Structured Query Language.The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack . LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured database management system often use MySQL.
prerequisties
  • All attendees should be experienced systems administrators with general relational database and SQL experience.
Duration
Online
  • It is a 16 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 4 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Starting, Stopping and Configuring MySQL
  • Security-Related Configuration
  • MySQL Database Creation
  • Using Client Programs for MySQL DBA Work
  • Setting up Character Set Support
  • Locking
  • Using Storage Engines, including the MyISAM and InnoDB engines
  • Table Maintenance
  • Obtaining Data from the Information_Schema Database
  • Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport
  • Using Stored Procedures and Triggers for Database Administration Tasks
  • User Management
  • Securing the Server
  • Upgrade-Related Security Issues
  • Optimizing Queries
  • Optimizing Schemas
  • Optimizing the Server
  • The Event Scheduler
  • Partitioned Tables
  • Interpreting Error Messages
  • Optimizing the MySQL Environment
  • Scaling MySQL, including Replication
  • MySQL Workbench and MySQL Administrator
Videos

MySQL Admin Videos will be updated soon
To watch more Videos Click Here

Flash News


AngularJS New Batch Starting From 14th NOV & 15th NOV.


Hadoop Dev New Batch Starting From 15th NOV & 16th NOV.


IBM COGNOS TM New Batch Starting From 16th NOV & 17th NOV.


Informatica Dev New Batch Starting From 17th NOV & 18th NOV.


Mean Stack New Batch Starting From 18th NOV & 19th NOV.

SAP BODS new Batch Starting From 19th NOV & 20th NOV.

SAP S/4 HANA New Batch Starting From 20th NOV & 21st NOV
.

Tableau New Batch Starting From 21st NOV & 22nd NOV

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30 P.M EST / 08:30 P.M CST / 6:30 P.M PST on 13th NOV & 07:00 A.M IST on 14th NOV

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings