(in Polish) Język SQL w bazach danych 2600-IADzJSQLkf
1. Theoretical Introduction to Databases
1.1. Basic Concepts
1.1.1. Definition of a Database and Its Role in Information Systems
1.1.2. Database Management System – Functions and Types
1.2. Data Models
1.2.1. Relational Model
1.2.1.1. Relationships, Attributes, Keys (Primary, Foreign)
1.2.1.2. Bindings (Referential Integrity)
1.2.1.3. Normalization and Its Importance
1.2.2. Other Data Models (Hierarchical, Network, Object-Oriented, NoSQL)
2. Database Queries
2.1. Query Classification
2.2. Functional Queries
2.2.1. Creating Databases and Tables
2.2.2. Deleting Databases and Tables
2.2.3. Adding Records
2.2.4. Modifying Data
2.2.5. Deleting Records
2.3. Select Queries
2.3.1. Selecting an Entire Table
2.3.2. Removing Duplicates
2.3.3. Sorting the Result Table
2.3.4. Selections
2.3.5. Joins
2.3.6. SQL Inner Join Syntax
2.3.7. Joining Multiple Tables
2.3.8. Self-Joins
2.3.9. SQL Outer Join Syntax
2.3.10. Subqueries
2.3.11. Negative Queries
2.3.12. Correlated Subqueries
2.3.13. Calculated Fields
2.3.14. Grouping and Aggregate Functions
Course coordinators
Type of course
Mode
Learning outcomes
K_W01 - Demonstrates in-depth knowledge of research methodology and terminology within the discipline of economics and finance and its complementary disciplines (management, quality, and legal sciences).
K_W05 - Complex technological, social, political, legal, economic, and ecological processes and phenomena, including fundamental dilemmas of modern civilization and their impact on financial decisions in organizations, the functioning of the entire economy, and organizations in the development of information systems.
K_W06 - Principles of industrial property protection and copyright.
K_W07 - Information technology and numerical methods necessary for solving financial problems; familiar with selected software used in finance.
K_U03 - Uses appropriate source selection and adapts existing or develops new methods and tools, including advanced information and communication techniques, to recognize, diagnose, and solve problems related to financial decisions in the field of investment and data analysis.
K_U06 - Independently and collaboratively prepare analyses, diagnoses, and reports on complex and unusual issues related to investments and data analysis in organizations, present them communicatively to diverse audiences, and lead debates, also in English, using advanced IT and communication tools.
K_U08 - Plan, organize, and manage teamwork, collaborate in teams, and take a leading role in team activities.
K_K05 - Adhere to, enforce, and develop professional ethical standards and build on the professional achievements.
Assessment criteria
- written test (open-ended and closed-ended questions) in person or remotely on the Kampus platform,
- class participation (exercises, case studies),
- project.
Practical placement
Professional practice is not required to complete the course
Bibliography
1. Garcia-Molina, H., Ullman, J.D., & Widom, J. (2011). Systemy baz danych. Kompletny podręcznik (wyd. 2). Gliwice: Helion.
2. Elmasri, R., & Navathe, S. (2019). Wprowadzenie do systemów baz danych (wyd. 7). Gliwice: Helion.
3. Dariusz Put (2007), Bazy danych: pojęcia, projektowanie, podstawy SQL, Kraków. Wydaw. Uniwersytetu Ekonomicznego, 2007.
4. Renée M. P. Teate (2023) SQL dla analityków danych. Tworzenie zbiorów danych dla początkujących, Helion