Shareittips.com

Computer & IT Tips By Akash Padhiyar

Archive for the ‘SQL’ Category

Jul
17

How to install oracle 9i database – Video

Posted by Akash Padhiyar 0 Comment

Here you can easily learn .How to install oracle 9i database .. Akash PadhiyarI am Akash Padhiyar Founder of Shareittips.com,BCA MCA Tutor ,Running Web development compnay “AkashInfoTech”.More Posts – Website – Facebook

Share
Categories: Software, SQL
Jul
17

Installing Oracle 9i on Windows

Posted by Akash Padhiyar 0 Comment
finallogo

If you downloaded the Oracle9i from Oracle Technet, then you need to unzip the files into a three temporary directories and double click on the setup.exe program in the Disk1 directory) to get the installation process started. The following Welcome window will appear: Akash PadhiyarI am Akash Padhiyar Founder of Shareittips.com,BCA MCA Tutor ,Running Web development  [ Read More ]

Share
Categories: Software, SQL
Jul
16

SQL -Syntax List

Posted by Akash Padhiyar 0 Comment

SQL is followed by unique set of rules and guidelines called Syntax. This tutorial gives you a quick start with SQL by listing all the basic SQL Syntax: All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW and all the statements end with a  [ Read More ]

Share
Categories: SQL
Jul
16

SQL – Operators

Posted by Akash Padhiyar 0 Comment

What is an Operator in SQL? An operator is a reserved word or a character used primarily in an SQL statement’s WHERE clause to perform operation(s), such as comparisons and arithmetic operations. Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement. Arithmetic operators  [ Read More ]

Share
Categories: SQL
Jul
16

SQL Data Types

Posted by Akash Padhiyar 0 Comment

SQL data type is an attribute that specifies type of data of any object. Each column, variable and expression has related data type in SQL. You would use these data types while creating your tables. You would choose a particular data type for a table column based on your requirement. SQL Server offers six categories  [ Read More ]

Share
Categories: SQL
Jul
16

SQL – RDBMS Databases

Posted by Akash Padhiyar 0 Comment

There are many popular RDBMS available to work with. This tutorial gives a brief overview of few most popular RDBMS. This would help you to compare their basic features: MySQL MySQL is open source SQL database, which is developed by Swedish company MySQL AB. MySQL is pronounced “my ess-que-ell,” in contrast with SQL, pronounced “sequel.”  [ Read More ]

Share
Categories: SQL
Jul
15

SQL Commands

Posted by Akash Padhiyar 0 Comment

SQL Commands :- SQL commands are instructions used to communicate with the database to perform specific task that work with data. SQL commands can be used not only for searching the database but also to perform various other functions like, for example, you can create tables, add data to tables, or modify data, drop the  [ Read More ]

Share
Categories: SQL

Relational Databases A relational database at its simplest is a set of tables used for storing data. Each table has a unique name and may relate to one or more other tables in the database through common values. Tables A table in a database is a collection of rows and columns. Tables are also known  [ Read More ]

Share
Categories: SQL

Google Search

Popular Posts

Web Designer vs Web Developer

Web Designer vs Web

This Infographic explain you what is role of Web Designer and ...

Download Bluestack Offline

Download BlueStack O

Download BlueStack Offline  BlueStack is software in which you can run ...

FireCMD user interface

Command Prompt (cmd.

Serious geeks spend a lot of time at the command ...

Sponsors