Category: Computer courses

0

Computer Fundamental

What is Computer? A computer is a device that accepts information (in the form of digitalized data) and manipulates it for some result based on a program or sequence of instructions on how the...

1

Introduction

Introduction Getting started Adobe Indesign software is very useful for all designers especially for designers of publishing industry. Adobe Indesign software we can say a combination of illustrator, pagemaker and photoshop. A designer can...

1

Tools of Indesign

Tools Overview To display Toolbox: Choose Windows > Tools To display tool options Double-click a tool in the toolbox. To display hidden tools: • In the toolbox, position the pointer over a tool that...

1

PL/SQL

What is PL/SQL? PL/SQL is Oracle’s procedural language extension to SQL. PL/SQL allows you to mix SQL statements with procedural statements like IF statement, Looping structures etc. PL/SQL is the superset of SQL. It...

1

DATA MANIPULATION SQL Function

  What is SQL Function? SQL has a lot of built-in functions for counting and calculations. Functions serve the purpose of performing operations on data such as manipulation of data items and returning a...

4

DATA MANIPULATION

SQL Create Database, Table Create a Database To create a database: Create a Table To create a table in a database: Example This example demonstrates how you can create a table named “Person”, with...

1

SQL Advanced

Use of ORDER BY The “ORDER BY” is used to sorting the result from table. “CORRIER DETAILS” TABLE NAME Example To shorting the courier service names in alphabetical order: RESULT Example To shorting the...

1

SQL Commands

The SQL SELECT Statement The SELECT statement is used to select data from a given table. The result is stored in a result table Syntax Example The table name “eBIZ” The Result To Select...

1

Introduction to SQL

      PL SQL Introduction to SQL What is Database? A database is an organized collection of data that is useful to us. The data inside in a database can be modified, deleted...

www.000webhost.com