+ Reply to Thread
Results 1 to 5 of 5
  1. Junior Member
    Join Date
    Jun 2005
    Location
    New York
    Posts
    15
    #1

    Default How to write reportsor talbes for SQL

    I am new at learning this program. I have been given the opportunity to advance in my company if I can learn Microsoft SQL Server and how to write, view and display report, queries and data on the network. I am baffled and do not understand this language yet, can anyone simplify this or help me out?
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    May 2003
    Location
    Toronto
    Posts
    1,160

    Certifications
    MCSD, RHCSA
    #2
    You need to learn the basics first. Try to be familiar with creating databases with the enterprise manager, stopping starting the server, creating users, etc.

    Then what you'll need to learn very well is Transact-SQL or T-SQL for short.

    Do you have any database design background?

    2lbs.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Apr 2005
    Location
    Houston
    Posts
    429

    Certifications
    CCNA; ITIL; MCSA/MCSE 2000/2003:Messaging
    #3
    SQL is whole new world, you need to know how to install, config, administer then do daily work in it. I didnt know anything about SQL but the past 2 yrs Ive been working with it only by administering and now Im installing, running scripts, understanding tables, sql profiler and sql analyzer.

    Take it one topic at a time, if you jump into learning so much at once you will be totally confused. My job is to provide support to client all running sql in the backend, from time to time I need to run scripts against the database tables to fix data. Its something I really dont like to do on a daily basis but again its enhancing my knowledge of SQL. I dont see myself being a dba but Im ok with the knowledge I have acquired.
    Reply With Quote Quote  

  5. Junior Member
    Join Date
    Jun 2005
    Location
    New York
    Posts
    15
    #4
    Thank you both for your information. I will start with the basic. Its crazy that I had to learn on my own how to start the server, by going to control panel/admin tools/comp. mnagemt/serv. & appl/services and running from the local system. I must get used to the terminalogy and well as learn the basics. Anything you guys can help with please let me know.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    May 2003
    Location
    Toronto
    Posts
    1,160

    Certifications
    MCSD, RHCSA
    #5
    You can get the basics of database design concept and writing queries by reading the SQL Sever Technotes on this site. They're free.

    Installing SQL Sever is easy. If you don't have a copy, buy the developers edition which is very cheap and is meant to be used for education purposes. Once you have the sofware, feel free to post any questions on this forum and we'll try our best to answer them.

    2lbs.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks