CodeCircle

If you are familiar with SQL, you might have written queries to fetch data using a single table. But SQL joins are used to fetch data from two or more tables. This can be considered as one of the most benefited features enable in SQL. Lets see how we can use SQL joins to fetch data . Rather than storing the same data in multiple tables,by using this method one table will keep a reference to a ID of the other table. This approach is more efficient  and lets see we can do this using SQL joins. Types of Joins In MySql we can see there are mainly three joins , INNER JOIN LEFT JOIN RIGHT JOIN 01. INNER JOINS In INNER JOIN,  the query selects all the rows from both tables where there is a match between the columns in both tables. SQL Query SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name; Here the INNER JOIN is Specified by the ON keyword which is in the syntax. Example : Lets see How t...

Microservice Architecture or simply Microservices, an emerging technology grown popular in recent years which is used in software development.The article will help you to get to know about Micro Services. This architecture is helpful for the deployment of large complex applications also support for range of platforms and devices like web,android,Internet of Things and wearables .  The large complex applications are deployed into small modules which runs separately as unique processes.So basically using Microservices you can easily use any of the technologies as the development is done separately as a module.  The communication among the modules are done considering the requirements of the business goal. Here HTTP/REST with JSON is mostly used. Examples  Netflix eBay Amazon Twitter PayPal Soundcloud   and many of the other applications have now moved to microservices from Monolithic Architecture where they have decompose...

AngularJS is a very popular Javascript framework that is used when adding java script to web project.It is mainly used for Single Page Applications(SPA) and very easy to learn. Set Up you Environment In this article I will be using Angular stable (v5.2.1) version.You can easily get this version from  angular.io . In the sidebar you can see the angular versions and you can select the particular version there.Then you will need to install the angular CLI by using npm command.For this you should have installed  node.js to your system first. After the installation you can run the npm command in your command line by copying the command from the angular guide . Now you can create your new project. Select the particular folder to create the project from the command line and type the following code. ng new my - app Here my-app is my project name and you can use any name you prefer. Directory structure of the project is given below. ...

Bootstrap is one of the most popular HTML,CSS and JavaScript framework used to develop web applications. Also it is a free and open source software designed by twitter including HTML,CSS and JavaScript based designed templates. This article will show you how to set up Bootstrap in your computer Method 1 Step 1 Go to getbootstrap.com to download Bootstrap and click  Download Bootstrap button. There You will get the following window. Click Download Bootstrap button and save the zip file. Step 2 Extract the zip file in to a new folder. There you will get three folders named as css, fonts and js. Step 3 Rename the folder and make it simple(eg : bootstrap). Then you will have to copy the  bootstrap folder to the root directory of the web project. Step 4 Get the bootstrap Basic template and copy it to your text editor and save it in your web project folder. Folder structure of the web project is shown in the below diagram. Then edit the html ...