How to create data apps with SQL Server and visual studio
3.9 (78 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,163 students enrolled

How to create data apps with SQL Server and visual studio

Learn to create a database driven application with SQL Server and Visual Studio
3.9 (78 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,163 students enrolled
Last updated 2/2017
English
English [Auto]
Current price: $74.99 Original price: $114.99 Discount: 35% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Download and install visual studio
  • Download and install SQL Server
  • Create a database and a table
  • Attach a database to a visual studio project
  • Design a form with dataset
  • Add controls to a form
  • Customise controls
  • Create a data app that saves data into a database
Course content
Expand all 32 lectures 02:48:33
+ Setting up the lab environment
7 lectures 33:02
Download and install visual studio - PART 2
05:09
Requirements for SQL Server
02:49
Download SQL Server
04:07
Install SQL Server
06:47
+ How to create a basic data application
10 lectures 38:51
Introduction
01:31
Download Northwind Database
04:35
How to add Northwind Database to SQL Server
05:10
Create a new project in visual studio
01:51
Create the Data Source
05:03
Create Controls to Display Data from Customers Table
03:42
Create Controls to Display Data from Orders Table
04:38
Test the Application
02:48
Modify Data
07:01
Run App outside Visual Studio
02:32
+ Project 1: Create a User Login data app
9 lectures 55:55
Project introduction
02:58
Create the project form
07:12
Customize controls
07:28
Add logged in form
05:58
Create a database table
06:10
Populate the table
06:58
Add database to visual studio
02:13
Write some code to activate form - Part 1
08:03
Write some code to activate form - Part 2
08:55
+ Project 2: Create an Image Upload Data App
6 lectures 40:45
Project Introduction
02:22
Create a database and table
09:05
Create new visual studio project and add database
05:48
Design form with dataset
07:33
Write C# Code to make app work
11:26
Test and Run the App
04:31
Requirements
  • You should be able to use a PC at a beginner level
  • You should have visual studio and SQL Server on your PC(We will cover how to install it)
  • Basic knowledge of C# Programming concepts (Not mandatory)
  • Basic knowledge of SQL Server (Not mandatory)
Description

Data apps are applications that saves data to and retrieves data from the database.We interact with data apps daily from Facebook,Instagram,emails and even our bank accounts.

In this beginners course we are going to create very basic data apps that will save data into databases.

We will be using C# an object-oriented language designed by Microsoft and used by systems engineers, desktop programmers, and mobile app developers the world over.
Also Microsoft SQL Server will be used as our database for storing and retrieving data.

This course is suitable for anyone who has basic  knowledge  of C# and SQL server .

You will learn:

  • How to download visual studio
  • How to install visual studio
  • How to download Microsoft SQL Server
  • How to install Microsoft SQL Server
  • How to create a database
  • How to create a table
  • How to populate a table
  • How to attach a database to a project in visual studio
  • How to design a form with dataset
  • How to create new C# project in visual studio
  • How to add controls to a form
  • How to customise controls on a form
  • How to test your data apps
  • How to run your data apps outside visual studio
  • How to create a login form data app
  • How to create an image upload data app

By the end of this course you should be able to create your own data apps using visual studio and SQL Server

Welcome :-)

Who this course is for:
  • Anyone with basic computer skills