| User | Post |
|
12:12 pm
July 9, 2005
|
Tempus Fugit
| | |
| posts 16985 | |
|
|
I have yet to be informed of when on Sunday. 
|
Former NYRA President
Life Member (2005-present)
|
|
|
3:01 pm
July 9, 2005
|
nostromo
| | |
| posts 1636 | |
|
|
How about: 7:00 PM central, 8:00 PM eastern ?
I might want to revise what topics I want to cover.
How many people seriously will learn some basic SQL and how to use it on the staff page?
Galen has been learning some, and he is picking it up quickly. I'll probably continue showing him.
Writing a custom query should ideally rarely be needed, however. We need to highly standardize a number of specific forms and reports that staff can quickly download themselves.
I'm gonna start adding some more stuff to the staff page now. A form is needed for managing chapter data. Also I want to add a much more complete table and field name reference.
|
"A fine is a tax for doing something wrong; a tax is a fine for doing something right." – from In Defence of Capitalism, Johan Norberg
"Put bluntly, the problem isn’t adolescents’ underdeveloped brains, but older generations’ underdeveloped ethics …" – Mike Males
|
|
|
3:12 pm
July 9, 2005
|
Superman
| | |
| posts 4119 | |
|
|
svendlarose wrote: Hopefully, someone who goes to this session will pass on that information to my replacement. As of August 1, 2005 at 9:00 AM PDT, I will begin to work exclusively on my new position (Research and Education Director) and will be replaced by a new staffer, an interim, or the National Formation Director (in that order of precedence).
I will not continue to need access to this type of information come that time (as I have been promoted into another office), so I will not be attending the training.
You could have just said that you are not part of this. Better yet, you didn't actually need to say anything….
|
|
|
|
|
1:06 pm
July 11, 2005
|
nostromo
| | |
| posts 1636 | |
|
|
I had the training session wtih Adam and Kelvin. Alex, Keith, and Chris Batchelor have the log, and hopefully they can read it and go through the examples as well. I called it quits after 2 hours, and I think I covered about half of what I wanted to cover. So hopefully we can schedule another 2 hour training session.
|
"A fine is a tax for doing something wrong; a tax is a fine for doing something right." – from In Defence of Capitalism, Johan Norberg
"Put bluntly, the problem isn’t adolescents’ underdeveloped brains, but older generations’ underdeveloped ethics …" – Mike Males
|
|
|
1:09 pm
July 11, 2005
|
Tempus Fugit
| | |
| posts 16985 | |
|
|
|
|
Former NYRA President
Life Member (2005-present)
|
|
|
1:15 pm
July 11, 2005
|
nostromo
| | |
| posts 1636 | |
|
|
Maybe I should make it two more sessions that are two hours…?
Here's the log.
http://www.youthrights.org/training_session.htm
|
"A fine is a tax for doing something wrong; a tax is a fine for doing something right." – from In Defence of Capitalism, Johan Norberg
"Put bluntly, the problem isn’t adolescents’ underdeveloped brains, but older generations’ underdeveloped ethics …" – Mike Males
|
|
|
3:27 am
July 14, 2005
|
nostromo
| | |
| posts 1636 | |
|
|
So…when can we have the next session… ?
|
"A fine is a tax for doing something wrong; a tax is a fine for doing something right." – from In Defence of Capitalism, Johan Norberg
"Put bluntly, the problem isn’t adolescents’ underdeveloped brains, but older generations’ underdeveloped ethics …" – Mike Males
|
|
|
12:37 pm
July 17, 2005
|
nostromo
| | |
| posts 1636 | |
|
|
Well we had the second training session, and I think it was a good success. I had some good students who listened and went through all the examples.
I think I covered basically all the fundamental concepts of the SQL language in two sessions.
Here are the logs for the sessions
Session 1:
1) Fundamentals of Relational Databases
2) SQL basics
– SELECT … FROM … WHERE … clauses.
– Optional ORDER BY and LIMIT clauses.
– SQL criteria and functions
3) Queries with inner table joins and applications
http://www.youthrights.org/training_session.htm
Session 2:
1) Obtaining database information and different MySQL data types
2) More applications of inner table joins, and the limitations of inner table joins.
-Zip code distance searches
3) Left outer joins and applications.
4) Aggregate functions, GROUP BY and HAVING clauses
5) UNION queries
http://www.youthrights.org/training_session2.htm
In session 2, I left everyone with the challenge problem to write a query for obtaining the email addresses for all paid members who have not voted yet. For the purposes of emailing a second reminder email. This query must employ a left outer join and the CURRENT_DATE SQL function.
P.S. Here is an indispensable resource: the MySQL reference manual, searchable with user comments
http://dev.mysql.com/doc/mysql/en/index.html
|
"A fine is a tax for doing something wrong; a tax is a fine for doing something right." – from In Defence of Capitalism, Johan Norberg
"Put bluntly, the problem isn’t adolescents’ underdeveloped brains, but older generations’ underdeveloped ethics …" – Mike Males
|
|
Login 
Register 
Forum
