from83.60QAR/ h
Learn SQL scripts, stored procedures, stored functions
In this class I start with teaching simple SQL like joins, cte functions etc. Later we will jump to advance sql like writing stored procedures, stored functions etc. Also I will cover very basic database designing concepts. Like the approach how to design good data base depending on the volume, performance etc.
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 |
Duration: | 60 minutes |
The class is taught in: | English, Hindi |
You can learn programming basics, object oriented programming basics. For beginners start with basic programming concepts and then gradually advancing to advance real world projects based on advance modelling approached or based AI ML solutions.
This course will be focusing on the programming basics. Student can choose his choice of language to learn like python, c#, vb.net or vba. This course will focus base constructs of programming like functions, classes, conditional, decision, repetitive constructs etc.
This course will help to build your skill in MS excel advance formulas like vlookup, hlookup, sumifs, countifs. Also we will look on analytics side covering Excel pivoting. We will also build small application covering excel formulas, vba macros and finally see the results via pivot reporting. Finally we will cover excel dashboarding also.
In this class I would like students to work on the real world time series fore-casting project. Where with the help of AI/ML Deep learning we will build models to forecast in future. We will write fore-casting models which will learn with historical data and then we test the model and see different scores. Finally we will use this model to predict.
Ask a question
Send a message explaining your needs and Shalini 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 -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | Saturday at 8:00 | Sunday at 8:00 | |||||
9 | 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 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 | ||||
13 | Tuesday at 13:00 | Thursday at 13:00 | Friday at 13:00 | Saturday at 13:00 | Sunday at 13:00 | ||
14 | Tuesday at 14:00 | Thursday at 14:00 | Friday at 14:00 | Saturday at 14:00 | Sunday at 14:00 | ||
15 | Tuesday at 15:00 | Thursday at 15:00 | Friday at 15:00 | Saturday at 15:00 | Sunday at 15:00 | ||
16 | Tuesday at 16:00 | Thursday at 16:00 | Friday at 16:00 | Saturday at 16:00 | Sunday at 16:00 | ||
17 | Tuesday at 17:00 | Thursday at 17:00 | Friday at 17:00 | Saturday at 17:00 | Sunday at 17:00 | ||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 83.60 QAROnline via webcam
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 May 2023
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | Saturday at 8:00 | Sunday at 8:00 | |||||
9 | 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 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 | ||||
13 | Tuesday at 13:00 | Thursday at 13:00 | Friday at 13:00 | Saturday at 13:00 | Sunday at 13:00 | ||
14 | Tuesday at 14:00 | Thursday at 14:00 | Friday at 14:00 | Saturday at 14:00 | Sunday at 14:00 | ||
15 | Tuesday at 15:00 | Thursday at 15:00 | Friday at 15:00 | Saturday at 15:00 | Sunday at 15:00 | ||
16 | Tuesday at 16:00 | Thursday at 16:00 | Friday at 16:00 | Saturday at 16:00 | Sunday at 16:00 | ||
17 | Tuesday at 17:00 | Thursday at 17:00 | Friday at 17:00 | Saturday at 17:00 | Sunday at 17:00 | ||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 83.60 QAROnline 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
online via webcam
Similar classes
Database (SQL Server, PostgreSQL, MySQL): From Fundamentals to Distributed Systems
Dive into the world of SQL databases with this comprehensive course designed for learners of all levels. Whether you are new to databases or seeking to expand your expertise to advanced concepts like distributed systems, this course has you covered.
What You can Learn:
- Fundamentals of relational databases and SQL syntax.
- Designing robust databases using normalization and entity relationships.
- Writing complex queries, joins, and subqueries.
- Database optimization techniques for performance tuning.
- Implementing stored procedures, triggers, and views.
- Managing transactions and ensuring data integrity.
- Understanding and working with distributed database systems like Distributed PostgreSQL
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.
SQL and Python lessons for beginners and career changers with a focus on real-world applications
I have a Master’s degree in Data Science from a UK university and a background in working with students and professionals who want to improve their skills in Python, SQL, or data analysis. I enjoy teaching in a practical, supportive way and always try to explain complex topics in simple terms. I also work on small real-world projects and guide learners through the logic behind every task. My goal is to help you feel confident and make steady progress.
Certified Trainer For Web Development (Front-End and Backend) Nodejs
- 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
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.
Complete SQL Training: Master data extraction and analysis.
I offer a comprehensive SQL course so you can efficiently retrieve and analyze your business data.
SQL is one of the most accessible languages in the world. By focusing on the fundamentals (joins, filters, aggregations, etc.), you can quickly acquire the skills needed to achieve your professional goals.
As a data trainer for several organizations, I offer this course, which is both theoretical and practical. Whether you're a beginner or an advanced user, I'll adapt the content to your level and needs.
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!
Master SQL from A to Z – From basics to advanced queries
This course is designed to guide you step-by-step through learning SQL, the essential language for interacting with databases. Whether you're a beginner or looking to strengthen your skills, you'll start with the basics (table creation, simple queries) and progress to advanced concepts such as query optimization, complex joins, and performance management.
By the end of the course, you will be able to effectively manipulate databases, write optimized queries, and manage large volumes of data with ease.
Javascript, HTML Computer Course for Beginners
This introductory web development course is specifically designed for beginners who want to learn the basics of JavaScript and HTML. You'll learn the fundamentals of creating interactive and dynamic web pages. Starting with the basics of HTML to structure your pages, you'll then learn how to make them interactive with JavaScript, manipulating page elements, handling events, and applying functions. By the end of this course, you'll be able to create simple web pages, add basic animations, and interact with users.
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.).
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.
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!
Introduction to SQL Database Query Basics
In this lesson, students will be introduced to Structured Query Language (SQL), the standard language used to manage and retrieve data from relational databases. They will learn how to perform basic queries such as INSERT, SELECT, UPDATE, and DELETE. They will also cover how to use control clauses such as WHERE, ORDER BY, and JOIN to search for and organize information. By the end of the lesson, students will be able to create simple SQL queries to read and modify data in databases.
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,
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.