|
ZealSoft Technology Solutions
Madurai-ISO 9001:2015
Zealsoft Technology Solutions (ZTS) PVT LTD, the leading IT solution company is known for it’s pioneering work in the field of IT education, training, consulting, web and multimedia. Our strong research orientation has helped us continuously innovate and implement cutting-edge technology.
TRAINING:
Training is to bring you out from the theoretical to the practical mode with the actual content. Get hand on training and experience with top level industrial technologies with guide of well-experienced IT Professionals. We ZealSoft are a great team of well- experienced developers, who have the thirst to keep learning more from experiences. We would like to teach the same to our students. The training is completely in friendly manner and won’t be like your everyday classroom sessions. You are also given the freedom to choose your training hours with the approval from our professionals, because we are more concerned with the comfort level of our students.
“Come join with Zeal and sculpt a bright future for you.”
MYSQL
Introduction to MYSQL
• What is Database?
• Understanding an RDBMS
• Understanding Tables,
• Record & Fields SQL Language
Working with MYSQL Admin
• Working with PHP MyAdmin
• Types Data Type
• Creating Database & Tables
• Dropping Database & Tables
• Adding Fields
• Selecting Table
• Alerting Fields Properties
MySQL Function in PHP
• Database Connections
• Managing Database
• Connections Performing Queries
• Closing Connection
SQL Queries
• Create Database& Table
• Drop Database& Table
• Insert Record
• Select Record
• Deleting Record
• Modifying Record
• WHERE Clause
• Using Operators
• Sorting Records
• Eliminating Duplicates
• Grouping Records, Having Clause
• Joining Tables
• Sub queries
• Using Table And Column Aliases
Backup and Restore
• Hot Backup with MySQL Enterprise Backup
• Backups with mysqldump
• Backups by copying Table files
• Delimited-Text File Backups
• Incremental Backups
• Replication based backups
• Recovering Corrupted Tables
• Sending Email
|
