TRAINING FOR COMPANIES
Informed SQL and database training
We teach your team how to model data, write efficient SQL queries, and apply best practices with SQL Server and other databases.
What is Databases and SQL?
Data is the heart of any application and knowing how to work it well makes all the difference. In this program, we train your team in relational databases and SQL, from fundamentals to advanced queries and best design practices.
We teach you how to model data correctly, write clear and efficient SQL queries, understand indexes and performance, and avoid the most common mistakes. We work with SQL Server (our main database) and the concepts apply to other relational databases.
The training is practical: it is consulted, modeled and optimized on real data. Ideal for developers, data and business profiles that need to exploit information. In-company, online or mixed and subsidized by FUNDAE.
FEATURES
Features of Databases and SQL
Data Modeling
Tables, relationships, keys and correct normalization.
SQL queries
SELECT, JOIN, filters, aggregations, and subqueries.
Advanced Queries
CTEs, window functions, and complex queries.
Indices and performance
Optimization of queries and understanding of the execution plan.
Integrity and transactions
Data constraints, transactions, and consistency.
Best practices
Security, maintenance and frequent mistakes to avoid.
TECHNOLOGIES
- SQL
- Node.js
- .NET
FREQUENTLY ASKED QUESTIONS