Olek
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from41.13CAD/ 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 with russian fascists in my country, I've relocated 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. In addition, I've got an experience as a Development Team Lead.

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.

Finally, I started to make corporate lessons for large companies in Ukraine. It was also wonderful - I'd never expect myself in such a role with so famous corporations when I've just started my teaching career.

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.
6+ years of experience in Team leading.
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 "Python.Base" class! In this course, you'll learn all the vital base knowledge about the development in Python. Topics to cover in this course: Lesson 01: Introduction to Programming. Algorithms. Python as a Programming language. Lesson 02: Operations, Operators, Variables, Data Types, I/O in Python. Lesson 03: Conditional operators. Ternary operator. Understanding boolean datatype in a nutshell. Lesson 04: Loops "while" and "for". Operators "continue" and "break". Endless loops. Generating collections in loops. Lesson 05: Working with text. String as a collection. Slices. Formatting. Lesson 06: Collections. Dictionaries. Lists. Sets. Nested collections. Lesson 07: Exceptions. Files. Import system. Lesson 08: Functions. Arguments. Returning values from functions. Lesson 09: Introduction to OOP. Basic usage of classes. Incapsulation, Polymorphism, Inheritance. Lesson 10: Final Exam: quiz, practical task. Final recommendations. Retrospective. Q/A session. 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 C$41.13Online 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 C$41.13Online 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


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 will learn the basics and tools to manipulate python and other programming languages as well as using them to build machine learning models. We also provide assistance to students specializing in programming and database management using SQL (CPGE students). Under special request, we provide courses on other programming languages such as C, R studio, MATLAB, ... If you have any further questions, feel free to contact us. Python is a powerful general-purpose programming language. It is used in web development, data science, software prototyping, etc. Fortunately for beginners, Python has a simple and easy to use syntax. This makes Python a great language for learning programming for beginners. In this course, you will learn the basics and tools for manipulating python as well as its use to build machine learning models. We also provide assistance to students specializing in python programming and database management using SQL (CPGE students). On special request, we organize courses on other programming languages such as C, R studio, MATLAB, ... If you have any further questions, please do not hesitate to contact us.

Aniket
Certified Trainer For SQL, Excel and Html (Web Development) 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

Sami
Software programming in Python, all libraries
What you will learn: - The Fundamentals: Understand the basics of Python, including variables, loops, and conditions. Perfect for those new to programming. - Object Oriented Programming: Learn to structure your programs using classes and objects, a crucial concept for writing clean, reusable code. - Web Development: Get started with web development with Django or Flask, two of the most popular web frameworks for Python. - Data Science and AI: Discover how Python can be used for data analysis, machine learning and artificial intelligence. - Real Projects: Apply your knowledge to real projects to consolidate your learning and build your portfolio.

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.

Zara
Power BI, data analysis, Data science and deep learning algorithms
I'm an IT engineer, with double master in software engineering ad 6 year do teaching experience. I'am found of english, french languages and IT development teanching. Giving private courses arround the world , is what I love doing in my free time for keeping me socially active! I love giving languages' courses in a new ways of pedagogy and for any students' age : Songs, projects, Poetry, Presentations, films etc.. As for teaching IT developement, my pedagogy is always teaching by practical projects and tutorials. Such as. developping games and usefull virtual services or application, depends of the technology we work on. Be ready for your best english and IT experience with me , it's not like any old way of teaching methodologies! Don't hesitate to reach out for me , if you wish to give it a try! I'll be the very happy to give more than I can to get you to your hopes.

Joel
Full-Stack Development: Building Web Applications with React, Node.js, Python and Databases
In these classes you will learn how to build complete web applications using industry-leading technologies such as React for the frontend and Node.js for the backend, along with Python for scripting and data management tasks. We will explore the design of databases to store and manipulate information efficiently. Immerse yourself in this world of full-stack development and unlock your potential to create innovative and scalable solutions!

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

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)

Ana Sofia
Python Programming for Data Science: From Beginners to Advanced
Presentation : Data Science and Data Analytics. Data Scientist in Banking for 3 years. A comprehensive course designed to equip you with the fundamental skills and knowledge needed to thrive in the dynamic field of data science using Python programming language. My classes offer a structured and hands-on approach to mastering Python's powerful tools and libraries for data manipulation, analysis, and visualization. Methodology : - Online course or presencial - Hands-on course with exercises and guidance to solve them - Presentations with theory and examples

