Position: Junior MS SQL Developer
Category: SQL
English level: pre
Years of experience: 0


Since I have no commercial experience, I will describe my experience and the technologies used during my training. During this, I mastered the entire DDL, DML, DCL syntax of the T-SQL language, wrote reporting queries using: analytical functions, CROSS APPLY, PIVOT.  I acquainted with architectural solutions OLTP, DWH, patterns for solving architectural problems, good practices. To solve ETL tasks, I used SSIS, .NET applications. Faced with the tasks of serializing SQL queries into xml, deserializing similar objects (XML, JSON) into tables using standard SQL Server features, etc.