Find the best tutors and institutes for MySQL

Find Best MySQL Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Search for topics

MySQL Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 21/09/2017 IT Courses/Website Scripting IT Courses/Programming Languages/PHP /Advanced PHP IT Courses/jQuery +2 IT Courses/CSS IT Courses/MySQL less

Handbook of websites for Website Developers/Designers (software professionals)

B V Krishna Pernamitta

6 years exp in website development. 100% practical classes no boring theory. Attend course and...

Know the trending languages(past & present) and their comparision with other languages: @ https://www.tiobe.com/tiobe-index/ Found an interesting website? identify the technologies used to build website by crome/firefox extension @ https://wappalyzer.com/download Wanna develop out standing website?... read more
  1. Know the trending languages(past & present) and their comparision with other languages: @ https://www.tiobe.com/tiobe-index/
  2. Found an interesting website? identify the technologies used to build website by crome/firefox extension @ https://wappalyzer.com/download
  3. Wanna develop out standing website? Need an inspiration? Study code & have fun: @ https://codepen.io/pens/
  4. Stuck with bug for days? Get some help @ https://stackoverflow.com/questions/tagged/php
  5. Need Infotainment? Chat with fellow programmers @ https://chat.stackoverflow.com/
  6. Know software concepts @ https://softwareengineering.stackexchange.com/
  7. Compare abilities & limitations of different languages @ https://codegolf.stackexchange.com/
  8. Know the best practices by code sharing @ https://codereview.stackexchange.com/
  9. Know different ways to achive similar objectvies by studying code @ https://github.com/showcases & https://sourceforge.net/
  10. Know how much does a technology worth, how much you are earning in comparision to your peers with different experiences, different locations, different companies @ https://www.payscale.com/wizards/choose.aspx
read less
Comments
Dislike Bookmark

Lesson Posted on 07/07/2017 IT Courses/SQL Programming IT Courses/MS SQL IT Courses/MS Office Software Training/MS Access +2 IT Courses/MySQL IT Courses/Programming Languages/PHP /Php MySQL less

SQL Tips (4 to 6)

Umasankar N.

Software Professional Trainer and Consultant with 24+ years of software design & development experience...

SQL tips 4:Avoid INDEX, unless you need to retrieve information quickly. Index will slower insert and update data query.The another way is using sub querySelect MAX(salary)FROM employeeWHERE salary IN(Select top 2 salary from employee where salary is not null order by salary desc)==============================================SQL... read more

SQL tips 4:
Avoid INDEX, unless you need to retrieve information quickly. Index will slower insert and update data query.

The another way is using sub query

Select MAX(salary)
FROM employee
WHERE salary IN
(Select top 2 salary from employee where salary is not null order by salary desc)

==============================================
SQL tips 5:
NULL and ZLS (zero length string) both are different.

NULL means data is unknown or missing.

NULL should be checked with IS NULL or IS NOT NULL only. Comparison operator equal to (=) or not equal to (<>) should not be used.

ZLS should be checked with two single quotes  ('') together.                        

==============================================
SQL tips 6:
Always use primary key with integer field and unique key with string or text field.

This is not rule, it is best practice.

read less
Comments
Dislike Bookmark

Lesson Posted on 07/07/2017 IT Courses/MS SQL IT Courses/SQL Programming IT Courses/MySQL +1 IT Courses/Programming Languages/PHP /Php MySQL less

Truncate, Drop And Delete Commands In SQL

Umasankar N.

Software Professional Trainer and Consultant with 24+ years of software design & development experience...

Truncate: Truncate command will delete the Table data only, it keeps the table schema as it is. Table data Can be rollback Example : TRUNCATE TABLE User; Drop: Drop command will delete both Table data table schema. Table data Can be rollback Example : DROP TABLE User; Delete: Delete... read more

Truncate:

  • Truncate command will delete the Table data only, it keeps the table schema as it is.
  • Table data Can be rollback
  • Example : TRUNCATE TABLE User;

Drop:

  • Drop command will delete both Table data table schema.
  • Table data Can be rollback
  • Example : DROP TABLE User;

Delete:

  • Delete command will delete the particular row based on the criteria in Where clause. If where clause is not mention in the squre, it will delete entire data, that is equalent to Truncate command action.
  • Once delete the data, data can not be rollback. Make sure to include where clause in the delete query.
  • Example : DELETE FROM User WHERE userid = 5;

Note: This concept will work only for MS SQL. It may be different or reverse in oracle sql and MySQL

read less
Comments
Dislike Bookmark

Looking for MySQL Training

Find best MySQL Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 15/06/2017 IT Courses/SQL Programming IT Courses/MS Office Software Training/MS Access IT Courses/MySQL +2 IT Courses/Programming Languages/PHP IT Courses/Programming Languages/PHP /Php MySQL less

SQL Tips (1 to 3)

Umasankar N.

Software Professional Trainer and Consultant with 24+ years of software design & development experience...

SQL tip 1: Instead of Full Outer Join, you can use Union All. Difference is, Full Outer Join provides results side by side. Union All provides result s one by one. Note: MYSQL does not support Full Join. SQL tip 2: To get column name of a table use following sql query Select... read more

SQL tip 1:

  • Instead of Full Outer Join, you can use Union All.
  • Difference is, Full Outer Join provides results side by side.
  • Union All provides result s one by one.
  • Note: MYSQL does not support Full Join.                

SQL tip 2:

  • To get column name of a table use following sql query
  • Select column_name from information_schema.columns
  • Where table_name = 'student'
  • Here 'student' is name of your table. It must be single quoted
  • If you want to complete information about table then use following queries.
  • Select * from information_schema.columns
  • Where table_name = 'student'

