JDEdwards

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