Blog Posts
Git and Github
Git is used to track the source code of the application. It is a collaborative tool that boosts the speed of development.
#16 Pushing and Deleting branches on remote
This is the last post of this series. In this post it is shown that how you can push your local branches on remote. Also you will get to know how you can delete them from remote. At the end of this post you will get to see the cheat sheet for git commands.
#15 Git: merging conflicts in git
This post gives the basic idea to solve the conflicts and then merge them. Also introduces some important commands, which helps us to maintain the git branches.
# 14 Git: Introduction to branching in git
Post consist of pretty basic command regarding creating new branches, switching between this branches, and merging the two branches.
#13 Git: Setting alias in git
In this post we will see what is alias in git and how to use it. Also we will see what are the various usage of alises by examples. So to explore the post click on read button now.
#12 Github: Working with remote repositories
In this post you will learn how to create github repository. Also how to add remote repository using git commands. We will push our code after creating the remote repository on github.
#11 Unstaging and unmodifying files in git
In this post you will get to see how you can unstage the staged file. Also you will learn how we can unmodify the files using git commands. You will learn how to get previous committed files.
#10 Git log: Viewing and changing commits
In this post you will learn how you can view the previous commits also you will get to see that how you can change the git commit messages.
#9 Git: Renaming and moving files in git
In this post we will get to see the commands with which we can remove and rename the git files. We can also remove them from tracking area using git command.
#8 Skipping the staging area.
In this post you will learn how you can directly commit your files without adding them into staging area. Git provides shortcut command to do so.
#7 Git diff – Comparing staging area, working directory, and previous commit.
In this post you will see how to do comparison between staging area, working directory and previous commit. Also you will get to know the options we can use with git diff command.
#6 .gitignore – Ignoring files in git
In this post you will learn how to ignore unnecessary files and folders which are created in the background while the software or application is running.
#5 Cloning a remote git repository
In this post we will learn how to clone remote git repository. Work with that repository. Checking previous commits made by authors on that cloned repository.
#4 Git’s file status lifecycle
Post gives the brief introduction to git file status life cycle. There are multiple stages like Untracked, Tracked, Unmodified, Modified, etc. Post introduces to some commands of git.
#3 Git – Three stage architecture
This post gives information about three stage artchitecture of Git. When we give our file to git it goes from this three stages.
#2 How to install git + initial configuration
This post will help you to install git on your system. Follow the procedure and select the recommended options. At last you will see some mandatory configurations.
#1 Introduction to Git/Github
This is a first blog on git and github tutorial.In this blog there will be a brief introduction on git.You will get know about Version Control System(VCS).Also you will understand the major difference between both i.e. Git and Github.
SQL Tutorial
SQL is a structured query language. It is used to operate databases in DBMS.
The Aggregate functions world in the MySQL
In this post, we will see how to use aggregate functions in MySQL. Each function takes the column name and according to their functionality returns the numeric value.
Update and delete commands in MySQL
In this post, you will see how to use update and delete commands in MySQL. As the name suggests they are used to update or delete the data in table. But there are some important thing we need to keep in mind while using those commands.
Order by keyword and is null operator
In this post, you will see how to order the data in ascending or descending order. Also you will see how to is the field is NULL or not with IS NULL and IS NOT NULL operator.
AND, OR, and NOT operators in MySQL
In this post, you will see AND, OR, and NOT operators in MySQL. How to filter data by combining these operators with WHERE clause. Also, how to combine these operators with each other.
WHERE clause in MySql
In this post, you will learn about WHERE clause in MySql command line. Where clause is used to fetch data with some specific conditions. If that specific condition is met, then it return the data to print.
Fetch data using select keyword
In this post, you will see how to fetch data using select keyword. Also, you will see different options to use with select statement. You will see how to use distinct keyword with the select statement.
XAMPP Tutorial
XAMPP is used to test develop websites before putting it on actual server.
#9 Operations on Database in XAMPP
In this post you will learn how you can handle the database operations. Also you will get to learn how to export and import the database in phpMyAdmin. Click on read more button to explore more.
#8 Add foreign key constraint in XAMPP table
In this post, we will see what is foreign key? Also we will see how we can define foreign key constraint in table of XAMPP? What happens when we select ON UPDATE and ON DELETE as RESTRICT and CASCADE?
#7 Handling the table and table data in XAMPP
In this post we will see how we can handle the data present in table of XAMPP. Also we will take a look at how can we do different-different operations on the existing table.
#6 Create database and table in phpMyAdmin
In this post, we will be using phpMyAdmin provided by the XAMPP. We will see how we can create database and table using phpMyAdmin user interface. To explore the post click on read more button.
#5 How to host a website locally using XAMPP
In this post we will see how we can host PHP-based website using XAMPP. We use XAMPP as a development tool. We can develop our website and deploy here before deploying it on server.
#4 MySql shutdown unexpectedly error in XAMPP
MySql is one of the core component in the XAMPP. In this post we will see how we can solve MySql shutdown unexpectedly. We get this error because of already occupied ports or blocked ports.
How To
Here you will the get posts, related to general problems in our day to day life.
How to install MySQL command line?
In this post you learn to install MySQL command line client for windows. Also you will see how you can use phpMyAdmin instead of command line client.
How to install WordPress on the local system?
In this post you will see how to install wordpress on your local machine. What are the prerequisites while installing wordpress? How to configure it? You will learn this things in this post.
#2 How to install XAMPP? | Local server
In this post you we see how to install XAMPP on our local system. XAMPP is a development tool to test developed websites locally. We can call it local server.
How to get saved network passwords from computer
In this post you will get to see the command prompt's one hidden feature. Which will let you get the saved network's password from your computer.
#2 How to install git + initial configuration
This post will help you to install git on your system. Follow the procedure and select the recommended options. At last you will see some mandatory configurations.
How to convert .py to .exe?
In this post we will learn to convert .py file to .exe file. It gives different-different option to use with commands to explore them click on read more button.
Top Items
Here you will get posts related to top technologies, extensions, plugins, etc. which with you can increase your productivity.
Top figma plugins for designers
This post is about must have plugins of figma. Iconify, Lorem Ipsum, Avatars, etc. plugins can boost your productivity. Also they make designing process easy.
Top 8 VS Code extensions for developers
This post is about must have vs code extensions. Live Server, Live Sass Compiler, ESlint this are pretty basic vs code extension.
Top 6 text editors | best text editors
This post gives information about the widely used text editors like Notepad++, Atom, VS Code. Post also tells where to find them. So without wasting time let's explore it.