|
Hardware
Requirements :- |
-
Intel-based
PC
Workstation
(Windows XP,
NT or 2000)
with minimum
Intel
Pentium III
processor.
(Pentium IV
1.8 GHZ or
higher
recommended).
-
512
MB RAM
minimum
recommended.
-
20
GB disk
space.
(Disk
space can be
reduced if
optional
features and
run-time
environments
are not
installed).
-
800
x 600
minimum
display
resolution(1024
x 768
recommended)
|
|
Software
Requirements :- |
|
>
MySQL 5.0
>
One of the
following
operating
systems:
>
Windows XP
Professional
with Service
Pack 2
>
Windows 2000
Professional
with Service
Pack 3 or higher
>
Windows NT
Workstation or
Server Version
4.0 with Service
Pack 5 or higher |
|
Objectives
:- |
|
Upon
completion of the course,
participants will be able to:
-
Understand
the concepts of relational
databases.
-
Understand to
create, update & delete
tables, databases.
|
|
Description
:- |
|
This
course provides a foundation for
professionals in SQL language. |
|
Prerequisites
:- |
|
Basic
programming background is required. A general
understanding of databases would be helpful. |
|
Outlines
:- |
|
|
|
Introduction
to MySQL :- |
Database
Design with MySQL
An overview of RDBMS
Types of Relationships
Normalization |
| |
|
|
SQL-I
:- |
CREATE
DATABASE Statement
USE Database Statement
CREATE TABLE Statement
Column Types
ALTER TABLE Statement
SHOW Table Statement
SHOW Columns Statement
DESCRIBE Statement
INSERT Statement
UPDATE Statement
DELETE Statement
DROP DATABASE Statement
DROP TABLE Statement
CREATE INDEX Statement |
|
|
|
|
SQL-II
:- |
SELECT
Statement
WHERE Clause
ORDER BY
LIMIT
GROUP BY
HAVING
GROUP Functions |
| |
|
|
SQL-III
:- |
Joins
:
Equi join
Non-equi join
Outer join
Self join
Functions
and operators
Introduction
to stored procedures
Triggers
and views
|
|
|
|
