Company Information

QRCode for Mobile Website
Visit our Mobile website.
Our Blog

Public Courses

Data Dog - Training your Data
Data Dog understands your Database issues.
Oracle

Microsoft

Java Training

Management

Today.com: Tech

Students can't resist distraction for two minutes ... neither can you



Aimee Copeland gets new high-tech hands

In a major milestone, Aimee Copeland, the Georgia graduate student who contracted flesh-eating bacteria after a zip-lining accident, is learning to use two state-of-the art prosthetic hands. The high-tech hands may one day allow her to do the kinds of things most of us take for granted: cooking, cleaning, driving a car. In May 2012, a wound Copeland sustained in her accident developed necrotizing ...

'Vampires,' hit men and more lurk in shocking online classifieds

Here's a quick look at Chris Hansen's upcoming video series "Wild Wild Web," that you can see in a new 2-hour Dateline that airs Friday night at 8 p.m. on NBC.

Google I/O keynote: A music service, revamped Maps and Larry Page

Google I/O, the tech giant's annual developer's conference, kicked off Wednesday with a keynote event in San Francisco. Though the show lacked a sky-diving stunt and new hardware (both which were the stars last year), the company offered up a new music service, redesigned Maps — and a surprise Q&A by a hoarse CEO Larry Page, who recently disclosed the nature of his ailment. "Welcome to the six...

Identity thieves busted by Instagram obsession

A man's inability to refrain from sharing his steak and mac n' cheese meal on Instagram got him and his partner-in-crime busted for identity theft. Some might argue that this is a karma's punishment for spamming social media with "food porn," but there's more to the story.According to court documents, Nathaniel Troy Maye and Tiwanna Tenise Thomason plead guilty to possession of unauthorized access...

Google Maps gets new look, built-in Earth and (later) mobile update

Google Maps got a few significant updates at the company's I/O event in San Francisco Wednesday, with a refreshed look and some handy new features aimed at letting you explore your surroundings without keyword searching. The updated maps will be coming to desktop and mobile, though you may have to wait a bit to try them out.The familiar mobile app (now seen on both Android and iOS) is getting a fe...

Google I/O begins: A music service, revamped Maps and more

