fbpx

Course Statues

Registration Open

Duration

3 Days, 24 Hours

Timing

9:00 AM - 04:00 PM

Availability

Weekdays - Weekends

Course Overview

SQL Databases introduction course is intended for people looking to move into a database professional role or whose job role is expanding to encompass database elements. You’ll learn the basic structure of relational databases, read and write SQL statements and advanced data manipulation techniques.  The course describes fundamental database concepts including, database types, database languages, and database designs.

Learning Outcome

Upon successful completion of SQL databases course, students will be able to:

  • Describe key database concepts in the context of SQL Server.
  • Understand and describe database languages used in SQL Server.
  • Various data modeling techniques.
  • Normalization and Denormalization techniques.
  • Describe relationship types and effects in database design.
  • Effects of database design on performance.
  • Describe commonly used database objects.
Prerequisite
  • Must have general computer literacy and interest in programming
Course Content
  • Course Content
  • Introduction to Databases
  • Data Modeling
  • Normalization
  • Relationships
  • Performance
  • Database Objects
  • SQL Labs
  • Exploring and Querying SQL Server Databases
  • Identify Components in Entity-Relationship Modeling
  • Normalizing Data
  • Planning and Implementing Referential Integrity
  • Performance Issues
  • Using SQL Server

Book your course today

Loading...

Enquire Now

Courses you maybe interested