Important concept in SQL

  • Hi Friends,...

    I have near 2 year exp in asp.net and SQL server.

    What are the concepts are important in SQL for 2 years exp.

    Regards

    Arul.R

  • Not sure I understand your question.

    Please elaborate?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • I Need what are concepts need to study or experienced for 2 + exp

  • What level of exposure have you had? Core principal DBA, developer, BI?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Developer

  • Do you recognize these terms? and know what they are used for? 😀

    T-SQL, ETL, BI, database design, SP's, Triggers, Functions, SSIS, dtsx?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • I Know below Concepts....

    1.Basic Queries

    2.Stored proc and functions

    3.triggers and Views

    4.SQL Server Business Intelligence Development Studio

    Then any thing can i learn

  • arulpandi.r (6/12/2012)


    I Know below Concepts....

    1.Basic Queries

    2.Stored proc and functions

    3.triggers and Views

    4.SQL Server Business Intelligence Development Studio

    Then any thing can i learn

    Well, Basic Queries is a bit generic, what would you define as a "Basic" query, and an "Advanced" query?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • arulpandi.r (6/12/2012)


    I Know below Concepts....

    1.Basic Queries

    2.Stored proc and functions

    3.triggers and Views

    4.SQL Server Business Intelligence Development Studio

    Then any thing can i learn

    And SQL Server Business Intelligence Development Studio is pretty broad. What have you done using BIDS? How complex have these projects been?

  • Front end design for stored procedure using BIDS

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply