Training
Train your developers: it pays off!
In-house Training · Course Content
HFSQL C/S
Thematic Training · 3 days (21 h)
You will learn to install an HFSQL server, use the HFSQL Control Center, migrate an HFSQL Classic database, optimize processes, stored procedures and queries, triggers, persistent parameters, manage rights and users programmatically, replication, set up SQL and materialized views, use HFSQL in the cloud, etc.
Prerequisites (Who is this training course intended for?)
Target audience: developers who need to install, administer and optimize HFSQL Client/Server databases.
Prerequisite: have already developed applications with PCSoft's DevOps IDEs (WINDEV/WEBDEV) or have previously attended the WINDEV or WEBDEV Fundamentals training courses.
Practical information
- Basis: 9 respondents out of 9 trainees (response rate 100%), 5 sessions from October 21, 2024 to October 21, 2026, inter-company, on-site and remote.
- Satisfaction questionnaire completed at the end of the course.
-
Calculation:
- each criterion is rated on the scale of its section;
- percentage = average / maximum score × 100, rounded to the nearest whole number;
- score out of 20 = average / maximum score × 20, rounded to one decimal place.
- Results of sessions delivered in French.
Training
20.0/20Average of criteria, based on 9 reviews. 3-level answer converted into points: Suitable = 20, Easy = 15, Very technical = 10 (out of 20).
- The content
- 20.0/20
-
Suitable 100 % Easy 0 % Very technical 0 %
- Exercises
- 20.0/20
-
Suitable 100 % Easy 0 % Very technical 0 %
- Progression
- 20.0/20
-
Suitable 100 % Easy 0 % Very technical 0 %
Trainer
20.0/20Average of criteria, based on 9 reviews. Score from 1 to 5.
- Explanations
- 20.0/20
- Technical level
- 20.0/20
- Pedagogy
- 20.0/20
- Comprehension
- 20.0/20
- Facilitation
- 20.0/20
The practical aspect (in-person)
19.7/20Average of criteria, based on 7 reviews. Score from 1 to 3; on-site sessions only (not applicable to remote sessions).
- Room
- 20.0/20
- Location
- 19.0/20
- Equipment
- 20.0/20
| Indicator | In-person | Online |
|---|---|---|
| Respondents | 7 | 2 |
| Training rating | 19.7/20 | 20.0/20 |
| Trainer rating | 20.0/20 | 20.0/20 |
| Average of criteria, training | 20.0/20 | 20.0/20 |
| Average of criteria, trainer | 20.0/20 | 20.0/20 |
| Practical Considerations | 19.7/20 | not applicable |
| Would recommend it | 100 % | 100 % |
| Multiple-choice test pass rate | 100 % | 100 % |
| Test participation rate | 100 % | 100 % |
| Dropout rate | 0 % (no trainee left the course before the end during this period) | |
Detailed Program
The following is the suggested content of this training session:
(This content can be fully customized)
The instructor uses the course materials, which are tailored to the training objectives (the materials are provided at the beginning of the course). This course support material is divided into subjects.
All of these methods and exercises will help you put into practice what you have learned, when you return to your company.
Each subject is based on 3 axes:
The trainer gives a theoretical presentation of the topic, followed by any questions and answers.
Practical application exercise (individual work) to be completed within a set time limit. The trainer remains available to help and provide additional explanations.
Correction of the exercise, with all necessary explanations and any questions and answers. The trainer makes sure that each trainee has fully understood the exercise before continuing.
HFSQL C/S 3 days (21 hours)
- Install the HFSQL Client/Server database (topics 1, 2, 6)
- Use the HFSQL Control Center (topic 2)
- Migrate an HFSQL Classic database and the associated projects (topic 3)
- Manage and administer databases (topics 2, 4, 5)
- Manage and administer user access rights (topics 2, 4)
- Features and installation prerequisites
- The benefits of Client/Server
- Installation principles
- Creating databases
- Network configuration (opening ports)
- Updating
- Managing HFSQL in the cloud
- Implementing GDPR
- Data anonymization
- The vault
- Importing HFSQL Classic files
- Adapting the analysis
- Adapting the projects
- Creating and managing connections
- User management
- Rights management
- Managing subdirectories in Client/Server mode
- Optimization: divide your execution times by 4
- Transactions
- Stored procedures and queries
- Query optimization
- Query EXPLAIN
- Asynchronous queries
- Security (server side and application side)
- Record locks
- Sending messages between users
- Persistent parameters
- Triggers
- SQL views
- Materialized views
- Turn your HFSQL Control Center into a "user-friendly" querying tool
- Universal replication
- HFSQL C/S server replication
- Spatial data
- Creating and configuring administration tasks
- Managing database backups
- Generating the setup and its specific features
Teaching, technical and supervisory resources
Each participant is equipped with:
- printed course materials
- a notebook
- a pen
The instructor leading the training is an experienced PCSoft employee.
During the training, you will be in constant contact with the trainer via the GoTo Meeting (©) software, which allows you to share your screen and the trainer's screen. You will connect to the workstations using RustDesk (©); the trainer will provide you with the login information on the first day of the training.
You can also interact with the other participants to foster a friendly atmosphere during the training and promote productive technical discussions.
The course materials (PDF format) are sent to you with the joining instructions before the training begins.
Learn more about the online formatArrangements
- Price
- Flat rate for 1 to 8 developers on-site and 1 to 6 remote. Ask us for a free quote.
- Financing
- skills development plan, OPCO, direct funding.
- Agreement
- A detailed training agreement is available upon request.
- General conditions
- PCSoft's general terms and conditions and specific training terms and conditions apply.General Terms and ConditionsSpecial Terms and Conditions of Service
- Rules and Regulations
- Please review the rules and regulations for trainees at the PCSoft training center.Rules and RegulationsProcedure for the Prevention and Handling of Violence, Harassment, and Discrimination
Methods for monitoring the execution of the training session
At the end of the training course, participants' mastery of the skills is assessed through a multiple-choice test. Non-certification, non-degree program—certificate of completion.
Frequently Asked Questions
Find answers to your most common questions: skills development plan, funding, registration, practical details, list of hotels, and more.
View the FAQYou can also contact the training department: formation@pcsoft.fr · +33 (0)4 67 032 032
Prices and VAT
It all depends on where you live:
- Mainland France: The training is subject to French VAT (20% as of 01/01/2014).
- Overseas Departments (DOM): The VAT rate (known as "octroi de mer") varies by DOM (Martinique, Guadeloupe, and Réunion: 8.5%; French Guiana: VAT-exempt).
- COM and POM: excluding tax.
- EEC: Invoicing excluding tax (provide the European VAT number).
- Other countries (outside the EEC): excluding tax.
Accessibility
PCSoft is particularly committed to including people with disabilities in its training programs.
Access Lead Times
The training date will be set in consultation with you: it can begin 2 to 4 weeks after the quote is approved, depending on the trainers' availability.
PCSoft is Qualiopi-certified for its training programs; certified process No. 2021/92442.2 (AFNOR Certification).Learn more
