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+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-03-25 02:57:24
30-Day Money-Back Guarantee
IT & Software IT Certification SQL Server

Mastering SQL Server | Passage to become Database Developer

Microsoft SQL database course for Beginners
Rating: 4.0 out of 54.0 (274 ratings)
47,337 students
Created by Yasir Mehmood
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Introduction to Database Management System (DBMS)
  • Microsoft SQL Server development and administration
  • Installation Guide of Microsoft SQL Server
  • How to Create database
  • How to create and modify tables
  • Primary Key
  • Foreign Key
  • Composite Key
  • How to drop a Table
  • Insert data into table
  • Select data from a table
  • Update/modify existing data of a table
  • Delete data from a table
  • Substring function
  • Group By Clause
  • Average function
  • Inner join
  • Left join
  • Right join
  • Full join
  • Distinct function
  • Database Views
  • Stored procedures
  • How to execute the stored procedure
  • SQL jobs
  • How to use Like Operator
  • Taking Database Backup
  • Restoring the database backup

Requirements

  • Student must be aware of basic database concepts.
  • must have a computer where Microsoft SQL Server could be installed

Description

This Course is designed for those students who want to get detailed knowledge of Microsoft SQL Server in short time,  These skills are also applicable to any other major SQL database, such as MySQL, Oracle etc.

SQL is one of the most in demand tech skills due to which Technology firms are in dire need for SQL experts . Learning SQL is one of the fastest ways to improve your career prospects  and to get SQL developer job.

This SQL weekender course  requires only 1 week to learn SQL Server online and  Mastering SQL Server course is the right place for you to learn SQL on fast pace to become SQL Developer in very short time.

you will get insights that how to Create the Sequel database as well as how to Drop an existing database.

We will also go through that how to Take the Backup of SQL Server database and how to restore the backup on a new location.

You will find lot of sql database online courses as well as online computer courses but here you will learn lot database concepts in very easy way.

We will also take you through that how to download SQL Server database and how to perform a fresh installation

We are hopeful that you will find this SQL Tutorial very beneficial for your future, 

Students will learn in this course:

  1. Installation of Microsoft SQL Server

  2. Installation of Microsoft SQL Server Management Studio

  3. How to create a database

  4. How to Drop a database

  5. Database Backup

  6. Restoration of database

  7. Data Definition operations like Create ,Alter and drop the Tables

  8. Creation of Primary Key, Foreign Key, Composite Key

  9. Data Manipulation options like Insert , Update , Delete the records

  10. SQL Joins ( Inner Join, Left Outer Join, Full Join, Right Join)

  11. Database Views

  12. Stored Procedures

  13. Database Functions ( User defined functions ,aggregate functions , SQL Provided functions like substring etc)

  14. Distinct

  15. Group By

  16. Little on SQL Server administration and SQL Jobs

  17. and many more things......

Upgrade your skill set quickly and add SQL in your resume by joining today! you will find lot of sql server tutorials on internet  however this course is the Best online sql server tutorial. 

Who this course is for:

  • Students who want to have solid grip over Microsoft SQL Server
  • Who wants to get database knowledge

Course content

9 sections • 33 lectures • 1h 47m total length

  • Preview02:59

  • Preview11:19
  • Installation of Microsoft SQL Server Management Studio
    01:27

  • Preview04:35
  • Preview06:38
  • Alter Tables
    07:00
  • Primary Key (part 1)
    01:18
  • Preview03:28
  • Composite Key (Part 1)
    00:43
  • Composite Key (Part 2)
    03:16
  • Foreign Key (Part 1)
    01:16
  • Create Foreign Key Relationship between Tables
    08:25
  • Drop Foreign Key
    01:18

  • Preview01:52
  • Select Command
    01:55
  • Update
    03:05
  • Delete
    02:26

  • Substring function
    02:30
  • Distinct
    01:53
  • Like Operator
    02:42

  • Preview05:21
  • Left Outer Join
    02:48
  • Right Outer Join
    01:12
  • Full Join
    01:43

  • SQL Views
    02:47
  • SQL Functions
    06:26
  • Group By
    02:20

  • Stored Procedure (without parameters)
    02:26
  • Stored Procedure (with parameters)
    03:19
  • SQL Server Jobs
    04:08

  • Backup of SQL database
    02:33
  • Restoring the database backup
    01:44
  • Thank You
    00:34

Instructor

Yasir Mehmood
Information Technology specialist and Database Architect
Yasir Mehmood
  • 4.0 Instructor Rating
  • 1,504 Reviews
  • 144,307 Students
  • 3 Courses

Yasir Mehmood is part of Information Technology industry since 2004 as IT Specialist and Database Architect. During his carrier he  worked on many state of the art software projects where he got the chance to design the huge database models for software projects

Beside the back end database programming he has a vast experience of front end technologies which includes the front end designing ,development and software architecture designing.

  • 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.