SQL, NoSQL and streaming: the data foundations of modern development
Databases remain the foundation of any information system. SQL for relational databases, NoSQL for massive volumes and flexible schemas, Apache Kafka for event streaming, Hadoop for large volume processing: mastering this ecosystem has become essential to back-end developers, data engineers and solution architects. In Geneva, Lausanne and across French-speaking Switzerland, banks, insurance companies, international organisations and industrial companies are structuring their data platforms around these technologies, which creates strong demand for data profiles.
Following a recognised SQL, NoSQL or Kafka training opens access to structuring technical roles: back-end developer, data engineer, data architect, integration engineer, big data engineer. This skill is particularly valued in organisations scaling their data, in analytics departments, in platform teams and at vendors structuring their services around event-driven architectures.
ITTA offers a catalogue dedicated to database design and development, from foundation SQL level to Kafka streaming and Hadoop big data. Each session is built around hands-on labs on real databases, with limited group sizes to enable personalised support.
Whether you are a back-end developer, data engineer, solution architect, integration engineer or analytics consultant, our training in Geneva and Lausanne provides the practical skills expected on the Swiss market to design, query and evolve relational databases, NoSQL stores and modern streaming architectures.
Skills covered by our database development catalogue
SQL and relational databases
SQL remains the unavoidable language of relational databases. Our SQL Database Training Introduction lays the basics: relational model, tables, primary and foreign keys, simple queries, aggregations, joins. Our SQL Fundamentals and Queries training deepens complex queries (subqueries, analytical functions, CTE), modelling, simple optimisation and best practices. These courses suit junior back-end developers, data profiles, business analysts and all profiles querying relational databases in their daily work.
NoSQL databases (Cassandra, HBase, MongoDB, Couchbase)
The Introduction to NoSQL Cassandra HBase MongoDB Couchbase training positions the main NoSQL families: key-value, document, wide-column, graph. You learn the use cases suited to each family, the CAP trade-offs and the consistency models. Our Cassandra Fundamentals training deepens Cassandra modelling, partition keys, CQL queries and production best practices. These courses suit back-end developers, data engineers and architects who must choose and deploy a NoSQL database alongside existing relational databases.
Apache Kafka for event streaming
Apache Kafka has become the event streaming standard in modern distributed architectures. The Apache Kafka Fundamentals training covers the concepts (topics, partitions, producers, consumers, brokers), cluster configuration, Avro serialisation, integration patterns and production best practices. This training suits back-end developers, data engineers, solution architects and integration profiles industrialising an event-driven architecture between microservices and data platform.
Hadoop for big data
The Introduction to Hadoop Development training covers the big data ecosystem: HDFS, MapReduce, YARN, plus an introduction to complementary bricks (Hive, Spark, HBase). You learn how to structure a processing job, leverage the Hadoop stack tools and understand the differences between traditional batch architecture and more modern architectures (Spark, cloud-native). This training remains relevant for profiles joining an existing big data platform or planning a progressive migration.
Build your database development path
A starting back-end developer follows SQL Database Training Introduction then SQL Fundamentals and Queries to acquire relational basics. An experienced SQL developer adds Introduction to NoSQL to structure architecture choices, then Cassandra Fundamentals or MongoDB depending on the target. A data engineer follows Apache Kafka Fundamentals to master event-driven architectures, complementing SQL. A solution architect combines SQL, NoSQL and Kafka to drive coherent hybrid architectures. A big-data oriented profile adds Introduction to Hadoop Development to understand stack history before tackling Spark or cloud-native services (Azure Databricks, AWS EMR, Google Dataproc).
Featured courses in this catalogue
Here is a selection of reference training courses in this catalogue, accessible directly:
Databases and related skills
Databases fit into a broader data ecosystem. The data analysis and databases sub-domain covers SQL Server, Azure SQL and infrastructure-side administration. Data analysis BI training brings mastery of Power BI to visualise data from your databases. Cloud computing training brings Azure (DP-203, DP-300) and AWS (Database Specialty, Data Analytics Specialty) certifications that naturally complement database skills. The programming languages sub-domain deepens Python, Java and Scala, essential to develop robust data pipelines. Containerisation and orchestration training brings Docker and Kubernetes, now standard to deploy modern databases and Kafka platforms.
Database and data trends in 2026
Several evolutions are shaping the domain in 2026. Cloud-native distributed databases (CockroachDB, Yugabyte, Aurora) are gaining ground for critical workloads. Streaming becomes central, with Apache Kafka widely adopted and complemented by managed solutions (Confluent Cloud, AWS MSK, Azure Event Hubs). Data lakehouses (Databricks, Snowflake, BigQuery) integrate batch and streaming approaches into a unified architecture. AI agents (GitHub Copilot, Claude Code) accelerate complex SQL query writing and modelling. Data security and GDPR compliance impose fine controls (encryption at rest, masking, auditing, classifications), particularly important for Swiss advertisers and organisations processing European data. Our pedagogical content regularly integrates these evolutions to remain aligned with current company practices.
Database training in Geneva, Lausanne and online
All our database design and development training courses are available on-site in our Geneva (Route des Jeunes 35) and Lausanne (Avenue de Mon-Repos 24) centres, as well as in interactive virtual classroom with a live trainer. Our sessions are organised in 5-week cycles, which makes registration fast and planning smooth for working developers and engineers. Each session includes hands-on labs on real databases. Customised corporate training is also possible at your premises, in Geneva, Lausanne, Vaud and across French-speaking Switzerland, with a programme adapted to your internal stack (PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, Cassandra, Kafka). Several professional funding paths can be considered depending on your profile and employer.
Why choose ITTA for your SQL or NoSQL training
ITTA is a certified training centre based in French-speaking Switzerland, official partner of Apache and MongoDB. Our database trainers are developers and data engineers active in production projects for Swiss and international companies, allowing them to share current concrete cases rather than purely theoretical materials. The catalogue regroups our training courses covering SQL, NoSQL, Cassandra, Kafka and Hadoop. Our pedagogical team supports you in choosing the right path and identifying the funding solutions that fit your professional situation.
FAQ
Is development experience required before the SQL Introduction training?
No. The SQL Database Training Introduction is accessible to profiles with no prior development experience. It lays the relational model concepts, the vocabulary and simple queries. Profiles already comfortable with the basics can directly chain with SQL Fundamentals and Queries to gain autonomy on complex queries.
What is the difference between SQL and NoSQL?
SQL designates relational databases structured by fixed schema (tables, columns, constraints), ideal for transactional data. NoSQL covers several families (documents, key-value, wide-column, graphs) characterised by great flexibility and good ability to handle large distributed volumes. Both approaches are complementary and often combined in the same modern architecture.
Does Apache Kafka require prior experience?
Back-end developer or integration engineer experience facilitates Apache Kafka onboarding. The Apache Kafka Fundamentals training is accessible to a technical audience with the basics of distributed architecture and integration. For complete beginners, starting with SQL Introduction then Introduction to NoSQL constitutes a good prelude.
Are your database courses available for companies?
Yes, the entire catalogue is available in-house, in Geneva, Lausanne and in virtual classroom, with a programme adapted to your internal stack. Our team builds the specifications with you and organises sessions according to your calendar.