BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan

BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan (http://bzupages.com/)
-   Introduction to Database (http://bzupages.com/314-introduction-database/)
-   -   Chapter 5- SQL Data Manipulation Book Database systems by Carolyn E. Begg, Thomas Connolly (http://bzupages.com/f314/chapter-5-sql-data-manipulation-book-database-systems-carolyn-e-begg-thomas-connolly-16407/)

.BZU. 13-06-2011 12:23 PM
Chapter 5- SQL Data Manipulation Book Database systems by Carolyn E. Begg, Thomas Connolly
 
1 Attachment(s)
Chapter-5-SQL Data Manipulation Book Database systems Carolyn E. Begg, Thomas Connolly
  • Purpose and importance of SQL.
  • How to retrieve data from database using SELECT and:
  • Use compound WHERE conditions.
  • Sort query results using ORDER BY.
  • Use aggregate functions.
  • Group data using GROUP BY and HAVING.
  • Use subqueries.
  • Join tables together.
  • Perform set operations (UNION, INTERSECT, EXCEPT).
  • How to update database using INSERT, UPDATE, and DELETE.


All times are GMT +5. The time now is 06:04 AM.

Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.