(in Polish) Digital Commerce, Services and Cyberpayments 2600-DB-DCSaC
Theory:
1. [seminar] Introduction to digital business
2. [seminar] Opportunity analysis for digital business and e-commerce
3. [seminar] E-commerce management
4. [seminar] Key issues in the digital environment
5. [seminar] Digital business strategy;
6. [seminar] Digital communications
7. [seminar] Digital experience and service design; TEST on Campus platform
Practise:
8. [laboratory] SQL: Fundamentals of relational databases; Data types; DDL – Creating a database schema: the CREATE statement, primary and foreign keys, tables, relationships between tables, structure modifications (ALTER and DROP),
9. [laboratory] SQL: DML – adding data to a database: INSERT, UPDATE, and DELETE commands; DQL – retrieving data: SELECT commands; WHERE clauses; subqueries; COUNT, MAX, MIN
10. [laboratory] SQL: review exercise; EXAM: in-class project
Course coordinators
Assessment criteria
Test and practice exercise in SQL language.