Translated by Google
SQL course for beginners to intermediate learners | the fundamentals (In-person or online)
From 442.87 CNY /h
This course is aimed at people wishing to acquire a solid foundation in SQL and progress to an intermediate level in the manipulation of relational databases.
The training covers the fundamentals of the SQL language, then gradually progresses towards more advanced queries:
-Understanding how relational databases work
-Write simple queries using SELECT, WHERE, ORDER BY
-Use the aggregation and GROUP BY functions
-Manipulate data using INSERT, UPDATE, DELETE
-Create and structure tables
-Use different types of JOIN
-Write subqueries
-Utilize date and text functions
-Optimize and structure their queries
The course is practice-oriented, with progressive exercises and real-world cases to develop a clear and operational understanding of SQL.
The training covers the fundamentals of the SQL language, then gradually progresses towards more advanced queries:
-Understanding how relational databases work
-Write simple queries using SELECT, WHERE, ORDER BY
-Use the aggregation and GROUP BY functions
-Manipulate data using INSERT, UPDATE, DELETE
-Create and structure tables
-Use different types of JOIN
-Write subqueries
-Utilize date and text functions
-Optimize and structure their queries
The course is practice-oriented, with progressive exercises and real-world cases to develop a clear and operational understanding of SQL.
Extra information
You must have a computer.
Location
At student's location :
- Around Geneva, Switzerland
At teacher's location :
- Chemin Edouard-Tavan, Genève, Suisse
Online from Switzerland
About Me
Student in Master's in Digital Systems and Services, specializing in User Experience, and holding a Bachelor's degree in Information Systems and Service Science from the University of Geneva, as well as a Bachelor's degree in Network and Service Administration from the Higher Institute of Computer Science at Tunis El Manar University. 🎓💼
I also work as a teacher for robotics programming courses for children and as a digital advisor at NoLimit, where we train candidates to apply for and find jobs through various workshops covering different digital themes. 💻🤖🔧
I aspire to share my knowledge and expertise as a robotics programming teacher for children and digital advisor at NoLimit. My diverse background and skills in programming and digital consulting make me an ideal choice to offer computer courses on the Apprentus platform. 🎓🌟
I also work as a teacher for robotics programming courses for children and as a digital advisor at NoLimit, where we train candidates to apply for and find jobs through various workshops covering different digital themes. 💻🤖🔧
I aspire to share my knowledge and expertise as a robotics programming teacher for children and digital advisor at NoLimit. My diverse background and skills in programming and digital consulting make me an ideal choice to offer computer courses on the Apprentus platform. 🎓🌟
Education
- Master's in Digital Systems and Services, specializing in User Experience
- Bachelor's in Information Systems and Service Science
- Bachelor's in Computer Networks
- High School Diploma in Information Sciences
- Bachelor's in Information Systems and Service Science
- Bachelor's in Computer Networks
- High School Diploma in Information Sciences
Experience / Qualifications
Skills
UX UI Design | Web Design | HTML5 | JAVASCRIPT | CSS3 | XML | UML Modeling | SQL Database Design and Creation | BPMN | Project Management | Agile Methodologies SCRUM | Wordpress | Concrete5 | Behat | GIT
Tools
Adobe Photoshop | InDesign | Adobe XD | Figma | Axure RP | Balsamiq | Trello | Jira | Slack | Unity | GitHub
UX UI Design | Web Design | HTML5 | JAVASCRIPT | CSS3 | XML | UML Modeling | SQL Database Design and Creation | BPMN | Project Management | Agile Methodologies SCRUM | Wordpress | Concrete5 | Behat | GIT
Tools
Adobe Photoshop | InDesign | Adobe XD | Figma | Axure RP | Balsamiq | Trello | Jira | Slack | Unity | GitHub
Age
Children (7-12 years old)
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Duration
60 minutes
The class is taught in
French
English
Arabic
Skills
Reviews
Availability of a typical week
(GMT -05:00)
New York
At teacher's location and via webcam
At student's home
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
🌟 Course for Beginners - Discover the Secrets of Adobe Photoshop! 🌟
Have you always wanted to master Adobe Photoshop, but the features seem intimidating? Do not worry anymore! I offer courses specially designed for beginners, to guide you step by step into the fascinating world of Photoshop.
🖌️ What you will learn:
The essential basics of the Photoshop interface.
Image editing tools to improve your photos.
Creating simple and impactful designs.
🗓️ Flexible hours:
Choose sessions that fit your busy schedule.
🎓 Experienced Trainer:
Benefit from the expertise of an experienced trainer who will guide you through each step, allowing you to unleash your creativity.
Have you always wanted to master Adobe Photoshop, but the features seem intimidating? Do not worry anymore! I offer courses specially designed for beginners, to guide you step by step into the fascinating world of Photoshop.
🖌️ What you will learn:
The essential basics of the Photoshop interface.
Image editing tools to improve your photos.
Creating simple and impactful designs.
🗓️ Flexible hours:
Choose sessions that fit your busy schedule.
🎓 Experienced Trainer:
Benefit from the expertise of an experienced trainer who will guide you through each step, allowing you to unleash your creativity.
387.51 CNY /h
🧑💻 WordPress Course – Beginner Level
This course is designed for anyone who wants to create and manage a website with WordPress, without prior technical knowledge.
You will learn step by step how to install WordPress, understand its interface, create pages and articles, customize the design of your site and add essential features using themes and extensions.
At the end of the training, you will be able to:
Create a showcase website or a professional blog
Manage content (text, images, menus)
Customize the site's appearance
Install and configure useful extensions
Understanding the basics of security and backups
🎯 Objective: to become self-sufficient in creating and managing a WordPress site.
👥 Target audience: beginners, entrepreneurs, freelancers, students, associations.
This course is designed for anyone who wants to create and manage a website with WordPress, without prior technical knowledge.
You will learn step by step how to install WordPress, understand its interface, create pages and articles, customize the design of your site and add essential features using themes and extensions.
At the end of the training, you will be able to:
Create a showcase website or a professional blog
Manage content (text, images, menus)
Customize the site's appearance
Install and configure useful extensions
Understanding the basics of security and backups
🎯 Objective: to become self-sufficient in creating and managing a WordPress site.
👥 Target audience: beginners, entrepreneurs, freelancers, students, associations.
Show more
Similar classes
Similar classes
Good-fit Instructor Guarantee
Contact Amine