Google I/O, the tech giant's annual developer's conference, kicked off today, with a keynote event in San Francisco and the latest on Android, a music service, a new version of the Samsung Galaxy S4, redesigned Maps, and more. "Welcome to the sixth annual Google I/O," senior vice president Vic Gundotra began before thanking developers for their work so far. (It is a developer-focused conference a...

Google I/O begins: Expect a music service, revamped Maps and more

Google I/O, the tech giant's annual developer's conference, kicked off today, with a keynote event in San Francisco and the latest on Android, shiny new Maps, and more. "Welcome to the sixth annual Google I/O," senior vice president Vic Gundotra began before thanking developers for their work so far. (It is a developer-focused conference after all.) Gundotra quickly turned the stage over to Googl...

LulzSec hackers 'at cutting edge' of cyber crime, court told

LONDON (Reuters) - Four British hackers who took part in 2011 cyber-attacks on targets ranging from the CIA to Sony were audacious, arrogant men whose motivation was "anarchic self-amusement", a court heard on Wednesday.The men, who have pleaded guilty to a variety of offences, were members of the hacking collective LulzSec that caused millions of dollars of damage to corporate and government ...

How not to be a 'creeper' on social media

Just met a really interesting guy or gal? These days, the first thing most people do is turn to social media to find out everything they can about the person. But this can lead to disaster—and quickly get you labeled as a creeper. First date? It's not going to happen if you're sloppy while sleuthing. When it comes to using social media, consult an expert—also known as a teenager. Our resident...


Tech Republic News

Reverse engineering your .NET applications

The .NET Framework makes it easy to reverse engineer an existing application. Discover what techniques to use to deter prying eyes from deconstructing your code.

BoomerangDoc: Another secure file sharing solution

Find out why Will Kelly isn't very impressed with BoomerangDoc, a secure file sharing app for iOS devices.

Review: EZ Opp for Microsoft Dynamics CRM

Manage CRM sales data on the go with ease using a Windows RT or Windows 8 tablet.

Personal social media? Not on company time

Using social media for personal reasons at work is widely frowned upon by those taking a recent TechRepublic survey and by those commenting on it.

Do students who are issued tablets miss the benefits of experiential learning?

What is your opinion about tablet initiatives in schools for the sake of education? Are students missing out on the benefits of experiential learning?

Quick Tip: Work with your Google Calendar in Outlook

Google Apps Sync lets you use your Google calendar in Microsoft Outlook. Find out why this can be handy and how to set it up.

How to harness Big Data in motion

Here are some of the technologies that companies need to look at if they want real-time big data analytics.

10 key questions about software-defined networking

Software-defined networking promises to deliver enormous benefits, from reduced costs to more efficient network operations. Here's why SDN belongs on your network roadmap.

How app developers can get their pots of gold

There are more ways than ever to create and consume content. This is good news for software developers, who now have even more opportunities to strike it rich.

Android Studio can fix Android development

Google has finally decided to get rid of the Eclipse albatross from Android's neck.


Information

On-Site Training - Have wheels will travel !!
On-site training course details, Click to view.
ComputerWorld - News

Dell replays Windows 8 blame card as PC sales slide

Dell last week again blamed Windows 8 for contributing to a decline in PC sales revenue during the quarter that ended May 3.

Report: Yahoo board approves deal to buy Tumblr for $1.1B

Yahoo's board of directors has approved spending $1.1 billion in cash to buy popular blogging site Tumblr, according to The Wall Street Journal.

Q&A: Bitcoin developer talks regulation, open source and the elusive Satoshi Nakamoto

With Bitcoin all the rage and startups popping up left and right, it's hard to know who's an expert in the virtual currency and who just has an opinion. Most people would put Jeff Garzik in the former camp.

Bitcoiners rally to enlighten Washington

Washington's biggest problem when it comes to Bitcoin may just be that policymakers on the Hill don't know enough about it, yet.

Bitcoiners crave coders to cope with demand

Bitcoin is not going away, the digital currency's developers say, and they're craving more technically savvy people to support its use.

Bitcoin's rollercoaster ride is not slowing down

More bumps in the road are probably in store for Bitcoin. The virtual currency has seen some massive swings in value over the last several weeks, but that volatility is not likely to end soon, its lead developer suggested on Saturday.

Google Now, Hangouts feel here, there and everywhere

Google this week unleashed a blizzard of updates and improvements that fundamentally change -- and radically improve -- how we get information and communicate.

Bitcoin finding its feet at first Silicon Valley conference

Bitcoin is growing up. The virtual currency that caught the public's attention last month when its value zoomed briefly past $200 kicked off its first Silicon Valley conference Friday evening and shows no sign of losing momentum.

Even without big Apps news at I/O, small changes matter

Apps, Google's flagship product for enterprise IT, had a minor presence at this week's I/O developer conference, but some announcements at the show and in prior weeks deserve attention from customers of the cloud email and collaboration suite.

At Google I/O, developer services hogged the spotlight

Forget Glass, self-driving cars or a smartwatch. Developers, not physical consumer products, were Google's darlings at the company's annual I/O conference this week.


Fifa News

Porto claim Portuguese title, Benfica win

Porto claimed their third consecutive Portuguese Liga title and ninth in 11 years after beating Pacos de Ferreira 2-0 Sunday, as Benfica also won to secure second place.

Milan late-show saves Champions League berth

A late Phillipe Mexes goal gave AC Milan a 2-1 comeback victory at relegated Siena to push I Rossoneri into Serie A's final UEFA Champions League position and consign Fiorentina to fourth.

Arsenal clinch fourth, Spurs fifth

Arsenal held on to edge Newcastle United 1-0 in the final day of the Premier League season, meaning the Gunners secured the fourth and final UEFA Champions League position, while Tottenham Hotspur beat Sunderland 1-0 to finish fifth.

Uruguay and Brazil prove opposites attract

Ahead of La Celeste's visit to the FIFA Confederations Cup Brazil 2013, FIFA.com takes a look at the special relationship between Uruguayan and Brazilian football.

Genes: Paraguay want to be favourites in Turkey

Following a friendly against Spain, part of their preparations for the FIFA U-20 World Cup, La Albirroja boss Victor Genes discussed his squad’s goals for the competition.

 

Barça win, Zaragoza slip to danger

Barcelona beat Valladolid 2-1 at Camp Nou to keep the La Liga winners on track for 100 points this season, while Real Zaragoza dropped a 2-1 result to Athletic Bilbao and slipped into the third relegation spot.

The Week in Quotes

Featuring Ludovic Giuly on making a fashion mistake at Barcelona, Marco Schallibaum on the amazing toughness of Jeb Brovsky and Gabriel Batistuta on what playing alongside Lionel Messi would have forced him to do.

How did you rate Beckham?

FIFA.com wants to know how good you thought David Beckham was and what are your best memories of his playing career.

Mazzarri confirms Napoli exit

After four years at Napoli, coach Walter Mazzarri has announced he is stepping down, saying he has taken the Serie A runners-up "as far as he can."

Ancelotti requests PSG release

Paris Saint-Germain sporting director Leonardo has said coach Carlo Ancelotti has asked to be released from his contract with the capital club, though no decision been taken.


Oracle Web Site

Valid HTML5

Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Valid CSS!

Get Adobe Reader



 
Contents

This course concentrates purely on data extraction and manipulation and is ideal for users who will not have permission to do anything other than create select statements.
The following aspects are included:

The SQLPlus Interface
Single Oracle Table queries
Oracle functions in the select statement
Where clauses to limit data


Exercises

There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.
The exercises include

Navigation of SQL Plus
Manipulating data using Oracle functions
Selecting records using querying
Saving results of Oracle Queries into output files



Duration

One Day

Simple SQL for Users

Oracle SQL for Users
Part 1 Training Course

Synopsis

A simple breakdown of SQL for users who need to extract information from an Oracle Database.

Delegates who need more comprehensive information such as relational techniques or creating Objects should refer to our other SQL based courses

Course Preview

The following options give examples of Course content ...

Index of Training Course Index of Training Course (html) Example pages of Delegate Manual Sample exercise


Pre-Requisite Course(s)

None

Suggested Further Course(s)

SQL for Users Part II



This intensive training course has a dynamic face to face, tutor led learning framework and is delivered by an experienced Oracle professional. In-depth course notes are provided in a presentation file for the delegate to use, and this becomes a valuable reference guide following the course.

On completion all delegates receive a certificate.



On Site or Off Site ?

On Site

All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor. We will provide each delegate with an individual laptop and all other equipment that is required.

Off Site

If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).



Weekday or Weekend ?

This course has the provision to be delivered over the weekend.
Ideal for your company, if you are working on projects with tight timescales or need to train employees with incredibly busy working weeks.



Standard or Customised ?

If you feel that this is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).



Contact Details

Please contact us on
+44 (0) 800 157 7519 or email at training@seercomputing.com