Browse Library

Microsoft SQL Server 2019 - An introduction

Latest version of Microsoft SQL Server 2019 - Easy course designed for everyone who wants to know and learn SQL Server.

Instructed by Sanesh Kale

18 days left at this price!
$25
30 days money back guarantee
$25
It Includes
  • Get access to this course only
  • Lifetime Course Access
  • Play & Pause Videos
  • Get Certificate of Completion
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Download Course for Offline Viewing
  • Inlcudes Real Projects
  • Free Instructor Support
  • know about Microsoft SQL Server 2019 - Latest Version
  • How to do Installation, Configuration of MS SQL Server
  • Creating, dropping database
  • DML Operations - SELECT, INSERT, UPDATE, DELETE
  • Play with SSMS
  • Database backup and recovery operations
  • Backup and Restore with Export, Import
  • Database Mail, Jobs
  • Security, Authentications

Microsoft SQL Server 2019 is the latest version from Microsoft, released in this year.

Its really easy and simple course designed for everyone to learn and know about latest version of SQL Server. 

I would like to share installation, configuration and handling SQL Server Management Studio in this web series.

I will be sharing syllabus and which books to read ? 

Also some links for Microsoft SQL Server practice and exams.


We will also have a look on below topics as well : 

1. T-SQL  - Transact SQL - having practice of T-SQL

2. SSRS -  SQL Server Reporting Services  - how to create report and view data

3. SSIS -  SQL Server Integration Services - how to use integration services

4. SSAS -  SQL Server Analytics Services  - how to work with analytics services


No basic knowledge required to do this course, only eager to learn...

  • No Basic knowledge required
  • For People eager to learn.
  • Easy course is designed for everyone to learn about latest version MS SQL Server 2019
View More...

Section 1 : Introduction

  • Lecture 1 :
  • Lecture 2 :
  • Hardware and Software requirement for Installation of SQL Server 2019

Section 2 : Which Version to Install ?

  • Lecture 1 :
  • Will see which version/edition to install ?

Section 3 : Installation

  • Lecture 1 :
  • Download Software
  • Lecture 2 :
  • Installation of Microsoft SQL Server 2019
  • Lecture 3 :
  • Installation of Microsoft SQL Server Management Studio

Section 4 : Security - Authentication

  • Lecture 1 :
  • Authentication to Connect MS SQL Server
  • Lecture 2 :
  • Generation of connection string

Section 5 : Overview of Database, SSMS

  • Lecture 1 :
  • Using SSMS and Database
  • Lecture 2 :
  • Starting, stopping database, instance

Section 6 : Database Operations

  • Lecture 1 :
  • Creating, Dropping database
  • Lecture 2 :
  • Basic DML Operations- INSERT, UPDATE, DELETE, SELECT

Section 7 : Backup, Recovery Operations

  • Lecture 1 :
  • Backup, Recovery Operations
  • Lecture 2 :
  • Export - Backup of database
  • Lecture 3 :
  • Import - Recover Database from Backup

Section 8 : More -

  • Lecture 1 :
  • Database Mail
  • Lecture 2 :
  • Jobs in MS SQL Server

Section 9 : What Next ?

  • Lecture 1 :
  • Syllabus
  • Lecture 2 :
  • books and Exam

Section 10 : Developer Edition

  • Lecture 1 :
  • Downloading Developer Edition
  • Lecture 2 :
  • Installation of Developer Edition
  • Lecture 3 :
  • Connecting SSMS to Developer Edition

Section 11 : End ?

  • Lecture 1 :
  • Practice
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Sanesh Kale,

I am Oracle Certified Professional with 12 years of experience on building large scale enterprise system and experience of working with Performance Tuning, Exadata, RAC, Golden Gate, MySQL, MS SQL Server, PostreSQL, Middleware, Golden Gate etc. I have experience on domain like Backing, finance, telecommunication, transport, insurance. I have been involved with building large scale database systems and implementation, migration, monitoring, high availability, availability and tuning of the database systems. Also involvement in design, development till production of large scan applications. I am passionate about teaching to people and enthusiastic of sharing knowledge with everyone.
View More...
managing-sql-business-intelligence-operations

Managing SQL Business Intelligence ...

By : Microsoft

Lecture 7

infinite-scroll-project-ajax-mysql-api-php-jquery

Infinite Scroll Project AJAX MySQL ...

By : Laurence Svekis

Lecture 19

learn-to-build-sql-query-ultimate-sql-and-database-concepts

Learn to Build SQL Query Ultimate S...

By : Jazeb Akram

Lecture 24

sql-server-101-microsoft-sql-server-for-absolute-beginners

SQL Server 101 : Microsoft SQL Serv...

By : Rashid Khan

Lecture 44

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password Request
Enter your email and we will email you the reset link