Learn Visual Basic

Learn and Master Programming in Visual Basic

Programming Basics & Databases4.5(87)13h 47m75 lectures21 sections

What you'll learn

  • Learn the basics of programming in Visual Basic
  • Design program interfaces
  • Work with Events
  • Use control statements, functions and arrays
  • Understand object-oriented programming
  • Handle programming errors
  • Work with databases using SQL and ADO.NET
  • Create reports and program web applications
  • Use the XML markup language

About this course

This course teaches Visual Basic and how to master programming with it. It is an easy language to learn and a good doorway into the world of programming. It starts with highlights from the course, then the first steps with Visual Basic, the tools for designing the program interface, Events, programming rules, statements that control the flow of the program, and functions and arrays. After that it explains object-oriented programming and handling programming errors, then database concepts, the SQL query language and ADO.NET technology, reports, the different data types, working with files, drawing functions, creating controls and libraries, programming web applications, and using the XML markup language. The course is suitable for beginners and for anyone who wants to enter the world of programming, and it needs no previous experience. By the end you will be able to design programs with graphical interfaces, connect them to databases, and work with files and web applications. The course is also built so the explanation moves from simple to advanced, so you can move between topics without confusion.

Expected outcomes

  • Acquire strong programming skills in Visual Basic.
  • Ability to design professional user interfaces.
  • Create database-connected applications using advanced techniques.
  • Handle files and create web applications efficiently.
  • Produce advanced programs using XML and object-oriented programming techniques.

Learner reviews

These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.
4.5
★★★★★
87 reviews
5★
47
4★
39
3★
1
2★
0
1★
0

    Course content

    1

    Getting Started with Visual Basic

    6 lectures
    1. Course HighlightsIntroduces Visual Studio components such as the Toolbox, Properties and Output windows, tests a button that shows a MessageBox, previews an If condition for grading, and touches on libraries and custom components.29:32
    2. Getting Started with Visual Basic (1)Introduces the first book and its contents: getting started with Visual Basic, interface design tools, programming basics, functions, arrays, object-oriented programming, and error handling.8:22
    3. Getting Started with Visual Basic (2)Explains installing Visual Studio 2019 through the small installer that downloads components online, choosing workloads and languages such as VB.NET and C#, and creating a new project of the desired type.8:14
    4. Getting Started with Visual Basic (3)Continues getting started with Visual Basic by exploring Visual Studio components, application types (desktop, web, mobile), the Output window for errors, and the toolbox, ahead of a simple calculator program.12:09
    5. Getting Started with Visual Basic (4)Outlines the stages of building a program in Visual Studio: designing the interface with tools, setting properties such as colors, then writing code, and shows that double-clicking a button opens its code editor.7:28
    6. Getting Started with Visual Basic (5)Programs an example that adds two numbers into a third box, shows why the program joins the text instead of adding it, then covers area examples and how to hand the finished program to the user as an executable.9:48
    2

    Program Interface Design Tools

    9 lectures
    1. Program Interface Design Tools (1)Gives an overview of the Toolbox in Visual Basic .NET 2019 and its best-known controls such as Label, TextBox, Button and ListBox, and the difference between shared common properties and control-specific ones.7:55
    2. Program Interface Design Tools (2)Explains the Label tool and its properties such as Text and colors, changing them in code, then LinkLabel used like a button, joining TextBox content into a welcome message, and Multiline for notes.15:16
    3. Program Interface Design Tools (3)Explains PictureBox for showing images, GroupBox for grouping tools in one frame, selection tools RadioButton and CheckBox, and adding Items to lists such as ComboBox in code.13:05
    4. Program Interface Design Tools (4)Applies an example with a ListBox and four buttons to add items, remove them and clear the list, then explains the Timer tool that runs an operation at set intervals, with a clock and moving an image.15:57
    5. Program Interface Design Tools (5)Continues the interface tools: the scroll bar with its minimum and maximum properties, the Timer tool enabled with a single line of code, and displaying results in a Label.14:01
    6. Program Interface Design Tools (6)Explains working with more than one Form in a single program and opening one Form from another in code, and covers the property that tells whether the user has selected a control.7:57
    7. Program Interface Design Tools (7)Explains the Panel control as a container for other controls with the AutoScroll property that adds a scroll bar, then the TabControl for splitting the interface into pages that each hold their own controls.5:56
    8. Program Interface Design Tools (8)Explains ready-made .NET dialog boxes such as Font, Color, Open and Print, opening them with ShowDialog, applying the chosen font to a TextBox, then leading into Menus.8:57
    9. Program Interface Design Tools (9)Explains adding Menus to a program with the MenuStrip tool, the context menu and attaching it to the form, keyboard shortcuts, and linking menu items to dialogs such as font and color.8:19
    3

    Events

    3 lectures
    1. Events (1)Explains events in Visual Basic .NET and how code responds to them, such as Click, MouseMove, MouseEnter, MouseLeave, MouseDown and MouseUp, with simple mouse examples.13:35
    2. Events (2)Continues mouse and keyboard events: MouseMove with X and Y coordinates moving a Label, key events appending typed characters, moving between fields with the Enter key, and detecting which mouse button was pressed.16:38
    3. Events (3)Continues events with Leave when a tool loses focus and checking an empty field, the form's own events, and a password example that closes the app if wrong and welcomes the user if correct.9:10
    4

    Programming Rules

    3 lectures
    1. Programming Basics (1)Starts programming basics in Visual Basic .NET with declaring variables using Dim and data types like Integer, Double, String and Boolean, and the Convert class for type conversion, with an add-two-numbers example.13:36
    2. Programming Basics (2)Explains input and output with MessageBox and its buttons such as Yes and No, using Mod to tell even from odd numbers, and running several commands on the same component.10:59
    3. Programming Basics (3)Explains Regular Expressions for validating the shape of input, such as digits only or letters only, by importing the text library, using IsMatch and comparing the input to a defined pattern.7:37
    5

    Control Statements in Program Flow

    5 lectures
    1. Control Statements in Program Flow (1)Explains the If statement for controlling program flow by comparing two values such as greater than and less than, showing the result, then If with Else and multiple conditions in a grade example.16:08
    2. Control Statements in Program Flow (2)Explains Select Case as an alternative to multiple If statements for deriving a grade from a TextBox value, with Case Else for other cases, mentions code Snippets, and leads into loop statements.10:55
    3. Control Statements in Program Flow (3)Explains loop statements and the For loop for repeating an operation, showing results in a multiline TextBox, changing the Step, counting down, and leading into nested loops.15:02
    4. Control Statements in Program Flow (4)Explains nested For loops, a loop inside a loop, the While and Do While loops and their difference in where the condition sits, Select Case for days of the week, and a multiplication table example.9:50
    5. Control Structures in Program Flow (5)Explains the Do While loop, which repeats on a condition rather than a fixed count, and applies it in a Console application that keeps asking the user until the correct value is entered.10:41
    6

    Functions

    4 lectures
    1. Functions (1)Explains Sub procedures and Functions in Visual Basic: defined once and called many times to organize the program, reuse code and ease maintenance, with an example of a procedure that shows a message passed as a parameter.16:38
    2. Functions (2)Applies functions and subprograms to computing a grade with Select Case, then turns the code into a function that takes a parameter and returns a value with Return, so it can be called from anywhere.15:36
    3. Functions (3)Continues functions with parameters and return values, using grade calculation and date formatting examples, shows that a small function can do a big job, and advises practicing add, subtract and divide functions.7:19
    4. Functions (4)Explains Optional function parameters with a default value used when none is passed, the need to declare the return type, and examples of functions computing areas of shapes such as square and circle.4:56
    7

    Arrays

    3 lectures
    1. Arrays (1)Explains arrays and their benefit, with an example of taking five values from the user and showing them reversed, comparing a solution using separate variables with one using an array, and using a For loop over the element index.12:03
    2. Arrays (2)Applies arrays with a password example stored in an array with initial values, checking user input using a For loop and a flag variable inside a Do While, along with the array's length.7:30
    3. Arrays (3)Explains two-dimensional arrays with rows and columns, filling their elements, changing their size, and taking X and Y coordinates from the user to store a value at a specific position.8:46
    8

    Programming by Objectives

    4 lectures
    1. Goal-Oriented Programming (1)Introduces Object Oriented Programming by placing subs and functions inside a Class to organize larger programs, then creating an object from the class and calling methods such as welcome, thanks and goodbye.19:06
    2. Goal-Oriented Programming (2)Explains object-oriented programming: classes, objects with their properties and methods, creating several objects from one class, overloading functions with the same name, and encapsulation.10:19
    3. Goal-Oriented Programming (3)Explains the Constructor, which runs automatically when an object is created from a class, and function overloading, such as one Sum function taking two, three or four numbers.23:32
    4. Goal-Oriented Programming (4)Explains the constructor and function overloading in a class, passing values when creating an object, making class members Private and accessing them through functions, before moving to error handling.15:26
    9

    Debugging Programming Errors

    2 lectures
    1. Debugging Programming Errors (1)Explains the types of programming errors: syntax errors, logic errors such as a wrong calculation, and runtime errors such as entering text instead of a number, then handling them with Try Catch.12:26
    2. Debugging Programming Errors (2)Continues error handling with Try and Catch: handling several expected errors with different Catch blocks, the square root of a negative number, a general Catch for the unexpected, a Finally block, and a wrap-up of book one.9:38
    10

    Database Concepts

    3 lectures
    1. Database Concepts (1)Outlines the second book: database concepts such as columns, rows, primary and foreign keys, then SQL, ADO.NET programming, reports, custom controls, web programming, and XML.3:53
    2. Database Concepts (2)Introduces databases and the importance of information systems, management programs such as Oracle, SQL Server and Access, and their structure of tables, rows (records) and columns, using employee data as an example.12:52
    3. Database Concepts (3)Continues database concepts with the Primary Key that uniquely identifies each row and rejects duplicates, and the relation between two tables through a Foreign Key, using a job number in an employees table.5:01
    11

    SQL Structured Query Language

    6 lectures
    1. SQL Query Language (1)Introduces SQL (Structured Query Language) as a set of commands rather than a programming language, with commands close to English, then preparing a database in SQL Server and creating a table with columns and their types.12:47
    2. SQL Query Language (2)Explains how SQL commands are grouped by purpose into three types, and applies Create Table with column types, altering a table to add a column, and removing a table with Drop Table.11:50
    3. SQL Query Language (3)Explains SQL commands for working with table data: Insert to add rows, Delete with Where to remove a specific row, Update to modify a row, Select to display, and Commit to confirm or undo.7:23
    4. SQL Query Language (4)Continues SQL commands inside Visual Studio: inserting rows with INSERT, selecting specific columns with SELECT, adding a calculated column such as tax, applying WHERE conditions with AND and OR, and introducing LIKE.10:02
    5. SQL Query Language (5)Covers SQL's LIKE with the % wildcard for matching a starting letter, BETWEEN and NOT, descending ordering, then GROUP BY with SUM, AVG, MIN, MAX and COUNT, and applying WHERE before grouping.10:28
    6. SQL Query Language (6)Explains the SQL Subquery inside SELECT to find an employee's department colleagues, then JOIN between the employees and departments tables after creating a Departments table and using table aliases.8:45
    12

    ADO.NET

    6 lectures
    1. ADO.NET (1)Introduces ADO.NET as Microsoft's set of classes for working with databases in code, preparing a form for saving and deleting, and setting up the data source and connection to a local database file.10:39
    2. ADO.NET (2)Explains the core ADO.NET classes for working with a database: Connection, Command and DataReader, building a screen that opens the connection and confirms success, ahead of Select, Insert, Update and Delete.11:42
    3. ADO.NET (3)Builds a graphical interface for the database program: a button that opens the Connection and uses a DataReader to display data, then a second form for searching, with variables declared at class level.11:07
    4. ADO.NET (4)Explains running save, delete and update operations on a database through ADO.NET, how queries differ from them, and tests inserting a record with a duplicate ID to show the database rejecting it.11:25
    5. ADO.NET (5)Explains connecting to SQL Server through SqlClient: getting the Connection String and opening the connection, then Command and DataReader, and using a DataAdapter to show data in a grid.6:59
    6. ADO.NET (6)Explains the offline database approach: working on a copy of the data without a live connection using DataSet, DataAdapter and an OleDb connection string, showing data in a grid, then leading into Crystal Reports.13:14
    13

    Reports

    1 lectures
    1. ReportsExplains the importance of reports in database applications from the programmer's view, the Crystal Reports tool from SAP for building them, and that no version was available for Visual Studio 2019 at recording time.4:21
    14

    Different Types of Data

    3 lectures
    1. Different Data Types (1)Covers String functions: getting a text's length, finding the position of a character or part, extracting the remaining text, removing spaces with Trim, and checking whether text starts or ends with something.22:55
    2. Different Data Types (2)Adds working with the Clipboard to copy and paste text in code, then math functions such as Max and Min for the largest and smallest value, dropping the decimal part, ahead of dates.15:09
    3. Different Data Types (3)Explains working with dates: showing today's date in various formats for year, month, day and time, adding days to a date, computing recurring installment dates, and finding the difference between two dates.17:24
    15

    File Handling

    2 lectures
    1. File Handling (1)Explains working with files and streams in Visual Basic .NET: using the File class from System.IO to read and write a text file, picking the file with a dialog box, and showing its content in a TextBox.16:07
    2. File Handling (2)Explains working with files and streams: machine information such as its name via My.Computer, the KeyDown event, checking a file exists, and reading a text file's content into a TextBox.14:07
    16

    Drawing Functions

    1 lectures
    1. Drawing FunctionsIntroduces the ready-made Graphics drawing functions in Visual Basic, using a Pen to draw lines and rectangles, changing dimensions, and printing text in a chosen font, before moving on to custom components.17:43
    17

    Tools and Library Creation

    2 lectures
    1. Tools and Library Creation (1)Explains creating a Class Library containing add, subtract, multiply and name functions, then adding it as a reference in another project and creating an object of its class to call the functions.11:45
    2. Tools and Library Creation (2)Explains building a custom Windows Forms Control Library by creating a clock from a Label and a Timer that updates every second, then adding it to the toolbox and using it in any project.7:19
    18

    Web Application Programming

    6 lectures
    1. Web Application Programming (1)Introduces web programming with ASP.NET and why it is better to host an application on a server instead of copying it to every machine, with a quick idea of HTML and JavaScript before moving to ASP.NET.9:04
    2. Web Application Programming (2)Introduces HTML as tags describing a web page, with the html, head, title and body structure, creating a page and opening it in a browser from Visual Studio, and the idea of CSS files for styling.5:22
    3. Web Application Programming (3)Continues web programming with page styling using CSS, closing every opened tag such as the h1 heading, linking a ready-made style file to the page, and applying classes to style buttons and other elements.10:27
    4. Web Application Programming (4)Introduces web programming basics: JavaScript running on the user's side inside the page, and jQuery as ready-made JavaScript code, as a lead-in to ASP.NET.6:23
    5. Web Application Programming (5)Starts a web project in Visual Studio by building a calculator page with text boxes and buttons, converting text to numbers, and notes the error that appears with an empty field, to be handled with a condition next.18:40
    6. Web Application Programming (6)Explains input validation controls in ASP.NET such as required field, compare and pattern checks, with error messages, then AJAX for updating part of a page without posting the whole page back.7:09
    19

    Using XML Markup Language

    3 lectures
    1. Using XML Markup Language (1)Introduces XML as a way to represent data with opening and closing tags, like a table with rows and columns, readable from any programming language, leading into creating an XML file in Visual Studio.8:37
    2. Using XML Markup Language (2)Explains creating an XML file, putting the declaration line at its start so any program recognizes it, opening it in a browser to check validity, writing custom tags, and exporting database data to XML.6:55
    3. Using XML Markup Language (3)Explains handling XML files in VB.NET code: writing data to a file and reading it back by looping over elements, when XML suits small data without a database, and a wrap-up of the book.9:07
    20

    Books

    2 attachments
    1. Visual Basic (Basic Tasks)
    2. Visual Basic (Advanced Tasks)
    21

    Extensions

    1 attachments
    1. Download Course Attachments

    Instructor

    Eng. Azab Mohamed Azab

    Eng. Azab Mohamed Azab

    Lecturer at the Arab Academy for Science, Technology and Maritime Transport, and the Egyptian Ministry of Interior, specializing in technology and information.
    68.8K views28 courses

    Related courses