The main objective of this program is to provide students with a good understanding of the Transact-SQL language used in all SQL Server related disciplines, namely database administration, database development and business intelligence.
Aimed at
- Database administrators
- Database developers
- BI professionals.
Duration
35 hours
Modalities
- On-site
- Virtual live through digital platforms
- On site
Includes
- 35 hours of training
- Trained instructors
- Participant's manual in digital format
- Proof of participation
Agenda
- The basic architecture of SQL Server
- SQL Server Editions and Versions
- Introduction to SQL Server Management Studio
- Working with SQL Server Management Studio
- Creation and organization of T-SQL scripts
- Using online books
- T-SQL Presentation
- Understanding sets
- Understanding predicate logic
- Understanding the logical order of operations in SELECT statements
- Execution of basic SELECT statements
- Execution of queries that filter data using predicates
- Executing queries that sort data using ORDER BY
- Writing simple SELECT statements
- Eliminating duplicates with DISTINCT
- Use column and table aliases
- Writing simple CASE expressions
- Writing simple SELECT statements
- Elimination of duplicates with DISTINCT
- Use column and table aliases
- Using a simple CASE expression
- Understanding unions
- Consult with internal combinations
- Consult with external combinations
- Consultation with Cross Joins and Self Joins
- Writing queries using Inner Joins
- Write queries that use internal combinations of multiple tables
- Writing queries using self-joins
- Write queries using external combinations
- Writing queries using cross combinations
- Data classification
- Filter data with predicates
- Data filtering with TOP and OFFSET-FETCH
- Working with unknown values
- Writing queries that filter data using a WHERE clause
- Writing queries that order data using an ORDER BY clause
- Writing queries that filter data with the TOP option
- Writing queries that filter data using the OFFSET-FETCH clause
- Introduction to SQL Server data types
- Working with character data
- Working with date and time data
- Writing queries that return date and time data
- Writing queries using date and time functions
- Writing queries that return character data
- Writing queries that return character functions
- Adding data to tables
- Modify and delete data
- Generating automatic column values
- Insert records with DML
- Updating and deleting records using DML
- Writing queries with built-in functions
- Using conversion functions
- Using logical functions
- Use of functions to work with NULL
- Writing queries using conversion functions
- Writing queries using logical functions
- Write queries proving null and voidability
- Using aggregate functions
- Use of the GROUP BY clause
- Filter groups with HAVING
- Writing queries using the GROUP BY clause
- Writing queries using aggregate functions
- Write queries that use different aggregate functions
- Writing queries that filter groups with the HAVING clause
- Write independent subqueries
- Write correlated subqueries
- Using the EXISTS predicate with subqueries
- Writing queries that use independent subqueries
- Writing queries using scalar and multiple result subqueries
- Writing queries using correlated subqueries and an EXISTS clause
- Using views
- Use of functions with inline table values
- Using derived tables
- Using common table expressions
- Writing queries using views
- Writing queries using derived tables
- Writing queries using common table expressions (CTE)
- Writing queries using expressions with inline table values (TVF)
- Writing queries with the UNION operator
- Using EXCEPT and INTERSECT
- Using APLICAR
- Writing queries using set operators UNION and UNION ALL
- Writing queries using CROSS APPLY and OUTER APPLY operators
- Writing queries using the EXCEPT and INTERSECT operators
- Creating Windows with OVER
- Exploring window functions
- Writing queries using sorting functions
- Writing queries using compensation functions
- Writing queries using window aggregation functions
- Writing queries with PIVOT and UNPIVOT
- Working with grouping sets
- Writing queries using the PIVOT operator
- Writing queries using the UNPIVOT operator
- Writing queries using the GROUPING SETS subclauses CUBE and ROLLUP
- Querying data with stored procedures
- Pass parameters to stored procedures
- Creation of simple stored procedures
- Working with dynamic SQL
- Using the EXECUTE statement to invoke stored procedures
- Pass parameters to stored procedures
- Execution of stored procedures in the system
