Search
David L.'s Photo

David L.

Expert Tutoring in Python, VBA, SQL & Databases (no Data Science)

Expert Tutoring in Python, VBA, SQL & Databases (no Data Science)

$45/hour

  • 1,340 hours tutoring

About David


Bio

I am a Physics Ph.D. with two areas of specialty: math and software.

I have 10 years of experience as a software Technical Support Engineer. I love helping customers. I have tons of experience with Python, SQL, databases, VBA (Visual Basic for Applications), Linux and UNIX (including shell scripting), VBscript with WSH, Excel, and troubleshooting everything you can imagine with Windows.

I have 15 years of experience as a math tutor, especially with pre-calculus or calculus.

I've been...

I am a Physics Ph.D. with two areas of specialty: math and software.

I have 10 years of experience as a software Technical Support Engineer. I love helping customers. I have tons of experience with Python, SQL, databases, VBA (Visual Basic for Applications), Linux and UNIX (including shell scripting), VBscript with WSH, Excel, and troubleshooting everything you can imagine with Windows.

I have 15 years of experience as a math tutor, especially with pre-calculus or calculus.

I've been told I'm kind and really good at communicating with people at their own level. I'm also patient, happy to work with students at their own pace, and good at putting students at ease.

I have extensive experience working with Oracle, Microsoft SQL Server, and Microsoft Access databases, but I've also worked with MySQL, PostgreSQL, and SQLite. I have sample MySQL and PostgreSQL databases running on Debian virtual machines, a sample SQL Server database running on a Ubuntu Server virtual machine, and a sample Oracle database running on a Windows virtual machine.

I have used Python extensively for web scraping and for accessing all of the database types I've mentioned above. I've taken basic and intermediate Python classes, plus 1 year of computer science classes. I do not know Data Science or typical Data Science Python libraries such as Pandas and Matplotlib.

I've done all sorts of insane things with Microsoft Excel, including using VBA anywhere from creating simple custom functions to complex functionality with multiple custom forms with various controls on them.

Here's a summary of all my work on Wyzant.com:
672 hours of Python tutoring in 566 session for 242 students.
279 hours of SQL and database tutoring in 256 sessions for 123 students.
62 hours of VBA tutoring in 53 sessions for 25 students.
43 hours of Linux and Unix tutoring in 45 sessions for 29 students.
43 hours of Calculus and pre-calculus tutoring in 67 session for 14 students.


Education

Alumni of University of California, Los Angeles (UCLA) B.S.
Physics
U.C. Berkeley
PhD

Policies

  • Hourly Rate: $45
  • Rate details: I charge for time used, not time reserved. I reserve the right to charge 75% of the fee for lessons missed, or canceled or postponed less than 3 hours in advance, but only for students being a jerk.
  • Lesson cancellation: 3 hours notice required
  • Background check passed on 8/29/2020

  • Your first lesson is backed by our Good Fit Guarantee

Schedule

Loading...

Sun

Mon

Tue

Wed

Thu

Fri

Sat


Subjects

Business

GRE,

GRE

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.
Microsoft Excel

Microsoft Excel

I have many years of experience with Excel, doing all sorts of insane things with it: chains of spreadsheet functions, pivot tables, statistical analyses, charts and tables, custom spreadsheet functions using several lines of VBA code, even custom windows with hundreds of lines of VBA code. I’m also an experienced tutor and technical support engineer, with a talent for two things: 1) seeing where my students are, and then 2) telling them what they need to know in an easy-to-understand way at a comfortable pace. If you want to systematically learn Excel or parts of it, we can select a good textbook on Excel, and we can regularly meet for lessons and Q&A as you read through the textbook and work assignments. Or I can directly teach you the parts of Excel you want to master. We can work on spreadsheets together using Wyzant’s desktop sharing feature.

Computer

Linux,

Linux

I have years of experience using the Linux and UNIX command line and with shell scripting, including with sed, awk, grep, and regular expressions. I have experience working with Ubuntu Desktop and Server, CentOS, and Debian. I have imported and installed a variety of Linux distros into virtual machines in Virtualbox and VMWare on Windows hosts, and have networked together multiple Virtualbox guests running in parallel. On Wyzant.com, I have tutored Linux & Unix to 29 students for 43 hours in 45 sessions. I cannot help with C/C++ System Programming on Linux.
Microsoft Excel,

