- Details
- Hits: 14273
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: 10476
If you have a Linux LAN server in your home network to provide printing and storage services you also can use this server to offer different operting systems to your clients with a PXE boot serevr. This can be liveCD images which can be started and used immediately or installation images so your clients can upgrade to the next distro release easily. Rescue live CDs are also useful if there are any client issues.
- Details
- Hits: 775
I recently enable IPv6 in my home network. Familiar with IPv4 I detected there are new commands I have to use and also commands I used with IPv4 have to get additional options for IPv6. The following list is just a collection of tools I think are useful for whoever starts to use IPv6.
- Details
- Hits: 32218
Read more: How to find out which Linux distribution a script runs on