Sony Ericsson Vivaz pro

The Sony Ericsson Vivaz PRO has a 3.2″ resistive touchscreen with nHD resolution. A 3.5mm jack is also present. The internal memory is of 75MB and the external microSD slot is expandable up to 16GB (8GB card will come onboard). Sony Ericsson Vivaz PRO also has 3G support. Wi-Fi support is also present. The Bluetooth version is 2.1 with A2DP support.

Specifications:

Network: GSM 850/900/1800/1900, HSDPA 900/2100, HSDPA 850/1900/2100/800

Dimensions: 109 x 52 x 15 mm

Weight: 117 grams

Screen: 3.2 inch 16M colors TFT resistive touchscreen (360 x 640 pixels)

Processor: 720 MHz, PowerVR SGX GPU

OS: Symbian Series 60, 5th Edition

Camera: 5MP (2560 ? 1920 pixels), Autofocus, LED Flash, Touch Focus, Image Stabilization, Geo-Tagging, Face аnd Smile Detection, Video Recording HD 720p @ 24fps

Memory: 75MB RAM, microSD (up tο 32GB), 8GB included

Connectivity: A-GPS, GPRS / EDGE, 3G, Wi-Fi 802.11b/g/n, DLNA, Bluetooth v2.1 + A2DP, microUSB, HDMI port, 3.5mm audio Jack

Additional Features: Accelerometer, GPS, FM Radio + RDS, HTML browser, Adobe Flash 10.1, Digital Compass, MP3/MP4 Player, TrackID, NeoReader Barcode Scanner, Google Quest, Maps, Gmail, YouTube, Calendar, Google Talk, Facebook, Chirrup , QuickOffice document reader, TV out, Gesture hegemony

Battery: 1200mAh Li-Po

SQL Basic Commands

SQL -> Structured Query Language

SQL lets you access and manipulate databases

Command functions

* SELECT – extracts data from a database
* UPDATE – updates data in a database
* DELETE – deletes data from a database
* INSERT INTO – inserts new data into a database
* CREATE DATABASE – creates a new database
* ALTER DATABASE – modifies a database
* CREATE TABLE – creates a new table
* ALTER TABLE – modifies a table
* DROP TABLE – deletes a table
* CREATE INDEX – creates an index (search key)
* DROP INDEX – deletes an index

SELECT Syntax
SELECT column_name(s) (Type the name of the column)
FROM table_name (Type the name of the table)

DISTINCT Syntax
SELECT DISTINCT column_name(s)
FROM table_name

WHERE Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name operator value

INSERT INTO Syntax
INSERT INTO table_name (column1, column2, column3,…)
VALUES (value1, value2, value3,…)

UPDATE Syntax
UPDATE table_name
SET column1=value, column2=value2,…
WHERE some_column=some_value

DELETE Syntax
DELETE FROM table_name
WHERE some_column=some_value

(example)
DELETE FROM Car (Table name)
WHERE LastName=’City’ AND FirstName=’Honda’

INNER JOIN Syntax
SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name

LEFT JOIN Syntax
SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2
ON table_name1.column_name=table_name2.column_name

RIGHT JOIN Syntax
SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name=table_name2.column_name

FULL JOIN Syntax
SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON table_name1.column_name=table_name2.column_name

PRIMARY KEY
CREATE TABLE_NAME
(
Column_name1 int NOT NULL PRIMARY KEY,
Column_name2 varchar(255) NOT NULL,
Column_name3 varchar(255),
Column_name4 varchar(255),
Column_name5 varchar(255)
)

FOREIGN KEY

A FOREIGN KEY in one table points to a PRIMARY KEY in another table.

CREATE TABLE_NAME
(
Column_name1 int NOT NULL PRIMARY KEY,
Column_name2 int NOT NULL,
Column_name3 int FOREIGN KEY REFERENCES Table_name1.(Column_name1)
)

Google Chrome OS

Google is one of the largest companies with all the software and the services they provide, and they want that to continue. Since the launch of Google Android operating system, Google has been working hard on the long-awaited operating system from Google Chrome. From what we have learned, we know about Google Chrome OS and in June this year.

Acer and underlying company must submit Chrome on OS Computex Taipei this year. As you probably know, is known for Acer notebooks and all kinds of mobile solutions, but Asus will offer at Computex this year? We might suppose, but we know you will use Chrome OS.

As for the operating system and Google Chrome is designed to be specialized operating system for network applications, most of them are powered by Google. It is based on Linux and it’s no coincidence that we call Chrome, like its popular browser. You need the Chrome’s minimalist design and transfers it to a web based operating system provides the same speed and simplicity that your browser Chrome a. It is designed for users who spend most of their time online so we can see a netbook from Acer in June

