Add to Wish List
Add to Wish List
from35.00EUR/ h
SQL: universal language for data manipulation.
Translated by Google. Click to view original.
SQL: universal language for data manipulation.I provide you with training for beginners who wish to enter the world of Databases and Business Intelligence
Installation of the RDBMS of your choice (Mysql, SQL SERVER, ORACLE, Postgresql, SQLITE)
Object(DB, Tables, View, Storeprocedure, Index...)
Read, write, modify and delete method (Select, Insert Into, Update, Delete)
Aggregation
Join.
ODBC connection.
Location
Online via webcam
At student's location: Around Chimay, Belgium
|
Use ⊞+wheel to zoom!
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 Advanced |
Duration: | 60 minutes |
The class is taught in: | English, French |
About Me
We all love the analytics, wether we have an IT background or not. Especially when we are face to the featured apps(Banking, Streaming, Shopping..), and we feel like we're interacting with humains made by humain. but believe me when i say that it's not that hard to learn. you need just willingness and the right instructor.After tasting what it's like to share the knowledge i've been acquiring for more than 15 years, i'm eager to share more, because with sharing we learn More
Education
Bachelor Degree in Software development (Java, C++, Access, VBA) Formatech Institut may 2005Specialization in Data Science(R, Shiny, Python, MarkDown), John Hopkins university
Experience / Qualifications
15 years Advanced Excel and Macro10 years in access
5 years in Python
5 years in Power BI
7 Years in Java
2 years in web development
Reviews (1)
Excellent teacher, I absolutely recommend, very educational
Translated by Google. Click to view original.
Python: Simple and Powerful.
I provide you with training for beginners who wish to integrate the world of Data Analytics and Science.
Python presentation.
Installation and configuration of Python and IDEs (Pycharm, Jupyter)
Python programming (Variable, Data type, Conversion, Operators)
Data type (List, Tuple, Set, Dictionary)
Function
Library Pandas, Matplotlib, Numpy, Scikitlearn
Interactive dashboards are cool, because apart from it being pretty to present, it summarizes the situation of a business in a single page. but we know that behind it, there is a lot of data coming from different data sources (BDD, CSV, AWS, etc.).
I provide you with training allowing you to tackle Power BI from Scratch.
Presentation of Power BI
Data Source
the modeling
Formatting.
the deployment of the online dashboard.
administration of the tool
Data Scientist is consider the sexiest job(according to forbes), as not only it's the highest paid job, but also from an intelectual perspective, it has a huge impact on the business in every industry.
If you like numbers and has a background in excel, i can help build foundation of data science and help you get certified.
Reach out to me if you're interested.
Whatever your level, beginner or with basic knowledge, student or employee.
Excel is not intended for programmers or mathematicians, rather a MUST LEARN tool for anyone who is preparing to enter the professional world or who is already there.
All it takes is willpower and discipline.
I provide you with simple methods to learn Excel and use it on a daily basis.
Excel structure
Formula and functions.
Pivot table
Connection with MS ACCESS
Formatting
Graphs (Dynamic and static)
the dashboards.
VBA Macro
Ask a question
Send a message explaining your needs and Tarik will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 35€Online via webcam
from 41€At student's home
100% Satisfaction Guarantee
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 August 2020
- Phone number verified
- Facebook connected
- Google connected
- Linkedin connected
- Twitter connected
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 35€Online via webcam
from 41€At student's home
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
Private lessons
in Chimay
Similar classes
Salah Eddine
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is WelcomeMaster 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.
Mazuba
Complete IGCSE Computer Science & ICT: From Basics to Advanced ProgrammingThis course is tailored for IGCSE Computer Science and ICT students who want to master all the key topics in their curriculum. With a focus on practical programming skills, theoretical computer science concepts, and hands-on problem-solving, this class will guide you through the essential topics covered in the IGCSE syllabus. Learn the fundamentals of data representation, hardware and software, databases, and Boolean logic, and then build on those concepts with programming and algorithm design. Gain a deep understanding of the inner workings of computers and their applications in real-world scenarios.
By the end of this course, you will have a solid understanding of key computer science concepts and the practical skills to succeed in your IGCSE exams and beyond.
What You’ll Learn:
Data Representation: Learn how computers represent and process data, including binary, hexadecimal, and conversions between number systems.
Data Transmission: Understand how data is transmitted over networks, focusing on packet switching, USB, and data packets.
Hardware & Software: Gain a foundational understanding of computer hardware components and the role of software in running programs.
Boolean Logic: Explore logic gates, truth tables, and Boolean expressions, and apply them to solve complex problems.
Algorithm Design: Learn to design algorithms and solve problems using effective computational methods.
Programming: Master the basics of programming with hands-on coding in Python, C++, and C#.
Databases: Understand database structures, SQL queries, and primary keys. Build single-table databases and learn data management techniques.
Efetabo
Building Marketing Campaigns with Data and Communication ExcellenceLearn how to create impactful marketing campaigns by combining data insights with effective communication strategies. This class will teach you to analyze customer data, identify trends, and design campaigns that resonate with your audience while delivering measurable results. Perfect for anyone looking to elevate their marketing efforts.
Oussama
Mastering Relational Database Management: Personalized Courses with SQL, DBSM, MySQL, and PostgreSQLI 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.
Jerome
PhD in cognitive psychology and statistician teaches psychology, neurosciences and statisticsExperienced 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.
Muhammad
Master Programming & Computer Science: GCSE, A-Level, BScI offer engaging and comprehensive programming lessons in C++ and Python, designed to help you master essential concepts and advanced topics in computer science. From problem-solving techniques, object-oriented programming, and data structures to database management, operating systems, digital logic design, and algorithm analysis, my lessons cover it all. I also introduce exciting areas like parallel and distributed computing and the basics of artificial intelligence. Whether you're preparing for GCSEs, A-levels, or pursuing a BSc in Computer Science, my tailored approach ensures you build a strong foundation and advance to becoming an exceptional programmer. Let’s make programming both accessible and enjoyable as you unlock your full potential in this ever-evolving field!
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.
Emna
[PYTHON - Data Science - AI] Learn Python & Data Science & Artificial Intelligence from beginner to advancedYou 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)
Susan
Project Management G& Research Methodology & strategy Simplified, CV writing skill, job search skill, employee vs Employer trust buildingThe Topics:
1. Winning Proposal Writing
2. Research Projects writing with implementable Deliverable &
3. Practical workshop using SPSS
Area to be covered:
1. Concept Paper
2. Topic Development
3. Winning Proposal Development
4. Questionnaires Design
5. Data Collection Method’s & Tools
6. Data Analysis Tools & visualization
7. Project Integration
8. Storytellingand report making
9. Project/ Proposal Presentation Techniques
10. Plagiarism Management
11. Journal publication
Ashington
STATISTICS AND STATISTICAL METHODS FOR STUDENTS AND PROFESSIONALSThis 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
Ana
Statistics, Data Analysis, Math, Economics all levelsI 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.
Shishir Shreyas
Bioinformatics and Data Skills using R, Python, Mega and GalaxyDive into the exciting world of bioinformatics, where biology meets data science! This class equips you with essential bioinformatics and data analysis skills to explore and analyze biological data effectively. You will learn how to manage, visualize, and interpret complex datasets using tools like R or Python, understand sequence alignment and annotation techniques, and delve into topics like genomics, transcriptomics, and proteomics.
What You'll Learn:
Data Handling: Fundamentals of working with large biological datasets, including cleaning, formatting, and preprocessing data.
Programming Skills: Basics of R or Python for bioinformatics applications, including scripting and automating analyses.
Genomic Analysis: Sequence alignment, gene annotation, and exploring genomic databases.
Statistical Analysis: Applying statistical techniques to identify patterns and draw meaningful conclusions.
Visualization: Creating clear and informative plots for biological data.
Applications:
Perform differential gene expression analysis to understand disease mechanisms.
Analyze genetic variants to study evolutionary patterns or predict disease risks.
Explore protein structures and functions for drug discovery.
Use bioinformatics pipelines to support cutting-edge research in academia or industry.
Whether you're aspiring to work in biotech, academia, or data science, this class provides the foundation you need to bridge biology and technology, opening doors to a range of exciting opportunities.
Zora
Data science, Deep learning, Business intelligence, Data analysis, Visualisation des donnéesJe propose des cours complets en Power BI, analyse de données, science des données et algorithmes d'apprentissage profond, adaptés à tous les niveaux d'expérience. Mon approche pédagogique se concentre sur l'acquisition de compétences pratiques, vous permettant d'appliquer directement ce que vous apprenez dans des projets réels.
Dans le cadre de mes cours de gestion de données, vous apprendrez à transformer vos données en visualisations interactives et informatives, en maîtrisant les techniques de création de tableaux de bord, de rapports et d'analyses visuelles. Vous découvrirez également comment connecter différentes sources de données et optimiser vos modèles pour des insights pertinents.
En ce qui concerne l’analyse de données, vous développerez une compréhension approfondie des méthodes statistiques et analytiques, vous permettant de tirer des conclusions significatives à partir de vos données. Vous serez initié aux outils et aux techniques de manipulation des données, y compris l'utilisation de langages de programmation tels que Python, R, PowerBI ou TABLEAU.
Dans le domaine de la science des données, nous explorerons les étapes clés du processus de data science, de la collecte et le nettoyage des données à la modélisation et à la validation des résultats. Vous serez également introduit aux algorithmes d’apprentissage profond, apprenant à construire et à entraîner des modèles neuronaux pour des applications variées, allant de la reconnaissance d'image à la prévision.
Chaque cours est structuré autour de projets pratiques et de cas d’étude, afin de vous préparer à relever des défis réels en matière d’analyse et d’interprétation des données. Si vous êtes prêt à développer vos compétences en Power BI, analyse de données, science des données et apprentissage profond.
Brahim
Introduction to NoSQL DataBase MongoDB by PratiqueDo 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
Nazam
Database Development, analysis, dwsign and development.In this class you will learn the basic, intermediate and advance topics of database development.
How to analyze the requirements,
design the basic structure of database and then implementing and then to retrieve the data.
The basic concepts regarding the normalization will also be discussed.