Help a Newbie Out... SQL Learning...

I am attanding school for Database Administration, still taking all the
English Classes and other requirements, but soon that will be over
with. I wanted to get a head start with SQL, I installed SQL 2005
Server Standard Edition, not the Enterprise one.
I installed it on my Laptop for learning purposes running Windows XP
Pro SP2, and it runs just fine. So I used some of the Tools to view
the tree of everything, the Tables and all that, but here is my
question.
Before I go on, the only experiance with SQL I have is from Linux,
working with the MySQL Open Source package, so I know some of the
commands for viewing Tables and all that and creating them, but nothing
too complex past this point, no scripting, however I do know VBA for
Excel and some with Access.
For someone new like me, where should I start ?
I have lots of Excel experiance, am good at it and also am good in
Access.
With Access you can create your Tables and put the data in there, the
FORMs and all that.
But with SQL, I am confused as to how to create the TABLES with the set
of tools that came with it. Is there a totally different product that
I must use to create the tables on the locahost for learning purposes
or what ?
Which books should I buy ?
Thanks for your input!!!!I figured out how to create a new Database using the SQL Server
Management Studio Tool, and then I created a Table too and now I am
creating the Table contents, different Columns.
What is the best way to enter the data into the Table ?
Are there like FORMs that exists, where once the Table is setup, people
can enter the datainto the Table remotely, say within the local
network, here where I work ?
Thanks!!!
RompStar wrote:
> I am attanding school for Database Administration, still taking all the
> English Classes and other requirements, but soon that will be over
> with. I wanted to get a head start with SQL, I installed SQL 2005
> Server Standard Edition, not the Enterprise one.
> I installed it on my Laptop for learning purposes running Windows XP
> Pro SP2, and it runs just fine. So I used some of the Tools to view
> the tree of everything, the Tables and all that, but here is my
> question.
> Before I go on, the only experiance with SQL I have is from Linux,
> working with the MySQL Open Source package, so I know some of the
> commands for viewing Tables and all that and creating them, but nothing
> too complex past this point, no scripting, however I do know VBA for
> Excel and some with Access.
> For someone new like me, where should I start ?
> I have lots of Excel experiance, am good at it and also am good in
> Access.
> With Access you can create your Tables and put the data in there, the
> FORMs and all that.
> But with SQL, I am confused as to how to create the TABLES with the set
> of tools that came with it. Is there a totally different product that
> I must use to create the tables on the locahost for learning purposes
> or what ?
> Which books should I buy ?
> Thanks for your input!!!!|||On 12 Sep 2006 15:49:44 -0700, "RompStar" <rmiecznik@.comcast.net>
wrote:
>But with SQL, I am confused as to how to create the TABLES with the set
>of tools that came with it. Is there a totally different product that
>I must use to create the tables on the locahost for learning purposes
>or what ?
You should learn to create tables using the query window built into
Management Studio. Forget the GUI tools for building tables, at least
until you can do them easily as straight CREATE TABLE commands. The
same goes for creating views and stored procedures. Anyone who
intends to function as a DBA has to be able to work that way. So open
up the Books on Line, and start learning the command syntax.
The GUI tools are fine for viewing what objects exist and how they are
defined, however.
Roy Harvey
Beacon Falls, CT|||RompStar wrote:
> I figured out how to create a new Database using the SQL Server
> Management Studio Tool, and then I created a Table too and now I am
> creating the Table contents, different Columns.
> What is the best way to enter the data into the Table ?
> Are there like FORMs that exists, where once the Table is setup, people
> can enter the datainto the Table remotely, say within the local
> network, here where I work ?
> Thanks!!!
>
> RompStar wrote:
>> I am attanding school for Database Administration, still taking all the
>> English Classes and other requirements, but soon that will be over
>> with. I wanted to get a head start with SQL, I installed SQL 2005
>> Server Standard Edition, not the Enterprise one.
>> I installed it on my Laptop for learning purposes running Windows XP
>> Pro SP2, and it runs just fine. So I used some of the Tools to view
>> the tree of everything, the Tables and all that, but here is my
>> question.
>> Before I go on, the only experiance with SQL I have is from Linux,
>> working with the MySQL Open Source package, so I know some of the
>> commands for viewing Tables and all that and creating them, but nothing
>> too complex past this point, no scripting, however I do know VBA for
>> Excel and some with Access.
>> For someone new like me, where should I start ?
>> I have lots of Excel experiance, am good at it and also am good in
>> Access.
>> With Access you can create your Tables and put the data in there, the
>> FORMs and all that.
>> But with SQL, I am confused as to how to create the TABLES with the set
>> of tools that came with it. Is there a totally different product that
>> I must use to create the tables on the locahost for learning purposes
>> or what ?
>> Which books should I buy ?
>> Thanks for your input!!!!
>
Hi
SQL Server it self hasn't got any "input" interface for users. You can
to some extend work with data from SQL Server Management Studio and you
can write all the queries you like from Query Analyzer (or Query Editor
as I think it's called in Management Studio) but that's not for regular
users.
Instead you'll have to either create some forms etc. in Access and then
use a SQL server Table as storage or you'll have to write your own
application.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator|||Great, good info. I am not afraid to use commands, that's all one uses
when running servers using Sun OS and Linux, I am used to running that
for over 12 years.
I prefer command line anyways.
Which books are boog for beginners, I want to learn all the syntax, and
whatever programming tools they offer, like in Access I can do VBA, and
examples on how to develop different FORMs.
Please recommend books for a Newbie, I want to do very well in all my
classes, thus why I am getting a head starts, I won't start my classes
for about another 6 months.
Thanks!
Steen Persson (DK) wrote:
> RompStar wrote:
> > I figured out how to create a new Database using the SQL Server
> > Management Studio Tool, and then I created a Table too and now I am
> > creating the Table contents, different Columns.
> >
> > What is the best way to enter the data into the Table ?
> >
> > Are there like FORMs that exists, where once the Table is setup, people
> > can enter the datainto the Table remotely, say within the local
> > network, here where I work ?
> >
> > Thanks!!!
> >
> >
> > RompStar wrote:
> >
> >> I am attanding school for Database Administration, still taking all the
> >> English Classes and other requirements, but soon that will be over
> >> with. I wanted to get a head start with SQL, I installed SQL 2005
> >> Server Standard Edition, not the Enterprise one.
> >>
> >> I installed it on my Laptop for learning purposes running Windows XP
> >> Pro SP2, and it runs just fine. So I used some of the Tools to view
> >> the tree of everything, the Tables and all that, but here is my
> >> question.
> >>
> >> Before I go on, the only experiance with SQL I have is from Linux,
> >> working with the MySQL Open Source package, so I know some of the
> >> commands for viewing Tables and all that and creating them, but nothing
> >> too complex past this point, no scripting, however I do know VBA for
> >> Excel and some with Access.
> >>
> >> For someone new like me, where should I start ?
> >>
> >> I have lots of Excel experiance, am good at it and also am good in
> >> Access.
> >>
> >> With Access you can create your Tables and put the data in there, the
> >> FORMs and all that.
> >>
> >> But with SQL, I am confused as to how to create the TABLES with the set
> >> of tools that came with it. Is there a totally different product that
> >> I must use to create the tables on the locahost for learning purposes
> >> or what ?
> >>
> >> Which books should I buy ?
> >>
> >> Thanks for your input!!!!
> >>
> >
> >
> Hi
> SQL Server it self hasn't got any "input" interface for users. You can
> to some extend work with data from SQL Server Management Studio and you
> can write all the queries you like from Query Analyzer (or Query Editor
> as I think it's called in Management Studio) but that's not for regular
> users.
> Instead you'll have to either create some forms etc. in Access and then
> use a SQL server Table as storage or you'll have to write your own
> application.
>
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator|||"RompStar" <rmiecznik@.comcast.net> wrote in message
news:1158102439.117633.76600@.m73g2000cwd.googlegroups.com...
> Are there like FORMs that exists, where once the Table is setup, people
> can enter the datainto the Table remotely, say within the local
> network, here where I work ?
If you have a background in Access, you might check out Access Data
Projects. Basically, you use Access as a front-end interface to SQL's
back-end. It is similar to a 'regular' Access MDB database.
Jonathan