facebook
Olek
member icon
Trusted teacher
favorite buttonAdd to Wish List
favorite buttonAdd to Wish List
member icon
Trusted teacher
from30.00USD/ h

SQL For Anyone - A Complete Course for Start Working with Relational Databases

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.

Extra information

No specific requirements needed - just your wish to learn and the PC/Laptop/Tablet to do practice :).

Location

Online via webcam

General info

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

About Me

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

Education

Master of Computer Science (Kyiv Politechnical University).
Master of Economics (Kharkiv University of Banking).
Bachelor of Computer Science (Kharkiv Private Academy "STEP").

Experience / Qualifications

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

Reviews (1)

Alex is really engaged and gives lots of practical tasks, which I find very useful. Also, he is tailoring his classes to my knowledge. I would recommend him to everyone who want to refresh or advance their coding skills!
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.

Ask a question

Send a message explaining your needs and Olek 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
  
  
  
  
  
  
  
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
  
  
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
  
  
  
  
  
  Saturday at 11:00
  Sunday at 11:00
12
  
  
  
  
  
  Saturday at 12:00
  Sunday at 12:00
13
  
  
  
  
  
  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
  
  
15
  Monday at 15:00
  Tuesday at 15:00
  Wednesday at 15:00
  Thursday at 15:00
  Friday at 15:00
  
  
16
  Monday at 16:00
  Tuesday at 16:00
  Wednesday at 16:00
  Thursday at 16:00
  Friday at 16:00
  
  
17
  Monday at 17:00
  Tuesday at 17:00
  Wednesday at 17:00
  Thursday at 17:00
  Friday at 17:00
  
  
18
  Monday at 18:00
  Tuesday at 18:00
  Wednesday at 18:00
  Thursday at 18:00
  Friday at 18:00
  
  
19
  
  
  
  
  
  
  
20
  
  
  
  
  
  
  
21
  Monday at 21:00
  Tuesday at 21:00
  Wednesday at 21:00
  Thursday at 21:00
  Friday at 21:00
  
  
22
  Monday at 22:00
  Tuesday at 22:00
  Wednesday at 22:00
  Thursday at 22:00
  Friday at 22:00
  
  
23
  
  
  
  
  
  
  
from $30Online via webcam

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 July 2019
  • Phone number verified
  • Google connected
  • Linkedin connected

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0
  
  
  
  
  
  
  
1
  
  
  
  
  
  
  
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
  
  
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
  
  
  
  
  
  Saturday at 11:00
  Sunday at 11:00
12
  
  
  
  
  
  Saturday at 12:00
  Sunday at 12:00
13
  
  
  
  
  
  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
  
  
15
  Monday at 15:00
  Tuesday at 15:00
  Wednesday at 15:00
  Thursday at 15:00
  Friday at 15:00
  
  
16
  Monday at 16:00
  Tuesday at 16:00
  Wednesday at 16:00
  Thursday at 16:00
  Friday at 16:00
  
  
17
  Monday at 17:00
  Tuesday at 17:00
  Wednesday at 17:00
  Thursday at 17:00
  Friday at 17:00
  
  
18
  Monday at 18:00
  Tuesday at 18:00
  Wednesday at 18:00
  Thursday at 18:00
  Friday at 18:00
  
  
19
  
  
  
  
  
  
  
20
  
  
  
  
  
  
  
21
  Monday at 21:00
  Tuesday at 21:00
  Wednesday at 21:00
  Thursday at 21:00
  Friday at 21:00
  
  
22
  Monday at 22:00
  Tuesday at 22:00
  Wednesday at 22:00
  Thursday at 22:00
  Friday at 22:00
  
  
23
  
  
  
  
  
  
  
from $30Online via webcam

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


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.

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.

Bobo
Course Title: Task Automation & Big Data with Hadoop

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.

Mohamed
Database (SQL Server, PostgreSQL, MySQL): From Fundamentals to Distributed Systems
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

Mathieu
Complete SQL Training: Master data extraction and analysis.
I offer a comprehensive SQL course so you can efficiently retrieve and analyze your business data. SQL is one of the most accessible languages in the world. By focusing on the fundamentals (joins, filters, aggregations, etc.), you can quickly acquire the skills needed to achieve your professional goals. As a data trainer for several organizations, I offer this course, which is both theoretical and practical. Whether you're a beginner or an advanced user, I'll adapt the content to your level and needs.

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

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.

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.

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

Hassane
Relational databases (SQL under MySql DBMS)
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.

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)

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.

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.

Philippe
Professional Computing for adults (Office, Databases, SQL, Python, Excel, etc.)
Discover "Professional Computing for Adults", a course specially designed to help you master the essential digital tools in the modern workplace. Whether you are a beginner or want to deepen your knowledge, I guide you through the basics of office automation, mastery of Office, Excel, database management, as well as an introduction to programming languages such as SQL and Python. With more than 7 years of experience as a private tutor and a solid background in computer engineering, I adapt each course to your specific needs to guarantee practical, effective learning that is directly applicable in your professional life.