Fwd: Regarding MYSQL Classes to OCMS members in nellore

[Hemanth Reddy]

---------- Forwarded message ----------
From: dinesh koppada <hcl_d...@yahoo.com>
Date: Wed, Dec 24, 2008 at 3:21 PM
Subject: Re: Regarding MYSQL Classes to OCMS members in nellore
To: sandeep reddy <sandeeps...@gmail.com>
Cc: doctor...@gmail.com, Pavan...@collabera.com

Hi Sandeep,   Please find the following topics and exercises on mysql.   MYSql Connectors:( it will connect from various front end applications) http://dev.mysql.com/doc/refman/5.1/en/connectors-apis.html   My SQL Documentation main page http://dev.mysql.com/doc/refman/5.1/en/   DDL: CREATE 1) Create table with the following options   - Primary Key,Foreign Key,NOT NULL & Check constraint   - Column comments ( which describes what is the purpose of that column)   - column with auto increment option ( auto incement means it generetes unique numbers when you insert data into this table) 2) Create a table from an existing table with data. 3) create a table from an existing table without data. ALTER: 1) Create a table with 4 columns. 2) Alter that table and add the following  - new column/columns  - primary Key, Check constraint 3) Alter table to drop  - any column/columns  - Primary Key, Check Constraint 4) Alter table to modify the following  - change the datatype of existing column  - change the width of existing column DROP: 1) Drop table TRUNCATE: 1) Truncate Table DML: SELECT: Select statement with different clauses 1) Where 2) Order by 3) Group by 4) group by with having clause Joins between tables: Inner Join left/right outer join: full outer join: INSERT: 1) Insert data into a table 2) insert data by selecting from a different table UPDATE: 1) Update the column with the same value 2) Update the column based on other column ( update the salary from 500 to 1000 for all employees with designation  'CLERK' ) 3) Update the column by selecting data from different table DELETE: 1) Delete the complete data from a table. 2) delete the data from a table based on some criteria. Functions: IN, LIKE , = , > , < ,<>, BETWEEN, http://dev.mysql.com/doc/refman/5.1/en/func-op-summary-ref.html The above link has all functions with examples. write queries using those functions and get familiar with those http://docs.rinet.ru/mysql/ - another link for functions   Thanks, Dinesh Koppada --- On Wed, 12/24/08, sandeep reddy <sandeeps...@gmail.com> wrote: From: sandeep reddy <sandeeps...@gmail.com> Subject: Regarding MYSQL Classes to OCMS members in nellore To: hcl_d...@yahoo.com Date: Wednesday, December 24, 2008, 1:08 AM Hello Mr Dinesh, We are highly delighted that you agreed to spare some of your valuable time in throwing light on some areas of Mysql. As you have spoken(on phone) to Shika about the topics we require and it seems you asked her to send a mail regarding the topics which we wanted you to cover. Actually we are pretty comfortable with SQL Sir. if you could let us know "Some frequent used functions", How MYSQL will be used in the real time applications(In the sense how it can be interfaced) and little programming in MYSQL then it would be appreciable. Hope to meet you soon. Thanks & regards, Sandeep. OCMS Member