Getting Started with SQL Server 2017 and .NET Core

Getting Started with SQL Server 2017 and .NET Core, available at $44.99, has an average rating of 4.3, with 30 lectures, based on 20 reviews, and has 1258 subscribers.

You will learn about High Level Overview of SQL Server 2017 SQL Server 2017 Installation SQL Programming SQL Development with .NET CRUD Operations This course is ideal for individuals who are Anyone who wants to start working with SQL Server 2017 or Anyone who wants to utilize a database for storing information or Anyone who wants to communicate through SQL Server using .NET or Students and Professionals getting started with database systems It is particularly useful for Anyone who wants to start working with SQL Server 2017 or Anyone who wants to utilize a database for storing information or Anyone who wants to communicate through SQL Server using .NET or Students and Professionals getting started with database systems.

Enroll now: Getting Started with SQL Server 2017 and .NET Core

Summary

Title: Getting Started with SQL Server 2017 and .NET Core

Price: $44.99

Average Rating: 4.3

Number of Lectures: 30

Number of Published Lectures: 30

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

High Level Overview of SQL Server 2017
SQL Server 2017 Installation
SQL Programming
SQL Development with .NET
CRUD Operations

Who Should Attend

Anyone who wants to start working with SQL Server 2017
Anyone who wants to utilize a database for storing information
Anyone who wants to communicate through SQL Server using .NET
Students and Professionals getting started with database systems

Target Audiences

Anyone who wants to start working with SQL Server 2017
Anyone who wants to utilize a database for storing information
Anyone who wants to communicate through SQL Server using .NET
Students and Professionals getting started with database systems

Get Started with SQL Server 2017 and Build .NET Core Applications that interact with relational data!

Are you a student or professional in the field of software engineering or maybe contemplating an educational or career move to the software engineering world? Have you been looking for a quick and easy way to get up and running with SQL Server 2017 and don’t want to go through an overwhelming amount of material just to get your environment setup and ready for building your own apps that interact with data? Don’t worry as THIS IS THE COURSE FOR YOU!�

In my course, I will teach you how to get your environment setup for SQL Server 2017 and help you to build your first set of apps that store and retrieve data quickly and through a step-by-step guided approach. I will be showing you all the necessary installation and setup needed for SQL Server 2017, SQL Server Management Studio, .NET Core, Visual Studio, and Dapper.�

Take this course and feel proud of the fact that you will be one step closer towards the rewarding field of Software Engineering using .NET technologies!

Course Curriculum

Chapter 1: Introduction to SQL Server 2017

Lecture 1: The Importance of Relational Data

Lecture 2: Installing SQL Server 2017

Lecture 3: SQL Server Management Studio (SSMS) Quick Overview

Chapter 2: The Data Model

Lecture 1: The University Data Model

Lecture 2: University Data Model using Database Diagrams Part 1

Lecture 3: University Data Model using Database Diagrams Part 2

Lecture 4: Generating Random or Seed Data Part 1

Lecture 5: Generating Random or Seed Data Part 2

Lecture 6: Generating Scripts

Chapter 3: Querying the University Data Model

Lecture 1: SELECT…FROM…ORDER BY

Lecture 2: SELECT…FROM… Using Table Alias

Lecture 3: SELECT…FROM…WHERE Part 1

Lecture 4: SELECT…FROM…WHERE Part 2

Lecture 5: Aggregates (Count, Max, Min, Avg, etc)

Lecture 6: Table Join

Lecture 7: Group By

Lecture 8: Common Table Expression CTE

Lecture 9: Creating Views

Lecture 10: Creating Functions

Lecture 11: Creating Stored Procedures

Chapter 4: .NET Core Integration with SQL Server

Lecture 1: Data Access Overview

Lecture 2: Installation .NET Core and Visual Studio

Lecture 3: .NET Core ADO.NET: Console and Nuget

Lecture 4: .NET Core ADO.NET: Application Settings JSON

Lecture 5: .NET Core ADO.NET: ConfigurationBuilder

Lecture 6: .NET Core ADO.NET: Snippet and Debug

Lecture 7: EF Core Database First: Nuget Packages

Lecture 8: EF Core Database First: Scaffolding

Lecture 9: EF Core Database First: Using UniversityDBContext

Lecture 10: Dapper ORM Approach

Instructors

Manish Narayan
President – Innovative Institution, Professor of Engineering

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 4 votes
4 stars: 8 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu