UrbanPro
true
D V J Ramanjaneyulu MySQL Development trainer in Hyderabad

D V J Ramanjaneyulu

MySQL DBA Trainer

JNTU, Kukatpally, Hyderabad, India - 500085.

1 Student

Referral Discount: Get ₹ 500 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of D V J Ramanjaneyulu

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

->10+ Years of IT experience MYSQL DBA/ Developer
->Data Center design, Capacity Planning, Disaster Recovery setup
->MySQL Database Server Configuration on Cloud Hosting
->Highly proficient with current technologies including: MYSQL,ORACLE,MS SQL Server 2008 and MS SQL Server 2005
->Extensive experience in performing administrative functions including backup and recovery, database security, indexing and physical/logical modeling
->Extensive experience in SQL to write Stored Procedures and Triggers programming and writing queries.
->Extensive experience in Database Architecture, Design, Performance tuning and optimization, data integrity and statistics.
->Extensive experience in performing administrative functions including backup and recovery, database security, indexing and physical/logical modeling.
->Extensive experience working with MySQL Tools
Automating the backup process with email intimation
Outstanding communication and interpersonal capabilities.
->Energetic self-starter and motivating team player; thrives in independent and collaborative work environments.
->Proficient at setting priorities and meeting goals.

Languages Spoken

English

Hindi

Telugu

Address

JNTU, Kukatpally, Hyderabad, India - 500085

Verified Info

Education Verified

Phone Verified

Email Verified

Facebook Verified

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Teaches

MySQL Development Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL Development Training

10

MySQL Certification Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL Certification Training

10

MySQL Consultant Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL Consultant Training

10

MySQL DBA Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL DBA Training

10

Teaching Experience in detail in MySQL DBA Training

Having 10 years of exp as a MySQL DBA and trained more than 20 individual candidates and 5 corporate consultancies.

Reviews

No Reviews yet! Be the first one to Review

FAQs

1. Which classes do you teach?

I teach MySQL, MySQL Certification, MySQL Consultant, MySQL DBA and MySQL Development Classes.

2. Do you provide a demo class?

Yes, I provide a free demo class.

3. How many years of experience do you have?

I have been teaching for 10 years.

Answers by D V J Ramanjaneyulu (3)

Answered on 07/09/2016 Learn IT Courses/MySQL/MySQL Development

you chosen wrong group for your question
Answers 2 Comments
Dislike Bookmark

Answered on 26/08/2016 Learn IT Courses/RDBMS

