Python and SQL Course: SQL and Python (original) (raw)

• Home
• Ask for information
• Enrolment
• Contact
• Overview courses
• Python
• ML
• JavaScript
• 3d-Animations
• Linux
• [Web Server](courses.php?topic=Web Server)
• [Server Training](courses.php?topic=Server Training)
• SEO
• SQL
• Perl
• Programming
• Java
• XML

"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)

We can adopt the topics of the seminar to your needs!

All our courses are made-to-measure your expectations and are conveniently scheduled and delivered at various locations: Lake Constance or Berlin in Germany, Toronto in Canada. London in England. On-site training at the location of your choice is no problem. We offer in-house training courses all over Canada and 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, Amsterdam, London, and Toronto in Canada.

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.

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.

The fees 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)

© The content and the images of this website are underlying copyright as described in the Imprint.