Database Testing Training

About Database Testing

Database / Data validation testing is the process of checking database to ensure that the information stored is clean, accurate and in standard format. It covers data integrity, data accessing, query retrieving, modifications, updating and deletion etc. There can be multiple input sources for Database testing

  • User interface / UI
  • Any sample XML or .Csv File
  • DCL Stream etc.

Who should attend this course?

Structured Query Language forms the cornerstone of all relational database operations. This course is beneficial for all those who develop database related applications and who test them. It can also be beneficial for Data Analyst and BIs as well. It provides a solid foundation of the SQL programming language that enables you to build, query and manipulate databases. You compare the ANSI/ISO standard with the SQL implementations of both Oracle and SQL Server databases.

TrainingJoiningBenefits

  • Weekend Batch
  • $149
  • 2Hrs Per Day
  • Saturday & Sunday
  • Weekday Batch
  • $149
  • 2Hrs Per Day
  • 3 Days per Week
  • Fast Track
  • $149
  • 6Hrs Per Day
  • 2 Days per Week

About Trainer:

  • A result oriented professional with over 15+ years of experience in full lifecycle of Database Administration including requirement gathering from the business, studying the existing process, involvement of technical & functional aspects & design specification.
  • Expertize in MySQL Server along with good working knowledge of Amazon RDS, MS-SQL, Oracle 11i/12c & MongoDB.
  • Proven expertise in space management, database security, auditing, logical & physical database design, Backup & Recovery.
  • Skilled in extending high-end technical support to Database Internals and Architecture and ensuring high customer satisfaction levels through prompt redressal of the problems.
  • An effective communicator with sound planning, analytical & interpersonal.
  • Performance Optimization using explain plan for MySQL, Innodb Monitors, Performance Schema.
  • Backup & recovery optimization using tools like mysqldump, MEB, Import/Export/Data Pump, Amazon RDS Snapshots.
  • Partitioning, Data modelling, OLAP, Logical and Physical Database Design, SQL, PL/SQL.
  • IT Infrastructure Design including Database, Storage, Operating Systems and Amazon Cloud RDS.
  • Leading & managing project teams throughout the project lifecycle and providing them support & guidance on technical and project-related issues.