- Details
- Hits: 12650
Some time ago I liked to play Little Big Adventure (LBA und LBA2) on DOS: It's a nice and amusing game. Recently I detected both CDs in my shelf and thought it would be great to play these games again.
Read more: How to play Little Big Adventure (LBA und LBA2) on Linux and Windows7
- Details
- Hits: 14553
SQL is not very easy to learn, in particular joins of multiiple tables are difficult to understand at a first glance. On the next pages it's explained for sql beginners how SQL joins work. Venn diagrams are used to explain how the tables are combined. In addition sample tables with sample data and sample joins are used to explain in detail the query input data results. SQL files to create the sample data and execute the queries can be downloaded. The samples are for mySQL and DB2.
If you want to see more complex sql joins in action visit Learning SQL by example for sql join examples and other SQL funktions as views, count, max, subselect and other.
 |
 |
 |
 |
 |
- Details
- Hits: 9610
I collected on the following pages various SQL queries and their results on a sample database. They use different SQL functions and will help to learn and understand SQL queries. In addition they help for look up most commonSQL syntax examples. A SQL beginner will get a good overview about the capabilities of SQL. Examples are given for select, count, union, where, having, order, limit, views, NULL, like, subselects and joins.
- Details
- Hits: 11012
To learn to use threading in Python you have to have a concrete problem to solve. Just use Raspberry Pi to connet 6 LEDs and manage them via GIO. On the following pages I describe how to customize my sample program to simulate tarffic lights. You also find a video which shows the program in action and a download link for the sample program.
Read more: Raspberry PI Trafficlight Sample Program written in Python with Threading