SQL Server 2014: Management Studio

A free online course on the basics of SQL Server Management Studio using Object Explorer and other useful tools.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

Identify the tools contained in Management Studio
Recall and set up the SQL Server environment
Explain Object Explorer and use it to administer SQL Server security and agent replication
Identify and work with the query tools in Management Studio
Discuss how to create data manipulation language scripts and data definition language scripts in SQL Server
Distinguish between the candidate key, the primary key and the foreign key
Describe the one-to-one, many-to-many and one-to-many relationships in a database
Explain briefly the relational model
Identify the types of constraints and columns in SQL Server
Identify the different data types

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.