Mentors Inn MYSQL ONLINE TRAINING IN HTDERABAD

MYSQL ONLINE TRAINING IN HTDERABAD

For Details Contact :
Mobile: +91-8897755222
Email: [email protected]
Website : http://mentorsinn.com/

MY SQL COURSE CONTENT
INTRODUCTION TO DATABASES
What is a database?
Tables, fields and records
CHOOSING AND HOSTING A DATABASE APPLICATION
Comparing MySQL with Microsoft Access, Microsoft SQL Server and others
Installing and running your own MySQL server
Hosting your database on the Internet
WORKING WITH MYSQL DATABASES
Using the command line
Using a client application (EMS SQL Manager)
Using a web interface (PHPMyAdmin)
CREATING TABLES
Choosing table types (MyISAM / InnoDB / other)
Choosing data types
Creating indices
CREATING RELATIONAL DATABASES
Understanding relational databases
Normalisation
Creating foreign keys
Planning relational database structure
QUERYING DATA
Introduction to Structured Query Language (SQL)
Writing single table queries using SELECT
Writing multi table queries
Saving queries as views
UPDATING TABLES
Writing SQL statements using INSERT, UPDATE and DELETE
Maintaining referential integrity
INTRODUCTION TO DATABASE ADMINISTRATION
Database security
Backing up database structure and data
WHERE TO GO NEXT - BRIEF INTRODUCTIONS TO
Integrating with PHP
Stored procedures
Full-text indexing and querying