Search
David L.'s Photo

David L.

Expert Software Tutoring: Python, SQL & Databases (no Data Science)

Expert Software Tutoring: Python, SQL & Databases (no Data Science)

$45/hour

  • 1,064 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 SQL, databases, Excel, Python, VBA (Visual Basic for Applications), Linux and UNIX (including shell scripting), VBscript with WSH, and troubleshooting everything you can imagine with Windows.

I have 15 years of experience as a math tutor, and I've worked with students from middle school through...

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 SQL, databases, Excel, Python, VBA (Visual Basic for Applications), Linux and UNIX (including shell scripting), VBscript with WSH, and troubleshooting everything you can imagine with Windows.

I have 15 years of experience as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra.

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. If you want to, we can use any of these virtual machines for practice.

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. I've taken 1 year of computer science classes, so I know about basic data structures and algorithms. 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.

I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that we're so good.


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 GRE. I’ve taken the GRE twice, plus I’ve taken many practice GREs, so I understand test taking strategies, which I will share with you. There are two keys to getting a great GRE score. First, understand the different types of GRE questions, which we can go over together. Second, take a number of practice GRE tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as you can. If you don’t have some, I can get you practice GRE tests.
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, and grep. 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. I cannot help with C/C++ System Programming on Linux, because I don't know C or C++ .
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

Since I started tutoring on Wyzant, I have tutored 83 students in Python in 185 sessions over 231 hours, most of them beginners in Python and programming. I don't tutor in Data Science. I have considerable experience with programming Python, with object oriented programming, and with computer science. 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. I'm not familiar with the usual data science libraries, such as Pandas and Matplotlib. I can't help you with AI. 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 Java, Fortran, VBA, Bash, 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

Since I started tutoring on Wyzant, I have tutored 35 students in SQL and databases in 66 sessions over 76 hours. 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 years of experience writing VB Script working with COM objects and the Windows Scripting Host for intelligently automating various tasks, including parsing the contents of web pages and running backups. I have also written VBA code for creating custom functionality in Excel, Access, and Outlook that includes custom forms. I have written Visual Basic programs. 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

Since I started tutoring on Wyzant, I have tutored 35 students in SQL and databases in 66 sessions over 76 hours. 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 as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra. I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that were no good. 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.
Precalculus,

Precalculus

I have 15 years of experience as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra. I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that were no good. 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.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the SAT Math. I’ve taken the SAT twice, plus I’ve taken many practice SATs, so I understand test taking strategies, which I will share with you. There are two keys to getting a great SAT Math score. First, understand the different types of SAT Math questions, which we can go over together. Second, during the test, there isn’t enough time for most people to complete all the SAT Math questions, so you must take practice SATs under simulated testing conditions. That way, you learn to pace yourself and answer as many questions as possible. If you don’t have some, I can get you practice SATs.

Math

ACT Math,

ACT Math

I have 15 years of experience tutoring on many subjects, including the ACT Math. I’ve taken the SAT twice, plus I’ve taken many practice ACT Math tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great ACT Math score. First, understand the different types of ACT Math questions, which we can go over together. Second, take a number of practice ACT Math tests under simulated testing conditions. That way, you learn to pace yourself and answer as many questions as possible. If you don’t have some, I can get you practice ACT Math tests.
Calculus,

Calculus

I have 15 years of experience as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra. I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that were no good. 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.
Precalculus,

Precalculus

I have 15 years of experience as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra. I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that were no good. 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.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the SAT Math. I’ve taken the SAT twice, plus I’ve taken many practice SATs, so I understand test taking strategies, which I will share with you. There are two keys to getting a great SAT Math score. First, understand the different types of SAT Math questions, which we can go over together. Second, during the test, there isn’t enough time for most people to complete all the SAT Math questions, so you must take practice SATs under simulated testing conditions. That way, you learn to pace yourself and answer as many questions as possible. If you don’t have some, I can get you practice SATs.

Most Popular

Calculus,

Calculus

I have 15 years of experience as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra. I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that were no good. 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.
Precalculus

Precalculus

I have 15 years of experience as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra. I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that were no good. 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.

Summer

Calculus,

Calculus

