Basic Relational Database Essentials

Work with relational databases in SQL Server Management Studio.

course image

Course details

ceus icon CEUs 0.3

schedule icon Schedule Days

location icon Location Main Campus

cost icon Cost

Registration details

Basic Relational Database Essentials

Work with relational databases in SQL Server Management Studio.

What you’ll be able to do — competencies

  • Create a database diagram using the Object Explorer window in SQL Server Management Studio (SSMS)
  • Describe terms that apply to relational databases, including tables, components of a table and relationships between tables
  • Create and run a simple structured query language (SQL) command to retrieve data from a table
  • Create and run a simple SQL command to create a table

Course description

expand drawer icon collaspe drawer icon

Learn the basics of working with relational databases within the SQL Server Management Studio (SSMS) environment. In this course, students will use the tools in SSMS to diagram an existing database and to create and run some very simple SELECT and CREATE TABLE structured query language commands. Students will learn the basic terminology that applies to all relational databases. Students will get hands-on practices performing these tasks.

Prerequisites

expand drawer icon collaspe drawer icon
  • Windows
  • Basic computer proficiency

Syllabus

expand drawer icon collaspe drawer icon

Create a database diagram using the Object Explorer window in SQL Server Management Studio (SSMS).

  • Connect to SQL Server and open SSMS
  • Open Object Explorer window to view databases
  • Create a database diagram

Describe terms that apply to relational databases, including tables, components of a table and relationships between tables.

  • View tables in a relational database and apply terminology to the parts of a table, including the primary key, rows, fields and data types of fields
  • Describe the referential integrity constraint as it applies to a one-to-many relationship between a pair of tables

Create and run a simple structured query language (SQL) command to retrieve data from a table.

  • Open a new Query Editor window in SSMS
  • Set the database context to the Query Editor window
  • Create and run a simple SELECT command to retrieve data from a table
  • Describe how to execute SQL commands in the Query Editor window and see the results in the Results pane

Create and run a simple SQL command to create a table.

  • Create a simple CREATE TABLE command to create a new table in an existing database
  • View the table and its fields in the Object Explorer window in SSMS

Next available start dates

Main Campus — Days

Registration open expand drawer icon collaspe drawer icon
Basic Relational Database Essentials
hours icon

Total classroom hours

3 hours

schedule icon

Schedule

Main Campus

Days, 9:00 AM - 12:00 PM, 1 W - 4/5/2023

Class Location:
3000 Landerholm Cir. SE Bellevue, WA 98007
Building A, Room 134
Campus Map
 

Quarter: Spring

cost icon

Total cost

$129

instructor icon

Instructor: Murray Law

Murray Law is a software engineer and network administrator. He spent 10 years at Microsoft working on the Windows Networking team and the Real Time Communications group, helping to develop networking protocols and messaging features for Office Communications Server and Lync. He is a Microsoft Certified instructor and has taught C# programming, SQL and applications such as Windows Active Directory and Cloud integration services.

Interested in custom learning solutions for your team?

Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.

Get started