Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React CSS Angular Node.Js PHP HTML5 Typescript
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy Coaching CBT Cognitive Behavioral Therapy
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Freelancing Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Google Analytics Internet Marketing Copywriting Email Marketing Startup YouTube Marketing

DevelopmentDatabase Design & DevelopmentMicrosoft SQL

Microsoft SQL Server 2017 Database Training For Beginners

Learn Microsoft SQL server step by step.An absolute beginners online course to learn SQL Server Database from scratch.
Rating: 4.2 out of 54.2 (376 ratings)
1,503 students
Created by Valiveti Sekhar
Last updated 1/2020
English
English

What you'll learn

  • Start from scratch by installing Microsoft SQL Server 2017 and create a practice environment for yourself.
  • You will be familiarized with some of the core concepts of RDBMS / SQL Server.
  • You will learn the ins and outs of SQL Server Management studio.
  • You will learn how to create and connect SQL server colud database using Amazon AWS and Microsoft Azure.
  • You will learn how to create, alter and drop database.
  • You will learn how to create, alter and drop tables.
  • You will learn how to insert, update and delete records from tables.
  • You will start constructing your SELECT statement to retrieve data from SQL Server.
  • You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.
  • You will also see how to use UNION / UNION ALL operators
  • You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.
  • You will learn Joins in SQL Server. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join and Self Join.
  • You will also know about some of the string functions, date functions, and system functions.
  • You will learn how to create your own function.
  • You will learn how to create, alter and drop Stored Procedure and advantages of stored procedure.
  • You will learn how to create, alter and drop Trigger and its advantage.
  • You will learn how to create, alter and drop View and its advantage.
  • You will learn about temp tables and its advantage.
  • You will learn how to handel exceptions in SQL Server.
  • You will learn how to import data from excel file, flat file, another SQL server database and MySQL.
  • You will learn how to export data to excel file, flat file and another SQL server database
  • You will learn about Bulk Insert.
  • You will learn about Cursors.

Requirements

  • No Pre-Requisites - I will explain everything in the lectures.
  • No Prior Database OR SQL experience is required.

Description

Microsoft SQL Server developers are earning higher salary in IT industry, but, it's not about writing queries it's about understanding and applying the right query at right time. This course will let you understand the SQL Server concepts in an easy way. This SQL course is for beginners who are interested to learn Microsoft SQL Server Database 2017.  

This Online SQL Server Training course takes some of the basics and then goes in depth. There are regular quizzes and self practice assignments to help you remember the information.   

  • Microsoft SQL Server 2017 Installation   

  • Introduction to SQL Server database and its structure

  • Database   

        - How to create database   

         - How to modify database   

        - How to delete database   

         - Database delete issues


  • Cloud Database

    - Amazon AWS

    - Microsoft Azure   

  • Tables   - How to create table   

      - How to modify table   

      - How to delete table   


  • Data manipulation   

         - How to insert data in tables   

        - How to update data in tables   

         - How to delete data in tables   

        - Truncating data vs deleting   

  • Retrieving data       

       - Select statement   

  • Filtering data retrieval   

    - Filtering Data with the WHERE clause    

      - Filtering Data with the WHERE clause using various Operators

       - UNION Operator and UNION ALL Operator    

       - EXISTS Operator    

       - Sorting Data with the ORDER BY Clause    

       - SELECT TOP Clause    

       - DISTINCT Statement    

       - GROUP BY Statement    

       - HAVING Clause   

  • Advance Table Concepts

       - Primary Key   

       - Foreign Key   

      - Unique Key   

       - Null values   

       - Default Values   

      - CHECK constraint   

  • Joins   

      Learn to write complex queries using different types of Joins in SQL Server   

        - Inner Join    

        - Left Outer Join    

        - Right Outer Join    

        - Full Outer Join    

        - Cross Join    

        - Self Join   

  • Stored Procedure

         - How to create, alter and drop stored procedure   

         - SQL Injection   

         - Advantages of stored procedure   

  • Built-in Functions     

         - String Functions   

         - Numeric Functions   

         - Date Functions   

         - Conversion Functions   

         - Advanced Functions   

  • User defined Functions   

  • Temp Tables   

  • Triggers   

  • Views

  • Exception Handling

  • Import

         - Import data from excel file   

         - Import data from flat file   

         - Import data from another SQL server database   

        - Filter data while importing   

        - Import data from MySQL

  • Export


        - Export data to excel file   

         - Export data to flat File   

         - Export data to another SQL server database   

         - Filter data while exporting

  • Bulk Insert

  • Cursors

  • Table Variable

  • Derived tables and Except operator

  • Common table expressions (CTE)

You will make your money back from the price of this course. If you didn't like the course you really have nothing to lose. Udemy guarantees it with their no-risk 30 day money back guarantee.   

So come on inside and learn about what Microsoft SQL Server has to offer. Thank you for signing up for this course on Udemy. The course will always be up-to-date. I am also available for questions inside the course discussion board.   

Who this course is for:

  • I have designed the course for beginners that want to learn Microsoft SQL Server from scratch.
  • Anybody who wants to better understand how databases work
  • Anybody who wants to enhance their career in Microsoft SQL Server database

Instructor

Valiveti Sekhar
IT Professional
Valiveti Sekhar
  • 4.2 Instructor Rating
  • 393 Reviews
  • 1,563 Students
  • 2 Courses

12 years IT industry experience in various domains CRM, Supply Chain Management, E Commerce applications. Worked on requirement gathering,analysis, design, development and implementation of IT systems. Worked on web technologies Html, CSS, JavaScript, jQuery, Bootstrap, ASP.Net, MVC, Web API and Web Services. Worked on databases Microsoft SQL Server, MySQL and Oracle.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.