facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from54.15GBP/ h

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.

Location

Online via webcam

General info

suitcase iconSkills:
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:
45 minutes
60 minutes
The class is taught in:English, Arabic, Hebrew, Turkish

About Me

Led software projects and machine learning algorithms that solve real-life problems from scratch into production.

8 years of experience with software engineering , algorithm development and customer-facing experience.

Professional mentor and technical consultant; completed 220+ mentoring sessions with 5.0/5.0 rating on codementor.io; have been selected for 7 times as featured mentor of the week.

Developed ML algorithms for prediction of customer purchase behavior, customer segmentation, and future purchase status.

Masters graduate in computer vision and machine learning; introduced a new method of Multiple Object Tracking using Kernelized Correlation Filters which increased tracking accuracy by 4%.

Education

Bahçeşehir Üniversitesi
M.A. of Computer Engineering
2014 – 2017
Areas of Study: Computer Vision. Artificial Intelligence. Machine Learning. Cyber Security. Network Cryptography

Birzeit University
B.A. of Computer Engineering
2007 – 2012

Experience / Qualifications

Lead Software Engineer

Nov 2020 - Present (3 years 1 month)
Leading the technical design and implementation of a SAAS AI-based IT support tickets automatic
routing service. In addition to data ETL process and customer-facing follow up and support.
Technologies: Python, PostgreSQL, Node.js, Google Cloud GCP, Containers, Kubernetes,
Microservices, Airflow, Git


R&D Team Lead

2019 - Aug 2020 (1 year)
Leading a team of 4 developers in full-stack development and architecture of an e-commerce live
solution. In addition, developing machine learning algorithms for prediction of customer behavior.
Technologies: Node.js, Python, AWS, MongoDB, Redis, MySQL


Mentor
Codementor
Aug 2018 - Jul 2020 (2 years)
Providing software and technical consultancy, mentorship and support through one-to-one live sessions
for tasks in various technologies and programming languages.
Achieved more than 220 sessions with a rating of 5.0/5.0, and have been selected as a "Featured
Mentor" for six times.


Senior Software Developer

2017 - Jun 2018 (1 year)
Design, development and maintenance at 3 e-commerce projects. Starting from system design of
entities and components to implementation and maintenance.
Technologies: .NET, C#, SQL, Entity Framework, Blockchain Network, JavaScript, HTML, CSS
Achievements:
- Design and implementation of a Bitcoin mining web platform and Blockchain transaction
- Implementation and maintenance for e-commerce website


Full Stack Developer

2015 - 2017 (2 years)
Development and maintenance for e-commerce web site. Implementing payment methods API’s and all
other forms and views.
Technologies: .NET, C#, SQL,Javascript, HTML, CSS
Achievements:
o Integrated multiple payment methods and services: Papara, Wirecard Mobile Payment, Inininal
o Created new Coupon system for discounts and mailing and SMS messaging system for automated
daily messages


Software Engineer

May 2011 - Feb 2014 (2 years 10 months)
Worked on Cisco’s classification engine that recognizes a wide variety of applications, including webbased and other difficult-to-classify protocols that utilize dynamic TCP/UDP port assignments
Built Web applications in JavaScript. The application was used by company’s customers to display and
monitor web traffic and show different details in charts and tables

Reviews (1)

It was very helpful ..
Machine Learning is a first-class ticket to the most exciting careers in data analysis today. As data sources proliferate along with the computing power to process them, going straight to the data is one of the most straightforward ways to quickly gain insights and make predictions. Machine learning brings together computer science and statistics to harness that predictive power. It’s a must-have skill for all aspiring data analysts and data scientists or anyone else who wants to wrestle all that raw data into refined trends and predictions. This is a class that will teach you the end-to-end process of investigating data through a machine learning lens. It will teach you how to extract and identify useful features that best represent your data, a few of the most important machine learning algorithms, and how to evaluate the performance of your machine learning algorithms.
Learning computer programming for university students in all levels. Could be very basic or for advanced courses. Suitable for reinforcement for university courses of: Java. Object Oriented, Data Structure, Advanced Java, Software Engineering, Database, Web Development.. etc. Can be given in: Java, C, C#, Javascript Course Outline: Section 1 - Getting Started Java Basics Data Types Arrays and References Operators and Constructs Java Objects Dynamic Memory Allocation Java Methods Java Strings Section 2 - Cla1sses and Objects Class Design Fields and Access Control Constructors Method Overloading Static Methods Inheritance Method Overriding Using final and super Abstract Classes and Methods Dynamic Binding Polymorphism Section 3 - Working with Classes Using instanceof Interfaces Exception Handling Exception Objects throw points, throws clause try, catch, finally Section 4 - User Interfaces Window Applications Layout Managers Event Handlers and Listeners Anonymous Classes and Lambdas Java Swing APIs Basic GUI Controls Menus and MenuBars Section 5 - Generics and Collections Why Use Generics? Generic Classes and Interfaces Generic Iterators Collections ArrayList, LinkedList, HashMap Section 6 - Threads Thread States Extending the Thread class Timer Thread Implementing the Runnable interface Section 7 - File I/O Input and Output Streams Binary and Text Files Files and Directory Methods
Teaching Arabic from scratch for any learner. Or teaching medium and advanced levels as well. Starting from basic reading and writing skills, into grammar and correct structure, and ending with reading and analyzing literature, novels or Quran

