The example you give isn't too useful: it doesn't need to include a subquery because it just selects everything from it anyway.
Subqueries are useful when you want to extract specific data, and then use it to match other data together: for example in a WHERE clause.
Suppose you have a table of employees, and you want to find all the employees in your department whose salary is higher than yours - you use a subquery.
First you write a query to return your salary:
SELECT Salary FROM Employees
WHERE EmpName = 'Proqramlaşdırma Dünyası'
That returns a single value - your salary.
You can then use that as a subquery to find the info you want:
SELECT * FROM Employees
WHERE Salary > (SELECT Salary FROM Employees
WHERE EmpName = 'Proqramlaşdırma Dünyası')
AND Department = 'Software'
Make sense?