facebook
favorite button
member since icon
Since May 2024
Instructor since May 2024
SQL tutoring and instruction from a patient tutor. 20 yrs in analytics, now a full-time tutor!
course price icon
From 40 € /h
arrow icon
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.
Extra information
I only offer classes online.
Location
location type icon
Online from Spain
About Me
My philosophy is that I am more of a guide than a teacher. I think the most effective learning is learning where the student is discovering their own answers and for the most part they just need a guide to point them in the right direct direction when they go astray.
Education
Masters of Business Administration - Virginia Commonwealth University 2006
Bachelor of Science in Business management and Spanish - dual major - Keene State College 1996
Experience / Qualifications
After twenty years in the business world working as an operational analyst, I have left my cubicle behind and have pursued education. I really have made a great move for myself as I love tutoring and teaching; I get to work from my home and I get to do what I love. Working in Analytics, I worked heavily with data and databases. I think I have spent most of my working career in MS Excel and have done innumerable things with it. In my work, I was always searching for answers, and SQL is the key computer language to know when looking for data. SQL is deceptively simple and yet so powerful, and I really enjoy using it. Displaying data deserves a good data visualization tool. To complete the picture (pun), you need to visualize data using Power BI or Tableau, both great tools.
Age
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
Skills
Availability of a typical week
(GMT -04:00)
New York
at teacher icon
Online via webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Even if you haven't used a spreadsheet program before you can learn Microsoft Excel!
My teaching style puts the student in the driver's seat. You will be hands-on creating formulas and using Excel's features and functions. I will be there to guide and encourage you. I feel more like a personal trainer at the gym than a tutor, you will feel that your mind has gotten a workout, and it will feel great.
I have twenty plus years hands-on work experience with Excel. I have worked for most of my professional career as an analyst and Excel was the most powerful tool in my toolbox.
Read more
Similar classes
arrow icon previousarrow icon next
verified badge
Pardeep
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!
message icon
Contact Cal
repeat students icon
1st lesson is backed
by our
Good-fit Instructor Guarantee
Similar classes
arrow icon previousarrow icon next
verified badge
Pardeep
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!
Good-fit Instructor Guarantee
favorite button
message icon
Contact Cal