{"id":2169260,"date":"2026-04-08T04:33:53","date_gmt":"2026-04-08T02:33:53","guid":{"rendered":"https:\/\/academy.asseco.pl\/training\/default-layout-itil-4-foundation\/"},"modified":"2026-04-08T04:33:54","modified_gmt":"2026-04-08T02:33:54","slug":"querying-data-with-transact-sql","status":"publish","type":"training","link":"https:\/\/academy.asseco.pl\/en\/training\/querying-data-with-transact-sql\/","title":{"rendered":"Querying Data with Transact-SQL"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n
Asseco Academy<\/a><\/span><\/span><\/div>\n <\/div>\n<\/div> <\/div>\n
\n

Training MS 55366AC<\/p>\n

Querying Data with Transact-SQL<\/h2>
\n \n<\/div> <\/div>\n
\n
\n Rozwi\u0105zania IT<\/a>\n Microsoft<\/a>\n <\/div>\n <\/div>\n <\/div>\n
\n

Accreditation<\/p>\n

<\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/section>\n\n
\n
\n
\n
\n

Training<\/p>\n\n

Price of training from <\/strong> PLN\u00a03,555  net<\/sup><\/strong><\/p>\n\n

Lowest price in the last 30 days: PLN\u00a03,555  net<\/sup><\/strong><\/p>\n \n

Language: <\/strong>polski<\/p>\n

*the price depends, among others on the form of training and the date<\/p>\n

\n
Sign up<\/div>\n
Download PDF<\/div>\n <\/div>\n <\/div>\n
\n\n

Additional products<\/p>\n

No additional books or exams are specified for this training.<\/p>\n \n \n <\/div>\n <\/div>\n <\/div>\n<\/section>\n\n\n

\n
\n
\n
\n
    \n
  • Training description<\/li>\n
  • Scope<\/li>\n <\/ul>\n <\/div>\n
    \n
    \n
    \n
    \n

    Training description<\/h2> <\/div>\n

    <\/p>\n

    \n

    This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.<\/p>\n<\/div>\n

    Audience Profile<\/h4>\n
    \n

    This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.<\/p>\n<\/div>\n

    Prerequisites<\/h4>\n
    \n
    \n
      \n
    • Basic understanding of relational databases.<\/li>\n
    • Basic Windows knowledge.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n

      At Course Completion<\/h4>\n
      \n
        \n
      • Create single table SELECT queries<\/li>\n
      • Create multiple table SELECT queries<\/li>\n
      • Filter and sort data<\/li>\n
      • Insert, update, and delete data<\/li>\n
      • Query data using built-in functions<\/li>\n
      • Create queries that aggregate data<\/li>\n
      • Create subqueries<\/li>\n
      • Create queries that use table expressions<\/li>\n
      • Use UNION, INTERSECT, and EXCEPT on multiple sets of data<\/li>\n
      • Implement window functions in queries<\/li>\n
      • Use PIVOT and GROUPING SETS in queries<\/li>\n
      • Use stored procedures in queries<\/li>\n
      • Add error handling to queries<\/li>\n
      • Use transactions in queries<\/li>\n<\/ul>\n<\/div>\n\n <\/div>\n
        \n
        \n

        Scope<\/h2> <\/div>\n

        <\/p>\n

          \n
        • Module 1: Introduction to Transact-SQL<\/li>\n
        • Module 2: Joining tables with Transact-SQL<\/li>\n
        • Module 3: Filtering and sorting results<\/li>\n
        • Module 4: SQL Server data types<\/li>\n
        • Module 5: Inserting, updating and deleting data<\/li>\n
        • Module 6: Using SQL Server functions with Transact-SQL<\/li>\n
        • Module 7: Aggregating data with Transact-SQL<\/li>\n
        • Module 8: Implement subqueries with Transact-SQL<\/li>\n
        • Module 9: Create queries that use table expressions<\/li>\n
        • Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data<\/li>\n
        • Module 11: Implement window functions in queries<\/li>\n
        • Module 12: Use PIVOT and grouping sets in queries<\/li>\n
        • Module 13: Use stored procedures in queries<\/li>\n
        • Module 14: Implement programming features in Transact-SQL<\/li>\n
        • Module 15: Add error handling to queries<\/li>\n
        • Module 16: Use transactions in queries<\/li>\n<\/ul>\n\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/section>\n\n\n\n
          \n
          <\/div>\n<\/div>\n
          \n
          \n
          \n

          Training schedule<\/h2> <\/div>\n
          \n
          \n
          \n
          \n \n

          Remote<\/p>\n

          … if you value the opportunity to learn with a trainer and other participants, from anywhere without having to commute.<\/p>\n <\/div>\n <\/div>\n

          \n
          \n \n

          Stationary<\/p>\n

          … if you want to learn while sitting in the same room with the trainer and other participants.<\/p>\n <\/div>\n <\/div>\n

          \n
          \n \n

          Online<\/p>\n

          … if you want to learn from materials available via the interenet anywhere at any time<\/p>\n <\/div>\n <\/div>\n <\/div>\n

          \n
          \n
          <\/div>\n<\/div>
          \n
          \n
          \n
          \n

          Filters:<\/p>\n <\/div>\n

          \n