Database Techniques (DV1201)

From FUKTwiki

This is a course that has a lot to do with SQL, so see that article for more information and links about that.

A database is used for data storage, you can use DML and DDL operation on the database. For every database there are stored procedures, functions stored in the user schema.

• Course schedule

[edit] Free database software

• PostgreSQL
  • Direct link to Installer for Windows

[edit] Labs

[edit] Lab 2

• SQL code for use with PostgreSQL

[edit] Lab 3

• SQL code for use with PostgreSQL

[edit] Lab 4

• SQL code for use with PostgreSQL

[edit] Paper

• Paper template files in multiple formats

[edit] Project

• http://www.connectionstrings.com/

[edit] C#

• The “Demo Form” code in source code format
• How to connect to PostgreSQL with C#, from the Mono project
  • Npgsql User Manual
• How to connect to an ODBC defined connection with C#, from the Mono project
• Documentation for the System.Data.SqlClient namespace, from the Mono project
• There is a book about this subject in Wikibooks, the open-content textbooks collection.

[edit] Java

• (Main article)
• PostgreSQL JDBC Driver
• GNU Classpath documentation for java.sql.*

[edit] PHP

• PHP example code
• PHP PostgreSQL Functions
• There is an article about this subject on Wikipedia, the free online encyclopedia.
• There is a book about this subject in Wikibooks, the open-content textbooks collection.

[edit] ASP.NET

• There is a book about this subject in Wikibooks, the open-content textbooks collection.

[edit] External links

• Programming languages bookshelf
• http://www.oracle.com

Exam Feeds
	Atom English · RSS 2.0 English · Atom Svenska · RSS 2.0 Svenska

• This course in the Student’s Portal’s “Guide for students”