Mastering SQL DB Management

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


Course Schedule

  Apr 28 - May 1, 2020
London

  Sep 8 - Sep 11, 2020
London

  Nov 9 - Nov 12, 2020
London

  • 4 Days Course
    Data Center (Insoft Specials)

    Classroom + Online

    Course Details

    The Mastering SQL DB Management course explains how to create and manage a database on SQL Server systems. The training starts analyzing the editing and insertion commands for data in the tables, it continues exploring the search and filter methods for the output generated by the queries. This course provides the skills for DB Management and technology solutions used to optimize and manage the storage and retrieval of data from databases.

    The course also describes the log methodologies used in monitoring and storage, the trigger insertion and the altering operation for the output table. Finally, a part related to the query translation from XML to SQL and vice versa is proposed.

     

    See other Microsoft courses

    Outline

    • SQL Database creation
    • Table selection
    • Search filters: Fields and Records
    • Regular Expressions
    • Exercises with most important predicates for Queries: SELECT, FROM, WHEN, CASE, Like…
    • A search operation with the correlation between tables: Inner e Outer JOINs
    • Database Snapshots
    • Database File Structures
    • Log files and Storage allocation
    • Altering table views
    • Aliases
    • Trigger insertion and management
    • XQuery methods (XML Query)
    • Binding XML to SQL and vice-versa
    • OPENXML parameters for T-SQL

    Target Audience

    • Technical personnel and IT Manager involved in the management of SQL Database systems.

    Prerequisites

    • Operating Systems basic understanding.