facebook
from64.61USD/ h

Data Essentials: Learn SQL from scratch and master Querying and design

This course is for university students who would like to master data essentials and database querying. We learn normalisation, ER diagrams, DDL, DML as part of this course. Immerse yourself in practicing logics via different exercises. The couse will be tailored per your specific needs.

Extra information

Please carry your laptop

Location

Online via webcam
At student's location: Around Brussels, Belgium
At teacher's location: Trammuseum, Woluwe-Saint-Pierre, Belgium

|
Use ⊞+wheel to zoom!
+

General info

Age:
Children (7-12 years old)
Teenagers (13-17 years old)
Adults (18-64 years old)
Student level:
Beginner
Intermediate
Duration:
45 minutes
60 minutes
90 minutes
120 minutes
The class is taught in:English, Hindi, French

About Me

I am a software engineer with over 12+ years of experience and holds a Masters and a Bachelors degree in computer science. I have been doing web development for over a decade and has been various clients in design and develolment of systems end to end.
I work.

Architecture stack:
• Clean Architecture
• Hexagonal Architecture
• Event Driven Design
• Object Oriented Analysis and Design, Design patterns
• Design Patterns and Unified Modeling Language
• Outboxpattern
• Saga orchestration

Technical Stack:

Backend development:
• Synchronous, Asynchronous and Reactive Programming
• Java 21, Mockito framework
• Spring Boot, Spring Cloud, Spring Webflux, Reactor IO
• Apache Kafka , RabbitMQ, websockets, Debezium Event capture
• Swagger Open Api Specifications (OAS3.0)
• Websockets

Authentication and Authorization:
• OAuth 2.0, mTLS, Kerberos

Fronetend:
• Angular 13, NgRx Store, Bootstrap, PrimeNG, CSS3

DevOps:
• Kubernetes
• Ansible roles and playbooks via AWX
• Gitlab pipelines
• HashiCorp Vault
• Grafana
• Prometheus

Databases:
• MongoDB, MySQL

Education

Master of Technology, Indian institute of indormation technology design and manufacturing Jabalpur.

Bachelors of Technology in Computer Science and Engineering.

I can help in all Computer science/software engineeruing subjects.

Experience / Qualifications

Over 12+ years of experience in the IT industry. I have over a decade of experience in web development and has helped various clients in projects end to end. This involved designing and developing web projects. Additionally I have 2 years of experience as a Teaching assistant while completing my masters degree.


Architecture stack:
• Clean Architecture
• Hexagonal Architecture
• Event Driven Design
• Object Oriented Analysis and Design, Design patterns
• Design Patterns and Unified Modeling Language
• Outboxpattern
• Saga orchestration

Technical Stack:

Backend development:
• Synchronous, Asynchronous and Reactive Programming
• Java 21, Mockito framework
• Spring Boot, Spring Cloud, Spring Webflux, Reactor IO
• Apache Kafka , RabbitMQ, websockets, Debezium Event capture
• Swagger Open Api Specifications (OAS3.0)
• Websockets

Authentication and Authorization:
• OAuth 2.0, mTLS, Kerberos

Fronetend:
• Angular 13, NgRx Store, Bootstrap, PrimeNG, CSS3

DevOps:
• Kubernetes
• Ansible roles and playbooks via AWX
• Gitlab pipelines
• HashiCorp Vault
• Grafana
• Prometheus

Databases:
• MongoDB, MySQL

Reviews (1)

Sanyam, is very good at teaching. He explain in different ways so that I can understand it.
Learn python from scratch. This course will help you learn python from the very basic and will help develop your to think in a logical manner while programming with python programming language. We will cover functional as well as object oriented concepts in a fun manner that are easy to remember.
This course is for absolute beginners who would like to take the first steps in web development. The couse will cover all the aspects of HTML5 and CSS3 along with a personal portfolio. You will learn the web basics along with concepts like frontend and backend This coure will further be tailored per you pace and needs. Please drop a meesage for more information. Additionally I will help you with your assignments and creating webportals. .
Java programming classes for beginners. You will learn from the very basics of Java programming to advanced concepts. This is an indepth course to learn and master this language. By the end of the course you would be able to apply advanced concepts using java streams and concurrent programming. The classes will be tailored per your need and pace.
Learn Algebra in a fun way. The course will help you construct mental models and help in easy visualization of problems. This will involve a lot of exercies and practical explainations to theorems. The course will help you understand and sharpen the logical thinking.

Ask a question

