Trusted teacher

This course aims to: -Understand the notions of relational databases: Entities, attributes, relationship types: cardinalities and identifier. -Organization of data in the form of tables and exploitation using a declarative language (mysql, Transact-SQL) -Implement acquired knowledge.

Trusted teacher

I work as a data consultant and hold a master's degree in Data Science and Statistics from UCLouvain. I use SQL and databases in a professional context. I offer SQL courses for students, beginners and people wishing to learn how to query and manipulate data in a structured way. The lessons are tailored to your level and your goal. We can work on, among other things: * understand how a relational database works; * Write your first SQL queries; * SELECT, WHERE, ORDER BY and DISTINCT; * GROUP BY, HAVING and aggregation functions; * understand and use the different types of JOIN; * subqueries and CTE; * SQL functions and window functions; * Data manipulation and analysis using SQL; * understanding and optimization of queries; * solving exercises and preparing for exams; * Debugging and correcting SQL queries. I favor a practical approach: we start with exercises or concrete datasets and gradually build the queries. The goal is to understand the logic behind SQL rather than memorizing commands. I can also assist you with an exercise, project or student work by explaining the process, the questions and the errors encountered, without doing the work for you.

Trusted teacher

Description: This course is a comprehensive introduction to database management, including design, administration, and integration into applications. Goals : Understand relational models and the use of the SQL language. Create and administer efficient and secure databases. Integrating foundations into modern applications. Course methods and format: Video courses: Guided practice on tools like MySQL or PostgreSQL. Flexibility: Exercises adapted to your specific projects. For who ? Students, developers or professionals wishing to master databases.

Trusted teacher

- B.tech and M.tech in Computer Science - Worked as a Software engineer in Virtusa Corp & DIGIDEZ - More than 6 years of teaching experience - Oracle Certified Developer - Helped students placed in FAANG Featured Review : Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!! Thanks Aniket

Trusted teacher

This course is accessible for all skill levels, from those who want to learn programming to those who are already familiar with it. Therefore, the purpose of the course will depend primarily on your knowledge and what you wish to learn. Obviously, if you are a complete beginner, you will be given an algorithm course to familiarize yourself with programming methods. These algorithm courses will be complemented by exercises in Pascal, Python or Java (or other programming language according to your preference) where other concepts will appear as we go along (procedures, object-oriented, ...). SQL courses will also be offered for intermediate and/or advanced level students. The idea of this course is to help you understand concepts either through theory, through kata, or both. The most advanced courses will focus on frameworks such as Vaadin, JavaFX, ... In short, feel free to contact me for further information and/or to provide me with the information that will allow me to offer you a tailor-made course that meets your needs. I remain available for an initial contact to assess your level or knowledge if you need it.