Ask a question

Send a message explaining your needs and Ibrahim 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  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00  Thursday at 4:00  Friday at 4:00  Saturday at 4:00  Sunday at 4:00
5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00  Thursday at 5:00  Friday at 5:00  Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday 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              
18              
19              
20              
21              
22              
23              
from £54.15Online 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 December 2017
  • Phone number verified
  • Google connected
  • Linkedin connected
    491 connections

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00  Thursday at 4:00  Friday at 4:00  Saturday at 4:00  Sunday at 4:00
5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00  Thursday at 5:00  Friday at 5:00  Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday 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              
18              
19              
20              
21              
22              
23              
from £54.15Online 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

Private lessons

Aniket
Certified Trainer For Web Development (Front-End and Backend) Nodejs | MEAN | MERN 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

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.

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.

Sanyam
Data Essentials: Learn SQL from scratch and master Querying and design
This course is for university students who would like to master data essentials and database querying. We learn normalisation, ER diagrams, DDL, DML as part of this course. Immerse yourself in practicing logics via different exercises. The couse will be tailored per your specific needs.

Pardeep
Mastering MS SQL Server: Database Development and Management
Mastering MS SQL Server: Database Development and Management Description: Unlock the full potential of database development and management with our comprehensive MS SQL Server course. Whether you're a budding database administrator, software developer, or IT professional, this course is designed to equip you with the skills and knowledge needed to harness the power of Microsoft SQL Server. What You'll Learn: Introduction to MS SQL Server: Understand the fundamentals of relational databases. Explore the architecture and components of MS SQL Server. Database Design and Normalization: Design efficient and normalized database structures. Learn best practices for creating scalable and maintainable databases. SQL Querying: Master Transact-SQL (T-SQL) for querying and manipulating data. Implement stored procedures, functions, and triggers. Data Modeling and Indexing: Create effective data models for optimal performance. Implement and optimize indexes for fast query execution. Advanced Querying and Reporting: Explore advanced querying techniques for complex data retrieval. Generate meaningful reports using SQL Server Reporting Services (SSRS). Data Security and Permissions: Implement robust security measures to protect sensitive data. Manage user roles and permissions effectively. Backup and Recovery Strategies: Develop comprehensive backup and recovery plans. Learn to restore databases in the event of data loss. Real-World Projects: Database Development: Design and implement a fully functional database for a real-world scenario. Performance Optimization: Identify and optimize slow-performing queries and database structures. Why Choose Our Course: Hands-On Labs: Apply your knowledge through hands-on labs and real-world scenarios. Expert Instructors: Learn from experienced database administrators and SQL Server professionals. Career Guidance: Receive insights into career paths in database development and administration. Certification Preparation: Prepare for Microsoft SQL Server certifications to boost your credentials. Who Is This Course For: Database Administrators Software Developers IT Professionals Students and Enthusiasts interested in database management Join us in this immersive journey to become a master of MS SQL Server. Enroll now to acquire the skills needed to build and manage robust databases that drive business success!

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

Oubaid
Learn SQL for Data Analysis Enthusiasts
This course will allow you to acquire SQL skills for data analysis and management. During this course, you will have the opportunity to use and manipulate the most well-known SQL features such as joins, subqueries, aggregation functions, filter and grouping clauses, as well as transactions. Finally, the methodology is based on familiarization with SQL syntax and the practice of acquired skills through real-world projects. SQL is one of the world's most widely used languages for relational database management, and it is essential for efficiently manipulating and extracting data in many fields, including data science and business intelligence.