Send a message explaining your needs and Sanyam will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1  Monday at 1:00  Tuesday at 1:00  Wednesday at 1:00  Thursday at 1:00  Friday at 1:00  Saturday at 1:00  Sunday at 1:00
2  Monday at 2:00  Tuesday at 2:00  Wednesday at 2:00  Thursday at 2:00  Friday at 2:00  Saturday at 2:00  Sunday at 2:00
3              
4              
5              
6              
7              
8              
9              
10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18              
19              
20              
21              
22              
23              
from $64.61At teacher's location
from $64.61Online via webcam
from $71.30At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Online reputation

  • Instructor since September 2018
  • 1 repeat student
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1  Monday at 1:00  Tuesday at 1:00  Wednesday at 1:00  Thursday at 1:00  Friday at 1:00  Saturday at 1:00  Sunday at 1:00
2  Monday at 2:00  Tuesday at 2:00  Wednesday at 2:00  Thursday at 2:00  Friday at 2:00  Saturday at 2:00  Sunday at 2:00
3              
4              
5              
6              
7              
8              
9              
10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18              
19              
20              
21              
22              
23              
from $64.61At teacher's location
from $64.61Online via webcam
from $71.30At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Share

You are here

Private lessons

Salah Eddine
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is Welcome
Master Python with Personalized Courses Discover the art of programming with Python courses tailor-made to meet your specific needs. Whether you are a beginner, intermediate or professional, my lessons are suitable for all levels. Why Choose My Courses? Personalized Teaching Approach: Each course is tailored to your skill level and individual goals. Practical Experience: Learn by doing with real-world projects that build your understanding and skills. Ongoing Support: Get unlimited email support for any questions you have between sessions. As a Python expert, I have a passion for teaching and sharing my knowledge. My goal is to guide you effectively in your learning journey. Book Your First Lesson: Start your journey to Python mastery now by booking your first lesson. Whether you aspire to enter the development field or hone your existing skills, these courses are designed for you.

Aniket
Certified Trainer For Web Development (Front-End and Backend) Nodejs | MEAN | MERN with 300+ Reviews
- 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

Alex
Python Learning Based on Projects - Master your Skills by Applying them in Real-Life Projects
I am a freelancer who graduated from the University of Westminster, where I began my journey into programming. During my studies, I started applying programming skills to solve physical and mathematical problems. Since then, I’ve developed a passion for continuous learning and have expanded my expertise in data implementation and software development. For the past 16 years, I have been offering private programming lessons, helping students of all ages and backgrounds, from beginners to advanced learners. Whether you're a student looking to build a project portfolio, prepare for an exam, or a professional aiming to learn Python through practical applications, I can help you reach your goals. What I Offer: Learn Python by building projects: From the basics to more advanced concepts, you will learn programming through hands-on experience, working on real-world projects that solidify your understanding. Customized lessons: I tailor each lesson to your learning style and needs, whether you're just starting out or looking to deepen your skills. Project support: Whether you're working on a portfolio, completing a boot camp project, or preparing for an exam, I offer guidance and assistance to help you succeed. Step-by-step approach: Before each lesson, you'll receive study materials and exercises designed to help you grasp the concepts we’ll cover. Afterward, you'll receive homework to reinforce what you've learned. Flexible online lessons: Learn from the comfort of your home with flexible scheduling. I currently work as a freelancer, collaborating with companies, startups, and schools to deliver online programming classes. If you’re eager to learn Python in a practical, engaging way, or if you have any questions, feel free to send me a message - I will surely reply. Thank you, Alex

Amin
Programming with Python, with C and database management (Introduction to machine learning)
Looking to master programming and become a skilled developer? In this course, you'll learn the basics of Python and other programming languages, as well as how to use them to build machine learning models. We also offer specialized assistance for students in programming and database management using SQL (CPGE students). Python is a powerful general-purpose language used in web development, data science, software prototyping, and more. Its simple and easy-to-use syntax makes it an excellent choice for beginners learning to program. Additionally, upon request, we offer courses in other programming languages such as C, R, and MATLAB. Classes can be conducted remotely or in person, and we tailor our instruction to meet individual or group needs. If you have any questions, feel free to contact us.

Emna
[PYTHON - Data Science - AI] Learn Python & Data Science & Artificial Intelligence from beginner to advanced
You are a highschool student? You have a baccalaureate? You need help with Python (Algorithmic Programming). I am here to teach you ! I am certified from Python Institute (PCAP: Certified Associate in Python Programming) and I work with Python for more than 5 years. I am also a teacher and my students love the way I teach with (simple, clear and always funny)

