This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title.
- Price: $1,785.00
- Duration: 1 day
- Delivery Methods: Virtual
| Date | Time | Price | Option |
|---|---|---|---|
| Please contact us at info@toptalentlearning.com or 469-721-6100 for this course schedule. |
For questions call: (469) 721-6100
Why choose
TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
1 – Introduction to databases
- Introduction to Relational Databases
- Other Databases and Storage
- Data Analysis
- SQL Server Database Languages
2 – Data Modeling
- Data Modeling
- Designing a Database
- Relationship Modeling
3 – Normalization
- Fundamentals of Normalization
- Normal Form
- Denormalization
4 – Relationships
- Introduction to Relationships
- Planning Referential Integrity
5 – Performance
- Indexing
- Query Performance
- Concurrency
6 – Database Objects
- Tables
- Views
- Stored Procedures, Triggers and Functions
- Describe key database concepts in the context of SQL Server
- Describe database languages used in SQL Server
- Describe data modeling techniques
- Describe normalization and denormalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.
No special prerequisites for this course provided. If you are unsure whether you might need to take another course first, please contact us to discuss.
