MICROSOFT SQL SERVER: A Beginner to Advanced Guide
3.6 (26 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
113 students enrolled

MICROSOFT SQL SERVER: A Beginner to Advanced Guide

Become a Database Master of RDBMSs'
3.6 (26 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
113 students enrolled
Last updated 5/2017
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 27 lectures 03:30:35
+ Module 1-Introduction to SQL and DDL
7 lectures 46:14
1.2 Creating, Altering and Dropping a Database
08:08
1.5 Cascading Referential integrity constraints
06:21
1.6 Check Constraints in SQL
08:57
1.7 Unique key constraints
04:59
+ Module 2-Clauses, Operators and joins
7 lectures 48:09
2.1 Using the select clause
07:42
2.2 Clauses, Operators and Conditions
08:22
2.3 Aggregate Functions with group by
09:38
2.4 Where and Having clauses in sql
06:00
2.5 Joins in SQL
06:17
2.6 Outer Joins
07:15
2.7 Full and Cross Joins in SQL
02:55
+ Module 3- Stored Procedures in SQL
3 lectures 25:00
3.1 Stored Procedures in SQL
09:21
3.2 Output parameters
06:51
3.3 Output parameters vs return values
08:48
+ Module 4- Indexes and Views
5 lectures 50:28
4.1 Indexes
05:29
4.2 Clustered and non-clustered indexes
13:12
4.3 Unique indexes
08:22
4.4 Views in SQL
12:01
4.5 Updating views and base tables
11:24
+ Module 5- Triggers and DCL
5 lectures 40:44
5.1 Triggers in SQL
07:50
5.2 Instead of triggers
13:23
5.3 Subqueries ion SQL
08:25
5.4 DCL commands in SQL
06:17
5.5 Database backup for SQL server
04:49
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