Yedija Messa Sirao
Learning and Mastering Artificial Intelligence and Data Science: From Fundamentals to Advanced Applications for Real-World Success
Welcome to "AI and Data Science" – a comprehensive, customizable course designed for learners at any level, from beginners to advanced professionals. Whether you're just starting your journey into the world of artificial intelligence and data science or looking to enhance your existing skills, this course will provide you with the knowledge and practical tools you need to excel. What You'll Learn: Fundamentals of Data Science: Understanding data collection, cleaning, and preprocessing; learning to analyze and visualize data using tools like Python, Pandas, and Matplotlib. Introduction to AI and Machine Learning: Explore basic concepts of AI, supervised and unsupervised learning, and popular algorithms (e.g., regression, classification, clustering) with hands-on coding exercises. Advanced AI Techniques: Delve into deep learning, neural networks, and advanced algorithms like decision trees, SVMs, and reinforcement learning. Practical Projects: Work on real-world projects such as predictive modeling, sentiment analysis, and building AI applications using Python libraries like TensorFlow and PyTorch. Storytelling with Data: Develop skills to communicate insights effectively, using data visualization tools and storytelling techniques to create compelling narratives from data. Database Management: Learn how to work with databases (SQL and NoSQL) and manage data efficiently for large-scale applications. What to Prepare: Basic Computer Skills: No prior programming experience is required for beginners, but familiarity with basic computer operations is recommended. Software Setup: Students will need to install software like Python, Jupyter Notebooks, and data science libraries (instructions will be provided during the course). Curiosity and Dedication: This course encourages a hands-on approach, so students should come ready to code, experiment, and learn through practical examples. What to Expect: Customized Learning Experience: Lessons are tailored based on the student’s level and goals, ensuring a personalized approach that aligns with your learning pace and interests. Supportive Environment: Receive one-on-one mentoring and support to help you overcome challenges and master complex topics. Skills You Can Apply Immediately: Gain practical, job-ready skills that are in high demand across industries, including AI, finance, marketing, and tech.

Alberto
Power BI applied. Charts, visualizations and data models.
In this course you will learn how to transform your data into useful information for decision making through visualizations. You will also create your data model. Cake Graphics. Bar Charts. Dispersion. Measurements. DAX expressions. At the end of the course you will have created your first report in Power BI Desktop.

Jerome
PhD in cognitive psychology and statistician teaches psychology, neurosciences and statistics
Experienced teacher in science and doctor in psychology and cognitive neurosciences graduated from the University of Strasbourg (holder of a master 2 in research in Biology and a professional master 2 in scientific communication), I offer private lessons in psychology (cognitive , social, developmental psychology, neuropsychology etc.), neurosciences as well as in statistics (theoretical and applied to experimental protocols) with a personalized methodology according to the needs and potentialities of each student. Thanks to a rigorous pedagogical approach, specific and adapted to each request, I offer effective methodological assistance (references available) to meet the expectations of the students and to achieve or even exceed the objectives set. My courses also include a coaching method to optimize the learning and training necessary to pass university exams in psychology, neuroscience and statistics (as well as your research dissertations and oral defenses with or without PowerPoint support). My courses are aimed at students (in psychology, neurosciences, medicine, etc.) wishing to optimize their performance and marks in exams and competitions. Schools, Universities and teaching institutes: Universities of Strasbourg and Paris 8, CNRS, Ecole Polytechnique, ESSEC Business School, ISTH, IONIS Education Group, EEEA, Institut Tocqueville etc.

Mohammad
Programming Assignments | Tutoring | Coding | GCSE | AI
This course provides a comprehensive introduction to the core principles of Computer Science, with a focus on practical applications in Computer Programming and Database Management. Students will explore the fundamentals of programming, learning how to write, analyze, and debug code using modern programming languages. The course also delves into database concepts, covering data storage, retrieval, and management techniques. By the end of the class, students will be equipped with the skills necessary to design efficient programs and manage databases effectively, preparing them for more advanced studies in computer science and related fields.

Erin
Tutoring in computer science (IT) and related subjects such as digital engineering
Offering tutoring for computer science (IT) and related subjects such as digital engineering for pupils, entry-level university students and trainees! My lessons are aimed at high-school level computer science (IT) pupils (AHS/BHS in Austria, “Gymnasium”/“Berufsgymnasium” in Germany), as well as entry-level university students and trainees in IT-heavy apprenticeships (“Lehrberuf” in Austria/Germany). The length and type of each individual lesson can vary based on the needs and wishes of my clients (project-related several hour-long blocks, weekly 60/90/120 minutes, interventions before tests/deadlines, ...). I try to lead my students to suitable solutions by asking specific questions, drawing on previously covered material as necessary to establish links aiding them in their understanding of the subject matter at hand. If all else fails, I’ll suggest a solution to my student and discuss with them how they could have derived this solution by themselves. Subjects we could work on include: databases, Linux/Unix, Web, microcontrollers, networking, server-administration, system-level programming, regular expressions, object orientation, state machines, ...

