Python from scratch
For office or technical staff who have never programmed.
- Variables, conditions and loops
- Functions and error handling
- Reading and writing files
- Project: a useful script for your department
Corporate training
Python and database courses for companies
Your team learns to automate tasks, analyze data and query databases with exercises based on their daily work.
- Beginner to advanced
- On-site or online
- Project with your data
Format
Learn by coding, not by watching slides
Every session is hands-on: your team writes code from day one and finishes with a project they can use at work.
- On-site at your companyCancún, Monterrey and Saltillo
- Live onlineWith screen sharing and guided exercises
- Project with your dataWe use your company data or sample data
- Certificate and materialsCode, exercises and a guide for every participant
Your instructor. A university lecturer in programming fundamentals, Python and databases, with hands-on experience in Python and SQL Server.
Course catalog
Six Python and database courses
Take a single course or build a full track. We adapt duration and examples to your team.
Office automation with Python
Stop copying and pasting: Excel files, reports and emails that build themselves.
- Read and write Excel with pandas and openpyxl
- Merge and clean files from several departments
- Generate Excel and PDF reports
- Send automatic emails
Data analysis with Python
Turn sales, production or quality data into decisions.
- pandas to clean and transform data
- Grouping, pivot tables and KPIs
- Charts with matplotlib
- Jupyter notebooks to share analysis
Databases and SQL from scratch
Understand how your company data is stored and query it yourself.
- Relational model: tables, keys and relationships
- SELECT, filtering and sorting
- JOINs across tables
- Grouping and aggregate functions
SQL Server for business
For people who manage or work with a production database.
- Advanced queries, views and stored procedures
- Indexes and performance
- Backup and restore
- Users, permissions and security
Python and databases
Capstone project: connect Python to your database and automate reports.
- Connect to SQL Server, MySQL or PostgreSQL
- Load Excel data into the database
- Query from Python with pandas
- Scheduled automatic report
Also looking for cybersecurity courses?Phishing, executives, IT teams, industrial cybersecurity and data protection.
See cybersecurity courses →
Suggested tracks
Combine courses around your goal
Each track can run over consecutive weeks or be spread across the year.
Automation track
Python from scratch → Office automation with Python.
Data analysis track
SQL from scratch → Data analysis with Python → Python and databases.
Database track
SQL from scratch → SQL Server for business.
Development track
Python from scratch → SQL from scratch → Python and databases.
How we work
From level check to final project
Level check
A short questionnaire to form balanced groups.
Program
We choose courses, schedules and the data we will use.
Hands-on sessions
Guided coding with exercises from your department.
Final project
Each participant solves a real case from their job.
Follow-up
A Q&A session after the course to apply what they learned.
FAQ
Questions about the Python and SQL courses
If your question isn't here, message us on WhatsApp.
Do we need prior experience?
Not for the "from scratch" courses. Advanced courses require the basic course or equivalent experience; we run a quick level check before starting.
What do we need to install?
Python with Visual Studio Code or Jupyter, and SQL Server Express, MySQL or PostgreSQL depending on the course. We send an installation guide and help you; online groups can also use Google Colab.
Can you use our company data?
Yes, and it is the most useful option. We can work with anonymized data or a test copy. If you prefer not to share it, we use sample data similar to yours.
How many people per group?
We recommend up to 15 people so everyone codes with support. For larger groups we open several sessions.
Are courses available in English?
Yes. Every course can be delivered in English or Spanish.
Ready to train your team?
Request a quote
Contact
Tell us about your project
Tell us how many people and their level; we will suggest the right track.
WhatsApp+52 998 198 9559
Emailcontacto@nomadanetworks.com
LocationsCancún · Monterrey · SaltilloRemote projects across Mexico