tag

home / developersection / tag

How to tune SQL Server DBA
mssql server 07-May-2019
How to tune SQL Server DBA

Tuning a Database is not a simple task, it is a complex task. Where the performance issues performed by tuning process which is Trust Effort. The SQL server Dashboard, according to the database consultant, should examine this.

SQLite- TRIGGERS EXAMPLE
sqlite 28-Sep-2015
SQLite- TRIGGERS EXAMPLE

In this article we will see the TRIGGER example that is automatically col on INSERT, DELETE, UPDATE operation, its main purpose is creating a log of any type of operation being on database.

iOS : Creating Sample App Using SQLite Database
iphone 25-Sep-2015
iOS : Creating Sample App Using SQLite Database

In this article we will learn how to create iPhone app using SQLite Database as Back-End.

Use of JOIN clause in SQLite Database
sqlite 22-Sep-2015
Use of JOIN clause in SQLite Database

The SQLite Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.

SQLite – where clause
sqlite 16-Sep-2015
SQLite – where clause

In this article we are going see the SQLite WHERE clause that is used to specify a condition while fetching the data from one table or multiple tables.

SQLite - Expressions
sqlite 10-Sep-2015
SQLite - Expressions

SQL Expression is a combination of one or more values, operators and SQL functions that evaluate to a value.

SQLite Operators
sqlite 09-Sep-2015
SQLite Operators

Operators are used to build expressions. SQL operators are very similar to mathematical operators. SQLite supports unary and binary operators.

SQLite  - SELECT Query
sqlite 08-Sep-2015
SQLite - SELECT Query

SQLite SELECT statement is used to fetch the data from a SQLite database table which returns data in the form of result table.

SQLite - Data Type
sqlite 05-Sep-2015
SQLite - Data Type

SQLite data type is an attribute that specifies type of data of any object. Each column, variable and expression has related data type in SQLite.

SQLite Commands
sqlite 04-Sep-2015
SQLite Commands

Here we will discuss simple and useful commands used by SQLite programmers.