Microsoft SQL Server Development for Everyone
With the help of a school management database system, learn how to work with SQL Server to manipulate data and databases
MySQL,Microsoft,SQL Server,Development
Lectures -31
Duration -6 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This video will help you learn about Microsoft SQL Server 2017, including the features and functionalities that are needed to design and develop reliable database systems.
The course starts with an introduction to SQL Server and databases and takes you through the installation of SQL Server Express 2017. Once you are ready with the set-up, you will learn to connect to a database instance and create a database and tables inside the database. As you advance, you will learn to run queries against tables to manipulate tables and data and create relationships in the SQL Server with foreign keys and normalization. Later, you will be able to perform mathematical operations using aggregate functions, such as AVG, COUNT, MAX, and SUM. Finally, you will get to grips with advanced SQL Server objects and concepts, such as views, triggers, stored procedures, database scripting, and more.
By the end of this course, you will be well-versed with SQL Server 2017 and have developed the skills to write SQL queries for manipulating databases.
All the resources and supportive files are available at https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone
Audience:
This course is for beginner and intermediate-level database developers and administrators who are looking to create, manipulate, and connect databases using Microsoft SQL Server 2017. There are no pre-requisites for this course as it provides you with fundamental SQL Server training.
Goals
- Become familiar with SQL Server
- Create, manipulate, and connect databases
- Export data to Excel using SQL Server Management Studio
- Create and manage database views
- Explore custom functions, table views, and stored procedures
- Find techniques to backup and restore databases
![Microsoft SQL Server Development for Everyone Microsoft SQL Server Development for Everyone](https://d3mxt5v3yxgcsr.cloudfront.net/courses/10189/course_10189_image.jpg)
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
![Tutorialspoint](/market/public/assets/images/loader.gif)
Relationships and Foreign Keys
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
GROUP BY and Aggregate Functions
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Advanced SQL Server Objects and Concepts
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Packt Publishing](https://www.tutorialspoint.com/assets/profiles/154467/profile/200_283401-1581924256.png)
Packt Publishing
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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 now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)