SQL tip 3:

  • Avoid Order By clause unless you need result in ascending or descending order.
  • It will be slower your query execution.                        

 

read less
Comments
Dislike Bookmark

Lesson Posted on 15/06/2017 IT Courses/MS SQL IT Courses/SQL Programming IT Courses/MS Office Software Training/MS Access +2 IT Courses/MySQL Php MySQL training less

DBMS (Database Management System) Vs RDBMS ( Relational Database Management System)

Umasankar N.

Software Professional Trainer and Consultant with 24+ years of software design & development experience...

DBMS RDBMS Stored data in a file Stored data in a table As it is stored in a file, there is no relationship concept Data in one table may be relationship with data in another table and vice versa Support only single user Support multiple users Normalization process will... read more
DBMS RDBMS
Stored data in a file Stored data in a table
As it is stored in a file, there is no relationship concept Data in one table may be relationship with data in another table and vice versa
Support only single user Support multiple users
Normalization process will not be present Normalization process will be present to check the database table consistency
Treats data as file Treats data as table
Work with low configuration software and hardware Work with high configuration software and hardware
Example : Foxpro MS SQL, MySQL, Oracle

 

read less
Comments
Dislike Bookmark

Lesson Posted on 15/06/2017 IT Courses/SQL Programming Php MySQL training IT Courses/MySQL +1 IT Courses/MS Office Software Training/MS Access less

Database Normalization

Umasankar N.

Software Professional Trainer and Consultant with 24+ years of software design & development experience...

Database Normalization is the process of reducing duplication in database by decomposing the table1. Normal Form (1NF): Every attribute is atomic, Each cell to be single valued No multivalued attribute: Example subject ( C, C++ ) No composite attribute: Example Address (392, XYZ street, Bangalore,... read more

Database Normalization is the process of reducing duplication in database by decomposing the table

1. Normal Form (1NF):

  • Every attribute is atomic, Each cell to be single valued
  • No multivalued attribute: Example subject  ( C, C++ )
  • No composite attribute: Example Address (392, XYZ street, Bangalore, 560001).  
  • Entries in a column are same type
  • Rows must be uniquely identified using UNIQUE ID or Add more column to make unique

2. Normal Form (2NF):
Table must not contain redundancy(Unnecessary repeating information).

3. Normal Form (3NF):
All fields can be determined only by Key in the table and not other column.

3.5. Normal Form - Boyce Codd Normal Form (BCNF):
Even when a database is in 3rd Normal Form, still there would be anomalies resulted if it has more than one Candidate Key. Table should not have multiple candidate key. Database should be only one primary key

4. 4NF (Fourth Normal Form):
Table instance contains two or more, independent and multivalued dependencies on Primary key

5. 5NF (Fifth Normal Form):
Table cannot be decomposed into any number of smaller tables without loss of data

read less
Comments
Dislike Bookmark

Looking for MySQL Training

Find best MySQL Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 14/06/2017 IT Courses/MS SQL IT Courses/SQL Programming IT Courses/MS Office Software Training/MS Access +2 IT Courses/MySQL Php MySQL training less

Primary Key VS Unique Key In Database.

Umasankar N.

Software Professional Trainer and Consultant with 24+ years of software design & development experience...

PRIMARY KEY UNIQUE KEY Primary key is a set of one or more fields/columns of a table that uniquely identify a record in database table. Primary keys must contain unique values. Unique-key is to prevent duplicate values in a column. prevents two records from having identical values in a column. There... read more
PRIMARY KEY UNIQUE KEY
Primary key is a set of one or more fields/columns of a table that uniquely identify a record in database table. Primary keys must contain unique values. Unique-key is to prevent duplicate values in a column. prevents two records from having identical values in a column.
There will be only one PRIMARY KEY per table. There may be more that one UNIQUE KEY per table.
Should not have a NULL value. Can have a NULL value.
Unique key identifier of the record. May not be unique.
By default, creates clustered index. Creates non-clustered index.
Values can’t change or delete. Values can change or delete.
Can be made into a foreign key into another table. Can not be made into a foreign key into another table.

 

read less
Comments
Dislike Bookmark

Lesson Posted on 31/10/2016 IT Courses/MySQL/MySQL Development IT Courses/Programming Languages/PHP Php MySQL training +3 IT Courses/jQuery IT Courses/HTML IT Courses/CSS less

How to be a good developer?

Bichitrananda Malik

I think practice more and read less.see what the logic in the programs then you must be a good developer
Comments
Dislike Bookmark

Lesson Posted on 30/10/2016 IT Courses/MySQL/MySQL DBA

More Opportunities in IT industry

K C Reddy

RealTimeTraining - Oracle DBA, MySQL DBA, Linux Admin, MS SQL DBA, DB2 DBA. I have ten yrs Real Time...

Learn any DBA and good package. Bcoz many openings in IT on DBA side.
Comments
Dislike Bookmark

Looking for MySQL Training

Find best MySQL Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 28/10/2016 IT Courses/MySQL

How to learn and practice

K C Reddy

RealTimeTraining - Oracle DBA, MySQL DBA, Linux Admin, MS SQL DBA, DB2 DBA. I have ten yrs Real Time...

Once you are learning, Do practice daily many time. Other wise there is a chance to forget what u laern.
Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best MySQL Training in India. Post Your Requirement today and get connected.

Overview

Lessons 15

Total Shares  

+ Follow 4,982 Followers

Top Contributors

Connect with Expert Tutors & Institutes for MySQL

x

Ask a Question

Please enter your Question

Please select a Tag

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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