Complete SQL in C#: Design Amazing Database Apps in C# & SQL
4.2 (62 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.
10,703 students enrolled

Complete SQL in C#: Design Amazing Database Apps in C# & SQL

10 in 1:Data Entry App,ADO.Net ,Search SQL in C# ,multi user App,Image in SQL Server ,Backup & Restore,Aggregate,Publish
4.2 (62 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.
10,703 students enrolled
Created by Musavi Abdullah
Last updated 6/2020
English
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 63.5 hours on-demand video
  • 19 articles
  • 21 downloadable resources
  • 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
  • 10 Courses in one + 64 Hours + 22 Projects
  • Start Working with SQL Server
  • Build C# Apps by SQL ADO .Net
  • Search the SQL Data by C# App
  • Design Pro Data Entry Forms
  • Save Image in SQL Db by C# App
  • Pro English Dictionary by 176,000 Words!
  • Create Phone Book Project in C#
  • Multi User App & Login Form in C#
  • Backup and Restore SQL Db in C#
  • SQL Aggregates ( Sum, Avg, Max, Min) in C#
  • Publish C# Apps in SQL in Users PC
  • Load,Save,Delete & New By C# in SQL
  • Using Date,Time,Currency & Number in C#
  • Working with Oracle VirtualBox
Course content
Expand all 697 lectures 63:45:45
+ A. Welcome to Course 1 : SQL ADO.Net in C#
4 lectures 14:42
Download projects and files of this course
00:53
How to increase sound volume of tutorials?
02:01
+ A.a. Visual Studio 2019 Update
5 lectures 30:55
Visual Studio 2019 Section Intro
01:09
Visual Studio 2019 requirements
04:18
How to Install Visual Studio 2019?
13:53
Working with Visual Studio 2019 and C#
06:07
Compare Visual Studio 2019 & Visual Studio 2017
05:28
+ A.b. Quick Review of SQL Server
53 lectures 04:29:00
Who should watch this section!
00:54
Download SQL Server 2014 express & requirements
08:07
Install SQL 2014 express in Windows 7
11:47
Install SQL 2014 express in Windows 10
10:17
What is SQL Server & its structure?
03:10
Common parts of SQL Server
02:13
What is SQL Server Management Studio (SSMS) ?
07:22
Customize SQL Server Environment
05:53
What is SQL Server database?
03:45
Create SQL Database
03:29
Different parts of the SQL database
03:33
Rename and delete SQL Database
03:17
Default location of the SQL Database files
03:09
Different type of SQL datbase files
05:05
Using SQL Server configuration manager
06:24
What is SQL table?
03:03
Add table to the SQL Database
12:31
Add data to the SQL table
05:24
Load data in to the SQL table
05:00
Change the design of table & save it
04:17
Rename and delete the SQL table
02:17
What is the prefix "dbo" in SQL table name?
02:50
What is SQL Numeric data type?
03:50
Int data type in SQL
08:23
Bit data type in SQL
05:28
Tinyint data type in SQL
03:40
Smallint data type in SQL
04:19
Bigint data type in SQL
02:55
Float data type in SQL
04:09
Decimal data type in SQL
10:27
Char data type in SQL
07:00
Varchar data type in SQL
05:29
Varchar(max) data type in SQL
06:13
Text data type in SQL
03:28
nchar data type in SQL
07:21
nvarchar data type in SQL
04:45
nvarchar Max data type in SQL
04:09
ntext data type in SQL
04:15
What is GUID in SQL?
03:04
Using GUID in SQL Server
08:21
How to detach SQL database?
04:53
How to attach SQL database?
03:30
Attach SQL database without LDF file
04:31
Make SQL database offline and online
03:27
Create sample database to set identity column
05:03
Add identity and auto increment column and test it
07:33
Identity column count in each table
03:35
SQL Date data type
06:19
SQL Smalldatetime data type
03:58
SQL Datetime data type
02:54
SQL Datetime2 data type
03:39
SQL Datetimeoffset data type
03:01
SQL Time data type
05:34
+ A.c. Create "Phone Book" Database in SQL
7 lectures 34:45
Create "Phone Book" database in SQL
03:47
Add "Phone Book" table to SQL database
03:52
Add personal & contact columns to "Phone Book" table
08:02
Add Address columns to "Phone Book" table
05:58
Add identity and auto increment column
06:43
Add sample data in SQL for "Phone Book" table
04:03
+ A.d. Select Data by SQL Select Query
7 lectures 39:07
Writing our first Select query
11:42
Use Select query with (*) to show all columns
02:02
Sort the records with Select query
09:47
Show specific number of top rows with Select Query
04:12
Show specific number of bottom rows with Select Query
03:51
Reorder the columns in Select Query
02:53
+ A.e. SQL ADO.Net in C#
6 lectures 36:56
Section Introduction for SQL ADO.Net
01:03
Create C# Phone Book Project for SQL Server
05:22
Add Dataset to C# project
07:05
Add Table Adapter to Dataset
11:56
SQL Server Connection String in Depth
07:38
+ A.f. Dataset and Table Adapter
6 lectures 34:29
Using Manual Query editor in C#
04:51
Using Diagram & Criteria to Create SQL Select Query
10:58
Finish Adding Table Adapter to Dataset
05:37
What is Dataset and Data table in C#
03:24
What is Table Adapter in C#
04:28
How to configure SQL Query in Table Adapter
05:11
+ A.g. Creating Phone Book Data Form
7 lectures 38:55
Add Datagrid view to Phone Book form
09:20
Resolve errors and create form again
04:54
What is Binding Source?
04:52
Add All Textboxes & Labels to Phone Book Form
06:45
Adding Textbox & Label one by one to Form
04:39
Add Records to Dataset and save in SQL Server Database
03:49
+ A.h. Data Entry Form Toolbar
7 lectures 37:06
Section intro
00:55
Upgrade to Visual Studio 2019 my Phone Book project
03:58
Add toolbar to data entry form
07:41
Add image to toolbar buttons
06:20
Enable|Disable toolbar buttons by C# code
07:44
Create method for Enable|Disable buttons
04:19
Enable|Disable Datagridview & Groupbox by C# code
06:09
+ A.i. Data Entry Buttons C# Coding
7 lectures 40:05
Write "Add New " button code in C#
04:21
Write "Save Changes" button code in C#
09:13
Show message box after saving data to SQL
04:30
Write "Delete" button code in C#
05:01
Write "Edit" & "Cancel" buttons code in C#
07:37
Add empty record guard to "Edit" & "Delete" Buttons
07:14
Disable groupbox Items when click the "Delete" button
02:09
Requirements
  • Visual Studio 2017 or 2019 Community edition or other versions
  • General Knowledge of C# Programming
  • Inner Motivation to Learn SQL in C# !
Description

Hi There!

With my 20 years programming skills i'm with you to share my knowledge with you.

So

If you try you will learn using SQL Server Database in C# Application!

If you are beginners or student looking for a tutorial to create database apps in SQL Server and create a application for that in C# in simplest way!

 

I started from beginning and show you how to :

  • Start Working with SQL Server

  • Build C# Apps by SQL ADO .Net

  • Search the SQL Data by C# App

  • Design Pro Data Entry Forms

  • Save Image in SQL Db by C# App

  • Pro English Dictionary by 176,000 Words!

  • Create Phone Book Project in C#

  • Multi User App & Login Form in C#

  • Backup and Restore SQL Db in C#

  • SQL Aggregates ( Sum, Avg, Max, Min) in C#

  • Publish C# Apps in SQL in Users PC

  • Load,Save,Delete & New By C# in SQL

  • Using Date,Time,Currency & Number in C#

  • Working with Oracle VirtualBox

  • and ...

Don't hesitate to start learning SQL Server in C#!

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi SQL & C# world and let's go !!!

Who this course is for:
  • C# programmers who want to work with SQL Server in C# code!
  • C# programmers who want to Learn Quickly SQL Server in C# code!
  • C# programmers who want to make more money by Using SQL Server in C# !