SQL Commands

SQL Commands SQL commands are instructions, coded into SQL statements,which are used to communicate with the database to perform specific tasks, work, functions and queries with data. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database […]

Read More

HTML Basics

HTML Basics HTML (Hyper Text Markup Language) is the standard markup language for creating Web pages. It describes the structure of Web pages. HTML elements are the building blocks of HTML pages and represented by tags. Anatomy of HTML element The main 4 parts of element are: The opening tag: This consists of the name […]

Read More

C – Constants

C Constants are also like normal variables. But, only difference is, their values can not be modified by the program once they are defined. Constants refer to fixed values. They are also called as literals. Constants may be belonging to any of the data type. Syntax:  1. const data_type variable_name;  2. const data_type *variable_name; TYPES OF C […]

Read More

SQL-The three magic words(SELECT, FROM & WHERE)

The three magic words Although there are lots of keywords used in SQL, SELECT, FROM, and WHERE are the ones you would be using in almost every query that you make. After reading ahead, you would realize that these key words represent the most fundamental aspect of querying a database, and other, more complex queries are simply extensions of […]

Read More

SQL Set Operators – Union, Intersect, and Except Clauses

The UNION, INTERSECT, and EXCEPT clauses are used to combine or exclude rows(records) from two or more tables.  They are useful when you need to combine the results from separate queries into one single result.  They differ from a join in that entire rows are matched and, as a result, included or excluded from the […]

Read More

Pointers in C with examples | Pointers | C Tutorials

C Pointers In general all beginners have a dislike for pointer in C. If the users have experience with any programming language, they must have been familier with the concept of branching, looping, use of functions to divide the program into small managable modules or even use of arrays. Pointer is a unique feature of […]

Read More

Unions in C Language | Learn C Language

C Unions Union is a data type with two or more member similar to structure but in this case all the members share a common memory location. The size of the union corresponds to the length of the largest member. Since the member share a common location they have the same starting address. Major difference […]

Read More

C Structure | Difference Between Array and Structure | Learn C

C Structure When we write a program, it is important to choose an optimal and best way to represent the data that further use in program. In general, scalar variables and arrays are sufficient. For example, in your program, you may want to refer to a student that holds multiple fields including Roll number, name, […]

Read More

Insert Images in HTML | HTML Images | Learn HTML

HTML Images Html Images plays an key role in any websites and it’s design. It can help the visitors of the websites to connect and feel comfortable on the website. In the world, 65% of population are visual learners. In HTML, <img> tag is used to display the images in the web pages. It requires […]

Read More

Different Types of SQL Keys | Learn SQL

Types of SQL Keys A key is a single or combination of multiple fields in a table. Its is used to retrieve records or rows from data table according to the condition/requirement. Keys are also used to create relationship among different database tables or views. Below are different SQL Keys. Super Key Candidate Key Primary […]

Read More