Description
The student will learn to work in an SQL environment (more specifically MySQL) and acquire knowledge on some topics at the certification level. This subject also provides more practical knowledge to solve problems in a work environment.
Type Subject
Primer - Obligatoria
Semester
First
Course
1
Credits
5.00
Titular Professors
Professor
Previous Knowledge
Objectives
Contents
MySQL client / server architecture
Commands and options for running the MySQL client. Differences between Windows and Unix systems
Charsets and collations.
Type of data
System Variables and User Variables
Queries: intermediate level
Prepared Statements
Triggers
Joins
Queries: advanced level. Subqueries
Views
Routines: functions & procedures
Non-SQL Databases
Methodology
Evaluation
Evaluation Criteria
The learning outcomes of this subject are the following:
[RA2] The student learns the current languages that allow the persistence of data and the recovery of it.
Basic Bibliography
Additional Material