I have 15 years of experience as a math tutor, and I've worked with students from middle school through college and beyond, covering topics from pre-algebra and algebra through calculus and linear algebra. I've helped math students with a variety of difficulties, such as math anxiety, a tendency to make lots of mistakes on homework and tests, and teachers and textbooks that were no good. 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.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the SAT Math. I’ve taken the SAT twice, plus I’ve taken many practice SATs, so I understand test taking strategies, which I will share with you. There are two keys to getting a great SAT Math score. First, understand the different types of SAT Math questions, which we can go over together. Second, during the test, there isn’t enough time for most people to complete all the SAT Math questions, so you must take practice SATs under simulated testing conditions. That way, you learn to pace yourself and answer as many questions as possible. If you don’t have some, I can get you practice SATs.

Test Preparation

ACT Math,

ACT Math

I have 15 years of experience tutoring on many subjects, including the ACT Math. I’ve taken the SAT twice, plus I’ve taken many practice ACT Math tests, so I understand test taking strategies, which I will share with you. There are two keys to getting a great ACT Math score. First, understand the different types of ACT Math questions, which we can go over together. Second, take a number of practice ACT Math tests under simulated testing conditions. That way, you learn to pace yourself and answer as many questions as possible. If you don’t have some, I can get you practice ACT Math tests.
GRE,

GRE

I have 15 years of experience tutoring on many subjects, including the GRE. I’ve taken the GRE twice, plus I’ve taken many practice GREs, so I understand test taking strategies, which I will share with you. There are two keys to getting a great GRE score. First, understand the different types of GRE questions, which we can go over together. Second, take a number of practice GRE tests under simulated testing conditions, so that you learn to pace yourself and answer as many questions as you can. If you don’t have some, I can get you practice GRE tests.
SAT Math

SAT Math

I have 15 years of experience tutoring on many subjects, including the SAT Math. I’ve taken the SAT twice, plus I’ve taken many practice SATs, so I understand test taking strategies, which I will share with you. There are two keys to getting a great SAT Math score. First, understand the different types of SAT Math questions, which we can go over together. Second, during the test, there isn’t enough time for most people to complete all the SAT Math questions, so you must take practice SATs under simulated testing conditions. That way, you learn to pace yourself and answer as many questions as possible. If you don’t have some, I can get you practice SATs.

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 (469 ratings)
5 star
(435)
4 star
(20)
3 star
(9)
2 star
(3)
1 star
(2)

Reviews

Show reviews that mention

All reviews

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, 4 lessons with David

Helpful, patient and kind

David L. has taken the time to help me through numerous problems I've come across regarding python coding. He has been extremely helpful, patient and kind throughout my experience working with him. He also helped guide me in a direction to be able to work more freely and become more proficient with the work. I would highly recommend David L.

Daniel, 3 lessons with David

Knowledge and patient tutor

He was able to explain the logic and theory behind what he was doing quite well and provided detailed, step-by-step instructions. I received more than one solution for my particular problem which was very helpful!

Rina, 1 lesson with David

Helpful, patient, efficient

David was well worth the money. Greatly appreciate his efforts. He works to your pace and does a great job of combining programming skills and goof tutoring. Thank you very much

Robert, 2 lessons with David

Patient and very observant!

David helped me on my precalc homework, he helped me work on some of my weaknesses in math and helped me understand them. I bounced all my questions off him and he always had a good answer I understood. He picked up that I was a visual learner and used a graph to help me understand a chart. Thank you, David.

Mitchell, 5 lessons with David

Great

David is great educator he follow up and make sure the lesson is well rounded and clear .He is knowledgeable .david send messages and keeps in touch to make sure the knowledge is delivered

Raied, 3 lessons with David

Knowledgeable and reliable

We worked on a postgresql project, he is a database expert, I liked that he gave me his calendar schedule, and I was able to choose from the available slots, straight forward and reliable.

Eaman , 2 lessons with David

Knowledgeable, Quick, Experienced, and Patient. Fun to talk to.

David was able to respond on a short notice. He was extremely patient and quick in solving the issue. He answered all my questions and even knew what I was asking even before asking it. I enjoyed learning with him, seems like an awesome guy. He obviously knows his stuff and I love his honestly. He guided me in the right direction and hence I was able to do the rest of my project all on my own. David, you're awesome!

Danielle, 1 lesson with David
Contact David

Response time: 2 hours

$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: 2 hours