SQL

The Structured Query Language, or SQL (for its acronym in English structured query language) is a declarative language for accessing relational databases for specifying various types of operations on these. One of its features is the management of relational algebra and calculus allowing consultations in order to recover, in a simple-interest information from a database, as well as make changes to it.

Job Profile

SQL Developer

Recipients

All those who want to learn programming in SQL-intensive and personalized.

Contents

CUSTOM COURSE SQL Programming

Unit 1: Introduction
What is SQL?
Language Features
Components
Types of Commands

Unit 2: Basic queries
SELECT syntax
FROM Clause
Clauses Top / All / Distinct
ORDER BY Clause
WHERE Clause
Selection Conditions
Logical Operators.

Unit 3: Grouping records
GROUP BY Clause
HAVING Clause
Functions SUM / COUNT / AVG / MAX / MIN

Unit 4: multitable queries
UNION Operator
INNER JOIN Operator
Operator JOIN LEFT / RIGHT JOIN

Unit 5: Data update queries
Insert Rows - INSERT
Upgrade data -UPDATE
Delete Rows - DELETE

Unit 6: Subqueries
Unit 7: Data Definition Language /strong>
Data Types
CREATE TABLE
ALTER TABLE
DROP TABLE statement
Indices

Unit 8: Views and Stored Procedures
Unit 9: Data tranformation Services
What is a DTS?
Designing a DTS.
Connections, Tasks and Workflows.
Transformations.
Global Variables.
Agenda of DTS.

Cursada Regime
To be confirmed
Duration
Two months
State
Registration Open