Microsoft Excel

I have many years of experience with Excel, doing all sorts of insane things with it: chains of spreadsheet functions, pivot tables, statistical analyses, charts and tables, custom spreadsheet functions using several lines of VBA code, even custom windows with hundreds of lines of VBA code. I’m also an experienced tutor and technical support engineer, with a talent for two things: 1) seeing where my students are, and then 2) telling them what they need to know in an easy-to-understand way at a comfortable pace. If you want to systematically learn Excel or parts of it, we can select a good textbook on Excel, and we can regularly meet for lessons and Q&A as you read through the textbook and work assignments. Or I can directly teach you the parts of Excel you want to master. We can work on spreadsheets together using Wyzant’s desktop sharing feature.
Microsoft Windows,

Microsoft Windows

I'm an experienced software technical support engineer who has worked with all versions of Windows since Windows 3.11. I have done extensive troubleshooting of problems with the Windows operating system and of programs running on Windows, including problems with slowness, crashing, errors, and malware.
Python,

Python

I have considerable experience with programming Python, with object oriented programming, and with computer science.  I'm not familiar with Pandas, Matplotlib, or other common data science libraries. I have 15 years of experience as a tutor of math and software, and 10 years as a Technical Support Engineer. I have a talent for understanding what my students need to know, and teaching them at their own pace. In Python, I'm familiar with the basic Python libraries, web scraping, and database programming.  My favorite development environments are PyCharm and PyDev, and I'm familiar with Thonny and Jupyter Notebook. I've posted some of my Python programs online on GitHub, at github.com/DavidJLambert, if you want to look at it.  I also have experience with VBA, Java, Bash, Fortran, and shell scripting. Python is a common choice for a first programming language, partly because it is easy for beginners to learn.  But it can still be a challenge to learn because Python has 3 different programming paradigms: procedural, object-oriented, and functional.  These paradigms work very differently from each other, and that can be quite a challenge for people new to programming.  Procedural is easy.  Object oriented is quite different, and can be a challenge to get used to.  Functional programming is not covered in a first course on programming, and is still harder to get used to.
SQL,

SQL

I have more than 10 years of experience as a Technical Support Engineer with SQL, and with 6 types of relational databases: Oracle, SQL Server, MySQL, PostgreSQL, Microsoft Access, and SQLite. I have lots of experience installing, configuring, and administering these 6 types of databases on Windows and Linux, and I have sample databases of all 6 types available for you to use: Access and SQLite database files, and VirtualBox virtual machines with the other 4 types: Oracle, SQL Server, MySQL, and PostgreSQL. I also have 15 years of experience as a tutor, making me a patient, easy-to-understand teacher of technical subjects.  I excel at figuring out where my students are, then giving them the knowledge they need at a pace comfortable for them. SQL can be a challenge for students.  It’s not a procedural language where you give the computer exact steps to follow.  In SQL, you tell the computer what results you want, and the computer figures out the quickest way to get your results.
UNIX,

UNIX

I have years of experience using the UNIX and Linux command line and with Korn and Bash shell scripting, including with sed, awk, and grep. I have experience working with the Solaris and HP-UX operating systems and with programs running on them, including performance issues. I cannot help with C/C++ System Programming on UNIX, because I do not know C/C++.
Visual Basic

Visual Basic

I have written lots of VBA code for creating custom functionality in Excel, Access, and Outlook that includes custom forms with buttons, lists, check boxes, and hundreds of lines of VBA.  I've also written custom worksheet functions. I have years of experience writing VB Script working with COM objects and the Windows Scripting Host for intelligently automating various tasks, including running backups, and fetching web pages and processing their contents. On Wyzant, I have tutored 25 students in VBA and VBScript in 53 sessions over 62 hours, most of them new to programming. I do not have experience with the .NET Framework.

Corporate Training

Microsoft Excel,

Microsoft Excel

I have many years of experience with Excel, doing all sorts of insane things with it: chains of spreadsheet functions, pivot tables, statistical analyses, charts and tables, custom spreadsheet functions using several lines of VBA code, even custom windows with hundreds of lines of VBA code. I’m also an experienced tutor and technical support engineer, with a talent for two things: 1) seeing where my students are, and then 2) telling them what they need to know in an easy-to-understand way at a comfortable pace. If you want to systematically learn Excel or parts of it, we can select a good textbook on Excel, and we can regularly meet for lessons and Q&A as you read through the textbook and work assignments. Or I can directly teach you the parts of Excel you want to master. We can work on spreadsheets together using Wyzant’s desktop sharing feature.
SQL

