Microsoft SQL Server Development Course
Microsoft SQL Server Development for Everyone: Learn the Fundamentals
Lectures -32
Duration -6 hours
30-days Money-Back Guarantee
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.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
2 Lectures
- Introduction to SQL Server and Databases 04:08 04:08
- Download and Install SQL Server Express 2017 05:21 05:21
Manipulating Tables and Data
12 Lectures
Relationships and Foreign Keys
5 Lectures
Group By and Aggregate Functions
5 Lectures
Advanced SQL Server Objects and Concepts
7 Lectures
Instructor Details
Trevoir Williams
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now