Ashington
STATISTICS AND STATISTICAL METHODS FOR STUDENTS AND PROFESSIONALS
This class covers statistics and statistical methods for data analysis which cuts across all industry and disciplines. Sample topics, Statistical calculations Statistical methods Statistical analysis Quantitative analysis Quantitative analysis techniques Non Quantitative data analysis Research methods Research methods paper section Mathematical analysis Statistical software and spreadsheets like Rsutdio, Excel, SPSS, and many others. and any statistical topic requests by students

Ana
Statistics, Data Analysis, Math, Economics all levels
I am a Ph.D. student at the University of Luxembourg. For the past 4 years, I taught the University: statistics and probability theory to first-year students, and economics to 3th-year students. I really enjoy teaching. I am looking forward to helping students when they need reinforcement on different subjects, or anyone interested in learning the following topics: For maths: System of equations, derivatives, integrals, type of equations, etc. For statistics: Probability theory, descriptive statistics, regression analysis, multivariate analysis, hypothesis testing, and methods for causal inference. For young professionals: I have extensive experience in data analysis, data management, and statistical modeling. My class mixes both theoretical and practical parts using financial data as examples. If you are interested, just write me a message telling me what topics are you interested in learning.

Brahim
Introduction to NoSQL DataBase MongoDB by Pratique
Do not deal with the manual with terms of reference statements and basic documents that cannot be obtained in order to avoid the MongoDB problem. Please include the connection to one of the MongoDB données base, comment on simple CRUD operations and sujets clés que l'agrégation, l'indexation, la mode des données et les Transaction. 1- Install MongoDB 2- Implement MongoDB 3- Use of documents and collectibles 4 - Leadership Committee 5- Execute CRUD commands (create, read, update, delete) avec mongo shell 6- Type the register in a MongoDB database 7- Reset the base to remonter specific documents depuis mongo shell. 8- Lagrégation 9- Indexing 10- Amending institutions and transactions

Amy
Lets Get Organised! Unlocking Your Data: Airtable for beginners - discover the magic of databases and project management without the stress!
Discover the Magic of Airtable: A Beginner's Guide to Database Bliss! Hey there! Are you intrigued by the idea of organising your life or business with a database tool but feel overwhelmed by the tech jargon? Don't worry, I've got your back! Join me for a laid-back class where we'll demystify the world of databases, starting with everyone's favourite: Airtable the no-coding needed database platform. I can show you the ropes of Airtable no need for fancy degrees or prior experience - just bring your curiosity and a willingness to learn! What's on the agenda, you ask? Well, we'll kick things off by getting cozy with the Airtable interface, so you can navigate like a pro in no time. Then, it's time to roll up our sleeves and dive into the juicy stuff: creating your own custom databases! Potential uses of Airtable bespoke creation: - Personal Task Management - Event Planning - Inventory Management - Content Calendar - Customer Relationship Management (CRM) - Project Management - Habit Tracking - Budgeting and Expense Tracking But hey, don't sweat it if you're not sure what kind of database you need. Whether you're a freelancer, small business owner, or just someone trying to keep track of your life admin, I'll help you brainstorm ideas and tailor your database to fit your unique needs. From managing contacts to tracking projects or even organizing your collection of cat memes (we don't judge!), Airtable's got you. And the best part? I can show you how to do it all without pulling your hair out in frustration! So, if you're ready to kick your spreadsheet game up a notch and embrace the zen of organized data, grab a spot with a class and let's get this database party started!

Adam
💻 Code Confidently! 🚀 Get expert help from the leader and founder of Teringette Programming School 🎓👨‍🏫.
Are you a university student 🎓 aiming to pass your programming exams and seeking guidance? 💻 Then these programming lessons are specially curated for you! 🚀 ⦿ Specialized support to conquer university assignments 📚 and excel in exams 📝. ⦿ Hands-on learning through live project development 🔧 to bolster your academic achievements 🎯. ⦿ Access to a wealth of learning materials: 📑 slides, 🎥 videos, 📖 tutorials, and supplementary reading resources 📚. ⦿ Patient, friendly, and supportive teaching approach 🤝. My goal is to assist university students in overcoming programming hurdles and achieving success 💡. Let's pave the way to exam success together 🏆—join these tailored programming lessons for your academic triumph! 🎯🎓