Introduction to SQL Databases (M10985)
Introduction to SQL Databases (M10985) Course Details:
This 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. Note:
- Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session
- Redeem three SATVs for an individual GITT Digital Learning course plus digital Microsoft Official Courseware (dMOC)
- Redeem two SATVs for an individual GITT Digital Learning course
Call (919) 283-1674 to get a class scheduled online or in your area!
1. Introduction to Databases
- Relational databases
- Other types of databases
- Data analysis
- Database languages in SQL Server
2. Data Modeling
- Data modeling
- ANSI/SPARC database model
- Entity relationship modeling
3. Normalization
- Fundamentals of Normalization
- Normal from
- 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
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- Key database concepts in the context of SQL Server 2016
- Database languages used in SQL Server 2016
- Data modeling techniques
- Normalization and denormalization techniques
- Relationship types and effects in database design
- Effects of database design on performance
- Commonly used database objects
Lab 1: Exploring and querying SQL Server databases
Lab 2: Identify components in entity relationship modeling
Lab 3: Normalizing data
Lab 4: Planning and implementing referential integrity
Lab 5: Performance issues
Lab 6: Using SQL Server
This is a foundation-level course and therefore only requires general computer literacy.
- The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.