Posts for Database Category
Database Interview Questions – Easy  1

Database Interview Questions – Easy 1

This question handled from https://leetcode.com/problems/combine-two-tables/

Table: Person

+-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | LastName | varchar | +-------------+---------+ PersonId is the primary key column for this table.

Table: Address

+-------------+---------+ | Column Name | Type | +-------------+---------+ | AddressId | int | | PersonId | int | | City | varchar | | State |...
MongoDB Indexes

MongoDB Indexes

MongoDB supoort different types of indexes such as Single Field Indexes, Compound Indexes, Multikey Indexes, Text Indexes,? Wildcard Indexes, 2dsphere Indexes, 2d Indexes, geoHaystack Indexes, Hashed Indexes, and default _id index.

Indexes support the efficient execution of queries in MongoDB queries. Without indexes, MongoDB must perform a collection scan, i.e. scan every document in a collection....

What’s Big Query?

What’s Big Query?

Yes. You have an opportunity to store and query massive datasets on Google Cloud Platform. Big Query which is an is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google’s infrastructure.

Google BigQuery is a cloud-based enterprise data warehouse that offers rapid?SQL queries?and interactive analysis of...

MongoDB GeoJSON Objects

MongoDB GeoJSON Objects

  • July 01, 2019
  • by
Introduction to Geospatial Queries

In this post, we feature a comprehensive Example on MongoDB Geospatial Query Operators. MongoDB is a JSON based document storage database. MongoDB stores the records in the form of unstructured JSON documents. It allows the flexibility of having varying number of columns for every record. This feature of MongoDB has been put...

About Me

I am a dad of two wonderful boys, Utku Efe and Omer Eren, and married with Elif. In addition, I am an academician and AI/ML scientist because I worked more than 15 years in universities, have M.S and Ph.D. thesis and more than 20 scientific papers/presentations and 100 citations. Now people call me as a Principal Developer in my last company :).
I am really hungry on learning new technologies and get more fun while developing new softwares.

Stay Connected

×