Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Startup Business Plan Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development SQL Server

MICROSOFT SQL SERVER: A Beginner to Advanced Guide

Become a Database Master of RDBMSs'
Rating: 3.9 out of 53.9 (28 ratings)
116 students
Created by Launch Programmers
Last updated 5/2017
English
English [Auto]
30-Day Money-Back Guarantee

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

  • Preview01:15
  • 1.2 Creating, Altering and Dropping a Database
    08:08
  • Preview05:09
  • Preview11:25
  • 1.5 Cascading Referential integrity constraints
    06:21
  • 1.6 Check Constraints in SQL
    08:57
  • 1.7 Unique key constraints
    04:59

  • 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

  • 3.1 Stored Procedures in SQL
    09:21
  • 3.2 Output parameters
    06:51
  • 3.3 Output parameters vs return values
    08:48

  • 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

  • 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

Instructor

Launch Programmers
Keep Programming Simple
Launch Programmers
  • 3.5 Instructor Rating
  • 190 Reviews
  • 883 Students
  • 5 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.