Home Development and training SQL basics workshops

SQL basics workshops

I. Goal
This training covers the basics of ANSI SQL as well as work environment based on Microsoft tools.

II. Acquired skills

Participants gain theoretical and practical knowledge regarding programming in SQL in Microsoft SQL Server including:

szkolenia_podstawy_sql_new
  • Designing database structures such as tables, primary and foreign keys, indexes
  • Writing SQL queries in ANSI SQL
  • Grouping, sorting and aggregating data
  • Combining tables and data from various databases
  • Putting conditions in queries
  • Using testing functions and data type conversion
  • Creating objects such as procedures or functions
  • Importing data from files

The training ends with a certificate of participation in SQL basics workshop.

III. Target group

Workshops are aimed at beginners that have never programmed in SQL including:

  • People without IT experience or education
  • Students or graduates of various majors
  • Those that want to retrain or change their career path
  • Others that want to utilize SQL in their everyday work

IV. Pros

Why do we recommend this training?

  • Great price to number of training hours ratio in comparison to other trainings offered on the market
  • A complete and elaborate training program – it provides skills to become an SQL developer
  • Practical exercises (case studies) that involve using various programming tools/software
  • A well-qualified teaching stuff that includes people who work as SQL developers and are able to share their practical knowledge and experience
  • Possibility of being employed by Sii after the training
  • Sii is a partner that is trustworthy and widely recognized on the market

V. Schedule

SQL basics workshops
Day 1 
Introduction to databases
Discussing basic terms connected with databases
Types of data exemplified by Microsoft SQL Server
Writing simple queries – SELECT
Filtering data
Sorting data
Aggregating data
Combining tables
Creating tables – CREATE TABLE
Day 2 
Revision
Deleting tables – DROP TABLE
Creating database objects
Procedures
Functions
Indexes
Advanced select queries
Combining tables and data from various databases
Writing conditions in queries
Using testing functions and data type conversion
Trivia
Importing data from files

VI. Organizational issues

  1. Duration: 16h = 2 days
  2. Time: : weekends (Saturday – Sunday)
  3. Pricing: 1299 PLN gross (12 people group)
  4. Organizer provides catering during the training
  5. The workshop ends with a certificate of participation
  6. Please, send your application and questions at szkolenia-lublin@sii.pl

*the organizer restricts the right to change the program and organization

recommend-people

Recommend a friend to Sii

Recommend a friend to work in Sii…

…if we hire him / her…

…You can get up to 8000 PLN!

Our Job Ads

Find out who are we looking for

Contact us

Close
Sorry, Your message has not been sent. Please fill out all required fields correctly and try again. Thank you!

I hereby grant consent for the processing of my personal data contained in this form by Sii sp. z o.o., with its registered office at Al. Niepodległości 69, 02-626 Warsaw (“Sii”), for the following purposes:

At any time, you may withdraw your consent for the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy

Apply now

Close
Sorry, Your message has not been sent. Please fill out all required fields correctly and try again. Thank you!

I hereby grant consent for the processing of my personal data contained in this form by Sii sp. z o.o., with its registered office at Al. Niepodległości 69, 02-626 Warsaw (“Sii”), for the following purposes:

At any time, you may withdraw your consent for the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy