Loading
What Is LevelDB
This article will describe the most commonly used database in blockchain technology; LevelDB which is an example of a NoSQL database and stores data as key-value.
TranslateSQL
TranslateSQL generates SQL Server schema scripts from an Oracle schema, converting tables, columns, indexes, keys, constraints, and supported data types.
Snowflake Connector For Python
This article shows the execution of SQL queries through a Python program using the Snowflake connector.
Snowflake And Its Features
In this article, you will learn about Snowflake and its features.
The Other Kafka's Metamorphosis
In this article, you will learn about the other Kafka's Metamorphosis.
Oracle Database Server To SQL Server Migration
In this article, you will learn about Oracle Database Server to Microsoft SQL Database Server Migration.
SAS Viya Visual Analytics
When facing analytical challenges, SAS Viya is the best tool for visualization of the data.
Introduction To Databases
This article is for students and newcomers to understand basics and types of databases and their history.
What Is Database Normalization And Denormalization
Learn how database normalization and denormalization organize relational data, with examples of first, second, and third normal forms.
What Are The Advantages And Usage Of Apache Cassandra Database
This article reviews basics of Apache Cassandra and its advantages and usages. Apache Cassandra is the easiest truly big-data database that can scale and replicate data globally in a master-less configuration. What used to be in the hands of only the biggest in Silicon Valley is now available as a mature database to the masses.
DataTypes In MongoDB
In this article, we will learn about the Datatypes and its usage in the MongoDB. As we already know, MongoDB stores data in BSON format. BSON stands for the Binary-encoded format of JSON. Using BSON, we can make remote procedure calls in MongoDB. In MongoDB, each data type has an alias as well as a number which can be used for finding or searching the record in MongoDB.
Creating Your First MongoDB Atlas Cluster
MongoDB Atlas is an online no-sql database that allows you to run a MongoDB database as a service. Running MongoDB as a service means that you no longer need to host your own servers or manage upgrades. MongoDB Atlas is a PaaS (Platform as a Service) offering that can be hosted on Amazon AWS, Google Cloud Platform, or Microsoft Azure. In this article I will be demonstrating the steps needed to create your first MongoDB Atlas cluster using the Microsoft Azure service, and add JSON documents manually using the Atlas portal.
Normalization In Databases
Sometimes the database design that looks Ok at first sight may have some hidden problems. One such kind of problem is Non-Atomic Values. This means that the value that stored in a single column in the database is actually a combination of multiple values which makes the database harder to work with because you’ll always need expressions to extract the individual value. And it comes with major impact in performance as well.
Getting Started With SQLite
Getting Started With SQLite. SQLite is a lightweight local database and it's become the industry standard for mobile apps. Learn SQLite, SQLite tutorial.
Importance Of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and play a part in execution plans. The cardinality estimator relies heavily on statistics to get the answer to selectivity (the ratio of distinct values to the total number of values) questions and calculate a cost estimate.
Essential Features Of TablePlus - The Best GUI Tool To Manage Relational Databases
TablePlus helps you to be more efficient while working with multiple relational databases. You can connect to the server, create a new database, manipulate and save your data at a fast speed, high-end secure guaranteed.
How To Survive As A Lone DBA
Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a decade. While many DBAs work on teams instead of alone, she has great advice for all.
Continue With Learning Indexes In MongoDB
This is the continuation of exploring the Indexes on MongoDB. We will be discussing various MongoDB indexes which we can perform on our data.
Learn MongoDB With Me - Part Two
This is the second article of the series “Learn MongoDB with Me,” and if you haven’t read my previous post on this topic, I strongly recommend you find it here. This is a continuation of exploring the Mongo shells. We will be performing some commands on the Mongo shells. For easy reference I will try to add screenshots for each of the steps I am following. I hope it will help you to come along with me. Thanks for reading.
Getting Started With MongoDB
MongoDB is an open-source/cross platform (Windows, Linux, etc) document database that is NoSql in JSON format database. A NoSQL database means it does not have any relationships (non-relational database). It is a document-oriented database.
Overview Of MongoDB
This article explains the basics of MongoDB, doing CRUD operations on it using command prompt and then CRUD operations with a sample ASP.Net WebAPI.
Getting Started With MongoDB - MongoDB With C#
In my previous article, you got a little knowledge of MongoDB basics. This article will focus on doing CRUD operations from a C# console application. The working mechanism will be same for web applications and desktop applications. Open up the mongod.exe in the command prompt to keep the MongoDB server running while executing our C# application.
Installation of SQL Server 2005
Using Windows 7 Ultimate, after installation of SQL Server 2005, an error occurrs regarding Connection. (Settings for Database Engine) Login failed for user Admin\vilas. (Microsoft SQL Server, Error : 18456) . Learn how to remove this error.
Learn MongoDB Step By Step
In this article, we are going to learn how to install MongoDB on a Windows machine in a step by step way. Along with this, we are also going to learn how to start the MongoDB Server and basic commands to access MongoDB Database.
Introduction To NO SQL And Working With MongoDB - Part One
In this article, you will learn what NO SQL is and how to use MongoDB as NO SQL in ASP.NET Web Application.
Learn MySQL Queries With Examples
In this article, you will learn select, update and delete statements in MySQL queries with examples.
MongoDB Tutorial - Queries: Part Two
In this article, we will see some MongoDB specific queries.
Introduction To MongoDB
In this article you will learn MongoDB and No-SQL. I will start with the definition of NoSQL.
