Oracle BPO

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