Introduction to Databases
The course provides a set of skills for utilizing relational and NoSql databases for multipurpose applications. Course content includes practicing SQL language for data management, elements of T-SQL and Python extensions. It will also introduce NoSql data management principle and practical exercises for students’ database skills formatting.
Did you know
Relational databases, utilizing Structured Query Language (SQL), are characterized by a structured schema that defines the organization of data into tables with predefined relationships. Adhering to the principles of ACID (Atomicity, Consistency, Isolation, Durability), they prioritize data integrity and reliability. SQL databases excel in handling complex queries and joins, making them ideal for applications with well-defined schemas and intricate relationships between data entities.
On the other hand, NoSQL databases, encompassing various types such as document-oriented, key-value stores, column-family stores, and graph databases, provide a flexible schema or no schema at all. Designed for scalability and performance, NoSQL databases are well-suited for scenarios where data models evolve rapidly, and there’s a need to handle large amounts of unstructured or semi-structured data across distributed architectures.
The choice between relational and NoSQL databases depends on the specific requirements of a given project, with relational databases being favored for structured data and complex queries, while NoSQL databases are preferred for dynamic data and scalability needs in applications like web development and big data analytics.
The program
The topics covered by the course include database fundamentals; installation and configuration of the database management system; usage of Microsoft Access and its objects: tables, queries, forms, reports and macros; installation and configuration of Microsoft SQL Server; using SQL statements for data acquiring, analysis and modification; using DBeaver and SQL Server Management Studio; retrieving data from SQL and NoSQL databases with Python.
This extensive course covers a range of database-related topics and practical tools, offering a balanced blend of theoretical understanding and hands-on experience. Beginning with the fundamentals of databases, participants gain insights into key concepts essential for effective data management. The course then delves into Microsoft Access, providing a comprehensive exploration of tables, queries, forms, reports, and macros. This practical experience enhances participants’ proficiency in utilizing this widely-used relational database management system.
Moving beyond Microsoft Access, the course shifts its focus to the installation and management of Microsoft SQL Server. Participants acquire practical skills in setting up and administering this powerful database engine. The exploration of DBeaver, a versatile cross-platform database tool, follows, expanding participants’ capabilities in navigating and interacting with various database environments.
Subsequent modules focus on practical aspects of database usage. Acquiring data from databases becomes a focal point, refining participants’ skills in data retrieval and extraction. The course further explores the complexities of linking tables and data aggregation, deepening understanding in relational database structures and analytical techniques.
Finally, the course introduces participants to relational and NoSQL (MongoDB) database manipulation with Python, empowering them to leverage programming for efficient and customized database interactions. Transitioning to a project-oriented approach, the course guides participants in conceptualizing and implementing a database project. This hands-on experience allows students to apply their knowledge to real-world scenarios.
Overall, this course equips participants with a robust skill set for roles in retrieving and processing data from databases. The combination of theoretical principles and practical application ensures a thorough understanding of databases’ role in real-world applications, preparing participants for the dynamic challenges of the field.
The professor
The professor of Introduction to Databases is Łukasz Wiechetek. He is an Assistant Professor at the Faculty of Economics at Maria Curie-Sklodowska University (Poland) and Head of the UMCS Analysis and Development Center. He has teaching, research, and practical experience in deploying information systems and managing IT projects. Łukasz Wiechetek is the author or co-author of over seventy publications. His research interests include e-business, IT project management, digital society development, cybersecurity, automated data analysis and technology-enhanced teaching and learning.
