SQL language e-learning channel
Practical course - 1d
- 04h58 - Ref. 8SQ
|
 | Know the main concepts of a database. |
| Use the SQL Server Management Studio query editor. |
| Insert, modify and delete data. |
| Filter and sort results. |
| Aggregate and join. |
| Use SQL in a Data Science context. |
| Use advanced functions such as Cube and Rollup. |
Intended audience
Anyone wishing to learn how to use SQL for relational databases.
Prerequisites
Basic knowledge of databases.
Practical details
Digital activities
IT structure: recorded courses, expert videos and best practice sharing.
Mentoring
The tutoring option offers personalized support from an ORSYS trainer who is an expert in the field. Adapted to the needs, abilities and pace of each learner, this tutoring combines asynchronous follow-up (personalized corrections of exercises, unlimited exchanges by message...) and individual synchronous exchanges. The result: better understanding, skills development and lasting commitment to training.
Pedagogy and practice
A wealth of content produced by trainers following a rigorous pedagogical approach. During each course, operational cases are commented on by experts to help learners put into practice what they have just learned. To help learners anchor their memory, each content item is broken down into short sequences of 3 to 10 minutes. This enables each learner to learn dynamically and independently.
Course schedule
1 SQL language, basic functions for querying a database
- Introduction to databases.
- Insert, modify or delete data.
- Retrieve data.
2 SQL for Data Science
- SQL language.
- Data handling.
- Joins and subqueries.
- Advanced SQL functionality.
- Analysis of complex data.
PARTICIPANTS
Anyone wishing to learn how to use SQL for relational databases.
PREREQUISITES
Basic knowledge of databases.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
Anyone wishing to learn how to use SQL for relational databases.
PREREQUISITES
Basic knowledge of databases.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.