Re: Follow up query from Fresher - Aaron Bertrand

From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 21:51:56 -0000

Start with Database Design for Mere Mortals, you need a decent introduction
to the ideas behind a relational database. Then read something about writing
SQL. There is another Mere Mortals book about writing queries, but I haven't
read that. If you like DDfMM though, you'll probably want to read that one
as well. Or you can read that SAMS book. I have seen people at work with
SAMS books, and they look pretty basic. Next read something about database
administration (Admin911 by Brian Knight is good), then Inside SQL Server
and a performance tuning book. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Alok" <anonymous@discussions.microsoft.com> wrote in message
news:1190f01c41018$0ea91cc0$a101280a@phx.gbl...
> Hi Aaron & Jacco,
>
> Thanks for helping a newbie. Meanwhile I purchased some of
> the below books.
>
> 1.Database Design for Mere Mortals ( yet to purchase)
> 2.Murach's SQL for SQL Server + SQL Server Books online.
> 3.Guru's Guide to T SQL ( yet to purchase)
> 4.Inside SQL Server 2000
> 5.Writing Stored Procedures for Microsoft SQL Server-SAMS
> 6.SQL Server 2000 Database Design - Wrox Press
> 7.SQL Server Operations Guide - MS Press
> 8.SQL Server Performance Tuning Tech. Ref.
> 9.SQL Server Performance Optimization by Don jones - took
> print from pdf and binded.
> 10.Fast answers for Programmers and DBA's
>  ( yet to purchase)
> 11. SQL Server 2000 Pocket Consultant.(yet to purchase)
> 12. SQL Server 2000 Companion (yet to purchase)
>
> Is there any order suggested to read the above books :-).
> I am once again giving work to your hands.
>
> Thanks & Regards
>
> Alok.
> >-----Original Message-----
> >"Database Design for Mere Mortals" by Micheal Hernandez
> is a good book to
> >start with.
> >
> >-- 
> >Jacco Schalkwijk
> >SQL Server MVP
> >
> >
> >"Alok" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:1158a01c40fcd$3e8e9320$a101280a@phx.gbl...
> >> Hi Aaron,
> >>
> >> Thanks for the URL and the inputs. What do you think is
> a
> >> good book to learn **Basic Relational Database
> >> Theory**.please suggest in view that I am a Bran New guy
> >> for SQL and RDBMS.
> >>
> >> Regards
> >>
> >> Alok
> >> >-----Original Message-----
> >> >For SQL Server, see http://www.aspfaq.com/2423
> >> >
> >> >But I strongly recommend you learn some basic
> relational
> >> database theory
> >> >first.  Many people jump into SQL Server and get tied
> up
> >> thinking about
> >> >sequential, file-based storage and row-by-row
> operations,
> >> and this is not
> >> >what a normalized relational database is about.
> >> >
> >> >-- 
> >> >Aaron Bertrand
> >> >SQL Server MVP
> >> >http://www.aspfaq.com/
> >> >
> >> >
> >> >"Alok" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >news:c02d01c40e8f$d1bad0d0$a001280a@phx.gbl...
> >> >> Dear SQL Gurus,
> >> >>
> >> >> I am brand new to RDBMS and SQL Server 2000. I want
> to
> >> >> make SQL Server 2000 as my career as programmer and
> DBA.
> >> >> Where do i start. Please suggest me some no non-sense
> >> >> books from basic to advanced in order of study. I
> have
> >> >> seen Self Taught DBA article from Brad MC Ghee and
> that
> >> >> list is his opinion which seems very helpful.
> However I
> >> am
> >> >> collecting as much information as possible and I
> request
> >> >> you people to help me out to shape a better future
> with
> >> >> SQL Server by suggesting good books and resources.
> >> >>
> >> >> Thanks
> >> >> Alok
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)