Report the ad
Mentors inn mysql online training in htderabad - Hyderabad
Saturday, 26 April, 2014Item details
City:
Hyderabad, Andhra Pradesh
Offer type:
Offer
Item description
MYSQL ONLINE TRAINING IN HTDERABAD
For Details Contact :
Mobile: +91-8897755222
Email: trainings@mentorsinn.com
Website : httpmentorsinn.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
For Details Contact :
Mobile: +91-8897755222
Email: trainings@mentorsinn.com
Website : httpmentorsinn.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