Course objectives

Understanding the basics of ANSI SQL query language along with the MS-SQL extension and acquiring practical skills in this field.

Benefits
  • Workshop participants will learn about:
    • basic concepts of MS databases
    • creating simple and advanced MS-SQL queries
    • using built-in functions and procedures
    • creating own functions and procedures
    • handling of conditional situations and errors
    • the importance of metadata
    • preparation of data for presentation
  • Participants will acquire detailed knowledge allowing for:
    • creating MS ‐ SQL queries
    • taking part in the work of the MS ‐ SQL programmers team
    • creating own procedures and automating operations
    • event and error handling
Training scope
  • Basics of SQL Server operation and support for MS SQL Server Management Studio
  • MS ‐ SQL syntax
  • Data Types
  • Creating simple and complex queries (select, distinct, case, group by, order by, having, aliases, subqueries)
  • DML and DDL instructions
  • Indexes (types, structure, principles of creation, use)
  • Joining tables (inner, outer, self, cross)
  • Sorting, filtering
  • Creating views, their use and restrictions
  • Built-in, ranking, shifts, aggregation functions
  • Array expressions
  • Operations on UNION, EXCEPT, INTERSECT, APPLY files
  • Programming in T ‐ SQL (loops, conditions, creating variables, functions)
  • Exception and error handling
  • Most common mistakes and practical remarks
  • Practical exercises
Audience

All individuals involved in the development, administration and maintenance of databases using MS-SQL query language in their work.

The number of participants: 8-15 people

Duration: 2 days

Available language: PL / EN

Available course material: PL / EN

Course form
Presentation, lecture, workshop, discussion.

Download materials

Download

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

Processing...

Contact our expert with questions

about any of our trainings

Agnieszka Rzeczkowska

Training Practice Manager

CONTACT OUR EXPERT

Agnieszka Rzeczkowska

or drag and drop your file here

Allowed extensions: DOC, DOCX, PDF (max 5MB)

Thank you for filling out the form

We will look over your message and get back to you as soon as possible

Sorry, something went wrong and your message couldn’t be delivered

Please refresh the page and try again

Processing...

You might also like

Databases

MS-SQL – queries and indexes plans

Duration:
1 day
Databases

T-SQL – advanced programming

Duration:
1 day
Databases

SQL and PL/SQL optimization

Duration:
2 days
Databases

Oracle and SQL Databases

Duration:
2 days
Databases

MySQL – introduction

Duration:
2 days
Databases

Informatica PowerCenter – Developer basics

Duration:
2 days
Databases

NoSQL – introduction

Duration:
2 days
Databases

Node.js and MongoDB – introduction

Duration:
3 days
DatabasesTesting solutions

SQL for testers

Duration:
3 days
Databases

Oracle SQL - Basics for data analysts

Duration:
2 days

ITIL® and PRINCE2® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
AgilePM® is a registered trademark of DynamicSystem Development Method Ltd.
All AgilePM® Courses are offered by Sii, an Affiliate of Quint Wellington Redwood, an Accredited Training Organization of The APM Group Ltd.
Lean IT® Association is a registered trademark of the Lean IT Association LLC. All rights reserved. Sii is an Affiliate of Accredited Training OrganizationQuint Wellington Redwood.
All prices presented on the website are net prices. 23% VAT should be added.

SUBMIT