Mysql Online Training in htderabad

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

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

"The Oracle BPO training was nice, helped me a lot thanks for your support and training." - K.H.Rao (Oracle PL-SQL)