Tech Junkie Blog - Real World Tutorials, Happy Coding!: Database

Latest Posts

Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
Friday, December 10, 2021

MongoDB In-Depth: The Difference Between RDBMS and MongoDB

›
Before we begin inserting data into mongoDB we need to understand the difference between Relational Database Management System (RDBMS) and m...
1 comment:
Tuesday, November 23, 2021

MongoDB In-Depth: Installing MongoDB on Windows

›
In the previous post we installed MongoDB on Linux on this post we are going to install MongoDB on Windows. Here are the steps: 1. Go to...
4 comments:
Tuesday, November 16, 2021

MongoDB In-Depth: Basic MongoDB Commands

›
In this post we are going to go over some basic commands that you can run on a machine that has MongoDB installed. One of the first thing ...
1 comment:
Tuesday, August 3, 2021

ACME Bank: Step 10: Getting Values From MySQL Database In Asp.Net Core Web Api Controller

›
 In the last post we created our ACME Bank database in MySQL, the next step is to get the values from the Values table in the Asp.Net Core W...
9 comments:
Thursday, July 29, 2021

ACME Bank: Step 9: Create Our Database In MySQL Using Asp.Net Core And EntityFrameworkCore

›
 In this post we are going to create our first Entity Framework migration and creating an actual database in MySQL.  In order to do that we ...
4 comments:
Tuesday, July 20, 2021

ACME Bank: Step 8: Install MySQL Workbench On Fedora

›
 In this post we are going to install MySQL Workbench on Fedora.  MySQL Workbench is a great GUI database management tool for MySQL.  Even t...
10 comments:
Tuesday, July 13, 2021

ACME Bank: Step 7: Add A Dev User In MySQL

›
 In this post we are going to circle back to MySQL and continue setting up our MySQL database, so that we can use it in our application.  Si...
7 comments:
Tuesday, June 22, 2021

ACME Bank: Step 3: Install MySQL on Fedora Linux

›
The most important thing for most modern dynamic application these day is choosing a database to store your data.  If you are on a Windows e...
2 comments:
Sunday, June 6, 2021

MongoDB In-Depth: Setting Up And Starting MongoDB For The First Time

›
In the previous post we installed MongoDB on a Linux orperating system.  On this post we are going to setup the data folder that MongoDB nee...
14 comments:
Saturday, May 29, 2021

SQL Server 2014 : Creating a Sysadmin Using a Windows 8.1 Account

›
The one of thing that Windows 8 forces you to do is to sign in with an e-mail account.  I am not here to debate if it's a good thing or ...
17 comments:
Friday, May 28, 2021

SQL Server : Installing AdventureWorks Sample Databases from Microsoft

›
1. Type in the following URL into your browser's address bar       AdventureWorks Database Download 2.  Click on the "Download...
545 comments:
Tuesday, May 25, 2021

SQL: The NOT IN Operator

›
The NOT IN operator in SQL means that you are retrieving records in the database that does not match the values in a comma separated list. ...
2 comments:

SQL: The IN Operator

›
The IN operator in SQL means that you are retrieving records in the database that matches the values in a comma separated list. Here is an...
3 comments:
Monday, August 5, 2019

Hour 10 ASP.NET Core : Add appSettings.json Configuration Files For Database

›
Now that we have most of our static contents taken care of for our application, meaning we did everything we could without a database.  It...
4 comments:
Thursday, December 13, 2018

Create a Data Science Virtual Machine on Microsoft Azure

›
It is time consuming and a lot of work to set up your own data science virtual machine locally.  If you don't mind the cost, the alterna...
12 comments:
Monday, August 8, 2016

ASP.NET Core : Add NorthwindContext To Startup Class And Create Database

›
In this post will are going to finally create the database that we have been preparing for in the last previous blog posts.  It's a two ...
4 comments:
Friday, August 5, 2016

ASP.NET Core : Configure project.json File To Support Entity Framework Core

›
In the previous post we created the DbContext for the Northwind Cafe application.  In this post we will configure the project.json file to s...
2 comments:
Wednesday, August 3, 2016

ASP.NET Core : Entity Framework Core Models For Northwind Cafe

›
In the previous post we added a configuration file call appSettings.json file to store our connection string to the database that we are goi...
1 comment:
Sunday, June 19, 2016

SQL: Using Parentheses To Get Expected Result

›
SQL Server as well as other DBMS has an order of evaluation that can throw you off. Especially when you have more than one comparison in t...
5 comments:
Saturday, June 18, 2016

End-to-End ASP.NET MVC 5 : Create Entity Data Model With Entity Framework

›
In our previous blogs we've created an ASP.NET MVC from scratch.  In this blog we are going to use Entity Framework as the ORM (Object...
14 comments: