Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

SQL in VB.Net Series: Publish SQL Apps by VB.Net in Users PC


Introduction :
Introduction
About Me!

Quick Review of SQL Server :
Download SQL Server 2014 express & requirements
Install SQL 2014 express in Windows 7
Install SQL 2014 express in Windows 10
What is SQL Server & its structure?
Common parts of SQL Server
What is SQL Server Management Studio (SSMS) ?
Customize SQL Server Environment
What is SQL Server database?
Create SQL Database
Different parts of the SQL database
Rename and delete SQL Database
Default location of the SQL Database files
Different type of SQL datbase files
SQL table intro
What is SQL table?
Add table to the SQL Database
Add data to the SQL table
Load data in to the SQL table
Change the design of table & save it
Rename and delete the SQL table
What is the prefix "dbo" in SQL table name?
What is SQL Numeric data type?
Int data type in SQL
Bit data type in SQL
Tinyint data type in SQL
Smallint data type in SQL
Bigint data type in SQL
Float data type in SQL
Decimal data type in SQL
Section Introduction
Char data type in SQL
Varchar data type in SQL
Varchar(max) data type in SQL
Text data type in SQL
Section Intro
nchar data type in SQL
nvarchar data type in SQL
nvarchar(max) data type in SQL
ntext data type in SQL
What is GUID in SQL?
Using GUID in SQL Server
How to detach SQL database?
How to attach SQL database?
Attach SQL database without LDF file
Make SQL database offline and online
Create sample database to set identity column
Add identity and auto increment column and test it
dentity column count in each table
Date Time Data type intro
SQL Date data type
SQ Smalldatetime data type
SQ Datetime data type
SQ Datetime2 data type
SQ Datetimeoffset data type
SQ Time data type
Create phone book project database in SQL Server
Add personal columns to phone book table
Add contacts columns to phone book table
Add address columns to phone book table
Add identity and auto increment column
Add sample data and test our SQL table
What is Select Query in SQL?
Writing our first Select query
Use Select query with (*) to show all columns
Sort the records with Select query
Show specific number of top rows with Select Query
Show specific number of bottom rows with Select Query
Reorder the columns in Select Query
Overview of Where clause for searching data
Using Where clause to find English characters
Using Where clause to find Unicode characters
Using Where clause to find Numbers
Different operators with Where clause
Use Not equal operator() with Were clause

Create Shop Pro for this Course :
Create SQL Database for shop
Add sample data in SQL for product list
Create shop project in VB.Net to use SQL Database

Connect our Project to SQL Database :
SQL ADO.Net Introduction
Add Dataset and table-adapter to VB.Net project
Working with query builder in Tableadapter
Add Datagrid view to shop form
Connection String in depth and configuring Tableadapter query

Start Using VirtualBox :
What is Virtual Machine?
Download and install Oracle VirtualBox
Quick tour of VirtualBox environment
Add new Windows 7 virtual machine to VirtualBox
Working with the settings of Virtual Machine
Delete virtual machine and settings from VirtualBox
Preparing Installing Windows 7 64 bit in VirtualBox
Host key in virtual machine
Installing Windows 7 64 bit in VirtualBox

Working with Virtual Windows :
Quick working with Virtual machine and menus
Installing Guest addition in virtual Windows 7
Share folder between your windows and virtual windows
Tips and tricks of share folder problem
Drag and drop files to virtual windows
Share clipboard between our Windows and virtual machine

Backup & Restore Virtual Machine :
Make a backup copy of virtual machine
Tips and tricks before make a backup of virtual machine
Restore virtual machine from backup file

Preparing to Test Application VB.Net in VirtualBox :
Introduction to publishing App process
Open shop project for publishing
Copy App files in virtual windows 7
How to Install .Net framework 2.0 on virtual machine
Install .Net framework 4 on virtual Windows 7
Change application .net framework version to 4

Publishing App Methods :
Different methods for publishing Apps With VB.Net & SQL

First Method: Publishing App with Manual attaching of Database :
Download SQL Server 2014 express with SSMS
Copy SQL installation file to virtual machine & start installation
Define dedicated SQL Server name & user & pass
Install SQL 2014 express with SSMS in virtual Windows 7
Start working with SQL management studio in virtual machine
Working with SQL Server configuration manager

Preparing VB.Net App for Publish :
What is Application config file?
Use dot (.) in SQL Server name
Copy shop SQL Database to virtual machine
Attach Shop SQL Database in virtual Windows 7 to SQL Server
Finalize publish process of VB.Net App
Protect SQL login info in Users computer

Automate Publish Process in First method :
Automate Publish Process in First method
Change connection string of tableadapter in VB.Net code
Write the VB.Net code for switching between Connections before publishing App

Publish SQL Apps By Using 2nd Method :
Section Introduction
Add New Virtual Machine & Install .net framework 4 and ...
Download SQL Server 2014 express
Define dedicated SQL Server name & user & pass
Preparing Installing SQL Server Express
Install SQL 2014 express in Windows 7
Move VB.Net project to Drive E
Copy SQL Database inside VB.Net project

2nd Method to Publish SQL Apps: Using SQL User Instance :
SQL Server Connection String in Depth
SQL Server normal instance Vs User instance
Add new connection string to use SQL user instance
Complete connection to SQL Db file to SQL user instance
What is "|DataDirectory|" in connection string?
Using new connection string with TableAdapter
Solve "database already exist" error while connecting to SQL user instance

SQL User Instance in Depth :
Get the list of SQL user instance in SQL management studio
Connecting to SQL user instance in SQL management studio
Detach and delete databases from SQL user instance

Connecting VB.Net app to SQL User Instance :
Attach SQL db file to SQL user instance with initial catalog
Attach SQL db file to SQL user instance with empty initial catalog
Solve in depth "database already exist" error with initial catalog
Solve in depth "database already exist" error with empty initial catalog

Publish SQL App By Using 2nd Method :
Different types of initial catalog in connection string
Using empty initial catalog for publishing SQL app by SQL user instance
Using not empty initial catalog for publishing SQL app by SQL user instance
Make easier 2nd method publish process and develop process

3rd Publish Method: Normal SQL Instance :
Preparing 3rd Publish method for publishing SQL Apps in VB.Net
Add connection to SQL normal instance
Adding permission to SQL database folder
Check effect of auto connecting database to SQL normal instance
Publish SQL App with SQL authentication and SQL normal instance
Publish SQL App with Windows authentication and SQL normal instance
Make easier 3rd method publish process and develop process

Join to My Other Courses with Discount :
Get My Other Courses with a Discount