Manejo de Datos usando Base de datos de codigo abierto(MySQL)

Programa del Curso (20 Horas)

Introduction to MySQL as an Open Source Database 
  • Features of MySQL 
  • Advantages of MySQL over other RDBMS 
  • Compare MySQL with other RDBMS 
  • Advantages of PHP in MySQL 
  • Open source software licenses

Installing and Configuring MySQL 
  • Various distribution options of MySQL 
  • Installation process of MySQL on Microsoft Windows 
  • Installation process of MySQL on Red Hat Enterprise Linux Configuration process of MySQL using Scripts 
  • Initialization of MySQL at startup

Using MySQL 
  • Data types 
  • Different types of data 
  • Creation of a table 
  • Normalization 
  • Forms of normalization
  • Indexes and Referential Integrity

Implementing SQL Queries Using MySQL - I 
  • Commands to view and alter a database 
  • Commands to retrieve data from a table 
  • Commands to modify the table definitions 
  • Cpmands to delete the table definitions

Implementing SQL Queries Using MySQL - II 
  • Use of keys in a table 
  • Modification of tables 
  • ORDER BY command 
  • GROUP BY command

Using Joins 
  • Types of table joins in MySQL 
  • Equi-Join, Inner Join 
  • Outer-Join, Self-Join
  • Multiple SELECT queries in a single SELECT query 
  • UNION clause

Using Basic Functions in MySQL - I 
  • Aggregate functions in MySQL 
  • Mathematical functions in MySQL

Using Basic Functions in MySQL - II 
  • Date functions 
  • String functions 
  • System Information functions

Controlling and Managing MySQL database 
  • User accounts 
  • Privileges 
  • Commands for setting up of restrictions