Nick
Master Data Analytics: Microsoft Excel, SQL, PowerPoint & Others
As an educator specializing in Data Analytics, I provide expert instruction in essential tools and techniques, including Excel, SQL, PowerPoint, and PowerBI. These applications have emerged as critical components across various industry landscapes as well as in personal ventures, making the mastery of such skills immensely valuable. Additionally, I place an emphasis on soft skills training - areas such as data storytelling, presentation, and communication, which are often overlooked by many instructors, yet crucial in today's data-driven world. Bringing rich experience in teaching a diverse age spectrum, I steadfastly adhere to fundamental teaching principles. These encompass segmentation for digestible understanding, visualization for tracking progress, tangible results as benchmarks of learning, and real-world applications to refine acquired skills. Recognizing that effective learning strategies can differ greatly among individuals, I understand that there is no universally successful method. The true spirit of private tutoring lies in its adaptability to meet unique needs. Consequently, my pledge is to identify and implement the most conducive strategies that will invigorate and facilitate each of my students' learning journeys.

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!

Florent
SQL course - command and data management (MySQL)
My name is Florent and I am a data analyst with over 5 years of experience. Graduated from ENSTA Paris in machine learning, I have acquired solid expertise in this field. My professional background has allowed me to collaborate with several renowned consulting companies, including Accenture. I developed algorithms in VBA, created forecasts in Python and C. I also worked on image recognition in Matlab and did a lot of data management in SQL and MySQL. Please feel free to contact me to discuss your needs and how I can help you achieve your goals. See you soon,

Cal
SQL tutoring and instruction from a patient tutor. 20 yrs in analytics, now a full-time tutor!
Even if you don't have any prior experience in programming you can learn SQL! My teaching style puts the student in the driver's seat. You will be hands-on writing SQL and creating queries. I will be there to guide and encourage you. I'm like a personal trainer at the gym, you will feel that your mind has gotten a workout, and it will feel great. I have twelve plus years hands-on work experience with SQL. I have worked for most of my professional career as an analyst and SQL was the most powerful skill in my toolbox. I can create complex multi-table queries, functions, subqueries, stored procedures and database connections.

Mohammed
Java, Springboot, AWS, EC2, SQS, Web Development, SQL, AI.
I have around 8 years of experience working with Java, Spring, SQL and Web Development. I would like to offer my expertise to students and beginners who are willing to learn coding. I'm here to guide you on your journey to becoming a skilled developer. Let's learn together and unlock the potential of coding! Happy coding!

Abdelhak
IT engineer with more than 15 years of experience specializing in SQl, PL/SQL.PostgreSQL and Oracle.
Hello everyone, I am delighted to be here today to introduce myself as a trainer. As a computer engineer with over 15 years of experience, I have worked in various industry sectors. During my career, I have developed solid programming skills especially in SQL and PL/SQL language, and I am passionate about sharing my knowledge with you and putting my professional experience and technical skills to good use in this role . Database: - SQL, PL/SQL - Oracle, PostgreSQL, MySQL

Navid
Your Coding Adventure Begins Here: Master Python or SQL with Me
Hi there! I'm an experienced Python and SQL professional, and I'm inviting you to join me on an exciting journey into the world of coding. Don't worry about your age, background, or experience level - all you need is curiosity and a thirst for learning! In my class, I'll guide you through Python or SQL, as if we're embarking on an adventure. We'll start from the basics, making sure you feel confident, and then gradually dive deeper into the fascinating world of these powerful languages. Throughout our journey, I'll share my experiences and insights from years in the industry, and we'll use real-world examples to make learning more relatable. We'll solve fun quizzes and puzzles along the way to keep things interesting, and I'll be there to answer all your queries and provide feedback. By the end of this course, you'll not just learn Python or SQL, you'll experience them. You'll transform from a coding enthusiast to a confident coder ready to conquer new challenges. So come aboard this coding adventure. Let's learn, grow, and have fun together! Sign up today and let's script the future!

Enrique
SQL - Basics / Intermediate / Advanced + Assessment on demand
Standard language for accessing databases. Queries, clauses, dynamic executions, traces, execution plans, inserts, updates, inserts, deletes, merges, joins, unions, intersections, complex cases, direct data loads, temporary data sets, queues, embedded queries in programming languages ( C, Python, etc.), most common SQL interfaces (SQL Developer, Toad, DBeaver, etc.).