facebook
from49.80GBP/ 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 -06:00) Chicago
MonTueWedThuFriSatSun
0  Monday at 0:00  Tuesday at 0:00  Wednesday at 0:00  Thursday at 0:00  Friday at 0:00  Saturday at 0:00  Sunday at 0:00
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              
3              
4              
5              
6              
7              
8              
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
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              
18              
19              
20              
21              
22              
23              
from £49.80At teacher's location
from £49.80Online via webcam
from £54.95At 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
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -06:00) Chicago
MonTueWedThuFriSatSun
0  Monday at 0:00  Tuesday at 0:00  Wednesday at 0:00  Thursday at 0:00  Friday at 0:00  Saturday at 0:00  Sunday at 0:00
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              
3              
4              
5              
6              
7              
8              
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
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              
18              
19              
20              
21              
22              
23              
from £49.80At teacher's location
from £49.80Online via webcam
from £54.95At 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.

Valnor
Basic computer and programming courses for beginners
💻 Learn IT easily with tailor-made support! 🚀 Do you want to improve your computer skills or discover the basics to better navigate the digital world? I offer courses adapted to all levels, whether you are a beginner or looking to improve. 🌟 Why choose me? • Adapted teaching: I explain concepts in a simple and clear manner, even for novices. • Personalized courses: Each session is designed according to your needs and objectives. • Hands-on learning: Immediately apply what you learn. 📘 Areas covered: • Introduction to computers (using the computer, browsing the internet, security). • Office software (Word, Excel, PowerPoint). • Introduction to programming (Python, HTML/CSS). • Basics of data management and analysis with tools like Power BI. 🕒 Flexible hours: Classes available on weekdays or weekends, depending on your schedule. 📍 Modalities: In person or online, according to your preferences. 👉 Contact me now to start your adventure in the digital world!

Efetabo
Building Marketing Campaigns with Data and Communication Excellence
Learn how to create impactful marketing campaigns by combining data insights with effective communication strategies. This class will teach you to analyze customer data, identify trends, and design campaigns that resonate with your audience while delivering measurable results. Perfect for anyone looking to elevate their marketing efforts.

Bert
Programming Teacher ( Java, PHP, Javascript, Python, SQL)
English: Do you want to learn programming or take your skills to the next level? I am an experienced software developer and tutor with in-depth knowledge of languages such as Java, JavaScript, Python, HTML, SQL, and more. Whether you are an absolute beginner, a child just starting out, or already have experience, I’m here to assist you with clear explanations, hands-on exercises, and personalized guidance. My approach is flexible and tailored to your learning style. Whether you want to build a solid foundation, need help with a specific project, or want to better understand complex concepts – together, we’ll make programming fun and accessible! Contact me, and let’s get started. 🚀 Thai: คุณต้องการเรียนรู้การเขียนโปรแกรมหรือยกระดับทักษะของคุณไปอีกขั้นไหม? ฉันเป็นนักพัฒนาซอฟต์แวร์และครูผู้สอนที่มีประสบการณ์และความรู้ลึกซึ้งในภาษาเช่น Java, JavaScript, Python, HTML, SQL และอื่นๆ ไม่ว่าคุณจะเป็นมือใหม่ที่เริ่มต้นเลย หรือเด็กที่เพิ่งเริ่มเรียน หรือมีประสบการณ์แล้ว ฉันยินดีช่วยเหลือคุณด้วยคําอธิบายที่ชัดเจน การฝึกฝนเชิงปฏิบัติ และคําแนะนําที่ปรับให้เหมาะสมกับคุณ แนวทางของฉันมีความยืดหยุ่นและปรับให้เหมาะกับสไตล์การเรียนรู้ของคุณ ไม่ว่าคุณต้องการสร้างพื้นฐานที่มั่นคง ต้องการความช่วยเหลือในโครงการเฉพาะ หรืออยากเข้าใจแนวคิดที่ซับซ้อนมากขึ้น – เราจะทําให้การเขียนโปรแกรมเป็นเรื่องสนุกและเข้าถึงได้! ติดต่อฉันและเริ่มต้นกันเถอะ 🚀

