To learn SQL, the best way is to practice different sets of commands and get hands on experience. If you have learned the SQL basics, then it is time for practice and reinforce your learning. This is a simple beginner’s guide to help you install MySQL for learning and practice SQL commands. If you are…
Continue Reading A Beginner’s Guide to Installing MySQL for Learning and Practice
ACID properties are related to transaction in database management systems (DBMS). Before we dive into the topic, understand the importance of database transaction. Transactions simulate real life events of an individual, organization or enterprise. The transactions are many read and write operation in database terms and without database transactions, there will not be any change…
A simple real life event is a transaction in DBMS. In DBMS, a transaction represents a logical unit of work that simulates some real life event of an individual, organization, or an enterprise. The logical unit of work is sub-divided into operations and executed one-by-one until the transaction is completed. The operations are database operations…
Continue Reading DBMS Transaction States: A Simple Guide for Students
As a software developer or a upcoming developer, knowledge of Git and GitHub is most essential skill. This article will help you get started if you already installed and configured Git on your computer. Also, I assume you are familiar with command-line tools and know how to use them. We will setup a local repository…
A markdown is a markup language to write readable documents and later convert it into different formats. You can use markdown syntax to write formatted documents whose style is already predefined and get a clean readable document. Read my previous post on how to learn about markdown and how to use it. These markdown files…
The Markdown is a light-weight markup language, that provide syntax for formatting text documents. A word processor is easy to text editor where you can format text what you see. That is why these applications are WYSIWYG editors. In the MS Word like application, you must format the text and changes are visible immediately. Markdown…