Advance SQL in VB.Net :Design Database Apps in VB .net & SQL

 | Details:

Duration: About 17:30 Hours

Publish Date: 01/08/2019

Featured Reviews:
Zahir Rabbani:
Very nice course !

SQL in VB.Net Tutorials

| Tutorial Contents of this course :

3 in 1: Barcode Scanner App in VB .net, Advance ADO.Net, ComboBox in Visual Basic & SQL, SQL CRUD in Visual Basic .Net


| Tutorial Overview:

Hi There!

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


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 create database apps 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

Using Barcode scanner by VB.Net App

Search data by Barcode scanner in VB.Net and SQL db

Using the ComboBox in VB.Net and SQL

Advance ADO.Net SQL and VB.Net

CRUD operations in SSMS

CRUD operations in SQL and VB.Net App

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 Barcode Scanner in vb .net code!
VB .Net programmers who want to Search products in VB .Net by using Barcode Scanner!
Visual Basic programmers who want to Learn quickly Advance SQL in VB. Net!


| Table of Contents:

 Show AllDurationDownload

Section 1 . Introduction to this course

 Introduction to this course04:44
 About Me!01:57
 How to increase sound volume of tutorials?02:01

Section 2 . A. Welcome to Course 1 : Using Barcode Scanner in VB.Net and SQL

 What you'll learn in Using Barcode Scanner in VB and SQL00:53

Section 3 . A.a. Working with Barcode

 Generate and print sample Barcode list05:09
 Read the Barcode with Barcode scanner04:53

Section 4 . A.b. Create Barcode Project in Vb.Net

 Create Vb.Net project for working with Barcode04:47
 Design the Barcode form05:58

Section 5 . A.c. Quick Review of SQL Server

 Who should watch this section!00:54
 Download SQL Server 2014 express & requirements08:07
 Install SQL 2014 express in Windows 711:47
 Install SQL 2014 express in Windows 1010:17
 What is SQL Server & its structure?03:10
 Common parts of SQL Server02:13
 What is SQL Server Management Studio (SSMS) ?07:22
 Customize SQL Server Environment05:53
 What is SQL Server database?03:45
 Create SQL Database03:29
 Different parts of the SQL database03:33
 Rename and delete SQL Database03:17
 Default location of the SQL Database files03:09
 Different type of SQL datbase files05:05
 Using SQL Server configuration manager06:24
 SQL table intro00:45
 What is SQL table?03:03
 Add table to the SQL Database12:31
 Add data to the SQL table05:24
 Load data in to the SQL table05:00
 Change the design of table & save it04:17
 Rename and delete the SQL table02:17
 What is the prefix "dbo" in SQL table name?02:50
 What is SQL Numeric data type?03:50
 Int data type in SQL08:23
 Bit data type in SQL05:28
 Tinyint data type in SQL03:40
 Smallint data type in SQL04:19
 Bigint data type in SQL02:55
 Float data type in SQL04:09
 Decimal data type in SQL10:27
 Section Introduction00:45
 Char data type in SQL07:00
 Varchar data type in SQL05:29
 Varchar(max) data type in SQL06:13
 Text data type in SQL03:28
 Section Intro00:45
 nchar data type in SQL07:21
 nvarchar data type in SQL04:45
 nvarchar(max) data type in SQL04:09
 ntext data type in SQL04:15
 What is GUID in SQL?03:04
 Using GUID in SQL Server08:21
 How to detach SQL database?04:53
 How to attach SQL database?03:30
 Attach SQL database without LDF file04:31
 Make SQL database offline and online03:27
 Create sample database to set identity column05:03
 Add identity and auto increment column and test it07:33
 Identity column count in each table03:35
 Date Time Data type intro00:50
 SQL Date data type06:19
 SQL Smalldatetime data type03:58
 SQL Datetime data type02:54
 SQL Datetime2 data type03:39
 SQL Datetimeoffset data type03:01
 SQL Time data type05:34
 Create phone book project database in SQL Server07:56
 Add personal columns to phone book table07:21
 Add contacts columns to phone book table06:54
 Add address columns to phone book table08:18
 Add identity and auto increment column06:43
 Add sample data and test our SQL table06:19
 What is Select Query in SQL?04:40
 Writing our first Select query11:42
 Use Select query with (*) to show all columns02:02
 Sort the records with Select query09:47
 Show specific number of top rows with Select Query04:12
 Show specific number of bottom rows with Select Query03:51
 Reorder the columns in Select Query02:53
 Overview of Where clause for searching data02:09
 Using Where clause to find English characters05:25
 Using Where clause to find Unicode characters02:57
 Using Where clause to find Numbers03:52
 Different operators with Where clause01:53
 Use Not equal operator(<>) with Were clause04:45

Section 6 . A.d. Barcode Database in SQL

 Create database in SQL for saving barcode list05:58
 Add sample data in SQL for Barcode list03:06

Section 7 . A.e. Working with SQL ADO.Net

 SQL ADO.Net Introduction03:52
 Add Dataset to Visual Basic project05:17
 Connect our project to SQL Database07:03
 SQL Server Connection String in Depth03:00
 Create Select query with Vb.Net query editor08:07
 Finish Adding Table Adapter to Dataset04:49
 Edit our Select query with table-adapter05:40
 Location for saving connection string03:18

Section 8 . A.f. Connect form to SQL ADO.Net

 Add Datagrid view to Barcode Search form07:39
 Customize default BindingNavigator04:36

Section 9 . A.g. Loading Data with TableAdapter

 Using fill method of TableAdapter in Visual Basic08:32
 Adding new select query for loading data by TableAdapter06:09

