Alex
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
FavouritesAdd to Wish List
from29.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

Skills:

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

I’m a senior software developer with commercial experience since 2012. By now I’ve tried different programming languages and tech stacks, but most of my projects for now are in Python. In addition, got experience in leading the team of developers.

I started teaching people a few years ago as a hobby. First on individual basis, then tried with groups, also got experience with special courses for large companies. I like this and wanna do it better and better.

Feel free to contact me :)

Education

Private Academy of Computer Science (2007-2010), Bachelor of Computer Science. Also graduated as a Master of Economics in Banking Institute of Ukraine (2009-2015).

Experience / Qualifications

Python software developer, teacher.
Worked in different companies - from startups to large product firms. As a teacher - worked in two private schools for adults. Tought data scientists with Python in Nova Poshta (the best postal company in Ukraine).

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!
Python is one of the most popular programming languages these days. It allows to create programs for almost everything: devices, websites, services, large systems, etc. This class contains only the most useful information which will help you to start programming in Python. The main focus is on practicing - without practice, any theoretical knowledge is nothing. This class is recommended for students of age 14-45, but this range is not restricted. Your level can be from the "very beginning" to "middle" - the class program will be adopted regarding to your skills, so you won't waste your time and money for learning things you know already enough.
This course is for Groups only! To take the same program on an individual basis, check this: https://www.apprentus.com/en-us/private-lessons/online/computers-electronics/python/programming-python-complete-becoming-progr Python is one of the most popular programming languages these days. It allows creating programs for almost everything: devices, websites, services, large systems, etc... This class contains only the most useful information which will help you to start programming in Python. The main focus is on practicing - without practice, and theoretical knowledge is nothing. This class is recommended for students age 14-45, but this range is not restricted. Your level can be from the "very beginning" to "middle" - the class program will be adopted regarding your skills, so you won't waste your time and money on learning things you know already enough. Studying in groups is cheaper than having individual lessons, but the result will not differ much, as I'm still paying attention to all the students I teach. If you have a few people for having group lessons, please contact me and we will organize it within Apprentus! Best regards, Alex Senior Python Developer
Python has become a widely used language. One of the key points which made this language a top, was ability to create web applications in it. Lots of large well-known projects are written using Python: Linkedin, OpenStack, Instagram, Spotify, Bitbucket, Dropbox, Prezi and even Mozilla browser. And that's just a few of most popular apps... This course will give you knowledge about: - general concepts of building web applications - how to create web app using Django framework - how to use Django REST framework - yet another popular library created for making Django projects faster and easier - how to make your first site Requirements: - You must have at least the basic knowledge of Python including OOP (Object-Oriented Programming). If not, you could choose another of my courses for learn Python first. - Ensure you have time for doing practical tasks. Theory-only courses are useless - you would forget all the learned materials less than in few weeks.

Ask a question

Send a message explaining your needs and Alex will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"

Availability of a typical week

MonTueWedThuFriSatSun
7              
8    Tuesday at 8:00    Thursday at 8:00    Saturday at 8:00  
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  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00    Thursday at 21:00  Friday at 21:00  Saturday at 21:00  
22              
23              
from $29Online 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

MonTueWedThuFriSatSun
7              
8    Tuesday at 8:00    Thursday at 8:00    Saturday at 8:00  
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  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00    Thursday at 21:00  Friday at 21:00  Saturday at 21:00  
22              
23              
from $29Online 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

   LinkedIn   

Mishra
private tutor for the subjects of Maths ,English and SQL
Professional Profile Qualified, friendly and experienced tutor dedicated to student learning. Confident teaching both one-on-one and in groups, I have strong communication skills. I am currently studying a Master of Science At imt Atlantique. I know what students go through when it comes to dealing with intimidating subjects and have the means to help them to overcome fear so they can harness their true abilities. Employment History • 2.5 years experience as private online tutor. • 3 year work experience as an computer engineer Responsibilities: • online tutoring for high school and pre university students • Conduct mini-tests and assessments to monitor progress • guiding the students on subjects of engineering mathematics • Experience in teaching professionals to make them prepare for the quantitative aptitude examination. Achievements: • Helped numerous students to achieve better academic results • Developed strong Quantitative teaching skills • Developed skills in leading classes and presenting to groups • I have been Awarded as Merit holder (0.1 % student in country) for scoring 100/100 in Maths .

Jerome
Course and help with the statistical analysis of data in psychology
Professor and doctor of psychology and cognitive neuroscience graduated from the University of Strasbourg (holder of a master 2 research in Biology and a master 2 professional in science communication), I offer private lessons in psychology (cognitive, social, developmental psychology, neuropsychology, etc.), neuroscience as well as statistics (theoretical and applied to experimental protocols) with a personalized methodology according to the needs and potentialities of each student. Thanks to a rigorous teaching approach, specific and adapted to each request, I propose an effective methodological aid (available references) allowing to answer to the waitings of the students and to reach or even exceed the fixed objectives. My classes also integrate a coaching method to optimize the learning and training necessary to pass university exams in psychology, neuroscience and statistics (as well as your oral exams with or without powerpoint support). My courses are aimed at university students, engineering schools, BTS wishing to optimize their performance and exam and exam scores (courses in psychology, neuroscience, medicine, etc.). I receive a lot of requests from students from Paris 8 University (IED or not), University Paris 5 and Nanterre because I know very well the program and the expectations of the jury for the research paper. Schools, Universities and teaching institutes offered: ESSEC Business School, Universities of Strasbourg and Paris 8, ISTH, IONIS Education Group, EEEA, Acadomia etc.

