Blog Detail

Learn SQL Easily At Home-totally free course

http://learn-sql-at-home.blogspot.com/

learn sql easily and quickly using related example, totally free course with questions and answers for key part of learning sql

• Added on: Jul 19th, 2009
• Country: Sri Lanka
• Language: English

• Author: piyathissa
• Listed in: Education & Learning Programming
• Tags: learn sql Free total easily

Recent Posts

• SQL Server 2008 : Overview

  Posted on Friday September 18th, 2009 at 13:58 in sql server 2008

  Your Data, Any Place, Any TimeSQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. Store data from structured, semi-structured, and unstructured documents, such as images an...

• SQL Hosting

  Posted on Wednesday August 26th, 2009 at 19:22 in sql hosting

  SQL Hosting is a hosting, which utilizes SQL database. There are many SQL databases used as SQL hosting backend, and the most common are MS SQL Server (2000 or 2005), MySQL, and MS Access. Why SQL Hosting?You may ask what is the difference between a...

• Learn the Modification of the Database

  Posted on Thursday July 30th, 2009 at 07:14

  Deletion- Delete all account records at the Kandy City branch.delete * from accountwhere branch_name = ‘Kandy city’- Delete all accounts at every branch located in Kandy.delete * from accountwhere branch_name in (select branch_namefrom branchwher...

• Learn Aggregate Functions (Group by and Having clause)

  Posted on Sunday July 19th, 2009 at 09:27

  - These functions operate on the multiset of values of a column of a relation, and return a valueavg: average valuemin: minimum valuemax: maximum valuesum: sum of valuescount: number of tuples/values- Find the average account balance at the Kandy cit...

• Learn Joined Relations in SQL

  Posted on Saturday July 18th, 2009 at 23:28

  - Join operations take two relations and return as a result another relation.- These additional operations are typically used as sub queryexpressions in the from clause- Join condition – defines which tuples in the two relations match,and what attr...

• Learn Nested Subqueries and Set Comparison use in SQL

  Posted on Saturday July 18th, 2009 at 22:09

  - SQL provides a mechanism for the nesting of sub queries.- A sub query is a select-from-whereexpression that is nested within another query.- A common use of sub queries is to perform tests for set membership, set comparisons,and set cardinality.Exa...

Comments & Reviews

There is no rating for this blog because there are no comments yet.

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.