Html is hyper text markup language in initial days it was used to publish or share data on the web. Later on modifications happens in html and now days we can use the html to format or create the presentation of data on web. Now a days we can say html is used for web-page […]
Read MoreWhat is Web Application? Web Application is a Application software which runs on internet or can be consumed from internet.Web Application is a Application software designed, developed, deployed and consume using web. What is Computer Network? Computer Network is inter connection between two or more devices, to communicate / to exchange data.e.g. WAN, LAN, MAN […]
Read MoreWhat is joins? Joins enables us to fetch data from multiple tables, in lot of situations you need to combine the multiple table data in a single select query, that we can do using sql joins. If you want to implement join between two or more tables in general those table should have some common […]
Read MoreWhile creating tables you can apply constrains/rules to column – SQL constraints are used to specify rules for the data in a table. Constraints are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the table. If there is any violation […]
Read MoreHow to create table using SQL? To create any thing in database SQL provides you create query or command. To create table in database we need to use Create Table query as follows – create table tablename ( fieldname datatype([size]), fieldname datatype([size]) ….) where field name is name of column from table and data type […]
Read MoreWhat is Database? Database is nothing but the collection of information about a particular topic or data stored in way that it can be manipulated easily. In general we store the database in tabular format. Storing data in tabular format makes it easy to manipulate and use. e.g. Buses Database, Flight Database , Student Database. […]
Read More