WORLD CLASS TRAINING FOR MY SQL @ZEALSOFT WITH PLACEMENT

05/10/2019 Professional & Short Term Course

Price: Free

No image available

Description

“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
Contact: Zeal Siva Shankar
Mobile: 9944974003 Tel: 0452-4210352
Address: 24B/1, Soundarya Towers, 2nd floor, Kuruvikaran salai,
Near Cinipriya Theater, Anna Nagar, Madurai 20.
Email: hr@zealsoft.net, sivasmsc@gmail.com.

More Details

Total Views:13
Reference Id:#1347224
Phone Number:09944974003
Current Rating: /5 0 Vote

Comments

Copyright © 2021 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com