SQL

I have more than 10 years of experience as a Technical Support Engineer with SQL, and with 6 types of relational databases: Oracle, SQL Server, MySQL, PostgreSQL, Microsoft Access, and SQLite. I have lots of experience installing, configuring, and administering these 6 types of databases on Windows and Linux, and I have sample databases of all 6 types available for you to use: Access and SQLite database files, and VirtualBox virtual machines with the other 4 types: Oracle, SQL Server, MySQL, and PostgreSQL. I also have 15 years of experience as a tutor, making me a patient, easy-to-understand teacher of technical subjects.  I excel at figuring out where my students are, then giving them the knowledge they need at a pace comfortable for them. SQL can be a challenge for students.  It’s not a procedural language where you give the computer exact steps to follow.  In SQL, you tell the computer what results you want, and the computer figures out the quickest way to get your results.

Homeschool

Calculus,

Calculus

I have 15 years of experience tutoring students in math, all the way from pre-algebra to calculus and linear algebra. I have a talent for seeing where my students are, and then telling them what they need to know in an easy-to-understand way at a comfortable pace. As a tutor, I usually explain a topic and show you an example or two.  Then I have you do an example or a homework problem, giving you hints to get you to the correct answer.  Think of me as your training wheels.
Precalculus,

Precalculus

I have 15 years of experience tutoring students in math, all the way from pre-algebra to calculus and linear algebra. On Wyzant.com, I have tutored various math topics to 28 students for 68 hours in 89 sessions. I have a talent for seeing where my students are, and then telling them what they need to know in an easy-to-understand way at a comfortable pace. As a tutor, I usually explain a topic and show you an example or two.  Then I have you do an example or a homework problem, giving you hints to get you to the correct answer.  Think of me as your training wheels.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.

Math

ACT Math,

ACT Math

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.
Calculus,

Calculus

I have 15 years of experience tutoring students in math, all the way from pre-algebra to calculus and linear algebra. I have a talent for seeing where my students are, and then telling them what they need to know in an easy-to-understand way at a comfortable pace. As a tutor, I usually explain a topic and show you an example or two.  Then I have you do an example or a homework problem, giving you hints to get you to the correct answer.  Think of me as your training wheels.
Precalculus,

Precalculus

I have 15 years of experience tutoring students in math, all the way from pre-algebra to calculus and linear algebra. On Wyzant.com, I have tutored various math topics to 28 students for 68 hours in 89 sessions. I have a talent for seeing where my students are, and then telling them what they need to know in an easy-to-understand way at a comfortable pace. As a tutor, I usually explain a topic and show you an example or two.  Then I have you do an example or a homework problem, giving you hints to get you to the correct answer.  Think of me as your training wheels.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.

Most Popular

Calculus,

Calculus

I have 15 years of experience tutoring students in math, all the way from pre-algebra to calculus and linear algebra. I have a talent for seeing where my students are, and then telling them what they need to know in an easy-to-understand way at a comfortable pace. As a tutor, I usually explain a topic and show you an example or two.  Then I have you do an example or a homework problem, giving you hints to get you to the correct answer.  Think of me as your training wheels.
Precalculus

Precalculus

I have 15 years of experience tutoring students in math, all the way from pre-algebra to calculus and linear algebra. On Wyzant.com, I have tutored various math topics to 28 students for 68 hours in 89 sessions. I have a talent for seeing where my students are, and then telling them what they need to know in an easy-to-understand way at a comfortable pace. As a tutor, I usually explain a topic and show you an example or two.  Then I have you do an example or a homework problem, giving you hints to get you to the correct answer.  Think of me as your training wheels.

Summer

Calculus,

Calculus

I have 15 years of experience tutoring students in math, all the way from pre-algebra to calculus and linear algebra. I have a talent for seeing where my students are, and then telling them what they need to know in an easy-to-understand way at a comfortable pace. As a tutor, I usually explain a topic and show you an example or two.  Then I have you do an example or a homework problem, giving you hints to get you to the correct answer.  Think of me as your training wheels.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.

