Introduction to SQL
Course number: CGISQL40
This course is geared toward anyone who is interested in transitioning 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.
What You’ll Learn
- Key database concepts in the context of SQL Server
- Database languages used in SQL Server
- Data modeling techniques
- Normalization and denormalization techniques
- Relationship types and effects in database design
- Effects of database design on performance
- Commonly used database objects
Prerequisites
- This is a foundation-level course and therefore only requires general computer literacy.
Target Audience
The primary audience for this course is anyone who is moving into a database role, or whose role has expanded to include database technologies. Developers who deliver content from SQL Server databases will also benefit from this material.
Course Content
This module introduces key database concepts in the context of SQL Server.
Lessons:
- Introduction to Relational Databases
- Other Databases and Storage
- Data Analysis
- SQL Server Database Languages
This module describes data modeling techniques.
Lessons:
- Data Modeling
- Designing a Database
- Relationship Modeling
- Database languages in SQL Server
This module describes normalization and denormalization techniques.
Lessons:
- Fundamentals of Normalization
- Normal from
- Denormalization
This module describes relationship types and effects in database design.
Lessons:
- Introduction to relationships
- Planning referential integrity
This module introduces the effects of database design on performance.
Lessons:
- Indexing
- Query performance
- Concurrency
This module introduces commonly used database objects.
Lessons:
- Tables
- Views
- Stored procedures, triggers and functions
Live Online