2020-06-09 10:43:24
Complete SQL in VB.Net :Design Pro Database Apps in VB & SQL
8,517 students enrolled
Complete SQL in VB.Net :Design Pro Database Apps in VB & SQL
10 in 1:Data Entry App,ADO.Net ,Search SQL in VB ,multi user App,Image in SQL Server,Backup & Restore,Aggregate,Publish
8,517 students enrolled
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
- 60 hours on-demand video
- 18 articles
- 20 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 + 60 Hours + 21 Projects
- Start Working with SQL Server
- Build VB. Net Apps by SQL ADO .Net
- Search the SQL Data by VB. net App
- Design Pro Data Entry Forms
- Save Image in SQL Db by VB .net App
- Pro English Dictionary by 176,000 Words!
- Create Phone Book Project in VB .net
- Multi User App & Login Form in VB. net
- Backup and Restore SQL Db in VB. Net
- SQL Aggregates ( Sum, Avg, Max, Min) in VB
- Publish VB .net Apps in SQL in Users PC
- Load,Save,Delete & New By VB. net in SQL
- Date,Time,Currency & Number in VB. Net
- Working with Oracle VirtualBox
Course content
Expand all
666 lectures
60:22:09
+
–
A. Welcome to Course 1 : SQL ADO.Net in VB.Net
4 lectures
12:49
Download projects and files of this course
00:54
How to increase sound volume of tutorials?
02:01
+
–
A.a. Visual Studio 2019 Update
5 lectures
32:15
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 VB.Net
07:27
Compare Visual Studio 2019 & Visual Studio 2017
05:28
+
–
A.b. Quick Review of SQL Server
57 lectures
04:32:05
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
SQL table intro
00:45
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
Section Introduction
00:45
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
Section Intro
00:45
nchar data type in SQL
07:21
nvarchar data type in SQL
04:45
nvarchar 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
Date Time Data type intro
00:50
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
Quick review and road map of this course
02:20
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 VB. Net
7 lectures
45:23
Section Introduction for SQL ADO.Net in VB
01:03
Create VB.Net Phone Book Project for SQL Server
06:19
Make a back up of our project
03:47
Add Dataset to VB.Net project
09:25
Add Table Adapter to Dataset
13:00
SQL Server Connection String in Depth
07:57
+
–
A.f. Dataset and Table Adapter
6 lectures
46:56
Using Manual Query editor in VB.Net
07:22
Using Diagram & Criteria to Create SQL Select Query
10:59
Finish Adding Table Adapter to Dataset
09:01
What is Dataset and Data table in VB.Net
06:19
What is Table Adapter in VB.Net
07:41
How to configure SQL Query in Table Adapter
05:34
+
–
A.g. Creating Phone Book Data Form
7 lectures
48:19
Add Datagrid view to Phone Book form
10:41
Resolve errors and create form again
08:31
What is Binding Source?
05:35
Add All Textboxes & Labels to Phone Book Form
07:23
Adding Textbox & Label one by one to Form
05:15
Configure New , Delete and Save Buttons in Form
05:13
+
–
A.h. Data Entry Form Toolbar
7 lectures
38:21
Preview
00:48
Upgrade to Visual Studio 2019 my Phone Book project
07:30
Add toolbar to data entry form
05:12
Add image to toolbar buttons
07:09
Enable|Disable toolbar buttons by VB.Net code
07:32
Create method for Enable|Disable buttons
04:12
Enable|Disable Datagridview & Groupbox by VB.Net code
05:58
+
–
A.i. Data Entry Buttons VB.Net Coding
7 lectures
37:10
Write "Add New " button code in VB.Net
03:47
Write "Save Changes" button code in VB.Net
07:14
Show message box after saving data to SQL
04:18
Write "Delete User" button code in VB.Net
06:05
Write "Edit" & "Cancel" buttons code in VB.Net
07:56
Add empty record guard to "Edit" & "Delete" Buttons
06:11
Disable groupbox Items when click the "Delete" button
01:39
Requirements
- Visual Studio 2017 or 2019 Community edition or other versions
- General Knowledge of Visual Basic Programming
- Inner Motivation to Learn SQL in VB. Net!
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 VB.Net Application!
If you are beginners or student looking for a tutorial to database app in SQL Server and create a application for that in VB.Net in simplest way!
I started from beginning and show you how to:
Start Working with SQL Server
Build VB. Net Apps by SQL ADO .Net
Search the SQL Data by VB. net App
Design Pro Data Entry Forms
Save Image in SQL Db by VB .net App
Pro English Dictionary by 176,000 Words!
Create Phone Book Project in VB .net
Multi User App & Login Form in VB. net
Backup and Restore SQL Db in VB. Net
SQL Aggregates ( Sum, Avg, Max, Min) in VB .Net
Publish VB .net Apps in SQL in Users PC
Load,Save,Delete & New By VB. net in SQL
Using Date,Time,Currency & Number in VB. Net
Working with Oracle VirtualBox
and ...
Don't hesitate to start learning SQL Server in vb.net!
Every thing will be discussed with sample project and you will have lot of fun within my course.
Say Hi SQL & VB .net world and let's go !!!
Who this course is for:
- VB. Net programmers who want to work with SQL Server in Visual Basic code!
- VB. Net programmers who want to Learn Quickly SQL Server in VB. Net code!
- VB. Net programmers who want to make more money by Using SQL Server in Visual Basic !