Switching from SQLPro Studio to Valentina Studio

I am in no way an SQL guru. My Select statements are cringeworthy to those who know what they're doing. To that end, I went searching for a tool to help diagram a database so I could better understand the data. What I walked away with, and what has become my SQL editor of choice, is Valentina Studio. Turns out diagramming is one small part of what Valentina Studio can do. It's a full featured SQL IDE loaded with features that can all be used for free. It connects to MS SQL, Postgres and MySql. It has a wonderful UI presentation that makes it easy to see the results of your query. It features tabs, syntax formatting, easy navigation and a host of information about the query and the database itself. Previously, I had been using SQLPro Studio, which was a decent IDE I purchased from Bundlehunt. It worked, it got the job done, and I have no regrets. However, […]

Udemy courses in Java and SQL

Over the past two years I have taken a lot of really good training courses at Udemy. It's a great way to get instructor led training on a wide variety of technology topics. From that, there are two courses that rise to the top because they are very well done and provide a wealth of information to the QA engineer. The first is a programming course. Since Java is the language of automation, I highly recommend: Java Programming Masterclass for Software Developers by Tim Buchalka You know you're in for a lot of information when the course is a staggering 80 hours of content. It covers the basics of Java, how to get it installed, picking an IDE, a quick overview of data types, and how to get your first programming running. Tim then gets into the meatier topics of classes, objects, inheritance, constructors and encapsulation. And for each topic there are plenty of code examples, exercises and demos. There […]