Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MICROSOFT SQL SERVER: A Beginner to Advanced Guide
Rating: 3.5 out of 5(34 ratings)
129 students

MICROSOFT SQL SERVER: A Beginner to Advanced Guide

Become a Database Master of RDBMSs'
Created byLaunch Programmers
Last updated 5/2017
English

What you'll learn

  • Build their database Schema
  • Add Tables to databases
  • Perform manipulations using DML queries
  • Understand and create views and stored procedures
  • Invoke triggers and indexes over queries and tables
  • Apply key constraints as required
  • Generate Sub-queries and Grant priviledges and User Roles

Course content

5 sections • 27 lectures • 3h 30m total length

  • 1.1 Introduction to SQL Server1:15
  • 1.2 Creating, Altering and Dropping a Database8:08
  • 1.3 Creating Tables5:09
  • 1.4 Foreign to primary key referencing11:25
  • 1.5 Cascading Referential integrity constraints6:21
  • 1.6 Check Constraints in SQL8:57
  • 1.7 Unique key constraints4:59

Requirements

  • Basic understanding of RDBMS
  • Basics of Databases

Description

Microsoft SQL Server is the most user friendly of all RDBMS' the extremely popular, greatly used, well known and generally utilized database framework available today. Launch Programmers’ Querying Microsoft SQL Server course acquaints you with building and utilizing databases in this platform.

The course gives understudies the technical skills required to compose basic Transact-SQL queries for Microsoft SQL Server. This course is the establishment for all SQL Server-related controls, including Database Administration and Database Development.

After the successful completion of this course, you will be able to build your own databases and add tables, Views and other SQL objects along with incorporating various user roles and privileges for the same.

Who this course is for:

  • Students who wish to have a practical hands-on over RDBMS
  • Anyone beginning their career in the database domain

Report abuse