Third Normal form (3NF) A table design is said to be in 3NF if both the following conditions hold: Table must be in 2NF Transitive functional dependency of non-prime attribute on any super key should be removed. An attribute that is not part of any candidate key is known as non-prime attribute. In... ...more
Third Normal form (3NF) A table design is said to be in 3NF if both the following conditions hold: Table must be in 2NF Transitive functional dependency of non-prime attribute on any super key should be removed. An attribute that is not part of any candidate key is known as non-prime attribute. In other words 3NF can be explained like this: A table is in 3NF if it is in 2NF and for each functional dependency X-> Y at least one of the following conditions hold: X is a super key of table Y is a prime attribute of table An attribute that is a part of one of the candidate keys is known as prime attribute. Example: Suppose a company wants to store the complete address of each employee, they create a table named employee_details that looks like this: emp_id emp_name emp_zip emp_state emp_city emp_district 1001 John 282005 UP Agra Dayal Bagh 1002 Ajeet 222008 TN Chennai M-City 1006 Lora 282007 TN Chennai Urrapakkam 1101 Lilly 292008 UK Pauri Bhagwan 1201 Steve 222999 MP Gwalior Ratan Super keys: {emp_id}, {emp_id, emp_name}, {emp_id, emp_name, emp_zip}…so on Candidate Keys: {emp_id} Non-prime attributes: all attributes except emp_id are non-prime as they are not part of any candidate keys. Here, emp_state, emp_city & emp_district dependent on emp_zip. And, emp_zip is dependent on emp_id that makes non-prime attributes (emp_state, emp_city & emp_district) transitively dependent on super key (emp_id). This violates the rule of 3NF. To make this table complies with 3NF we have to break the table into two tables to remove the transitive dependency: employee table: emp_id emp_name emp_zip 1001 John 282005 1002 Ajeet 222008 1006 Lora 282007 1101 Lilly 292008 1201 Steve 222999 employee_zip table: emp_zip emp_state emp_city emp_district 282005 UP Agra Dayal Bagh 222008 TN Chennai M-City 282007 TN Chennai Urrapakkam 292008 UK Pauri Bhagwan 222999 MP Gwalior Ratan Boyce Codd normal form (BCNF) It is an advance version of 3NF that’s why it is also referred as 3.5NF. BCNF is stricter than 3NF. A table complies with BCNF if it is in 3NF and for every functional dependency X->Y, X should be the super key of the table. Example: Suppose there is a company wherein employees work in more than one department. They store the data like this: emp_id emp_nationality emp_dept dept_type dept_no_of_emp 1001 Austrian Production and planning D001 200 1001 Austrian stores D001 250 1002 American design and technical support D134 100 1002 American Purchasing department D134 600 Functional dependencies in the table above: emp_id -> emp_nationality emp_dept -> {dept_type, dept_no_of_emp} Candidate key: {emp_id, emp_dept} The table is not in BCNF as neither emp_id nor emp_dept alone are keys. To make the table comply with BCNF we can break the table in three tables like this: emp_nationality table: emp_id emp_nationality 1001 Austrian 1002 American emp_dept table: emp_dept dept_type dept_no_of_emp Production and planning D001 200 stores D001 250 design and technical support D134 100 Purchasing department D134 600 emp_dept_mapping table: emp_id emp_dept 1001 Production and planning 1001 stores 1002 design and technical support 1002 Purchasing department Functional dependencies: emp_id -> emp_nationality emp_dept -> {dept_type, dept_no_of_emp} Candidate keys: For first table: emp_id For second table: emp_dept For third table: {emp_id, emp_dept} This is now in BCNF as in both the functional dependencies left side part is a key.
Answers 18 Comments
Dislike Bookmark

Answered on 26/08/2016 Learn IT Courses/RDBMS +1 IT Courses/MySQL/MySQL Certification

Hi Hemanth, You can follow the below youtube link to learn mysql quickly https://www.youtube.com/watch?v=mdGKgasqKCs&list=PLyTQS5V4iATQTdd8DqI5-NQ3HYUOMYtZE and for quick learn through MySQL documentation from dev.mysql.com webpage
Answers 1 Comments
Dislike Bookmark

Teaches

MySQL Development Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL Development Training

10

MySQL Certification Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL Certification Training

10

MySQL Consultant Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL Consultant Training

10

MySQL DBA Training
1 Student

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MySQL DBA Training

10

Teaching Experience in detail in MySQL DBA Training

Having 10 years of exp as a MySQL DBA and trained more than 20 individual candidates and 5 corporate consultancies.

No Reviews yet! Be the first one to Review

Answers by D V J Ramanjaneyulu (3)

Answered on 07/09/2016 Learn IT Courses/MySQL/MySQL Development

you chosen wrong group for your question
Answers 2 Comments
Dislike Bookmark

Answered on 26/08/2016 Learn IT Courses/RDBMS

