Objectives:
The objective of the course is training in ERD design and building a solid and secure database. Working with real projects where each session is based on practice. Acquisition of the latest techniques of database communication with the web or application. Apply images to unravel problems and increase security
Audience:
All interested individuals interested in mastering the management of the database.Students who find difficulties in the University subject, employees and persons who have prospects to work in this profile.
TRAINING TOPICS:
1.RDBMS concept and introduction to SQL
2. Syntax and data types
3. Operators and conditions
4. Create databases, tables and delete them
5. Updates to tables, columns and rows
6. Selection and basing the results on conditions
7. Keywords LIKE, TOP, Order By, Group By, Distinct, Step
8. NULL values, Synonyms and various functions
9. Mergers and sub-questions. Join and Subqueries
10. Indexes, Views, Temporary Tables, Triggers
TEST
WORKSHOP – PRESENTATION OF THE COURSE PROJECT
Course Features
- Lectures 0
- Quizzes 0
- Duration 10 hours
- Skill level All levels
- Language English
- Students 4
- Certificate Yes
- Assessments Yes