Training agenda
  1. Discussion of the basic issues related to relational databases (on the example of the database on the SQL Server platform)
    • Tables
    • Fields
    • Keys
    • Indices
    • Relations
    • Integrity ties
    • Views
    • Stored procedures.
  2. Creating selection questions (SQL language)
    • SELECT phrase
    • Data filtering (WHERE)
    • Data sorting (ORDER BY)
    • Grouping data (GROUP BY)
    • Aggregating data (SUM, AVG, MIN, MAX, COUNT)
    • Joining tables (WHERE … = …, WHERE … IN …, INNER JOIN, LEFT JOIN, etc.)
    • Combining data from various databases
    • Using text functions (LEFT, RIGHT, SUBSTRING, etc.)
    • Conditional phrases
    • Data type conversion.
  3. Creating functional queries
    • Adding data (INSERT)
    • Modifying data (UPDATE)
    • Deleting data (DELETE)
    • Deleting tables (DROP TABLE).
  4. Downloading data from SQL Server using Microsoft Excel
    • Creating connections to MS SQL Server data
    • MS Query supplement.