Hi, I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot. So, does anyone still have their DB cursus ( with exercises )? Any gene related DBscheme or query questions are greatly appreciated. Kenny -- ================================================================== Kenny Billiau Web Developer Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM kenny.billiau@psb.ugent.be http://bioinformatics.psb.ugent.be ==================================================================
Apparently, databases at hogent is now thought by our beloved Joris Moreau from Computer Graphics ;) Check out the inwe wiki: http://wiki.inwe.be/index.php?title=Gegevensbanken Those are some pretty hilevel and stupifying queries. There are insane questions like: Give me a query which determines the date of the last 50 easters. No db needed or provided. The formula is: j = jaar - 1900 a = MOD(jaar - 1900, 19) b = FLOOR(( 7 * a + 1 ) / 19) c = MOD(11 * a + 4 - b, 29) d = 25 - c - MOD(j + FLOOR(j / 4) + 31 - c, 7) ;) (I know, in the end this ain't that hard, but still, this is not as easy as a squirrel homing in on a nut) -Kenny On Mon, 22 Sep 2008, Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
--
Why the hell would you want to use SQL for that question though? Kenny Billiau wrote:
Apparently, databases at hogent is now thought by our beloved Joris Moreau from Computer Graphics ;)
Check out the inwe wiki: http://wiki.inwe.be/index.php?title=Gegevensbanken
Those are some pretty hilevel and stupifying queries.
There are insane questions like: Give me a query which determines the date of the last 50 easters. No db needed or provided. The formula is: j = jaar - 1900 a = MOD(jaar - 1900, 19) b = FLOOR(( 7 * a + 1 ) / 19) c = MOD(11 * a + 4 - b, 29) d = 25 - c - MOD(j + FLOOR(j / 4) + 31 - c, 7)
;) (I know, in the end this ain't that hard, but still, this is not as easy as a squirrel homing in on a nut)
-Kenny
On Mon, 22 Sep 2008, Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
-- ================================================================== Sofie Van Landeghem PhD Student VIB Department of Plant Systems Biology, Ghent University Bioinformatics and Evolutionary Genomics Technologiepark 927, 9052 Gent, BELGIUM Tel: +32 (0)9 331 36 95 fax:+32 (0)9 3313809 Website: http://bioinformatics.psb.ugent.be ==================================================================
Because we can! :p No other reason than that. Why would we write a char-skipping program in haskell, python, java and x86-assembly? Because we can! Sofie Van Landeghem wrote:
Why the hell would you want to use SQL for that question though?
Kenny Billiau wrote:
Apparently, databases at hogent is now thought by our beloved Joris Moreau from Computer Graphics ;)
Check out the inwe wiki: http://wiki.inwe.be/index.php?title=Gegevensbanken
Those are some pretty hilevel and stupifying queries.
There are insane questions like: Give me a query which determines the date of the last 50 easters. No db needed or provided. The formula is: j = jaar - 1900 a = MOD(jaar - 1900, 19) b = FLOOR(( 7 * a + 1 ) / 19) c = MOD(11 * a + 4 - b, 29) d = 25 - c - MOD(j + FLOOR(j / 4) + 31 - c, 7)
;) (I know, in the end this ain't that hard, but still, this is not as easy as a squirrel homing in on a nut)
-Kenny
On Mon, 22 Sep 2008, Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
-- ================================================================== Michiel Van Bel PhD student Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809 VIB Department of Plant Systems Biology, Ghent University Technologiepark 927, 9052 Gent, BELGIUM mibel@psb.ugent.be http://www.psb.ugent.be ==================================================================
But maybe for once, Excell really was the right solution (I did not just say that!) Michiel Van Bel wrote:
Because we can! :p No other reason than that. Why would we write a char-skipping program in haskell, python, java and x86-assembly? Because we can!
Sofie Van Landeghem wrote:
Why the hell would you want to use SQL for that question though?
Kenny Billiau wrote:
Apparently, databases at hogent is now thought by our beloved Joris Moreau from Computer Graphics ;)
Check out the inwe wiki: http://wiki.inwe.be/index.php?title=Gegevensbanken
Those are some pretty hilevel and stupifying queries.
There are insane questions like: Give me a query which determines the date of the last 50 easters. No db needed or provided. The formula is: j = jaar - 1900 a = MOD(jaar - 1900, 19) b = FLOOR(( 7 * a + 1 ) / 19) c = MOD(11 * a + 4 - b, 29) d = 25 - c - MOD(j + FLOOR(j / 4) + 31 - c, 7)
;) (I know, in the end this ain't that hard, but still, this is not as easy as a squirrel homing in on a nut)
-Kenny
On Mon, 22 Sep 2008, Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
-- ================================================================== Sofie Van Landeghem PhD Student VIB Department of Plant Systems Biology, Ghent University Bioinformatics and Evolutionary Genomics Technologiepark 927, 9052 Gent, BELGIUM Tel: +32 (0)9 331 36 95 fax:+32 (0)9 3313809 Website: http://bioinformatics.psb.ugent.be ==================================================================
It seems to be somewhat complex. At least four algorithms seem to exist to do this very important task of calculating when we have holidays. http://en.wikipedia.org/wiki/Computus Sofie Van Landeghem wrote:
But maybe for once, Excell really was the right solution (I did not just say that!)
Michiel Van Bel wrote:
Because we can! :p No other reason than that. Why would we write a char-skipping program in haskell, python, java and x86-assembly? Because we can!
Sofie Van Landeghem wrote:
Why the hell would you want to use SQL for that question though?
Kenny Billiau wrote:
Apparently, databases at hogent is now thought by our beloved Joris Moreau from Computer Graphics ;)
Check out the inwe wiki: http://wiki.inwe.be/index.php?title=Gegevensbanken
Those are some pretty hilevel and stupifying queries.
There are insane questions like: Give me a query which determines the date of the last 50 easters. No db needed or provided. The formula is: j = jaar - 1900 a = MOD(jaar - 1900, 19) b = FLOOR(( 7 * a + 1 ) / 19) c = MOD(11 * a + 4 - b, 29) d = 25 - c - MOD(j + FLOOR(j / 4) + 31 - c, 7)
;) (I know, in the end this ain't that hard, but still, this is not as easy as a squirrel homing in on a nut)
-Kenny
On Mon, 22 Sep 2008, Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
ow .. I think we have new signature for the list ;) On Mon, 22 Sep 2008, Sofie Van Landeghem wrote:
But maybe for once, Excell really was the right solution (I did not just say that!)
Michiel Van Bel wrote:
Because we can! :p No other reason than that. Why would we write a char-skipping program in haskell, python, java and x86-assembly? Because we can!
Sofie Van Landeghem wrote:
Why the hell would you want to use SQL for that question though?
Kenny Billiau wrote:
Apparently, databases at hogent is now thought by our beloved Joris Moreau from Computer Graphics ;)
Check out the inwe wiki: http://wiki.inwe.be/index.php?title=Gegevensbanken
Those are some pretty hilevel and stupifying queries.
There are insane questions like: Give me a query which determines the date of the last 50 easters. No db needed or provided. The formula is: j = jaar - 1900 a = MOD(jaar - 1900, 19) b = FLOOR(( 7 * a + 1 ) / 19) c = MOD(11 * a + 4 - b, 29) d = 25 - c - MOD(j + FLOOR(j / 4) + 31 - c, 7)
;) (I know, in the end this ain't that hard, but still, this is not as easy as a squirrel homing in on a nut)
-Kenny
For when is this, by the way? Stephen has MySQL exercises, which finish in 6 weeks (so he should have the solution by then...) Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
-- ================================================================== Sofie Van Landeghem PhD Student VIB Department of Plant Systems Biology, Ghent University Bioinformatics and Evolutionary Genomics Technologiepark 927, 9052 Gent, BELGIUM Tel: +32 (0)9 331 36 95 fax:+32 (0)9 3313809 Website: http://bioinformatics.psb.ugent.be ==================================================================
Hi, these are the dates: Main course (wednesdays 11h30 - 12h45) 24/09 01/10 08/10 15/10 22/10 29/10 5/11 12/11 19/11 26/11 3/12 10/12 Two practcal sessions (thursdays) 9/10 14h-17h 16/10 14h-17h but as Eric doesn't really have a lot of theory to give, and I'm actually giving the explanation about the SQL syntax, I'm guessing the first exercises will be on 1/10. But, I've got those covered :) I'm just worried that in the end, people will not have made enough execises (as this is all about experience, the idea of the course is not the make them fullfledged DBAs ;)). So all extra excercises are welcome, even if they come in late :) -Kenny On Tue, 23 Sep 2008, Sofie Van Landeghem wrote:
For when is this, by the way? Stephen has MySQL exercises, which finish in 6 weeks (so he should have the solution by then...)
Kenny Billiau wrote:
Hi,
I have to teach 40hours of SQL and I'm looking for excercises. Apparently I was so smart to save all my answers when I as in college, but the questions I forgot.
So, does anyone still have their DB cursus ( with exercises )?
Any gene related DBscheme or query questions are greatly appreciated.
Kenny
--
participants (4)
-
Kenny Billiau -
Michiel Van Bel -
Sofie Van Landeghem -
Thomas Abeel