Brahim
Introduction to Relational Database and SQL Language by practise
Module 1: SQL Overview Outlining SQL as the cornerstone of database activity Applying the ANSI/ISO standards Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys Module 2: Building the Database Schema - Creating tables and columns Building tables with CREATE TABLE Modifying table structure with ALTER TABLE Adding columns to an existing table Removing tables with DROP TABLE - Protecting data integrity with constraints Guaranteeing uniqueness with primary key constraints Enforcing integrity with foreign key constraints Imposing business rules with check constraints - Improving performance with indexes Expediting data retrieval with indexes Recommending guidelines for index creation Module 3: Manipulating Data - Modifying table contents Adding table rows with INSERT Changing row content with UPDATE Removing rows with DELETE - Applying transactions Controlling transactions with COMMIT and ROLLBACK Deploying BEGIN TRANSACTION in SQL Server Module 4: Working with the SELECT Statement - Writing Single Table queries Retrieving data with SELECT Specifying column expressions Sorting the result with ORDER BY Handling NULL values in expressions - Restricting rows with the WHERE filter Testing for equality or inequality Applying wildcard characters Avoiding NULL value pitfalls Module 5: Querying Multiple Tables - Applying the ANSI/ISO standard join syntax Matching related rows with INNER JOIN Including nonmatched rows with OUTER JOIN Creating a Cartesian product with CROSS JOIN - Combining results with set operators Stacking results with UNION Identifying matching rows with INTERSECT Utilizing EXCEPT to find nonmatching rows Module 6: Employing Functions in Data Retrieval - Processing data with row functions Conditional formatting with the CASE expression Utilizing the CASE expression to simulate IF tests Dealing with NULL values - Performing analysis with aggregate functions Summarizing data using SUM, AVG and COUNT Finding the highest/lowest values with MAX and MIN Defining the summary level with GROUP BY Applying filter conditions with HAVING Module 7: Constructing Nested Queries - Applying subqueries in filter conditions Creating correlated vs. noncorrelated subqueries Testing the existence of rows - Including subqueries in expressions Placing subqueries in the column list Creating complex expressions containing subqueries Handling subqueries that return no rows Module 8: Developing In-Line and Stored Views - Breaking down complex problems Selecting data from a query result set Using subqueries in the FROM clause - Creating views in a database Building reusable code Creating updateable vs. non-updateable views

Noshima
Foundation of Data Science -- For Beginners students.
Hi Students, Foundation of Data Science is for complete Beginners. This course is In-depth knowledge and hands-on tools to use and work with different kinds of data. Gaining practical experience across the data science pipeline by acquiring proficiency in the data science coding language R. Foundations of Data Science is for those who work with both structured – spreadsheets and data tables – and unstructured data and who need to understand how to automate data to gain insights, contribute to strategic discussions and make data-driven decisions. With my Course you’ll gain a broad understanding of the tools and techniques used to work with data. 1. What is Data: Learn about data types, structures and frameworks 2. Interacting with Data: Understanding how data is used and how to use data 3. Where Data comes from: The processes for acquiring and sharing Data 4. Storing & Structuring Data: Working with different types of databases and data sets 5. Cleaning Data: Working with messy or incomplete data sets 6. Analyzing Data: Gaining insights with data science techniques and tools 7. Visualizing Data: Best practices and tools for data visualization and presentation 8. Machine Learning & Artificial Intelligence: How data is used by machines 9. Working as a Data Scientist: What do data scientists really do? 10. Data & Society: Ethics and the uses of data in society

Ray
Data Science Course (specialised course on Artificial Intelligence)
Specialized course to become a data scientist. I have found a student who wants me to tutor him how to become a data scientist and he has asked me to set up an account on this, so here I am. This course will go through the fundamentals of AI.

Abdelatif
Training in business intelligence
I am a data expert, and I offer you a complete 8-hour training course in business intelligence (Data analyst). The training will be organized as follows: - Courses (summary slides) to master the life cycle of a business intelligence project (ETL, data integration, modeling, reporting) - Theoretical exercises on modeling business intelligence problems (star diagram, snowflake diagram). - practical case study using SQL server tools: SSIS, SSAS, SSRS - reports with QlikView

Juan Carlos
Programming in Python, SQL, HTML and Data Science.
Learn to program from scratch in Python with solid foundations with a Mathematician and Data Scientist. We will go into everything from the most basic such as data types, variables, loops, conditionals, to creating your own programs with a graphical interface, or entering the world of Data Science and Machine Learning. We will learn Pandas, Numpy, Sklearn, among other useful libraries in the world of Data Science. We can learn HTML to create web pages. We will see SQL for creating and managing databases.

Claudia
Learn Excel online for beginners and intermediate
Excel allows users to create tables and formats that include mathematical calculations using formulas. Mathematical operators are used: addition, subtraction, multiplication, division, empowerment, greater, lesser, percentage, equal and also functions that help to find the results more effectively.