1
Relational algebra and the SQL standard.
- The concepts of the relational model.
- History of RDBMSs and the SQL language.
- Entities, associations, and ER diagrams.
- Types of data and value expressions.
Role-playing
Learn about and register for the AVIT® certification option. Getting started with the software SQL Server Management Studio. Discovering the studied database.
2
Database theory
- Elements of the DBMS.
- Tables, keys, and normal forms.
- Entities, associations, and ER diagrams.
- Column and table restrictions.
Hands-on work
Identifying the objects of a database. Determining the normal form type of a relationship and a transformer, creating an ER diagram.
3
Single-table data querying
- Structure of a SELECT query.
- WHERE filters, predicates, and ternary logic (NULL).
- SQL operators and expressions.
- Predefined functions.
Hands-on work
Extraction using the WHERE clause. Using IN, LIKE, CASE, etc. operators of numerical operators, data, string functions Data sorting
4
Multi-table querying
- Combining results with set clauses (UNION, INTERSECT, EXCEPT).
- Overview of joins.
- Embedding queries.
- Using CTEs and discovering recursive queries.
- Correlated subqueries and the EXISTS operator.
Hands-on work
Using set clauses, creating queries with joins.
5
Data analysis
- Aggregation functions (AVG, SUM, COUNT, etc.).
- Creating subsets (GROUP BY clause).
- Filtering aggregates with the HAVING clause.
- Discovering data analysis functions (LEAD, LAG...) and ranks (RANK, ROW_NUMBER, NTILE...).
Hands-on work
Analyzing data by writing queries that use calculations with grouping.
6
Updating data
- INSERT, UPDATE, DELETE, TRUNCATE orders.
- Simple updates.
- Updating with subqueries.
- Updating data through views.
Hands-on work
Database table insertion and update operations.
7
Introduction to procedural SQL
- SQL dialects of major publishers.
- Basic notions of triggers.
- Introduction to stored procedures.
- UDFs or “user” functions.
Hands-on work
Hands-on work
3d
- 21h00 
Download in PDF format
Share this course by email