BEGIN:VCALENDAR
VERSION:2.0
PRODID:icalendar-ruby
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTAMP:20260407T181316Z
UID:b043a46c-5991-4d1c-9254-093e250879e6
DTSTART:20260420T090000Z
DTEND:20260421T170000Z
DESCRIPTION:**This course will take place on 2 afternoons\, on 20 and 21 Ap
 ril 2026** \n\n# Overview\nThere are several reasons why learning or impro
 ving SQL (Structured Query Language) can be beneficial for data science: \
 n\n1. SQL is the standard language for working with relational databases\,
  which are a common source of data for data science projects. By learning 
 SQL\, you'll be able to easily retrieve\, manipulate\, and analyze the dat
 a stored in these databases. \n\n2. SQL allows you to efficiently work wit
 h large datasets. When working with data science projects\, it is common t
 o deal with datasets that are too large to fit into memory. SQL provides p
 owerful tools for filtering\, grouping\, and aggregating large datasets\, 
 so you can work with subsets of the data that are small enough to fit into
  memory. \n\n3. SQL can help you to understand the underlying data better.
  Even though SQL is a programming language\, it is declarative\, unlike mo
 st of the general-purpose programming languages like Python\, C++ or Java.
  It means the code you write will tell the SQL engine what you want and th
 e engine will take care of the HOW to get the results\, so it will help to
  get more understanding about the dataset\, its structure and its constrai
 nts \n\n4. SQL is a good tool for data preparation\, cleaning and validati
 on. Since it is a powerful tool to manipulate and filter the data\, you co
 uld use it to prepare your dataset to a better shape before applying any s
 tatistical or machine learning models. \n\n5. SQL can be a valuable skill 
 in the job market. Many companies store data in relational databases\, and
  SQL knowledge is often a required or preferred skill for data science pos
 itions. \n\nIn summary\, learning SQL can be a valuable addition to your d
 ata science toolkit\, as it allows you to efficiently work with large data
 sets and can be a valuable skill in the job market : [Survey](https://surv
 ey.stackoverflow.co/2022/#most-popular-technologies-language-prof)\n\n# Au
 dience\nThis course is addressed to Data scientists\, programmers\, bioinf
 ormaticians\, researchers or students.\n\n# Learning outcomes\nAt the end 
 of the course\, the participants are expected to:\n* Understand what a rel
 ational database is \n* Understand the basics of SQL \n* Write and execute
  simple to complex SQL queries \n* Retrieve data from a relational databas
 e using the SQL language  \n* Filter\, order and group query results \n* J
 oin tables together \n* Use set operations \n* Use dates and times in SQL.
  \n\n# Prerequisites\n##### **Knowledge / competencies**\nThis course is a
 ddressed to data scientists\, programmers\, bioinformaticians\, researcher
 s or students and there is no requirement.\n##### **Technical**\nYou are r
 equired to bring your own laptop with administrative rights. You will be a
 sked to download and install a database client prior to the course. \n\n# 
 Outline\n**Module 1**\n* What is SQL? \n* Data models: structure and conte
 nt \n* Datatypes in SQL \n* Presentation of our used case \n* Retrieve dat
 a with SELECT \n* Filtering with SQL \n* Limiting your results with LIMIT 
 \n* Advanced filtering: IN\, OR\, AND and NOT \n\n**Module 2**\n* Wildcard
 s \n* Ordering your results with ORDER BY \n* Aggregate functions: AVG\, C
 OUNT\, MIN\, MAX and SUM \n* Grouping your results with GROUP BY \n\n**Mod
 ule 3**\n* Subqueries \n* Introduction to joining tables \n* Cross joins \
 n* Inner joins \n* Left and right joins \n\n**Module 4**\n* Set operations
  with UNION\, INTERSECT and EXCEPT \n* Date and Time \n* Views \n* Conclus
 ion \n\n# Application\nThe registration fees for academics are **100 CHF**
  and **500 CHF** for for-profit companies.\n\nWhile participants are regis
 tered on a first come\, first served basis\, exceptions may be made to ens
 ure diversity and equity\, which may increase the time before your registr
 ation is confirmed.\n\nApplications will close as soon as the places will 
 be filled up\, but not later than **13/04/2026**. Deadline for free-of-cha
 rge cancellation is set to **13/04/2026**. Cancellation after this date wi
 ll not be reimbursed. \n\nYou will be informed by email of your registrati
 on confirmation. Upon reception of the confirmation email\, participants w
 ill be asked to confirm attendance by paying the fees within 5 days.\n\n# 
 Venue and Time\nThe course will be live-streamed across two half-day sessi
 ons. \n\nIt will start at 13:00 and end around 17:00. Precise information 
 will be provided to the participants in due time.\n\n\n#  Additional infor
 mation\nCoordination: Grégoire Rossier\, SIB Training Group\n\nYou are we
 lcome to register to the SIB courses mailing list to be informed of all fu
 ture courses and workshops\, as well as all important deadlines using the 
 form [here](https://lists.sib.swiss/mailman/listinfo/courses).\n\nPlease n
 ote that participation in SIB courses is subject to our [general condition
 s](https://www.sib.swiss/training/terms-and-conditions).\n\nSIB abides by 
 the [ELIXIR Code of Conduct](https://elixir-europe.org/events/code-of-cond
 uct). Participants of SIB courses are also required to abide by the same c
 ode.\n\nFor more information\, please contact [training@sib.swiss](mailto:
 //training@sib.swiss).
SUMMARY:First Steps with SQL for Data Science
URL;VALUE=URI:https://www.sib.swiss/training/course/20260420_FSSQL
END:VEVENT
END:VCALENDAR