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:
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 also lots of conversations about programming methodology to hold things together.
While not an automation course, it provides a wealth of information to develop and improve your code. I've learned a huge amount from this course and I don't consider myself to be a developer.
The second course on the list is:
To me, SQL is an umbrella term for many things. There is the language, the database itself, database theory, architecting, maintenance, and development (stored procedures).
That's not where I need to be. I'm not a SQL engineer, but writing a query is a huge benefit to the QA engineer. We can validate site information and provide dynamic data for Katalon scripts. This course focuses on building those kinds of queries.
It starts off with the basics of SQL, the SELECT statement then moves into COUNT, JOIN, ORDER BY, LIKE, WHERE, BETWEEN and GROUP BY.
For your own practice, it goes over the basics of installing and creating a database, setting up data types, and gives a solid foundation for starting with SQL – the language.
I am by no means an expert, but the topic is no longer a total mystery to me. As noted, I've been able to connect Katalon into our database and retrieve data. While I'm not the fastest at putting a query together, I have a far better understanding of what I'm doing.
As a matter of fact, I plan to retake this course during this slow period of the holidays as a refresher and to dig deeper into topics now that I have a better understanding.
Other articles of interest:
- Damn, Java confuses the hell out of me.
- Programmatic Database query with Katalon
- Switching from SQLPro Studio to Valentina Studio
- From the Selenium IDE to Katalon Studio
- Connecting Katalon Studio into XLS and CSV files
- More Katalon Studio and Automation to come
- Boostnote for Code Snippets
- DevonAgent for Deep Dive Internet searches
- What is Katalon Studio? A Distro of Selenium, Groovy and Eclipse
- Productivity Tools for 2020
Not the language itself since I don’t do any actual Java programming, but getting the environment set up. I thought I had things set up correctly with the JRE, which took for damn ever mind you. But then one of the apps I’m testing actually needs the JDK. It sounds simple enough until you go looking for the right file to install because you need a specific build number. I guess I’m just not familiar with how Java does their version numbering because I got all manner of confused.
After going around in circles I finally turned to the dev guys and had them point me in the right direction. I have the JRE and the JDK installed, but it still doesn’t make any sense to me. I’m used to seeing something like 1.6.0 or something like that. Those Java kids, they gotta be all different and stuff.
Now let’s see what crashes.
Other articles of interest:
- Udemy courses in Java and SQL
- Minecraft and the wicked lava machine
- Upgrading to Ubuntu 10.04
- End of the decade
- Abraham Lincoln Vampire Hunter
- Currency Formatting with getCurrencyInstance()
- Ok, this needs to change
- Not everything is different between Windows and Mac
- Yep, there’s issues
- The Six “Wow” Features of Windows 7