facebook
favorite button
super instructor icon
Vertrauter Lehrer
Dieser Lehrer hat eine schnelle Reaktionszeit, was eine hohe Servicequalität für seine Schüler beweist.
member since icon
Seit Juli 2019
Lehrer seit Juli 2019
SQL For Anyone - A Complete Course for Start Working with Relational Databases
course price icon
Von 30 $ /Std
arrow icon
Most of applications nowadays have to work with different storages. One of the most popular types is Relational Database Storage (PostgreSQL, MySQL, Oracle, Microsoft SQL Server and so on). To work with data contained in it, you will need to use SQL - Structured Query Language.

This course will help you to:
- learn the concepts of making queries in SQL
- become familiar with the most common operations in Data processing
- obtain a practical experience in SQL using one of popular DB engines.
Zusätzliche Informationen
No specific requirements needed - just your wish to learn and the PC/Laptop/Tablet to do practice :).
Ort
location type icon
Online aus Kanada
Über mich
Welcome to my class!

My name's Olek, I’m a Senior Software Developer. Initially I'm from Ukraine where I lived the most part of my life. Currently, however, due to the war in my country, I've moved to Canada.

My professional experience starts since 2012. By now I’ve got a wide experience across different programming languages and technical stacks, but most of my projects for now are in Python.

I started teaching people in 2016, just for fun. Quite soon I got 5 individual students in parallel, and it made me thinking that I can help others to grow in Software Development in an easier and faster way than me and lots of my contemporaries have done so far...

So I continued my practice. In a year, I tried myself in group lessons. That was a new challenge, but it also went well. I taught people with different past: someone came to switch the career, some needed Python for doing the current job, some went just for fun... It's an amazing experience.

You can come to me to learn Python for any purpose. I'll do my best to help you reach your goal. Still, after all years, I do it more for fun than for making an income. So I'm interested in your results as much as you.

Feel free to ask me any questions.

Wish you a good day!


Olek
Bildung
Master of Computer Science (Kyiv Politechnical University).
Master of Economics (Kharkiv University of Banking).
Bachelor of Computer Science (Kharkiv Private Academy "STEP").
Erfahrung / Qualifikationen
11+ years in Backend development using Python.
7+ years of experience as a Teacher and Coach.
Creator of 2 open-source Python libraries: python-shell and smart-env (available on PyPI).
Alter
Kinder (7-12 Jahre alt)
Jugendliche (13-17 Jahre alt)
Erwachsene (18-64 Jahre alt)
Seniorinnen und Senioren (65+ Jahre alt)
Unterrichtsniveau
Anfänger
Mittel
Dauer
30 Minuten
45 Minuten
60 Minuten
90 Minuten
120 Minuten
Unterrichtet in
Englisch
Russisch
Ukrainisch
Fachkenntnisse
Bewertungen
Verfügbarkeit einer typischen Woche
(GMT -04:00)
New York
at teacher icon
Online via Webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Welcome to my class!

In this course, you'll learn all the vital knowledge to start coding in Python. We'll cover all the basis, along with the most popular frameworks and libraries.

Each lesson comes with a practical homework.

There can also be a little practice during the lesson if needed.
Mehr lesen
Ähnliche Kursen
arrow icon previousarrow icon next
verified badge
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.
verified badge
Hello! I am a graduate of the MSc in business informatics (FH Technikum Wien) and have been working as a systems engineer in Vienna for several years. I also have IT tuition experience in diploma theses as well as in exam preparation (HTL). I like to teach fluently in German, English and Greek. I mainly offer tutoring in: systems administration, big data, databases (PostgreSQL, MySQL), MS Office, application servers (JBoss, Tomcat, Apache), networks, OS applications (such as Linux, Windows, MacOS), web design and development, programming for beginners and hardware. I also like to teach German (as a foreign language), English (mother tongue) and Greek (mother tongue).
verified badge
Learn about:
- Normalization
- Relation data model and its nested relations
- SQL Language, scripts and others
- Dynamic SQL
- Security and User authorization
- Object oriented data model
- Functional dependencies
- Different type of data model, such as Datalog
verified badge
I am a senior Java Software developer with 10+ years of industrial experience. I have good teaching abilities. The course will contain Object oriented programming concept to provide the base, core java concepts and Java enterprise edition concepts. Course will also have spring boot concepts and a hands on project.
message icon
Olek kontaktieren
repeat students icon
Der richtige Lehrer Garantie
Ähnliche Kursen
arrow icon previousarrow icon next
verified badge
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.
verified badge
Hello! I am a graduate of the MSc in business informatics (FH Technikum Wien) and have been working as a systems engineer in Vienna for several years. I also have IT tuition experience in diploma theses as well as in exam preparation (HTL). I like to teach fluently in German, English and Greek. I mainly offer tutoring in: systems administration, big data, databases (PostgreSQL, MySQL), MS Office, application servers (JBoss, Tomcat, Apache), networks, OS applications (such as Linux, Windows, MacOS), web design and development, programming for beginners and hardware. I also like to teach German (as a foreign language), English (mother tongue) and Greek (mother tongue).
verified badge
Learn about:
- Normalization
- Relation data model and its nested relations
- SQL Language, scripts and others
- Dynamic SQL
- Security and User authorization
- Object oriented data model
- Functional dependencies
- Different type of data model, such as Datalog
verified badge
I am a senior Java Software developer with 10+ years of industrial experience. I have good teaching abilities. The course will contain Object oriented programming concept to provide the base, core java concepts and Java enterprise edition concepts. Course will also have spring boot concepts and a hands on project.
Der richtige Lehrer Garantie
favorite button
message icon
Olek kontaktieren