BEGIN:VCALENDAR
VERSION:2.0
PRODID:icalendar-ruby
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTAMP:20260614T180205Z
UID:88aa2c3a-183b-4c89-9330-f9efd00d5ee4
DTSTART:20240418T090000Z
DTEND:20240418T170000Z
DESCRIPTION:# Overview\nThere are several reasons why learning or improving
  SQL (Structured Query Language) can be beneficial for data science: \n\n1
 . SQL is the standard language for working with relational databases\, whi
 ch are a common source of data for data science projects. By learning SQL\
 , you'll be able to easily retrieve\, manipulate\, and analyze the data st
 ored in these databases. \n\n2. SQL allows you to efficiently work with la
 rge datasets. When working with data science projects\, it is common to de
 al with datasets that are too large to fit into memory. SQL provides power
 ful tools for filtering\, grouping\, and aggregating large datasets\, so y
 ou can work with subsets of the data that are small enough to fit into mem
 ory. \n\n3. SQL can help you to understand the underlying data better. Eve
 n though SQL is a programming language\, it is declarative\, unlike most o
 f 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 the en
 gine 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 constraints 
 \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 could 
 use it to prepare your dataset to a better shape before applying any stati
 stical or machine learning models. \n\n5. SQL can be a valuable skill in t
 he job market. Many companies store data in relational databases\, and SQL
  knowledge is often a required or preferred skill for data science positio
 ns. \n\nIn summary\, learning SQL can be a valuable addition to your data 
 science toolkit\, as it allows you to efficiently work with large datasets
  and can be a valuable skill in the job market : [Survey](https://survey.s
 tackoverflow.co/2022/#most-popular-technologies-language-prof)\n\n# Audien
 ce\nThis course is addressed to Data scientists\, programmers\, bioinforma
 ticians\, researchers or students.\n\n# Learning outcomes\nAt the end of t
 he course\, the participants are expected to:\n* Understand what a relatio
 nal database is \n* Understand the basics of SQL \n* Write and execute sim
 ple to complex SQL queries \n* Retrieve data from a relational database us
 ing the SQL language  \n* Filter\, order and group query results \n* Join 
 tables together \n* Use set operations \n* Use dates and times in SQL. \n\
 n# Prerequisites\n##### **Knowledge / competencies**\nThis course is addre
 ssed to data scientists\, programmers\, bioinformaticians\, researchers or
  students and there is no requirement.\n##### **Technical**\nYou are requi
 red to bring your own laptop with administrative rights. You will be asked
  to download and install a database client prior to the tutorial. \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\nYou will be informed by email 
 of your registration confirmation. Upon reception of the confirmation emai
 l\, participants will be asked to confirm attendance by paying the fees wi
 thin 5 days.\n\nApplications close on 10/04/2024. Deadline for free-of-cha
 rge cancellation is set to 10/04/2024. Cancellation after this date will n
 ot be reimbursed. Please note that participation in SIB courses is subject
  to our [general conditions](https://www.sib.swiss/training/terms-and-cond
 itions).\n\n# Venue and Time\nThis course will be streamed. \n\nIt will st
 art at 9:00 and end around 17:00. Precise information will be provided to 
 the participants in due time.\n\n\n#  Additional information\nCoordination
 : Grégoire Rossier\n\n\nYou are welcome to register to the SIB courses ma
 iling list to be informed of all future courses and workshops\, as well as
  all important deadlines using the form [here](https://lists.sib.swiss/mai
 lman/listinfo/courses).\n\nPlease note that participation in SIB courses i
 s subject to our [general conditions](https://www.sib.swiss/training/terms
 -and-conditions).\n\nSIB abides by the [ELIXIR Code of Conduct](https://el
 ixir-europe.org/events/code-of-conduct). Participants of SIB courses are a
 lso required to abide by the same code.\n\nFor more information\, please c
 ontact [training@sib.swiss](mailto://training@sib.swiss).
SUMMARY:First Steps with SQL for Data Science
URL;VALUE=URI:https://www.sib.swiss/training/course/20240418_SQL
END:VEVENT
END:VCALENDAR