GREP Regular Expression examples – Regex with grep command

Hello, readers! I hope my previous posts on OpenCV face detection and JavaFX material design were useful to you. Here I will show you how to use the Linux utility such as grep for pattern matching using regular expressions. I will also show you some grep regular expression examples. So let’s get started. The Grep command Before describing grep regular expression examples, a brief introduction to Grep utility. Grep(globally search a regular expression and print) is a command line UNIX utility for searching for patterns that match a regular expression in a plain text data set. So, how to use […]

» Read more

JavaFX tableview example – building tableview with JSON data

Hello, readers! My last post about JavaFX was about implementing the material design using JFoenix library. Here I am going to show you steps to build your JavaFX tableview with JSON data. So Let’s get started. JSON for JavaFX tableview First of all, let us discuss why do we need to put JSON data in the JavaFX tableview. As we all know, APIs are everywhere. All the data is flowing between different applications via APIs. APIs send responses mainly in either JSON or XML format. JSON is much simpler, faster and readable as compared to XML. So, most of the […]

» Read more

Functions and aggregate functions in Oracle || query order of execution

Hello, readers! I hope you found my previous posts on Oracle and database useful. I recently learned the grouping functions in Oracle. It’s a very important feature that Oracle offers. Let us see what it is. First of all, we look into the flow through which a query executes in Oracle. For example, we have a query below. Query order of execution flow in Oracle Here, the Clause Trigger flow is as below: Projection [FROM] ——>[WHERE] predicate——-> [SELECT] predicate. So, first of all, Oracle learns FROM where it has to query the data, then it checks the condition as specified […]

» Read more

Accounting and fee management solution for schools and colleges

Online accounting for educational institutions. It is a platform to help accountant and student to make their work easier. To provide an online Account Management system for colleges, which would offer all accountancy functionalities. With the help of this software, the college would be able to keep the student fee and other accounting functionalities record online. Also, by using this software amount of errors or dispute that has been occurring during the manual accounting should be minimized. It will provide a database system that deals with all activities done by the computer such as admission process, fee payment, etc. All […]

» Read more

OpenCV Face Detection in Images using Haar Cascades with Face Count

Hello, Readers! I hope my previous posts on JavaFX material design were useful and informative. This post will hopefully show you some basics of OpenCV face detection using Haar Cascades. So let’s start. OpenCV and Applications First of all, let’s visit the basics. OpenCV is a very useful library that contains functions for real time computer vision. So what is it used for? OpenCV has a number of applications which include the following. OpenCV face detection Facial recognition Motion Tracking Gesture recognition Augmented reality, and much more. OpenCV is now cross platform. Also, it can be used with popular languages […]

» Read more

Level pseudo column in Oracle example || Hierarchical query

Hello Readers! I hope my previous articles on Oracle were useful. In this one, I am explaining an Oracle pseudo column. The level is one of the pseudo columns that Oracle adds up with each queried row. It is very useful in some cases, which I am explaining in this article. The level is generated automatically during query processing. By default, each generated row has the same level that is 1. Although levels for each queried row starts varying when we provide some level criteria.This criteria is given using the ‘CONNECT BY’ clause. Level Pseudo column in action. Suppose we […]

» Read more

JavaFX Material Design Setup Tutorial with JFoenix library

Hello, readers! I hope my previous posts on database design concepts with Oracle were useful. Here, I will discuss the JavaFX material design concepts and features. I use JFoenix library for Java which is a JavaFX material design library. Setup JFoenix JavaFX material design library in Netbeans     First of all, I will show you how to setup JFoenix library in Netbeans and Scene Builder so that you could add some JavaFX material design to your applications. So let’s start learning. The material design was developed by Google and makes use of grid-based layouts, responsive animations, and transitions. JavaFX […]

» Read more

Data views and entity in DBMS

Hello, Readers. In my previous post, I discussed different Database models and types of database. This post aims to explain different views of data and also discusses different types of entities. So, what is an entity in DBMS(Data Base Management System)? An entity is simply a real world object. So, it must have a set of properties that describes it. Logical and physical views of data Data is stored by Oracle in tables. And that data is visible to us in two views, namely Logical View Physical View When you see the data arranged in tables in the form of records, […]

» Read more

Database models and types of database

Hello, reader. A database has many models depending on whom the database is targeted for use. Different people having different requirements would want to use the database. So, they get different database models to use. Common Database Models Mainly, the following database models are used:- Strategic database model Tactical database model Clerical database model The strategic database model is for those group of users that need to work on building strategies based on the data they have in the database. And they generally don’t perform day to day transactions on the data. The Tactical database model refers to utilizing specific […]

» Read more

Oracle database tutorials for beginners

Hello, readers! This is going to be a short blog which is targeted at Learning Oracle database concepts and provide simple Oracle database tutorial. The difficulty level of understanding this Oracle database tutorial blog stuff is ‘beginner’, so experts stay away. I am myself exploring Oracle right now, so please excuse any mistakes. All comments, suggestions are most welcome. Make sure you add this website to your browser bookmark if you are willing to learn upcoming Oracle database tutorials. Learn more about the Oracle database versions and features here : link to Oracle. You can request for tutorials and concepts […]

» Read more