Section 10 . A.h. Searching Barcode By Barcode Scanner

 Add simple search query to form05:47
 Search user input Barcode05:43
 Manual Search Barcode by Barcode Scanner02:19
 Auto search Barcode by Barcode Scanner05:24
 Search Multiple Barcode by Barcode Scanner03:41

Section 11 . B. Welcome to Course 2 : Advance ADO.Net & ComboBox in SQL & VB.Net

 What you'll learn in Advance ADO.Net & ComboBox in SQL & VB.Net02:54

Section 12 . B.a. Create ComboBox Database in SQL

 What is ComboBox and SQL in VB.Net?03:11
 Create SQL Database for combobox03:18
 Add table and sample data for combobox in SQL Db03:04

Section 13 . B.b. ComboBox Project in VB.Net & SQL ADO.Net

 Create ComboBox Project in VB. Net06:47
 Add Dataset to combobox project in VB .Net02:20
 Add Table Adapter to Dataset and connect it to SQL04:09
 Create Select query with query builder in table adapter09:53
 Configure SQL Query in Table Adapter & connection string in depth07:23

Section 14 . B.c. Simple Using ComboBox in Visual Studio & SQL

 Section intro to : Using ComboBox in VB. Net and SQL01:15
 Main parts of ComboBox04:23
 Simple binding of combobox to database08:16
 VB.Net code to load the data by tableadapter08:03
 Binding multiple combobox to database05:24
 Using Selected text and Selected index of combobox10:54
 Using the selected value in combobox04:42

Section 15 . B.d. Advance Using ComboBox in VB.Net & SQL

 What is advance using of combobox in VB and SQL?02:43
 Add group id column to combobox items table in SQL Db08:04
 Add advance combobox form to VB .Net windows form project05:51
 Add group id column to datatable inside the VB project03:51
 Bind multiple ComboBoxes to datatable by the bindingsource06:26
 Filter multiple ComboBoxes items by group id05:34
 In depth filtering the combobox items03:42
 Sort the items of combobox by the bindingsource05:59
 Sort & Filter the Combo Items by VB.Net code04:41
 Speed up form load by excluding unused combo items in form load06:41

Section 16 . B.e. ComboBox Items Form in VB.Net

 Section intro: Create Combobox items form01:00
 Add combobox items manager form to VB .Net project08:30
 Add and Design DataGridView in Combo items form05:02
 Write VB. Net code for save button07:15
 Show message after saving records05:04
 Add delete button to DataGrid View07:00
 Send selected combo group id to Combo items form07:21
 Load the combobox items based on selected combobox09:29
 Manually "Add,Delete,Update" the combobox items by combo items form04:59

Section 17 . B.f. Advance ADO.Net & Datatable

 Section intro: Advance ADO.Net & Datatable02:16
 Datatable structure in depth06:35
 Get the row and column count of datatable06:26
 Get single record Rowstate in datatable05:53
 Get multiple records Rowstate in datatable06:53
 Using "AcceptChanges" method of datatable04:46
 Get the value of single row and column10:24
 Get the value of multiple rows and single column06:51
 Write the value inside single row and single column05:37
 Write the value inside multiple rows and single column03:54

Section 18 . B.g. Add New Item to ComboBox

 Add the new item to combobox by VB .Net code11:48
 Close the form after adding new combo item10:57

Section 19 . B.h. Binding ComboBox to the Database

 Section intro: Binding Combobox to SQL Database02:02
 Add customer info table to SQL database09:52
 Add customer info table to VB.Net App04:55
 Add controls on form to customer info datatable09:34
 Bind ComboBox text to datatable06:39
 Bind ComboBox selected value to datatable05:55
 Advance topic of ComboBox binding06:21

Section 20 . C. Welcome to Course 3 : Using SQL CRUD in Visual Studio

 What you'll learn in: Using SQL CRUD operations in VB. Net02:42

Section 21 . C.a. SQL CRUD Operations in SSMS

 Section intro: Sql CRUD operation in Sql Server management studio (SSMS)01:38
 What is the Crud operations?04:43
 Using the SQL INSERT query in simple method10:40
 Using INSERT query without column list03:25
 Advance topics of INSERT query ( Adding Date,Text,Numbers)08:54
 Add NULL values by INSERT query07:12
 Auto generate Insert query in SQL Management Studio (SSMS)04:47
 Using the SQL Update query in simple method07:39
 Advance topics of UPDATE query & Auto generate it07:03
 Use UPDATE method with custom column list03:05
 Using NULL value with UPDATE method05:48
 Using the SQL DELETE query07:01

Section 22 . C.b. Prepare the VB.Net App to use SQL CRUD

 Add & design CRUD form in VB. Net project10:12
 Bind the DGV to datatable and load the data from SQL db06:40

Section 23 . C.c. Using INSERT Method in VB App

 Use default INSERT query of TableAdapter to add the new record08:24
 Add new INSERT query to TableAdapter and used it08:19
 Get the last inserted ID in DataBase after inserting the new record12:46

Section 24 . C.d. Using DELETE Method in VB .Net App

 Use default DELETE query of TableAdapter to delete the record10:32
 Customize the default DELETE query of TableAdapter04:44
 Add our new DELETE query to TableAdapter and use it05:52
 Show confirm Message box to user before deleting a the record06:40

Section 25 . C.e. Using UPDATE Method in VB App

 Show the InputBox to user to edit the value in edit button05:29
 Use default UPDATE query of TableAdapter to save changes09:59
 Customize the default UPDATE query of TableAdapter05:31
 Add new UPDATE query to TableAdapter for updating the record09:47

Section 26 . C.f. Finalizing the Visual studio CRUD Project

 Reload the data after : New,Edit and Delete operations08:00
 Connect the "Combo items CRUD" form to the main form07:00
 Finalize connecting the "Combo items CRUD" form09:10, 2003-2020