Transact SQL

Code: T-SQL
Category: MSSQL
Format: 50% lecture / 50% workshop
Duration: 2-3 days
Target audience: developers
Enrollment: Groups, companies
Venue: Client's office.

Training Program

The content of our program can be customised during pre-training analysis.

  1. DB architecture
  2. Tools
    1. Management Studio
    2. SQL Profiler
  3. Reading data
    1. Projections
    2. Filtering
    3. Grouping and aggregating
    4. Sorting
    5. Joining
    6. Sub-queries
    7. Full-text search
  4. Creating and modifying tables
    1. Designer
    2. DDL
  5. Data modification
    1. INSERT, UPDATE, DELETE
    2. MERGE
  6. Handful objects
    1. Procedures
    2. Functions
    3. Triggers
  7. Optimisation basics
    1. Tips and tricks
    2. Mode problem
    3. Rankings
    4. Paging
    5. Aggregates


Download PDF

Trainers

Meet the experts who will conduct your training.

Michał Mac

Contact us for a free consultation.

Firstname and lastname:
Company:
E-mail:
Phone:
Subject:
Message:

If you prefer direct contact then you can always call.

Iwona Sobótka

Training coordinator


I agree to the processing of my personal data in accordance with the Law on the Protection of Personal Data in connection with sending a request via the contact form.

Providing the data is voluntary but necessary to process the query. I have been informed that I have the right to access my data, the possibility of correcting them, demanding stopping their processing.

The administrator of personal data is Bottega IT Minds, ul. Jana Sawy 2, 20-632 Lublin, Poland.

The information clausule