Python and SQL Course: SQL and Python

Bodenseo: International Canada / US Germany Switzerland Jobs Imprint Data Protection Declaration

"An easily accessible and transparent database of contract information will bring sunshine into the confusing and sometimes shadowy practice of government contracting."
(Tom Coburn, US politician)

O. Von Corven, Bearbeitung Bernd Klein

We can adopt the topics to your needs!

All our courses are tailored to meet your expectations and are conveniently scheduled and delivered at Lake Constance or the location of your choice, if you prefer onsite training. We offer onsite training in Canada, and all over Europe, especially in Germany, Switzerland, Austria, Luxembourg, Italy, the Netherlands and England and the UK. Covering cities like Munich, Stuttgart, Frankfurt, Saarbrücken, Zürich, Bern, Basel, Luzern, Bregenz, Strasbourg, Paris, Rhome and London.

SQL and Python

This course has been held as an online training course since March 2020. Further Information!

This hands-on class covers all the basics of relational databases, like SQL and MySQL. At the end of the course participants will be able to design and maintain databases in MySQL and other SQL based databases. Participants will also be familiar in querying, retrieving filtering and sorting information from existing databases. Additionally, a short introduction in Python and the SQL interfaces of Python is provided.
Though the course is based on MySQL, it is a general SQL course without using any MYSQL specific features.

Target Group:
This is the right course for those who want to use SQL under Python and are novices concerning SQL / MySQL and have a little knowledge of programming or in Python.

Our other SQL-Course:

MySQL Course for Beginners

Content:
SQL content:

History of datbases and SQL
SQL vs. MySQL
The basics of relational databases
Create Databases
Organize Data into Tables
Primary and Foreign Keys
Extract Information from a database using the SELECT command
CASE, WHERE and ORDER BY clauses
Use simple functions (String, Date, Numerical)
Deleting and modifying databases and tables
Nested sub-queries
Group query data with aggregation
Using JOIN to connect data from multiple table rows

Python content:

Using the interactive Python shell
Editing and starting Python scripts
Fundamentals: Variables, basic data types and assignments. Operators and expressions.
Conditional Statements: The details of the if statement and the conditions
Loops: While and for-loops
Data Types: Lists, Tuples and Dictionaries
Lists and stacks
Functions
File Handling

Dates:

Dieser Kurs findet bei ausreichender Teilnehmerzahl statt. Bitte geben Sie uns unverbindlich ihr Interesse an dieser SQL-Schulung kund.

Prices for this SQL course per day:

ONLINE:: €414 per day (exclusive of VAT)
Toronto, Canada:: $580 per day (exclusive of HST)
Lake Constance, Hemmenhofen, Germany:: €414 per day (exclusive of VAT)
plus € 139 for full board and lodging in 4 star hotel
Hamburg, Munich, Frankfurt, Berlin (Germany):: €442 per day (exclusive of VAT)
Zurich and Geneva (Switzerland):: £442 per day (exclusive of VAT)

Attention:
The price of this course includes participation in the seminar and board and lodging in a 4-star hotel located at Lake Constance.
Also included in the price:
Schulungsunterlagen