IT refresher course

Refresher course for ENSAI students who have been admitted directly into the second year

This section has been translated by a generative AI and may contain errors.

ImportantWhy this refresher course?

This refresher course is intended for students directly entering the second year of ENSAI. It provides an overview of the courses followed by first-year students.

The computer science project starts at the beginning of the second year.

It is therefore essential for everyone to have the basics of Python, OOP, SQL, and UML in order to start the computer science project with confidence.

These courses are to be completed independently. The estimated workload is 21 hours.

Prerequisites and Datalab

• Create a GitHub account
• Create an account on SSP Cloud
  • using your email firstname.lastname@eleve.ensai.fr
• Read this page about Datalab
• Create a token by following the instructions above
  • you will find the information here

Program

Git

3h

Git is a version control system that allows you to track changes made to files, collaborate efficiently, and keep the history of a project.

• Read the Git presentation
• Quick Git practical work Introduction course to databases and SQL

Introduction to SQL

3h

SQL (Structured Query Language) is the standard language used to create, query, modify, and administer relational databases.

• Read the introduction course to databases and SQL
• Complete the exercise

Introduction to Python

6h

Python is a versatile programming language, easy to learn and widely used for application development, data analysis, artificial intelligence, and automation.

• Read the introduction course to Python
• Read and complete the exercises from the 5 notebooks

Object-Oriented Programming

9h

OOP is a programming paradigm that consists of modeling a program as objects combining data (attributes) and behaviors (methods).

You can start by creating a clone of the Git repository on your machine:

• Open Git Bash, then paste the following commands
  • mkdir -p /p/Cours2A/UE3_Remise_a_niveau && cd $_
  • git clone https://github.com/ludo2ne/ENSAI-2A-remise-a-niveau.git
  • this creates a copy of the repository in P:/Cours2A/UE3_Remise_a_niveau/ENSAI-2A-remise-a-niveau

---

• Read the introduction course to OOP
• Follow the instructions for VSCode configuration
• Complete the exercises

UML

3h

UML is a graphical modeling language used to represent the structure and behavior of a software system before or during its development.

• Read the introduction course to UML
• Complete the exercise

Alternatives

Here are other possibilities to get up to speed in Python, OOP, and SQL.

Videos from the 2022-2023 session

If you have access to MyENSAI, videos from the 2022-2023 session are available here

Online courses to learn Python and SQL

• Openclassrooms - Query a database with SQL
• Introduction to Python from the Public Statistical Service
• Openclassrooms - Python basics (parts 1 and 2)
• Openclassrooms - OOP with Python (parts 1 and 2)

Useful resources

• https://realpython.com/
• https://refactoring.guru/
• https://github.com/faif/python-patterns
• https://inseefrlab.github.io/formation-bonnes-pratiques-git-R/
• Python for data science, Lino Galiana (INSEE, ENSAE)