Learning the SQL and NoSQL Language

Learning the SQL and NoSQL Language
Learning the SQL and NoSQL Language

This course is designed to empower participants with the skills needed to excel in database programming. Starting with a comprehensive SQL training that covers relational databases, you'll learn to develop applications tailored to business needs. Delve into MySQL for solid SQL foundation, independent of specific database nuances.

Next, explore the realm of NoSQL technologies and MongoDB Query Language (MQL). Emphasis is on hands-on practice and practical implementation to ensure you're ready for real-world challenges.

Cap off your learning journey with a stimulating case study project, where you'll apply your skills to deliver a full-scale database solution. Join us and elevate your database programming expertise today!

Assistant Professor of Computer Science, Department of Economics, University of Athens

The coures is addressed to university graduates worldwide, as well as secondary education graduates with relevant work experience, who aspire to master SQL database programming and its applications

Meet the Rising Demand for Data Management Skills Across Industries! 

In today's digital age, proficiency in both SQL and NoSQL is indispensable across sectors such as data science, finance, and IT. With the exponential growth of diverse data types and large-scale operations, mastering these technologies has become essential.

Socially and institutionally, there is a heightened focus on digital literacy and data skills, echoing initiatives like the EU's Digital Education Action Plan, which prioritizes digital competences. The course meets this critical educational need by preparing learners for cutting-edge data environments and aligning with strategic policy initiatives.

The course is designed for asynchronous distance learning, divided into three comprehensive instructional units. Throughout the entire program, participants receive dedicated educational support from expert instructors.

Total engagement time is estimated at seventy-three (73) hours.

Unit 1: Structured Query Language (SQL) Discover the fundamentals of SQL, including its origins, importance, and basic operations. Explore database design principles focusing on relational databases, tables, rows, columns, and primary keys. Estimated engagement time: 25 hours

Unit 2: Programming with the SQL Language Dive into advanced SQL programming techniques. Learn to create stored procedures and functions to streamline repetitive tasks, and implement triggers for automated actions based on specific table events. Estimated engagement time: 30 hours

Unit 3: Special SQL Topics and NoSQL Database Programming Expand your SQL expertise with advanced functions such as window functions, common table expressions (CTEs), and recursive queries. Explore dynamic SQL for generating and executing SQL code dynamically. Estimated engagement time: 18 hours

Assessment occurs through the educational platform, featuring tests including multiple-choice, true-false, and matching questions.

Online and distance training learning at National and Kapodistrian University of Athens offers a new way of combining innovative learning and training techniques with interaction with your tutor and fellow trainees from around the world.

The e-learning course is implemented via a user-friendly educational platform adjusted to the Distance Learning Principles. Courses are structured as weekly online meetings; interaction with the course tutor and other trainees takes place in a digital learning environment. The courses are designed to fit around your schedule; you access the course whenever it is convenient for you, however within the given deadlines.

The whole world becomes your classroom as e-learning can be done on laptops, tablets and phones as a very mobile method. Learning can be done on the train, on a plane or even during your trip to Greece!

The educational platform is a portal that offers access to electronic educational material based on modern distance learning technologies. The computer based nature of training means new technology is being introduced all the time to help trainees engage and learn in a tailored way that will meet their needs. E-learners have access to the educational platform with their personal code number in order to browse all relevant training material and interact with their instructors.

Moreover, an online communication system through own personal e-mail account is available in order to make the process easier and more interactive. Trainees can contact directly their tutors or the administration office of the course and share any concerns or anxieties related to the course in order to make the most of their experience.

Every week e-learners are provided with the relevant material, delivered either in the form of video-lectures, text notes and relevant presentations or as a combination of them. The educational material of the course is uploaded gradually, per educational unit. During the course, important info for the smooth conduct of the educational process, such as timetables for the submission of the exercises are announced on the Announcement section of the platform.

For successful completion of the course the e-learner should have fulfill her/his academic obligations, meaning should have submitted all corresponding assessment exercises and have achieved at least an average of 50% grade in the corresponding tests for each module. The score scale ranges from 0 to 100%. Finally, if the total score on one or more lessons of the course does not exceed 50%, trainees can ask for reassessment.

During the course trainees will be attending a training experience designed by academics and lecturers from the National University of Athens as well as from other Universities, Research Institutes and Cultural organizations around Greece.

Interactivity, flexibility and our long tradition guarantee that learning with us offers a successful and rewarding experience. Finally, access to a large variety of material and online resources available in each unit aims to excite your curiosity and guide you in exploring further your favourite topic. Part of the online material can be downloaded providing the chance to quickly refresh your memory after the completion of the course.