Well over a decade ago, a book came out simply titled MySQL by Paul DuBois. Everyone I know learned about MySQL from this book.
I guess I mentioned in the past that I liked this book and ever since I get requests for the code from the book. I guess it isn’t available online anymore?
So, here I gather together all of the code in one place. So, I can just point people to it from now on 🙂
I’ve been asked to make a Java JTable tutorial by many people. Today I’ll show you how to display database query results from my Sabermetrics Tutorial into a Java JTable.
I then cover most everything about Java JTables. How to display data into a JTable. How to change fonts in a JTable. How to change row height in a JTable. How to sort a JTable. How to align a JTable column and much more.
All of the code follows the tutorial and it has even more tricks.
Previously I made a couple of Baseball Sabermetrics videos and it was a lot of fun. In this Sabermetrics tutorial I’ll cover a few of the Sabermetrics formulas I missed.
One question I received from a few of you was which team uses Sabermetrics most effectively. You’ll find that answer in the first query below named TTRC for Teams.
I also show how to perform many Sabermetric Pitching formulas below.
I continue covering some neat Sabermetrics formulas in this video. If you missed part 1 of my Sabermetrics Tutorial, check it out first.
I’m going to cover a few new complicated formulas including: Theoretical Team Runs Created, Batting Average on Balls in Play, Weighted On Base Average and more. I’m also going to show you how to easily save queries using views.
This tutorial has been a great deal of fun. All formulas follow the video.
Here I continue my Sabermetrics Baseball tutorial. If you missed part one, check it out first because in it I show you how to get all of your tools. It is here Sabermetrics.
I’m going to introduce a few new SQL functions being CONCAT, COALESCE and HAVING.
We will also calculate the top players based on RBIs, HRs, Batting Average, On Base Percentage, and Slugging Percentage. And, I’ll show you how to pull in data on the players position and their salary.
In this article I introduce you to the world of Sabermetrics. Sabermetrics is the analysis of baseball statistics to measure player performance, in game probabilities and much more.
With Sabermetrics you’ll be able to do most anything from decide who was the greatest hitter of all time to analyze the probability that your team will win.
But, to get started with Sabermetrics, you need to first get your tools being MySQL and a Baseball Stat Database. Both are free! More info follows the video below.
One of you guys asked me to do a tutorial on Fixing Java Errors. I thought it was a good idea, so here I’ll show you over 30 common Java errors.
Sometimes it is hard to figure out what Cannot be Resolved, Syntax Error on Token, or Method is not Visible mean. But, after watching this video you should better understand.
Also, you’ll learn how to get Eclipse to help you fix Java errors.
A while back I made a tutorial on how to make thin crust pizza. I have worked on this Homemade Pizza Recipe for years and am happy to share it.
Based on comments though, I decided to remake it. Now I make everything 100% by hand. I also show you how to work with a wet dough, knead dough, add tons of toppings and much more.
You’ll learn a great deal about baking in this one tutorial. I hope you like it 🙂
In this part of the Java Video Tutorial I show you how to setup Java JDBC in Eclipse.
I then cover how to connect to a MySQL database, query it and get the results of a query. We also look at the Exceptions you’ll need and much more.
I will cover SQL in this tutorial, but not to the extent that I did in the past. My SQL tutorials can be found after the video.
Here I continue covering everything about Java. Today I completely cover reading and writing Java Binary Streams.
I cover everything you need to know including DataOutputStream, FileOutputStream, BufferedOutputStream, all of the reading and writing primitive type methods and more.
All of the code follows the video. It is heavily commented.
In this part of my Java Video Tutorial, I completely cover how to both write to and read character streams from files.
I explain all of the following: PrintWriter, BufferedWriter, FileWriter, BufferedReader, FileReader, common file exceptions and much more.
All of the code follows the video. It is heavily commented and will help you build your Java code repository while helping you to learn Java better.
In this part of the Java Video Tutorial, I completely cover the Java File Class.
I’ll show you how to create and delete files and directories. How to pull lists of files from directories and manipulate them. We’ll look at the errors to watch out for and a whole bunch more.
All of the code follows the video and should be used to help you understand this topic better.