Anyway, Google has announced that Chrome will release their OS in 2010, so that we can only wait and see how to deal with Google OS with other operating systems on the market.

IPhone 4G / iSlate tablet

This is a good visual of all the rumors that have been underway for possibly the next 4G iPhone / Apple islate Tablet . Its functionality is most likely predicted OLED and five megapixel camera. It is also important to consider the possibility of faster half of the options for dual-core processor and a touchscreen.

Android phone – Motorola MOTOROI

Motorola-Motoroi-XT720-Android phone

The smartphone includes a camera of 8 mega-pixels with xenon flash and a 720p HD camcorder, empowerment capture precious moments of life on the high quality photos and video. The unit ensures photos through image capture functions with intelligent red-eye correction, face detection and more. Using the HDMI port, you can watch videos in HD from your phone on their television screens.

With MOTOROI large 3.7 inch WVGA touch screen, will have greater access to games, photos, music and more. The combination of an intuitive touch sensor and an advanced user interface of the company, the device offers a smoother operation. Other entertainment features include an MP3 player, terrestrial DMB, Jack 3.5 mm ear and a resort exclusively designed home.

The Motorola MOTOROI also addresses the need for companies through its Advanced Office Mobile package. It easily handles multiple accounts and also features text recognition. The multitasking device facilitates the publication of official documents through Microsoft and PDF readers.

Like other smartphones, WiFi technology opens the door to the Internet, revealing many online services. The Web browser Android Kit supports many services offered by Google, like Google Maps, Gmail, YouTube and Google Talk. Motorola Android Powered MOTOROI be available in early February by SK Telecom and retail channel partners.

DELL-Inspiron Mini Zino HD-desktop

Inspiron Mini Zino HD-desktop

The new Inspiron Mini Zino HD-desktop. You will be surprised how many powerful features found within this very small 7.8 “by 7.8” square.

Designed to fit almost anywhere, the Inspiron Zino power supply units and HD entertainment by 8 “by 8” on the package. And with the option of exchanging a selection of 7 vibrant colors, plus 3 unique designs, HD Zino can mix and appear. Choose the standard piano black finish and customize your own with one or more of these styles: Pink Flamingo, Formula Red, Tangerine Orange, Plum Purple, True Blue, Spring Green and a choice of 3 modes of artists Derek Welch, Mike Ming and Brittany Waldner.

Entertainment Hi Def
Enjoy all your favorite movies as they were on the big screen with DVD-RW or Blu-ray DiscTM. Or, transform your living room in his movies by connecting to an HDTV via the HDMI port.

Media Card Reader
Quickly transfer digital photos and music from your digital camera with the optional 4-in-1 card reader.

Ports potential
Connect your digital devices with 4 USB ports, 2 of which are in the front for convenient access. And with an extra 2 eSATA ports, can connect to multiple devices like an external hard drive.

Impressive Power

All that is small, the size is Zino HD. This clear and direct mini office has its fair share of powerful features.

Processor
Be prepared for today and tomorrow. The AMD dual-core Athlon ™ offer outstanding performance in a rapidly changing world of technology.

Playlists
Watch the screen are made to life with integrated ATI Radeon HD3200 graphics3 and optional discrete ATI graphics3.

Storage
See, love, save it. Store your favorite music, photos and video with up to 1TB2 a hard drive.

NOKIA N900

Nokia released a few videos about Nokia newly launched N900 phone and his Maemo OS.It’s a high performance mobile computer with advanced Maemo 5 software on Linux. Explore Nokia N900 features like multitasking on a live Dashboard, wide screen video capture, 3,5“ WVGA touch display (800 x 480 pixels), QWERTY keyboard and personalisable panorama desktop.

Nokia N900 phone and mobile computer: Technical Specifications:

Display – 3.5 inch touch-sensitive widescreen display
800 × 480 pixel resolution

Processor and 3D accelerator – TI OMAP 3430: ARM Cortex-A8 600 MHz
PowerVR SGX with OpenGL ES 2.0 support

Memory – Up to 1GB of application memory
(256 MB RAM, 768 MB virtual memory)

Mass memory – 32 GB internal storage
Store up to 7000 MP3 songs or 40 hours of high-quality video
Up to 16 GB of additional storage with an external microSD card

GPS and navigation – Integrated GPS, Assisted-GPS, and Cell-based receivers
Pre-loaded Ovi Maps application
Automatic geotagging

The Nokia N900 also features 1 GB of application memory and up to 48GB of storage. Maemo browser is powered by Mozilla Technology and includes Adobe Flash 9.4 and full AJAX support. Wi-Fi and 3.5G connectivity provides fast access to Internet. Take high quality photos and wide screen videos using 5Mpix camera with Carl Zeiss optics.

