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

Van 70.6 $ /h

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 informatie

Please carry your laptop

Locatie

Gebruik Ctrl + muiswiel om in te zoomen

Plaats gekozen door de student :

In de omgeving van Brussel, België

Bij de leraar :

Trammuseum, Woluwe-Saint-Pierre, Belgium

Online vanuit België

Over

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 working with various clients in design and develolment of systems end to end.
I am happy to offer help on below topics and skills.

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 18, NgRx Store, Bootstrap, PrimeNG, CSS3

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

Databases:
• MongoDB, MySQL

Opleiding

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.

Leservaring

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

Leeftijd

Kinderen (7-12 jaar oud)

Tieners (13-17 jaar oud)

Volwassenen (18-64 jaar oud)

Niveau van de leerling

Beginner

Gemiddeld

Duur

45 minuten

60 minuten

90 minuten

120 minuten

De les wordt gegeven in

Engels

Hindi

Frans

Vaardigheden

Sql

Database

Beoordelingen

Beschikbaarheid typische week

(GMT -05:00)

New York

Bij de leraar en via webcam

Bij de student thuis

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Python programming for absoilute beginners from basic to advanced

63.3 $ /h

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.

Lees meer

Web Essentials: Javascript, HTML and CSS and Javascript

55.99 $ /h

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. .

Lees meer

Toon meer

Corinne

5.0

(2)

Learn how to use and create a database with Access in a simple way using logic rather than memorization.
- creation of tables
- the different types of controls with their properties and their input masks
- choice lists
- the 1st and 2nd keys
- creation of relationships between tables
- referential integrity
- filtering and sorting
- creation of queries (selection, table addition, update, deletion, table addition, cross analysis)
- calculated fields
- different displays (creation mode, data mode to be encoded, personalized displays, adding to groups ...)
- creation of forms
- creation of reports
- external data (import and export)
- compaction
- linked source tables
- etc ...

Marc

5.0

(2)

I am a student in the 3rd year of management computer science. I propose to fill your gaps in programming / computer concepts.
My favorite subjects (non-exhaustive list):

- Java
- Sql / Sql Procedural
- Object-oriented concepts
- Javascript
- HTML / CSS

A course generally takes place as a follow-up, a review of the theory followed by a practice with the student's exercises and / or my own exercises.
My courses are primarily intended for people who are new to programming.
Classes are given at home or in a public place.
Feel free to send me a message detailing your needs.

Mohamed

5.0

(2)

Dive into the world of SQL databases with this comprehensive course designed for learners of all levels. Whether you are new to databases or seeking to expand your expertise to advanced concepts like distributed systems, this course has you covered.

What You can Learn:
- Fundamentals of relational databases and SQL syntax.
- Designing robust databases using normalization and entity relationships.
- Writing complex queries, joins, and subqueries.
- Database optimization techniques for performance tuning.
- Implementing stored procedures, triggers, and views.
- Managing transactions and ensuring data integrity.
- Understanding and working with distributed database systems like Distributed PostgreSQL

Good-fit Leraar Garantie

Contacteer Sanyam