Introduction to SQL Databases

Course Statuse

Registration Open

Duration

3 Days, 24 Hours

Timing

9:00 AM - 04:00 PM

Availability

Weekdays - Weekends

Course Id:

10985

Exam #:

70-764

Seat Reservation:

Before 14 Days

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, […]

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
Bokking-form

Courses Details



Personal Details

(905) 212-9039

Enquire Now

Courses Form

Courses you maybe interested

Programming with PHP and MYSQL

Programming with PHP and MYSQL course offers advanced knowledge in open source technologies MySQL and PHP to develop console and web applications. Gain hands-on training to use Connectors to access MySQL databases, query the database effectively, present data in...

CCNA Scaling Networks

CCNA Scaling Networks certification training advances your networking career and prepares you for networking analyst and engineering jobs. The course focuses on hands-on training to configure and troubleshoot routers and switches and resolve common issues with OSPF,...