Oussama
Mastering Relational Database Management: Personalized Courses with SQL, DBSM, MySQL, and PostgreSQL
I offer personalized courses that cover a wide range of topics, from the basics of relational database management to advanced data manipulation using query languages such as SQL and tools such as DBSM, MySQL, and PostgreSQL. My courses are tailored to the needs and learning styles of each student, and I am committed to helping my students achieve their individual learning goals. Whether you are a beginner or looking to improve your skills, I can help you develop your relational database management skills and take your expertise in this field to the next level. I am excited to guide you through the world of relational database management and help you master the skills necessary to succeed in this field. Please do not hesitate to contact me for more information about my services and how I can help you achieve your relational database management goals.

Muhammad
Master Programming & Computer Science: GCSE, A-Level, BSc
I offer engaging and comprehensive programming lessons in C++ and Python, designed to help you master essential concepts and advanced topics in computer science. From problem-solving techniques, object-oriented programming, and data structures to database management, operating systems, digital logic design, and algorithm analysis, my lessons cover it all. I also introduce exciting areas like parallel and distributed computing and the basics of artificial intelligence. Whether you're preparing for GCSEs, A-levels, or pursuing a BSc in Computer Science, my tailored approach ensures you build a strong foundation and advance to becoming an exceptional programmer. Let’s make programming both accessible and enjoyable as you unlock your full potential in this ever-evolving field!

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.

Aniket
Certified Trainer For Web Development (Front-End and Backend) Nodejs
- 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

Susan
AI, BI, Digital Strategy &Project, Digital Marketing, Digital Health, Leadership Skill, Scaling Global Business, Fundraising
The Topics: 1. Winning Proposal Writing 2. Research Projects writing with implementable Deliverable & 3. Practical workshop using SPSS Area to be covered: 1. Concept Paper 2. Topic Development 3. Winning Proposal Development 4. Questionnaires Design 5. Data Collection Method’s & Tools 6. Data Analysis Tools & visualization 7. Project Integration 8. Storytellingand report making 9. Project/ Proposal Presentation Techniques 10. Plagiarism Management 11. Journal publication

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.

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.

Shishir Shreyas
Bioinformatics and Data Skills using R, Python, Mega and Galaxy
Dive into the exciting world of bioinformatics, where biology meets data science! This class equips you with essential bioinformatics and data analysis skills to explore and analyze biological data effectively. You will learn how to manage, visualize, and interpret complex datasets using tools like R or Python, understand sequence alignment and annotation techniques, and delve into topics like genomics, transcriptomics, and proteomics. What You'll Learn: Data Handling: Fundamentals of working with large biological datasets, including cleaning, formatting, and preprocessing data. Programming Skills: Basics of R or Python for bioinformatics applications, including scripting and automating analyses. Genomic Analysis: Sequence alignment, gene annotation, and exploring genomic databases. Statistical Analysis: Applying statistical techniques to identify patterns and draw meaningful conclusions. Visualization: Creating clear and informative plots for biological data. Applications: Perform differential gene expression analysis to understand disease mechanisms. Analyze genetic variants to study evolutionary patterns or predict disease risks. Explore protein structures and functions for drug discovery. Use bioinformatics pipelines to support cutting-edge research in academia or industry. Whether you're aspiring to work in biotech, academia, or data science, this class provides the foundation you need to bridge biology and technology, opening doors to a range of exciting opportunities.

Yacine
Private Course in Initiation and Management of Databases: SQL, MySQL, WAMP, DBever, SQL Server
Introduction to Databases Learn about the importance of databases in the digital world, their role in managing and exploiting data, and the fundamental concepts of structured storage. SQL for Beginners Learn the basics of SQL: SELECT, INSERT, UPDATE, DELETE queries, joins, aggregate functions and more to effectively interact with a database. MySQL and WAMP Server Install and configure WAMP Server to create and manage MySQL databases locally. Learn how to use phpMyAdmin for easy management. DBever and SQL Server Introduction to professional database management tools: Get started with DBever and SQL Server to administer, analyze and optimize your databases. Database Management and Operation Learn best practices for database management: indexing, query optimization, data security and backup. Database Administration Understand the roles of a database administrator (DBA): user management, access rights, maintenance and performance monitoring. Practical DBMS Project Apply your knowledge to a real-world database management project, from design to deployment, optimization and administration.

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)

Nazam
Database Development, analysis, dwsign and development.
In this class you will learn the basic, intermediate and advance topics of database development. How to analyze the requirements, design the basic structure of database and then implementing and then to retrieve the data. The basic concepts regarding the normalization will also be discussed.