MICROSOFT SQL SERVER: A Beginner to Advanced Guide
4.6 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MICROSOFT SQL SERVER: A Beginner to Advanced Guide to your Wishlist.

Add to Wishlist

MICROSOFT SQL SERVER: A Beginner to Advanced Guide

Become a Database Master of RDBMSs'
4.6 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Last updated 5/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Students who wish to have a practical hands-on over RDBMS
  • Anyone beginning their career in the database domain
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
About the Instructor
Launch Programmers
3.6 Average rating
45 Reviews
198 Students
5 Courses
Keep Programming Simple

Launch Programmers is an intuitive e-learning platform that is changing proficient online training. We offer online courses supported by online assets, alongside 24x7 on-request support. We give to experts the adaptability to learn at their own time and place, even from their mobile devices. Launch Programmers courses are uncommonly curated by specialists who screen the IT business with a hawk's eye, and react to desires, changes and prerequisites from the business, and consolidate them into our courses.