Test Preparation

ACT Math,

ACT Math

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.
GRE,

GRE

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the ACT, the GRE, and the SAT.  I’ve taken the SAT twice, the GRE twice, and I’ve taken many practice tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great test score.  1)  Understand the different types of test questions, which we can go over together. 2)  Take practice tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as possible. This is very important on the SAT Math, because there isn’t enough time for most people to complete all the questions. If you don’t have practice tests, I can get you some.

Examples of Expertise


David has provided examples of their subject expertise by answering 18 questions submitted by students on Wyzant’s Ask an Expert.

Ratings and Reviews


Rating

4.9 (583 ratings)
5 star
(541)
4 star
(26)
3 star
(11)
2 star
(3)
1 star
(2)

Reviews

Show reviews that mention

All reviews

Excellent tutor.

David helped guide me through multiple SQL practice exam questions. Afterwards, he provided a detailed explanation as to how best to approach the questions, which helped further my understanding. I will seek him out when I need help with new concepts in the future.

Frank, 1 lesson with David

First session-awesome!

I learned more from David in one session then online classes and 2 books. I told him what I needed to learn and on one session we are already halfway there -he was willing to continue but I had learned so much I needed the break!!!

Diane, 2 lessons with David

Very informative and knowledgeable guy

At my university, there was this one class I was required to take that is notorious for having one of the lowest passing rates, and that was an "intro" to python programming class. The professor for this course literally has a 1.5/5 rating on ratemyprofessor.com and it's not surprising at all. This class contained tedious, hour long coding projects, with vaguely written instructions. I had to retake this class so as to increase my gpa for admission to MSU's college of engineering. I decided to then find a tutor and so I stumbled upon David's profile on Wyzant. David is an absolutely amazing tutor. He is a very friendly, knowledgeable, and dedicated person. He definitely shows that he has much expertise when it comes to Python programming, as he was able to fully break down and explain a concept to me whenever I had a question about it. His explanations are 10x better than however my professor, or his textbook, tried to explain. While David definitely helps you with a lot of coding in his tutoring, it's important to know that he is not there to just "give you the answer" right away. He will definitely make you think about it for a minute or two and ask you to try to brainstorm ways to solve complex problems, but he only does this as an effective way to make sure it sticks with you after you figure it out. It can be a bit tricky to sometimes grasp problems at first but, once you get it, you realize that his method of teaching it to you is very effective. My first attempt at this course last year was a disaster and I really had no idea what exactly I was doing every time I attempted to code something. When I retook this class recently with David tutoring me, I gained a much deeper understanding of Python and how to use it to solve complex problems that were handed to me in both the coding projects and the coding questions on exams. Overall, he is a solid tutor and I HIGHLY recommend anyone struggling with Python to reach out to him. He's worth every penny!

Sachid (such-id), 30 lessons with David

Very Knowledgeable and patient!

I need help to understand how to access files and directories using if statements and for/while loops in bash scripts. David was very patient because It was the first time I’m working on it and he explained every line of code we were working on. He helped me a lot.

Carlos, 3 lessons with David

So worth it!

David knew how to solve every problem within seconds of looking at it. He walked me through each line of code and is extremely patient when it comes to ensuring you understand the concepts. I 100% recommend David!!

Shea, 3 lessons with David

Super Helpful!

David - responded quickly and was able to help in a pinch. Explained the context well and helped find the solution!

Julius, 1 lesson with David

the best

David is the best Wyzant tutor I’ve ever had. He is so friendly, so patient, so smart. I just showed up one day and said, hey teach me this. On the spot lesson, BOOM! Killed it

Brandon, 9 lessons with David

Patient and knowledgeable

We were not able to complete my needs since I am working from home. We have an appointment set for the next time I am in the office so I can fully get the information that I need.

Susan Marie, 3 lessons with David

SQL subject matter expert

David was very helpful. I have high functioning autism but I sometimes get frustrated. David did a great job of working with me and I plan on havining a minimum of 1 session per week moving forward.

Hunter, 5 lessons with David
Contact David

Response time: 51 minutes

$45/hour

David L.'s Photo

David L.

$45/hour

  • No subscriptions or upfront payments

  • Only pay for the time you need

  • Find the right fit, or your first hour is free

Contact David

Response time: 51 minutes