Course of study

Computer science B.U.T., second year, Data administration, management and use track

Pass the second year of the computer science B.U.T. in data administration, management and use, from databases to data that helps decide.

22 paths · 300 decks

Path 4

Proving an application works

Build an application's test campaign, from the unit to the interface, measure what it covers and run it on every change.

  1. Test levels

  2. From the user's side

  3. Measuring and automating

Path 8

Growing a network

Segment a network into VLANs, let it compute its routes with RIP, OSPF and BGP, and know its weaknesses.

  1. Configuring and segmenting

  2. Addressing and naming

  3. Dynamic routing

  4. Weaknesses

Path 9

Connecting an application to its database

Connect a program to its database safely, program logic inside it, stay correct when several users write at once and make a query fast..

  1. From the code

  2. Inside the database

  3. Concurrency

  4. Performance

Path 10

Shaping data well, in tables or otherwise

Normalise a relational schema from its dependencies and tell when another database model fits better.

  1. Normalising a schema

  2. Beyond the relational model

Path 11

Data to decide with

Go from a production database to a star schema, then to a dashboard where every figure helps someone decide.

  1. Modelling for analysis

  2. Reporting to decide

Path 12

Keeping a secret

Encrypt, decrypt and break the classical ciphers by hand, run RSA and Diffie-Hellman on small numbers, and detect and correct a transmission error..

  1. Arithmetic

  2. Symmetric ciphers

  3. Asymmetric ciphers

  4. Codes

  5. Going further

Path 13

Cryptography at work

Explain how hashing, signatures, block ciphers and certificates protect a real service, and recognise a faulty setup..

  1. Digests and signatures

  2. Block ciphers

  3. Trust on the network

  4. Beyond encryption

Path 15

Finding the best solution

Set up an optimisation problem and solve it by hand: linear programme, matching, gradient descent, search through a tree of possibilities.

  1. Optimising

  2. Searching the possibilities

Path 16

Working agile

Run a team with Scrum or Kanban, read its progress, describe a business process and carry a responsible product vision.

  1. Agility

  2. Organisation

  3. Innovation and ethics

Path 17

Steering an information system

Explain what an organisation's information system is for, align it with its strategy, weigh its risks and footprint, and lead the arrival of an ERP.

  1. The information system and what is at stake

  2. Governing

  3. Enterprise resource planning

  4. Deciding and keeping

Path 21

Communicating at work

Know how to find information, gather a need, write the documents of the trade, hold a defence or a meeting and support users, choosing each time the form that suits the reader or listener.

  1. The basics

  2. Finding information

  3. Gathering a need

  4. Writing

  5. Speaking and working in a group

  6. Supporting users

Path 22

Landing an internship or a job

Know how to read the market and a job posting, build a CV and a letter that answer it, hold an interview, and control what the web and your network say about you.

  1. Aiming right

  2. Applying

  3. Being visible

The course badge

Computer science B.U.T. year two, data administration, management and use

The first path fits in one session.

Free: the whole library, unlimited reviews, no ads. See pricing