As many of you know, my technical roots are in databases, SQL, and full stack web development. I’ve spent a lot of time creating videos on YouTube over databases. For example, I have a 51 part video series on Database Design. Who or What is freeCodeCamp? Recently I was reached out to by freeCodeCamp. For […]
Databases
Db2 SQL Tutorial 4 – Create and Drop Table
So far we’ve learned about the very basic concepts of Db2, but now I want to dive in a bit and work with tables. Some of the material in blog may take a few more blogs to fully understand, but that is okay. The goal is to get you started. Later we will come back […]
Db2 SQL Tutorial 3 – Data Structure and Data Types
Before building a database for yourself or a corporation, you need to understand a bit about database structure. We are going to go in some depth on how to design a database, which deals with structuring your database the best way possible. However, I thought it would be appropriate to give an overview of the […]
Db2 SQL Tutorial 2 – Getting Started with Db2 and DSM
Here it is, your guide on getting started with Db2! Working with new software can be stressful, so my goal is to make this as easy as possible for you. Fortunately, Db2 setup is not too challenging. Db2 Editions Before we dive in and start downloading stuff, I want to take a moment to explain […]
Db2 SQL Tutorial 1 – Intro to Db2
First off, what is a database? A database stores data, which is any information that might be of use to a company. Db2 is a database created by IBM that is best known as an enterprise database, so we are talking about a database used by huge companies who have more data than they know […]
Intro to MongoDB
What is Mongo DB? MongoDB is an unstructured database that is becoming extremely popular for speed, ease-of-use, and scalability. The Problem with Structured Data Until now, the majority of the my content has covered relational databases. You communicate with a relational database using SQL (Structured Query Language). A relational database follows a structure defined by columns in a […]