dodatni materijal

(prof. dr Zoran Avramović)

Moderators: aleksandar, vladimir, dbojan

dodatni materijal

Postby dbojan » Tue Jun 10, 2014 2:35 pm

pomoc kod kucanja sql upita:
dbForge SQL Complete, v4.6 Express:
stranica: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
link na fajl: http://www.devart.com/dbforge/sql/sqlcomplete/sqlcompletefree.exe


SQL Tutorial (koristi Northwind bazu)
sadrzi:
-Simple SELECTs
-Advanced SELECTs
-Subqueries, Joins and Unions
-Conditional Processing with CASE
-Inserting, Updating and Deleting Records
http://www.learn-sql-tutorial.com/

Northwind sql baza:
http://www.microsoft.com/en-us/download/details.aspx?id=23654


sql tutorial:
insert, create, alter naredbe,
procedure, view:
http://home.hit.no/~hansha/documents/database/documents/Structured%20Query%20Language.pdf


Ostalo:

Microsoft .NET Framework 3.5 Service Pack 1 (nije potrebno za windows 7 i novije sisteme)
http://www.microsoft.com/en-us/download/details.aspx?id=22

SQL Server 2005 Books Online
ako vam trebaju informacije o sql-u, offline
http://www.microsoft.com/en-us/download/details.aspx?id=4152

w3schools sql:
http://www.w3schools.com/SQl/default.asp

sta su agregatne funkcije:
http://msdn.microsoft.com/en-us/library/ms173454.aspx


linkovi sa sajta http://home.hit.no/~hansha/:
http://home.hit.no/~hansha/documents/database/training/sql/Database%20Examples.zip
http://home.hit.no/~hansha/documents/database/sql.htm
http://home.hit.no/~hansha/documents/database/training/Introduction%20to%20Database%20Systems/Code.zip
http://home.hit.no/~hansha/documents/database/Introduction%20to%20Database%20Systems.htm
http://home.hit.no/~hansha/documents/database/training/Introduction%20to%20Database%20Systems/Introduction%20to%20Database%20Systems.pdf
User avatar
dbojan
 
Posts: 383
Joined: Mon Feb 14, 2011 9:01 pm

Return to RDBMS (SQL administracija & CASE alati)

Who is online

Users browsing this forum: No registered users and 1 guest