How to do a Simple Database Project - Revision history

Ed at 16:39, 7 March 2019

2019-03-07T16:39:12Z

Ed at 21:58, 21 March 2017

2017-03-21T21:58:30Z

Ed at 18:54, 20 March 2017

2017-03-20T18:54:21Z

Ed: Created page with "This page assumes that you have read Working_with_the_infrastructure and Working with PostgreSQL. The best way to learn..."

2017-03-20T18:54:03Z

Created page with "This page assumes that you have read Working_with_the_infrastructure and Working with PostgreSQL. The best way to learn..."

New page

This page assumes that you have read [[Help:Helppage#Working_with_the_infrastructure|Working_with_the_infrastructure]] and [[Working with PostgreSQL]].

The best way to learn how to work with a database server, how to code SQL, and how to put together datasets for analysis is to actually do it! This page helps you do that.

==Getting some data together==

You'll need to put together:
*A tab delimited text file of data that contains:
**A header row
**At least one text variable (like name, etc)
**At least one categorical variable (like state, industry, etc.) in text format
**At least one numeric variable (like an amount)

Another tab delimited text file of data that contains:
*A header row
*The same text variable as in the first file
*Some other variable

These files should be of a reasonable size (say at least say 80 records, but not more than say 1,000 records), and drawn from something that you are working on or are going to be working on. You need to put them together before you get any formal instruction!

==Connecting to the server and making a dbase==

See [[Working with PostgreSQL]] to connect to the server and how to make a dbase.

==Making your base tables==

==Building a lookup table==

We are going to create:

A table delimited text file of data that contains:
**A header row
**The same categorical variable as before as text
**A numeric coding of that variable

@@ Line 1: / Line 1: @@
-This page assumes that you have read [[Help:Helppage#Working_with_the_infrastructure|Working with the infrastructure]] and [[Working with PostgreSQL]].
+This page assumes that you have read [[Team Help]] and [[Working with PostgreSQL]].
 The best way to learn how to work with a database server, how to code SQL, and how to put together datasets for analysis is to actually do it! This page helps you do that.
@@ Line 33: / Line 33: @@
 **The same categorical variable as before as text
 **A numeric coding of that variable

← Older revision		Revision as of 21:58, 21 March 2017
Line 33:		Line 33:
	**The same categorical variable as before as text		**The same categorical variable as before as text
	**A numeric coding of that variable		**A numeric coding of that variable
		+	[[Category:McNair Admin]]

← Older revision		Revision as of 18:54, 20 March 2017
Line 1:		Line 1:
−	This page assumes that you have read [[Help:Helppage#Working_with_the_infrastructure\|~~Working_with_the_infrastructure~~]] and [[Working with PostgreSQL]].	+	This page assumes that you have read [[Help:Helppage#Working_with_the_infrastructure\|Working with the infrastructure]] and [[Working with PostgreSQL]].

	The best way to learn how to work with a database server, how to code SQL, and how to put together datasets for analysis is to actually do it! This page helps you do that.		The best way to learn how to work with a database server, how to code SQL, and how to put together datasets for analysis is to actually do it! This page helps you do that.