Third Normal form (3NF) A table design is said to be in 3NF if both the following conditions hold: Table must be in 2NF Transitive functional dependency of non-prime attribute on any super key should be removed. An attribute that is not part of any candidate key is known as non-prime attribute. In... ...more
Third Normal form (3NF) A table design is said to be in 3NF if both the following conditions hold: Table must be in 2NF Transitive functional dependency of non-prime attribute on any super key should be removed. An attribute that is not part of any candidate key is known as non-prime attribute. In other words 3NF can be explained like this: A table is in 3NF if it is in 2NF and for each functional dependency X-> Y at least one of the following conditions hold: X is a super key of table Y is a prime attribute of table An attribute that is a part of one of the candidate keys is known as prime attribute. Example: Suppose a company wants to store the complete address of each employee, they create a table named employee_details that looks like this: emp_id emp_name emp_zip emp_state emp_city emp_district 1001 John 282005 UP Agra Dayal Bagh 1002 Ajeet 222008 TN Chennai M-City 1006 Lora 282007 TN Chennai Urrapakkam 1101 Lilly 292008 UK Pauri Bhagwan 1201 Steve 222999 MP Gwalior Ratan Super keys: {emp_id}, {emp_id, emp_name}, {emp_id, emp_name, emp_zip}…so on Candidate Keys: {emp_id} Non-prime attributes: all attributes except emp_id are non-prime as they are not part of any candidate keys. Here, emp_state, emp_city & emp_district dependent on emp_zip. And, emp_zip is dependent on emp_id that makes non-prime attributes (emp_state, emp_city & emp_district) transitively dependent on super key (emp_id). This violates the rule of 3NF. To make this table complies with 3NF we have to break the table into two tables to remove the transitive dependency: employee table: emp_id emp_name emp_zip 1001 John 282005 1002 Ajeet 222008 1006 Lora 282007 1101 Lilly 292008 1201 Steve 222999 employee_zip table: emp_zip emp_state emp_city emp_district 282005 UP Agra Dayal Bagh 222008 TN Chennai M-City 282007 TN Chennai Urrapakkam 292008 UK Pauri Bhagwan 222999 MP Gwalior Ratan Boyce Codd normal form (BCNF) It is an advance version of 3NF that’s why it is also referred as 3.5NF. BCNF is stricter than 3NF. A table complies with BCNF if it is in 3NF and for every functional dependency X->Y, X should be the super key of the table. Example: Suppose there is a company wherein employees work in more than one department. They store the data like this: emp_id emp_nationality emp_dept dept_type dept_no_of_emp 1001 Austrian Production and planning D001 200 1001 Austrian stores D001 250 1002 American design and technical support D134 100 1002 American Purchasing department D134 600 Functional dependencies in the table above: emp_id -> emp_nationality emp_dept -> {dept_type, dept_no_of_emp} Candidate key: {emp_id, emp_dept} The table is not in BCNF as neither emp_id nor emp_dept alone are keys. To make the table comply with BCNF we can break the table in three tables like this: emp_nationality table: emp_id emp_nationality 1001 Austrian 1002 American emp_dept table: emp_dept dept_type dept_no_of_emp Production and planning D001 200 stores D001 250 design and technical support D134 100 Purchasing department D134 600 emp_dept_mapping table: emp_id emp_dept 1001 Production and planning 1001 stores 1002 design and technical support 1002 Purchasing department Functional dependencies: emp_id -> emp_nationality emp_dept -> {dept_type, dept_no_of_emp} Candidate keys: For first table: emp_id For second table: emp_dept For third table: {emp_id, emp_dept} This is now in BCNF as in both the functional dependencies left side part is a key.
Answers 18 Comments
Dislike Bookmark

Answered on 26/08/2016 Learn IT Courses/RDBMS +1 IT Courses/MySQL/MySQL Certification

Hi Hemanth, You can follow the below youtube link to learn mysql quickly https://www.youtube.com/watch?v=mdGKgasqKCs&list=PLyTQS5V4iATQTdd8DqI5-NQ3HYUOMYtZE and for quick learn through MySQL documentation from dev.mysql.com webpage
Answers 1 Comments
Dislike Bookmark

D V J Ramanjaneyulu describes himself as MySQL DBA Trainer. He conducts classes in MySQL, MySQL Certification and MySQL Consultant. D V J is located in JNTU, Kukatpally, Hyderabad. D V J takes at students Home, Regular Classes- at his Home and Online Classes- via online medium. He has 10 years of teaching experience . He is well versed in English, Hindi and Telugu.

X

Share this Profile

Recommended Profiles

Pradeep Kumar K

Pradeep Kumar K photo Gandhipuram, Coimbatore

Raj Kumar D

Raj Kumar D photo Navalur, Chennai

Milind Srivastava

Milind Srivastava photo Thane West, Mumbai

Raja Reddy

Raja Reddy photo Malleshpalya, Bangalore

Vinay Kumar Jaiswal

Vinay Kumar Jaiswal photo Vasundhara, Delhi

Sudhir Gadipathi

Sudhir Gadipathi photo Perungudi, Chennai

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more