Seminars for your success 

SQL basics and database development

Databases are the central component in information technology today. When workflows, transactions and information are available around the clock, the storage of large amounts of data is usually required. SQL is the most widespread database language for managing relational databases and is indispensable for efficient work with databases.
Urs Scheufele: Seminar leader and lecturer SQL basics and database development

The content of this seminar is aimed at people who are completing IT training, such as IT specialists, business IT specialists or IT business people. I like to divide this seminar into 2 parts. In the first part, I give a basic and detailed overview of database theory, which includes the topics of database models, database design and normalisation.

In the second part of the seminar "SQL Basics and Database Development", the participants use this knowledge together with me to create databases with SQL, to learn how to handle tables and data and to carry out the different work with keys and indices, queries, joins and views. In the further course, the seminar participants learn e.g. user rights and transactions, create stored procedures and learn how to monitor a database with triggers. The training content and focus can be determined in the seminar and, if necessary, directly applied to concrete examples in professional practice.

  • Introduction relational databases
  • Introduction SQL
  • Database design
  • Data model, ER model
  • Installation of the professional working environment, XAMPP, or similar;
  • PHP MyAdmin Admin interface MySQL or MariaDB configuration,
  • Database connection, manage user rights;
  • Create, delete, change databases and tables, add records via the PHP-MyAdmin interface;
  • Digression MySQL data types;
  • Simple SQL queries with conditions;
  • Online documentation;
  • Data types in PHP;
  • Primary key, foreign key and indices
  • Integrity
  • Database and table definitions, data types
  • Create and manage tables
  • Edit data (insert, edit, delete)
  • Data queries (SELECT, WHERE)
  • Data queries from several tables (JOIN)
  • Sub-queries
  • Cursor
  • Working with views
  • Create, edit and delete routines and triggers
  • Transactions
  • User/rights management and access protection
  • SQL syntax of common databases

At least 3 days

Recommended 5 days

Aspiring web designers, web developers, programmers, IT specialists, IT business people and anyone who wants to gain a sound understanding of database architecture. You should have basic knowledge of an operating system such as Windows, Linux or MAC OS/X and general IT basics.

Urs Scheufele: Seminar leader and lecturer SQL basics and database development

Training.Internet.Coding Urs Scheufele

Similar seminar topics

HTML & CSS Training.Internet.Coding

Basics HTML5.X and CSS3 

Seminars for your success Basics HTML5.x and CSS3 Static web pages are not programmed, but written in the markup language

request seminar date

100% secure internet 100% SSL access Quality Icon

You are looking for another topic

Cryptocurrencies

Currency $ Price Market cap.
bdt-ep-crypto-table-image Bitcoin btc $ 19269.13 367.6B
bdt-ep-crypto-table-image Ethereum eth $ 1068.17 127.5B
bdt-ep-crypto-table-image Tether usdt $ 1.00 66.3B
bdt-ep-crypto-table-image USD Coin usdc $ 1.00 55.8B
bdt-ep-crypto-table-image NBB bnb $ 218.09 35.6B

Payment methods

de-pp_plus-logo-quer_ohne_PUI_540x60px
bank transfer

Shipping with

DHL

Log in

Newsletter subscription

Current information New seminars, tips and tricks around IT.