2020-06-17
This is a somewhat advanced course on how to write SQL (Structured Query Language) syntax to help you perform useful calculations in a relational database system (e.g., MySQL, Oracle, Microsoft Access, PostgreSQL, Microsoft SQL Server, et cetera). This video follows my other lectures on Basic SQL Queries and another one dealing with SQL Multi-Table Queries. Therefore, if you have not yet watched those previous lectures, please view those first unless you feel comfortable writing SQL generally.
2020-06-05
This is a beginner-level course on how to write SQL code to "talk" to a relational database system (e.g., MySQL, Oracle, Microsoft Access). I eventually get into showcasing a hands-on demonstration of creating SQL queries using Microsoft Access, which you can use this knowledge to also apply to more serious database systems like: MySQL, Oracle, PostgreSQL, Microsoft SQL Server, IBM Db2, and so forth. However, before I get to that portion, I initially explain some general concepts and I give a slide-based overview of how to write various SQL syntax.
2020-03-28
Learn the basics concepts of programming in Java! I will be going over a lot of content in an easy to understand fashion. Though, please know that this video lecture follows my other lecture on YouTube called: Orientation to Java Programming (IDEs, JDK vs. JRE, "Hello, World!"). So, you may want to start with the previous video first to get yourself up and running before trying to dive into Java coding.
2020-03-24
This is a somewhat advanced course on how to write SQL multi-table queries on relational databases (e.g., MySQL, Oracle, Microsoft Access) that essentially allows you to recombine your data tables back together to find useful information. If you are new to SQL, please watch my other video titled Basic SQL Queries before watching this lecture.
2020-03-22
Get your feet wet with programming in Java! I'd recommend starting with this video first before moving onto my next video lectures on the subject.
