none
Do not know Tsql/SQL server . However I know SQL. want to take up a course in BI RRS feed

  • Question

  • Hi , I do not know Tsql/SQL server .

    However I use SQL on oracle 10G. I want to take up a course in microsoft BI ( SSRS) . Is there a lot of difference in SQL and T-SQL .

    Is knowledge of Sql Server 2008 essential for SSRS course ?

    Thanks

    Thursday, September 20, 2012 6:54 PM

Answers

  • http://extension.ucsd.edu/studyarea/index.cfm?vAction=singleCourse&vStudyAreaID=14&vCourse=CSE-41072

    They state the class only requires you to have basic T-SQL experience.

    You will most likely create reports in Visual Studio 2008 (called Business Intelligence Development Studio - BIDS) and/or Report Builder.

    BIDS can be a bit intimidating for people new to Visual Studio 2008.

    Report Builder looks like another Office 2007/2010 application, like Word, Excel, etc.

    Most likely, you will just being doing basic SELECT statements with WHERE and ORDER BY statements. You will probably be using tools (for example, the Query Designer window) that write most of the the T-SQL queries for you.

    Good luck!


    Best wishes, Davin Mickelson

    Monday, September 24, 2012 9:05 PM
    Answerer

All replies

  • Hi,

    it depends on the course. Normally you should have some knowledge about T-SQL, but is very similar to the one Oracle uses. Depending on the course it could have a bigger SQL part.


    Best Regards. When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer. This helps us build a healthy and positive community.

    @Horizon_Net | Blog

    Thursday, September 20, 2012 8:07 PM
    Answerer
  • If you can provide the course number, we'll be able to give you a better indication on what SQL skills you'll need.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Thursday, September 20, 2012 11:02 PM
    Moderator
  • The course description says following - 

    Learn how to build reports using SQL Server 2008 and how to integrate those reports in your environment.

    We will be developing reports against both transactional and OLAP data sources along with exploring features such as Charts, Graphs, Interactive Reports, and Gauges.

    Thursday, September 20, 2012 11:47 PM
  • The course description says following - 

    Learn how to build reports using SQL Server 2008 and how to integrate those reports in your environment.

    We will be developing reports against both transactional and OLAP data sources along with exploring features such as Charts, Graphs, Interactive Reports, and Gauges.


    Please provide the course number as each course contains a list of prerequisites as well as details of what’s covered in the course.

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Friday, September 21, 2012 12:04 AM
    Moderator
  • Sounds like a course developed by someone else than Microsoft. (Can't seem to find something on Google using the exact phrase.) It's best to ask the course organizer.
    Friday, September 21, 2012 4:59 AM
  • http://extension.ucsd.edu/studyarea/index.cfm?vAction=singleCourse&vStudyAreaID=14&vCourse=CSE-41072

    They state the class only requires you to have basic T-SQL experience.

    You will most likely create reports in Visual Studio 2008 (called Business Intelligence Development Studio - BIDS) and/or Report Builder.

    BIDS can be a bit intimidating for people new to Visual Studio 2008.

    Report Builder looks like another Office 2007/2010 application, like Word, Excel, etc.

    Most likely, you will just being doing basic SELECT statements with WHERE and ORDER BY statements. You will probably be using tools (for example, the Query Designer window) that write most of the the T-SQL queries for you.

    Good luck!


    Best wishes, Davin Mickelson

    Monday, September 24, 2012 9:05 PM
    Answerer