Re: Regarding MYSQL Classes to OCMS members in nellore

[Hemanth Reddy]

Hi all,

       yesterday, we had a great session on Mysql. Mr. Dinesh, project manager in HCL technologies, is the guest mentor for this session.

 Though Iam a non-technical one who is in the session, I could easily understand that it is indeed a great session.

 Students interacted with sir with great enthusiasm and are able to get the real time scenario and their queries regarding Mysql. 

He told them in a clear way about different database systems and also how to form the data tables and the significance of information design in relation to the database retrieval. 

Different database system and their strengths, he explained the students. He told them about integrating Mysql to coding languages. He gave some examples and some exercises.

We are very fortunate enough to get exposed to an enthusiastic mentor like Dinesh sir. Infact the session went on for two and half an hour. It started at 11am morning and ended at 1.40 pm afternoon. Sir and students are continuously interactive and knowledge transfer seems active and focussed. Nearly many of the ocms trainees clarified their queries.

Sir also explained few interesting concepts like Dataware housing and Data mining as some students enthusiastic to know about them. He also advised the students what industry does require from them.

Its indeed a great session yesterday and we may also have another session shortly.

After that students discussed the composite team structure and formed different teams with responsibilites on the basis of technologies. Students will send the team members structure shortly.

Yesterday session also, we have invited few students who are doing web designing courses and they also active to join the team. One is Anudeep, third year student in ECM branch in the same college and also two students from the other college, Priyadarshini college of engineering, Nellore, who also active to web learning and already does building their own college website by themselves. It seems they are very much interested and also going to be contributing to OCMS project.

These are the updates about OCMS.

With regards

Hemanth

On Wed, Dec 24, 2008 at 4:07 PM, Pavan Kumar PV <Pavan...@collabera.com> wrote:

Hi Dinesh,

 

Thank you very much for your kind support. Hope your join will gives us huge strength and support to implement this project so that to serve the society in better way.

 

Regards,

Pavan.

---

From: Hemanth Reddy [mailto:doctor...@gmail.com]
Sent: Wednesday, December 24, 2008 3:32 PM

To: hcl_d...@yahoo.com

Cc: sandeep reddy; Pavan Kumar PV

Subject: Re: Regarding MYSQL Classes to OCMS members in nellore

Hi Dinesh sir,

 as you told me, I have arranged a first interactive session tomorrow at 11 am at Aditya college. I have informed all OCMS team members regarding that. When you arrived here and about to start, give me a call, we will come to your chosen place and pick up you to the session place at Aditya College.

Once again thanks for your support to train our students.

With regards

Hemanth 

On Wed, Dec 24, 2008 at 3:21 PM, dinesh koppada <hcl_d...@yahoo.com> wrote:

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

This e-mail contains Privileged and Confidential Information intended solely for the use of the addressee(s). It shall not attach any liability on the sender or Collabera or its affiliates. Any views or opinions presented in this email are solely those of the sender and may not necessarily reflect the opinions of Collabera or its affiliates. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. While Collabera has taken reasonable precautions to minimize this risk, Collabera accepts no liability for any damage that may be caused to you in the event that there is any virus in this e-mail or any attachments attached hereto. It is the addresses(s) duty to check and scan this email and any attachments attached hereto for the presence of viruses prior to opening the email. ** Thank You **