THE MAC TABLET PC-POWERED BY APPLE

No words to describe this note book from apple its just out of imagination.An imagination brought in to reality by apple a note book with a thickness of just 0.38(8mm) and resolution of 2540 Lines Per Inch .

It has all kind of features like Wireless, Text-To-Speech, PDF support.And according to the report suggests that Foxconn will manufacture the new device.No need for a Keyboard, this futuristic device will feature a pen and handwriting recognition ,the touch screen of this new device will lift the new Apple tablet in the ever-popular NOTEBOOK market.

And it is expected that the price of this gadget will be around $500-$600.It is expected that apple will release this by october and create it’s own cpu design.Mac tablet is truly a revolution and surely will be the next generation pc.

GOOGLE CHROME

google-chrome

Most of us still have got addicted to the usage of internet explorer as the web browser but web browser’s like fire fox,opera, safari with advanced plugins have more advantages and are more user friendly which most of us have never explored.

One among them is the latest release by google the GOOGLE CHROME web browser i really felt advantageous when i used it, compared to any other browser it just brings up the search data in a relatively quicker time as google chrome is related with google search engine the search results are getting displayed fast.

Initially available for Windows Vista and XP, Google plans to expand its Chrome offerings to the Mac and Linux platforms as well.Chrome imports your bookmarks, passwords, and settings datas from Firefox or Internet Explorer. It even can acquire username and password data, and it automatically populates those fields for you when you use Chrome for the first time to visit a particular site, your username and password will be automatically filled in .

The browser also includes a java script called V8 and because of this JavaScript performance in the browser is increased.Google also say they’re using a “multi-process design” which they say “a bit more memory up front” but over time also “less memory bloat.”

The tabs that are available in google chrome are entirely different from others ,the tabs are present on the upper part of the window and you will feel different when you are using chrome for the first time.

The browser has an option of auto completion and before you type in your search word lot of search items will be listed below so that you can narrow down your search.The home page that is present in chrome is similarly related towards opera and a list of 9 thumb nails with most related search results will be displayed and also your recently bookmarked pages, as well as recently closed tabs will be displayed.

To fight malware attempts, Chrome constantly downloads lists of harmful sites. Google also promises that whatever runs in a tab is sandboxed so that it won’t affect your machine and can be safely closed. And Chrome also has an idea to add a task manager that gives the user an idea of how much memory and CPU use a page is consuming, and by allowing you to close anything that is causing a slow browse problem. But you should configure this tool on your own.

So google has produced an awesome user friendly browser and which is a powerful tool to help the needs of advanced users.There were talks that google will be releasing it’s operating system and this web browser release by google shows out one thing clearly the google chrome browser is specially made for google operating system.

Macintosh Operating System-review

Macintosh operating system is one of the best innovations of apple.But it is hard for people who are using windows operating system to get used to mac os but not a big deal can get used to it in a little bit of time.

Mac OS X 10.5 Leopard is Apple’s first major operating system it has more than three hundred features .Mac OS X 10.5 Leopard will cost you around $129 and up to five users can install it .

Mac OS X 10.5 Leopard will take an installation time of around 40 mins on an mac book.To run Leopard, you’ll need an Intel or PowerPC G5 Mac. A PowerPC-based G4 Mac with an 867MHz or better processor will work, as well. Apple suggests having 512MB of RAM.The boot time for this operating system is around 28 seconds.

Additionally, you’ll need a USB or FireWire external backup drive to use Time Machine. Features on iChat require a Webcam.After installation when you start to use it most of the design element features are same as in an iphone for example the slide show feature that you get in an iphone.

In case if you want to restore an earlier file just go to an earlier time and click on the restore button you will be zoomed back to your present desktop.But apple doesn’t provide you the option of password-protection and encryption options but if you are using mac for a long time then you can explore such options easily.Ichat helps you with the option of sharing files and can control each other desktops.

Mac’s mail options has 32 e-mail templates which enable you to drop in pictures and resize them with a built-in photo browser.And you are also provided with one of the coolest web browser which is the safari, there is also options for connecting more cameras via cable or Wi-Fi, and for other gadgets via Bluetooth.

The firewall which is present in this operating system is not turned on by default as in windows xp or vista and parental controls are available which can help in case if it is an young web browser .

The system configuration that is required for this operating system is 2×2.66GHz Xeon X5355 (note that this is not a production configuration); 2GB 667MHz DDR2 FB-DIMM; 5126MB ATI X1900 graphics card; 500GB 7,200rpm hard drive.