Conducted in
term:
Winter Semester 2019/20
Winter Semester 2019/20
ECTS credits:
5
Organized by:
Faculty of Mechanical Engineering
Data Analysis and Reporting IS-FME-00203
Description:
Creating reporting systems using MSSQL Introduction to SQL and T-SQL. Introduction to Tables. Introduction to Data Selection.
Sorting Records. Introduction to Data Filters. Introduction to Relational Databases.
Introduction to Data Joins. Introduction to Views. Topics on Views. Aggregate Queries. Selecting Records Over Partitions. Ranking Records Over Partitions. Triggers. Sub-Queries. Stored Procedures.
Requirements:
-