Course Outline
Module 1: Introduction to databasesThis module introduces key database concepts in the context of SQL Server 2016.Lessons
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
Module 2: Data ModellingThis module describes data modelling techniques.Lessons
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Module 3: NormalizationThis module describes normalization and denormalization techniques.Lessons
- Fundamentals of Normalization
- Normal form
- Denormalization
Module 4: RelationshipsThis module describes relationship types and effects in database design.Lessons
- Introduction to relationships
- Planning referential integrity
Module 5: PerformanceThis module introduces the effects of database design on performance.Lessons
- Indexing
- Query performance
- Concurrency
Module 6: Database ObjectsThis module introduces commonly used database objects.Lessons
- Tables
- Views
- Stored procedures, triggers and functions
Testimonials (5)
database optimization, dedicated approach, ability to ask questions, insight/assessment of our database
Aleksandra Czyndacka - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).