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

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  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday 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            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  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday 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              
19              
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00    
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday 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  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday 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            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  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday 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              
19              
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00    
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday 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

You are here


Zen
Train yourself in the Merise method and design your information system from the abstract model to the Microsoft Access or Oracle database.
The merise training teaches you both an analysis method and an information system construction process. It consists of carrying out the studies of the processing and the data at the same time, and then making them coincide. The merise training teaches you an approach based on 3 levels of concern: conceptual, organizational and physical. Merise training and Project management Merise training is particularly suited to the management of a project in the field of new technologies. Merise training: physical level The answers provided by the Merise method at this last level make it possible to establish the concrete way of setting up the system. The Physical Data Model (or PDM or MPhD) makes it possible to specify the storage systems used. The Operational Processing Model (or MOT or MOpT) allows the functions to be specified as they will then be performed by the programmer. This step is the culmination of the Merise method. Merise training: organizational level Did the merise training teach you to do conceptual analyzes? At this level of concern, the conceptual models are specified to be the subject of organizational choices. The merise training then teaches us the construction: - a Logical Data Model (or LDM), which takes the content of the previous CDM, but specifies the volume, structure and organization of the data as they can be implemented. - a Logical Processing Model (or MLT), which specifies the actors and the means that will be implemented. It is here that the treatments are divided into functional procedures (or PF). The organizational level of the merise method focuses on specifying the organization of company data (MLD) and tasks or procedures (MLT). Merise training: conceptual level In Merise training, the conceptual level is subdivided into two levels: the Conceptual Data Model (CDM) and the Conceptual Processing Model (MCT). A company's MCD and MCT are stable, modeled once and for all, and do not depend on the choice of one software package or another.

Abdullah
How do you make a Web application? How do you automate business processes? How do you write an API system?
Do you also want to delve into complex API systems? Or do you want to write a central Web application that you can access from any device? Or are you thinking of how can I automate administrative work? I'll help you get started. We make a step-by-step plan together. Are we going to work with a framework such as Laravel, Symfony or are we going to deepen our knowledge of PHP? How do we create a database? How does Oracle or MySQL work? How about Scrum and Git? Which IDE are we going to use? We go through everything. You decide what you want to delve into. I'll help you discover your strengths. We go at your pace and you develop your own style.

Badr
Méthode merise de conception des bases de données.
Merise is a general-purpose modeling methodology in the field of information systems development, software engineering and project management. First introduced in the early 1980s, it was widely used in France, and was developed and refined to the point where most large French governmental, commercial and industrial organizations had adopted it as their standard methodology. Merise proceeds to separate treatment of data and processes, where the data-oriented view is modelled in three stages,

Austin
Tableau, Qlik Sense and (Data Analysis, Dashboards and Storytelling)
Data analyses is a very useful skill in todays world. Young individuals as well as businessmen, students and successful people need to effectively see the story that the data is telling us. Analysing data helps us discover trends and hard facts that would otherwise be unseen to us. In this class you will learn how to use 2 free data analysis tools which are most commonly used in organizations and industry today. Gaining these skills will help you start a career in a Data Analyst field or use the analytic skills for your business or personal decision making

William
Fundamentals of SPSS: A step by step approach to doing more with SPSS
SPSS is a statistical tool that can be used for analyzing data. It is used by researchers, data scientists, and students for recording, analyzing, and interpreting data in order to create useful information which can be used for creating solutions in various settings. In this course, I will teach you the fundamentals of SPSS in a manner that can be easily understood by people from various backgrounds.

Sabrine
Algorithmics / Python, C, Pascal, Java Programming / Databases / Information Systems Design
University teacher offers simplified and clear lessons as well as progressive activities covering the entire computer science program of the 3rd and 4th Tunisian or digital system and computer science of the French system. Various university support courses for computer science modules such as algorithms, python programming, java, etc.

Mark
Programming tutoring with 3 years of corporate experience
*** Technologies that I can help with *** Java, (Java) Spring Boot, Spring Security, HTML5, Bootstrap 4, CSS, JavaScript, React, SQL (Oracle, Postgresql, MySql), PHP Welcome here. My name is Mark. I'm in love with computer sciences since I'm a little child. I clearly remember when I was only 8 and I disassembled my father's PC (and made him incredibly happy) just to check what's inside. For me, it took nearly 10 years to pick-up the required amount of knowledge to get a good job at a high-end company. My main principle and motivation is to cut-off this time for you by leading you to the exact information that you will need to get hired. I'm actively doing programming since I'm 14 years old. After finishing high school I've attended a 2 years long programming vocational college (Forrai private school, Hungary) and a 1-year long private school (Codecool, Hungary) too. After finishing my education I worked at GE (General Electric), IFRC (International Federation of Red Cross), and Capgemini.

Md Mafizur
Web development with a real project development and assignment
If you are looking for a professional tutor you are in right place. I will teach you web designing and development on your desktop using TeamViewer or in person. Complete course : html and html5 (including assignments) css and css3 (including assignments) Bootstrap (including a project) .Net core (including assignments) mySQL/MSSQL (including assignments) using mysql with .Net core A Final Project

Beheddine
Relational and non-relational database (SQL / NoSQL) (MongoDB)
I offer courses in spring and .Net frameworks, java, php and c # courses basic web development technologies such as html, css and javascript relational and non-relational database and NoSQL SQL (MongoDB) courses

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!

Mohammed
Learn SQL -> A class for Beginners as well as Advanced users!
Do you wish to up your SQL skills, from excel? or want to become a pro in sql quick! The quikly sign up for a SQL class with a PRO Data Scientist You learn 1. Why SQL 2. Basics of SQL 3. SELECT queries 4. Joins 5. group by expression | Having | Order by 6. Self joins 7. Learn all these concepts with industry type examples and data

Alaa
Postgresql Computer Courses For Students and Professionals
Engineer in computer systems and networks with extensive professional experience in various essential sectors, offers courses on the Postgresql DBMS for students to strengthen the level or for professionals to use with Odoo or others ...

Houssein
Computer Science Tutoring for beginners and professionals
Lectures in Computer Science (Optimization, Graphs, Data Structures, Data Base, Data Mining, Computer Architecture, Image Processing, Numerical Simulation, Office, ..) and programing (C, C++, Java, R, Matlab, MIPS, ..) for beginners and professionals

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

Mohamed Amin
Programming with Python, with C and database management (Introduction to machine learning)
Python is a powerful general-purpose programming language. It is used in web development, data science, creating software prototypes, and so on. Fortunately for beginners, Python has simple easy-to-use syntax. This makes Python an excellent language to learn to program for beginners. In this course, you will learn the basics and tools to manipulate python as well as using it to build machine learning models. We also provide assistance to students specializing in python programming and database mangement 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.