BEGIN:VCALENDAR
VERSION:2.0
PRODID:icalendar-ruby
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTAMP:20261120T104018Z
UID:3e49c7af-8e6a-4311-b04e-634f1c96838a
DTSTART:20270405T090000Z
DTEND:20270406T170000Z
DESCRIPTION:**This course will take place on 2 afternoons\, on 5 and 6 Apri
 l 2027** \n\n# Overview\nThere are several reasons why learning or improvi
 ng SQL (Structured Query Language) can be beneficial for data science: \n\
 n1. SQL is the standard language for working with relational databases\, w
 hich are a common source of data for data science projects. By learning SQ
 L\, you'll be able to easily retrieve\, manipulate\, and analyze the data 
 stored in these databases. \n\n2. SQL allows you to efficiently work with 
 large datasets. When working with data science projects\, it is common to 
 deal with datasets that are too large to fit into memory. SQL provides pow
 erful tools for filtering\, grouping\, and aggregating large datasets\, so
  you can work with subsets of the data that are small enough to fit into m
 emory. \n\n3. SQL can help you to understand the underlying data better. E
 ven though SQL is a programming language\, it is declarative\, unlike most
  of the general-purpose programming languages like Python\, C++ or Java. I
 t means the code you write will tell the SQL engine what you want and the 
 engine will take care of the HOW to get the results\, so it will help to g
 et more understanding about the dataset\, its structure and its constraint
 s \n\n4. SQL is a good tool for data preparation\, cleaning and validation
 . Since it is a powerful tool to manipulate and filter the data\, you coul
 d use it to prepare your dataset to a better shape before applying any sta
 tistical or machine learning models. \n\n5. SQL can be a valuable skill in
  the job market. Many companies store data in relational databases\, and S
 QL knowledge is often a required or preferred skill for data science posit
 ions. \n\nIn summary\, learning SQL can be a valuable addition to your dat
 a science toolkit\, as it allows you to efficiently work with large datase
 ts and can be a valuable skill in the job market : [Survey](https://survey
 .stackoverflow.co/2022/#most-popular-technologies-language-prof)\n\n# Audi
 ence\nThis course is addressed to Data scientists\, programmers\, bioinfor
 maticians\, researchers or students.\n\n# Learning outcomes\nAt the end of
  the course\, the participants are expected to:\n* Understand what a relat
 ional database is \n* Understand the basics of SQL \n* Write and execute s
 imple to complex SQL queries \n* Retrieve data from a relational database 
 using the SQL language  \n* Filter\, order and group query results \n* Joi
 n tables together \n* Use set operations \n* Use dates and times in SQL. \
 n\n# Prerequisites\n##### **Knowledge / competencies**\nThis course is add
 ressed to data scientists\, programmers\, bioinformaticians\, researchers 
 or students and there is no requirement.\n##### **Technical**\nYou are req
 uired to bring your own laptop with administrative rights. You will be ask
 ed to download and install a database client prior to the course. \n\n# Ou
 tline\n**Module 1**\n* What is SQL? \n* Data models: structure and content
  \n* Datatypes in SQL \n* Presentation of our used case \n* Retrieve data 
 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* Wildcards 
 \n* Ordering your results with ORDER BY \n* Aggregate functions: AVG\, COU
 NT\, MIN\, MAX and SUM \n* Grouping your results with GROUP BY \n\n**Modul
 e 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 w
 ith UNION\, INTERSECT and EXCEPT \n* Date and Time \n* Views \n* Conclusio
 n \n\n# Application\nThe registration fees for academics are **100 CHF** a
 nd **500 CHF** for for-profit companies.\n\nWhile participants are registe
 red on a first come\, first served basis\, exceptions may be made to ensur
 e diversity and equity\, which may increase the time before your registrat
 ion is confirmed.\n\nApplications will close as soon as the places will be
  filled up\, but not later than **30/03/2027**. Deadline for free-of-charg
 e cancellation is set to **30/03/2027**. Cancellation after this date will
  not be reimbursed. \n\nYou will be informed by email of your registration
  confirmation. Upon reception of the confirmation email\, participants wil
 l be asked to confirm attendance by paying the fees within 5 days.\n\n# Ve
 nue and Time\nThe course will be live-streamed across two half-day session
 s. \n\nIt will start at 13:00 and end around 17:00. Precise information wi
 ll be provided to the participants in due time.\n\n\n#  Additional informa
 tion\nCoordination: Grégoire Rossier\, SIB Training Group\n\nYou are welc
 ome to register to the SIB courses mailing list to be informed of all futu
 re courses and workshops\, as well as all important deadlines using the fo
 rm [here](https://lists.sib.swiss/mailman/listinfo/courses).\n\nPlease not
 e that participation in SIB courses is subject to our [general conditions]
 (https://www.sib.swiss/training/terms-and-conditions).\n\nSIB abides by th
 e [ELIXIR Code of Conduct](https://elixir-europe.org/events/code-of-conduc
 t). Participants of SIB courses are also required to abide by the same cod
 e.\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/20270405_FSSQL
END:VEVENT
END:VCALENDAR
