[vicsireland] Re: Using sql with jaws 8
- From: Mairead O Mahony <maireadomahony@xxxxxxxxx>
- To: vicsireland@xxxxxxxxxxxxx
- Date: Wed, 9 Sep 2009 20:01:56 +0100
Hi all
Thanks to everyone who replied to my email about using sql with jaws.
At the moment I am checking out what Gui we will be using. As far as
I am aware we will be using Sql with Microsoft access but I need to
get that confirmed. Any other suggestions are greatly appreciated.
Thanks in advance
Mairead
On 9/9/09, Tony.G.Murray@xxxxxx <Tony.G.Murray@xxxxxx> wrote:
> Hi Mairead,
>
> "I am using jaws 8 and would appreciate it if anyone could let me know for
> definit if sql works with jaws. "
>
> SQL (Structured Query Language) is a computer language used for
> manipulating relational Databases and their contents. Like a lot of
> computer programming languages, it is simply text which is interpreted by
> the machine. So in that sense, yes SQL definitely works with Jaws.
>
> Now then, SQL is often used in conjunction with a relational DBMS
> (Database Management System), which is basically an environment in which
> your relational database and the tools you use to manage/access it are
> living. There are lots of very widely used DBMS', like Oracle, SQL
> Server, MySQL, the list goes on and on and on. A lesser DBMS is
> Microsoft's Access, but this wouldn't be considered an enterprise DBMS; it
> is limited in the data it can store. It's a nice way to learn Relational
> Database methodologies etc, and is probably used behind some smaller web
> applications or in small office environments, but that's about it.
>
> When you say 'SQL' could you possibly be referring to SQL Server? This is
> Microsoft's bigger DBMS, which is often just called 'SQL'. This is a
> pretty crazy way to refer to something like SQL Server, but that's
> unfortunately computing... init! For the rest of this mail, when I say SQL
> I mean the computer language, and when I say SQL Server, I mean... you've
> guessed it, SQL Server the Relational Database Management System!
>
> If you are indeed talking about Microsoft SQL Server, the news is good.
> I've used SQL Server 97/2000/2005 in my time. The SQL Server Tools (which
> are part of the DBMS) allow you to do everything you could possibly want
> to do with a Database, or the data stored within one.
>
> There are two major ways of accessing the Microsoft SQL Server Database.
> One is through SQL (and I mean the computer language remember), and the
> other is through a visual interface.
>
> SQL can be typed out in an editor provided as part of SQL Server, and
> executed against your database. This is very very accessible and easy to
> use... AS easy as Notepad! The editor contained within SQL Server to do
> this is called 'Query Analyser', or something similar depending on the
> version of SQL Server you're using.
>
> The other way is through the visual tool, called 'Enterprise Manager' or
> 'Management Studio', again depending on the version of SQL Server you're
> working with. This allows you to do everything you can do through SQL and
> more, without having to actually know the language. It too is pretty
> accessible, when you get to know the environment. It's mainly tree views,
> lists, menus... All the normal stuff Microsoft has got us all so used to.
>
> "I would also appreciate it if someone could
> let me know if I need to download scripts to increase the functionality of
> Sql."
>
> To be honest, I didn't know there were scripts available... but that's no
> surprise! I'm not so well up on Jaws, even though I use it every day. If
> there are scripts available, and you are talking about SQL Server, I'm
> sure someone on here can help you to install them.
>
> All the above assumes that when you say 'SQL', you mean Microsoft's SQL
> Server. However, if you're not talking about SQL Server, I think you'll
> be safe enough when it comes to programming in SQL (the language). Once
> you know how to write SQL, you'll be able to access and use most
> Relational DBMS', like Oracle, Microsoft SQL Server, MySQL, all those. SQL
> is simply a language used to access all sorts of relational databases...
> Kind of like a skeleton key! You can get in to any relational database if
> you've a bit of SQL knowledge. Beautiful huh?
>
> To finish, I'll say that SQL is a nice language to learn. It looks very
> much like English; it is based on a bunch of keywords, some logical
> operators, and that's about it.
>
> For example, let's say you have a table in your database called
> UserInformationTable containing names and addresses.... The SQL to show
> you all the names in that table might look something like:
> SELECT FirstName, LastName FROM UserInformationTable;
>
> Not bad eh?
>
> Best wishes,
>
> Tony Murray
>
> Internet Solutions,
> AIB Enterprise Systems & Technology,
> Block B0,
> AIB Bankcentre,
> Ballsbridge,
> Dublin 4.
>
> T: +353 (0) 164 13801
> E: tony.g.murray@xxxxxx
>
> ===========================================================
> The vicsireland mailing list
>
> To unsubscribe at any time send a mail to:
>
> vicsireland-request@xxxxxxxxxxxxx
>
> with the word "unsubscribe", without the quotes in the subject of the
> message.
>
> To contact the moderator send mail to:
>
> tim.j.culhane@xxxxxxxxx
>
> For mor information on the Visually Impaired Computer Society visit:
>
> http://www.vicsireland.org
>
>
===========================================================
The vicsireland mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
Other related posts:
