Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Microsoft SQL Server Development Course

person icon Trevoir Williams

4

Microsoft SQL Server Development Course

Microsoft SQL Server Development for Everyone: Learn the Fundamentals

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Trevoir Williams

English [CC]

category icon Development,SQL Server

Lectures -32

Duration -6 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Microsoft SQL Server Development for Everyone is a step-by-step guide on Microsoft SQL Databases and Querying that will teach you the fundamentals of database design, development, and querying. You'll learn how to install SQL Server Express 2017, create databases and tables, run queries, and manage data. 

Course Overview

This course will help you understand and learn the best practices in database development, creating relationships and foreign keys, using aggregate functions, and exporting data to Excel. Whether you're a beginner with no prior experience or you're looking to refresh your skills, this course will teach you everything you need to know to get started. 

Microsoft SQL Server is a powerful database management system that is used by organizations of all sizes to store and manage data. It is a relational database, which means that it stores data in tables that are related to each other. SQL Server is a popular choice for database development because it is scalable, reliable, and secure. This course covers the following topics:

  • Introduction to Microsoft SQL Server
  • Database design
  • Querying data
  • Managing data
  • Database Administration

Goals

  • Design and create databases.
  • Write queries to retrieve and manipulate data.
  • Create relationships and foreign keys.
  • Use aggregate functions to perform mathematical operations on data.
  • Export data to Excel.
  • Follow best practices in database development.
  • Install SQL Server Express 2017.
  • Create and manage databases and tables.
  • Run queries against tables.

Prerequisites

  • A computer
  • A desire to learn database development.
Microsoft SQL Server Development Course

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
2 Lectures
  • play icon Introduction to SQL Server and Databases 04:08 04:08
  • play icon Download and Install SQL Server Express 2017 05:21 05:21
Manipulating Tables and Data
12 Lectures
Tutorialspoint
Relationships and Foreign Keys
5 Lectures
Tutorialspoint
Group By and Aggregate Functions
5 Lectures
Tutorialspoint
Advanced SQL Server Objects and Concepts
7 Lectures
Tutorialspoint

Instructor Details

Trevoir Williams

Trevoir Williams


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515