Loading

Explore Diplomas & Certificates

Course Types

Diploma Courses

View all Diploma Courses

Certificate Courses

View all Certificate Courses

Course Categories

IT

Health

Language

Business

Management

Personal Development

Sales & Marketing

Engineering & Construction

Teaching & Academics

Discover Careers More

Claim Your Certificates

Get Certified now

Discover Careers

See Your Future

Workplace Personality Assessment

Discover Your Strengths & Weaknesses

Mental Health Assessment

Assess Your Mental Wellbeing

Resumé Builder

Create Your Professional Resumé

Alison Blog

News, Insights, Tips And Stories From Alison

Alison For Business

Upskill Your Employees

Get Alison Premium

Explore Course Categories
- Explore Course Categories
- IT
  813 Courses
- Health
  390 Courses
- Language
  198 Courses
- Business
  1180 Courses
- Management
  663 Courses
- Personal Development
  688 Courses
- Sales & Marketing
  240 Courses
- Engineering & Construction
  622 Courses
- Teaching & Academics
  875 Courses
Diploma Courses
Certificate Courses
Discover Careers
Get Alison Premium (Remove Ads)
Workplace Personality Assessment
Mental Health Assessment
Alison Blog
Alison For Business

Hello, Log In Sign Up

en

Change Language
English
Spanish
French
Italian
Brazilian Portuguese

Module 1: Installation

Module 1: Getting Started

Conditionals and Blocks - Learning Outcomes

Introducing SQL Core 2016

Using SSMS

Installing and Exploring the Sample Database

Conditional and Blocks - Lesson Summary

Getting Started - Assessment

Module 2: SSMS and Data Tools

SSMS and Data Tools - Learning Outcomes

Database Objects

SSMS Features and Help

SQL Server Data Tools

Working with Tables

Creating a View

SSMS and Data Tools- Lesson Summary

SSMS and Data Tools - Assessment

Module 3: Installation

Installation - Learning Outcomes

Preparing to Install

Upgrading

Installation

Customizing Installation

Performing Installation

Installation - Lesson Summary

Installation - Assessment

Module 4: Server Configuration

Server Configuration - Learning Outcomes

Install SSMS and SSDT

Configure the Server

Server Properties and Configurations

Server Configuration - Lesson Summary

Server Configuration - Assessment

Module 5: Using Management Studio

Using Management Studio - Learning Outcomes

SQL Server Management Studio

SSMS Options

Configure SSMS Windows

Object Explorer

Edit Objects in Designer

Using Management Studio - Lesson Summary

Using Management Studio - Assessment

Module 6: Writing and Executing Queries

Writing and Executing Queries - Learning Outcomes

Working with the Query Editor

Scripting with Management Studio

Debugging TSQL Code

Executing Queries

Writing and Executing Queries - Lesson Summary

Writing and Executing Queries - Assessment

Course assessment

Course assessment

Study Reminders

Support

Set your study reminders

We will email you at these times to remind you to study.

Monday

Reminder set

-

7am

+

Tuesday

Reminder set

-

7am

+

Wednesday

Reminder set

-

7am

+

Thursday

Reminder set

-

7am

+

Friday

Reminder set

-

7am

+

Saturday

Reminder set

-

7am

+

Sunday

Reminder set

-

7am

+

Log in to continue
Log in to save your progress and obtain a certificate in Alison’s free SQL Server Core 2016 online course
Sign Up

Log In
Continue with Facebook

Continue with Google

Continue with Microsoft

Continue with Linkedin

Continue with Yahoo
- Don't have an Alison account? Sign Up
or
Keep me logged in

Forgot password?
Back to Homepage
Sign up for free to continue learning
Sign up to save your progress and obtain a certificate in Alison’s free SQL Server Core 2016 online course
Sign Up

Log In
Continue with Facebook

Continue with Google

Continue with Microsoft

Continue with Linkedin
- Already have an Alison account? Log In
or
This is the name that will appear on your Certification

I agree to the Terms and Conditions

I agree to the Terms and Conditions
Back to Homepage
Forgot password?
Please enter you email address and we will mail you a link to reset your password.
- Back to login

About Alison

Our Story
Open Positions
Alison Programmes
Empower Us
Our Publishers
Blog
Hubs
Index

Learning

Get the App
COVID19 Emergency course
About Alison Courses
Alison Testimonials
East Africa Graduate Outcomes
Accreditation
Premium Learning
Refer a Friend
Pricing

More

Become a Self Publisher
Become a Course Creator
Training Webinars
Alison for Business
Graduate Outcomes
Free Personality Test
Free Wellbeing Check-up
Media Centre
Affiliate Programme

Connect

FAQ
Facebook
Twitter
LinkedIn
Instagram
TikTok
YouTube
Customer Support

© Alison 2022
Privacy
Terms
Cookie Policy
Sitemap