Lucija
Teaching and helping with SQL, Data Analysis and Data Science
Helping with SQL and data extraction, exploration, analysis and modelling. I have a MSc in Mathematics and have been working as a data scientist and BIE for the last three years in FAANG. I can teach you SQL and help you with your projects in Data Analytics and Science.

Ashington
STATISTICS AND STATISTICAL METHODS FOR STUDENTS AND PROFESSIONALS
This class covers statistics and statistical methods for data analysis which cuts across all industry and disciplines. Sample topics, Statistical calculations Statistical methods Statistical analysis Quantitative analysis Quantitative analysis techniques Non Quantitative data analysis Research methods Research methods paper section Mathematical analysis Statistical software and spreadsheets like Rsutdio, Excel, SPSS, and many others. and any statistical topic requests by students

Enrico
Microsoft Excel for any application [ITA/ENG] 100% Practical
Finance professional with 6 years working experience offering courses in Italian/English on Microsoft Excel for financial application & database management. I enjoy teaching, students of any level are welcome. If you're looking at anything ranginfg from basic formulas, graphs, pivots up to a complete automation of spreadsheets via complex formulas or VBA macros, hit me up. The course can also be helpful in preparation for internships at top tier investment banking / consulting firms. 100% practical session with extensive examples. Google Meet / Skype or any other software is fine.

Ibrahim
SQL, mySQL, Databases: queries, views and ERD diagrams
This course provides a step-by-step overview and instructions that help you get started with the SQL language. We use MSSQL, but you can use this course to get started with understanding data structures and techniques for all SQL engines including Access, Oracle and MySQL. We show you how to create SQL statements including SELECT, DELETE, UPDATE and INSERT. Then, we show you how to create and design tables. We show you how to create stored procedures, which allow you to run the same SQL statement multiple times without reprogramming your database. Finally, we show you how to use cursors, use transactions to preserve data integrity, and creating views for larger data sets.

Corinne
Course of use and creation of databases with Access
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 ...

Ahlem
Symfony Angular PHP CSS Html Algorithmic language C and other
I give support courses and supervision of projects for all levels. I teach face-to-face or remotely, I can help you in Algorithmics, C language, C ++, PHP, Javascript, Database, linux

Jules
Software Engineering for beginners and intermediates
learn how to build innovative and digital solutions to respond to day-to-day problems using development tools and infographics. You will learn web and mobile design mobile app prototyping wordpress websites development Database modeling Web frameworks Javascript & PHP Marketing digital Search Engine Optimization Create logos And many more on demand

Nish
Offering lessons in Computer Science and programming - SQL, Database
I am an IT professional having a great passion towards teaching. I have done Masters and bachelors in computer Application and programming. I completed Masters in 2007. I believe that teaching is an art and a smart teacher should understand how an individual students understand well. What is the best teaching approach that suits the individual teacher? I customise the teacing approach based on the student's need and this comes from years of experiece teaching varieties of students across different countries. My teaching methodology is a gentle approach which 100% ensure the subject matter is understood to the student - - Teach the subject matter - Practice exercises based on subject matter - Explain any doubts/queries the student may have - And revise Thanks

Baba Nizamuddin
SAP HANA ERP TUTORING, SHAREPOINT TRAINING, COMPUTERS
SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.Its primary function as a database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics (predictive analytics, spatial data processing, text analytics, text search, streaming analytics, graph data processing) and includes extract, transform, load (ETL) capabilities as well as an application server.

Arpan
Learn basics of SQL programming with no prior knowledge
Do you want to learn SQL but feel overwhelmed by the amount of knowledge present on the internet? Would you like to learn SQL from the very basics to a respectable level with hands-on practice? My goal is to exactly do that. You need no prior knowledge, all you need is the will to learn(which you already have, otherwise you wouldn't be here!) My modules on SQL(which I will provide you with) will help you get up and running with SQL in absolutely no time. I will personally assist you through downloading all the required software and then teach you how to use them so that you do not feel lost or overwhelmed. So what are you waiting for, contact me and let's start collaborating!

Ifrah
Computer Science software architecture, Data science
Some students will know how to use technology tools (such as texting) better than their teachers. But to really understand computing, including the science behind it and the ways to manipulate it, students need to take classes related to computer science taught by certified teachers who can express themselves well and who may have worked in the computing field before they became educators. In addition to explaining the fundamentals of computing, these teachers will be showing their students the merits of problem-solving, collaboration, and creativity. It’s a challenging and rewarding profession. Computer science teachers are always looking forward. They keep their eyes on the latest advances, the newest tools and breakthroughs. And they always keep the future in mind while teaching because, if they do their job right, some of their students may be inspired to become tomorrow’s engineers, system administrators, and innovator.

Nafisa
Maths. Learn maths that you would at school. Upto GCSE level.
Maths is a fundamental subject that some may find easy and some find it hard. I am here to make maths simpler and offer one to one classes. I enjoy number crunching and hoping to pass all my knowledge on to my students. The class is very basic and you will get full support from myself.

Rahma
Private lessons in computer science: Programming, Database, office automation ...
Senior consultant with a degree in computer engineering gives private lessons in computer science (Java, C, C ++, BD, Programming, database ...). I have 5 years experience in teaching in the computer field. See you soon, I hope :