How to create data apps with SQL Server and visual studio
3.8 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,929 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to create data apps with SQL Server and visual studio to your Wishlist.

Add to Wishlist

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.8 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,929 students enrolled
Last updated 2/2017
English
Curiosity Sale
Current price: $10 Original price: $115 Discount: 91% off
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Anyone with basic computer skills
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,562 Reviews
35,132 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.