Introduction to SQL

À qui s'adresse la formation?

The SQL course caters to individuals at a beginner level or possessing a foundational understanding, making it suitable for adults seeking to transition into the IT field, as well as students and high school teenagers.

Niveau atteint

Débutant

Durée

3,00 jour(s)

Langues(s) de prestation

EN FR RO

Prochaine session

Contacter l'organisme

Prérequis

No prerequisites are necessary for enrollment.

Objectifs

The key topics covered include:

Querying Data: Emphasizing the essential skill of extracting and comprehending data in a relational format through SQL queries, covering clauses such as select, from, where, order by, group by, and having.
Data Manipulation: Exploring the insertion, modification, and deletion of data within relational databases, involving SQL instructions such as insert, update, and delete.
Database Structure and Constraints: Instructing students on creating and modifying table structures, including constraints such as primary key, unique, check, and foreign key for ensuring data integrity and consistency.
Advanced Topics: Extending the course to encompass additional database objects like views, sequences, and synonyms, alongside an introduction to programming extensions of SQL such as PL SQL for Oracle and Transact SQL for SQL Server.
Importance of Database Knowledge: Highlighting the necessity for understanding both SQL and its extensions, particularly for individuals involved in database programming roles, while acknowledging that proficiency in SQL alone may suffice for certain roles such as analysts or testers.

Contenu

This three-day instructor-led course caters to individuals aspiring to assume a database professional role or broaden their current job scope to include database-related functions. The course delves into fundamental database concepts, covering database types, languages, and designs.