Talk:Ben Baldazo (Work Log) - Revision history

BenBaldazo: /* Compustat */

2017-09-25T21:46:57Z

Compustat

BenBaldazo at 21:29, 25 September 2017

2017-09-25T21:29:37Z

BenBaldazo: /* Creating Folders and SQL */

2017-09-12T20:25:59Z

Creating Folders and SQL

BenBaldazo: /* Folders and SQL */

2017-09-12T20:16:08Z

Folders and SQL

BenBaldazo: /* SQL */

2017-09-12T20:11:06Z

SQL

BenBaldazo at 20:10, 12 September 2017

2017-09-12T20:10:23Z

BenBaldazo at 22:45, 5 April 2017

2017-04-05T22:45:32Z

BenBaldazo at 22:45, 5 April 2017

2017-04-05T22:45:09Z

BenBaldazo at 22:44, 5 April 2017

2017-04-05T22:44:35Z

BenBaldazo: Created page with "Proposal for general timeline / overview / structure of projects Regarding SQL database creation: *Create a folder in the Z: Drive that has the same name as the PSQL database..."

2017-04-05T22:44:03Z

Created page with "Proposal for general timeline / overview / structure of projects Regarding SQL database creation: *Create a folder in the Z: Drive that has the same name as the PSQL database..."

New page

Proposal for general timeline / overview / structure of projects

Regarding SQL database creation:
*Create a folder in the Z: Drive that has the same name as the PSQL database
*Create a PSQL database that is all lowercase and has no spaces (the shorter the better)
*Create a ".sql" file named <databasename>.sql and save it in your project folder in the E: Drive in a new folder named <databasename>_SQL
*create a ".txt" file in this SQL folder in the E: Drive named <databasename>SQL_notes.txt
**Every time you create a new table in your database, document it here in the notes file
**This means put "table title : a short description of your table" for each new one you create
**It should look like this:
database name
tables:
<tablename> : Uploaded from text file with data on the VC round amounts into companies
*optional comment on work this table needs or the state it's in

Regarding your database.sql file (etiquette and notation):
*This ".sql" file is where you are going to write and save all of your code (you copy it out of here then paste it into terminal or putty to run it)
*Every time you create a table, precede the command with a "drop table" command with the table you are about to make
**This way you will be able to just copy and paste the entirety of your code into your database should you need to recreate it
*Every time you create a table put "--<# of entries>" in the line under your code so we can keep track of the number of rows in each table within your code file
*anytime you want to comment on a table use "/* comment */" in your .sql file

← Older revision		Revision as of 21:46, 25 September 2017
Line 38:		Line 38:

	==Compustat==		==Compustat==
−	~~[[File~~:~~CompustatBar~~.~~jpg]]~~	+	Website: https://wrds-web.wharton.upenn.edu/wrds/ds/compm/funda/index.cfm?navId=84
		+	*Select search entire database
		+	*Pass: 9Mil2015
		+	*User: mcnair

← Older revision		Revision as of 21:29, 25 September 2017
Line 36:		Line 36:

	/* If you would like to add a comment afterwards, it should be notated like this */		/* If you would like to add a comment afterwards, it should be notated like this */
		+
		+	==Compustat==
		+	[[File:CompustatBar.jpg]]

@@ Line 1: / Line 1: @@
 =Proposal for general timeline / overview / structure / etiquette of projects=
-==Folders and SQL==
+==Creating Folders and SQL==
 ===Regarding Folders and SQL database creation:===
 *Create a folder in the Z: Drive that has the same name as the PSQL database

@@ Line 1: / Line 1: @@
 =Proposal for general timeline / overview / structure / etiquette of projects=
-==SQL==
+==Folders and SQL==
-===Regarding SQL database creation:===
+===Regarding Folders and SQL database creation:===
 *Create a folder in the Z: Drive that has the same name as the PSQL database
 *Create a PSQL database that is all lowercase and has no spaces (the shorter the better) ([[Help:Access RDP Sever]])

@@ Line 1: / Line 1: @@
 =Proposal for general timeline / overview / structure / etiquette of projects=
-==Regarding SQL database creation:==
+==SQL==
 *Create a folder in the Z: Drive that has the same name as the PSQL database
 *Create a PSQL database that is all lowercase and has no spaces (the shorter the better)
@@ Line 14: / Line 15: @@
   *optional comment on work this table needs or the state it's in
-==Regarding your database.sql file (etiquette and notation):==
+===Regarding your database.sql file (etiquette and notation):===
 *This ".sql" file is where you are going to write and save all of your code (you copy it out of here then paste it into terminal or putty to run it)
 *Every time you create a table, precede the command with a "drop table" command with the table you are about to make

@@ Line 5: / Line 5: @@
 *Create a folder in the Z: Drive that has the same name as the PSQL database
 *Create a PSQL database that is all lowercase and has no spaces (the shorter the better) ([[Help:Access RDP Sever]])
-*Create a ".sql" file named <databasename>.sql and save it in your project folder in the E: Drive in a new folder named <databasename>_SQL
+*Create a "'''.sql'''" file named <databasename>.sql and save it in your project folder in the E: Drive in a new folder named <databasename>_SQL
-*create a ".txt" file in this SQL folder in the E: Drive named <databasename>SQL_notes.txt
+*create a "'''.txt'''" file in this SQL folder in the E: Drive named <databasename>SQL_notes.txt
 **Every time you create a new table in your database, document it here in the notes file
 **This means put "table title : a short description of your table" for each new one you create
@@ Line 12: / Line 12: @@
   database name
   tables:
   <tablename> : Uploaded from text file with data on the VC round amounts into companies
   *optional comment on work this table needs or the state it's in
 ===Regarding your database.sql file (etiquette and notation):===
-*This ".sql" file is where you are going to write and save all of your code (you copy it out of here then paste it into terminal or putty to run it)
+*This "'''.sql'''" file is where you are going to write and save all of your code (you copy it out of here then paste it into terminal or putty to run it)
 *Every time you create a table, precede the command with a "drop table" command with the table you are about to make
 **This way you will be able to just copy and paste the entirety of your code into your database should you need to recreate it
 *Every time you create a table put "--<# of entries>" in the line under your code so we can keep track of the number of rows in each table within your code file
 *anytime you want to comment on a table use "/* comment */" in your .sql file

← Older revision		Revision as of 22:45, 5 April 2017
Line 1:		Line 1:
−	=Proposal for general timeline / overview / structure of projects=	+	=Proposal for general timeline / overview / structure / etiquette of projects=

	==Regarding SQL database creation:==		==Regarding SQL database creation:==