Posts tagged ‘Database’

I created a third ASP.NET online class called Database Web Development with ASP.NET at LVS Online.com.

This 6-week class will focus on how you can interact with databases such as SQL Server, MySQL and Microsoft Access using ASP.NET and C#. I start with the very basics on explaining how to use data source controls and objects in ADO.NET (Connection, Command, DataReader and DataSet) to retrieve, update and delete records in a database.

The great thing about ASP.NET is that you can work with almost any data source and are not limited to a Microsoft based technology. I provide a sample database in three separate versions (SQL Server, MySQL and Microsoft Access) and explain how SQL (Structure Query Language) statements are used to interact with your data.

The class is only $30 and there are no other materials or software needed.

Topics Covered:

Week 1: Database Overview (SQL Server, MySQL, Microsoft Access)
Week 2: Using SqlDataSource; SELECT statement and filtering data
Week 3: ADO.NET Review; Connection, Command and DataReader objects
Week 4: Updating and Inserting data (using data controls and ADO.NET objects)
Week 5: Databinding Techniques with GridView and DetailsView controls
Week 6: Understanding Stored Procedures (SQL Server and MySQL)
Extra: Concurrency issues and Transaction benefits

To give you an idea of how each lesson looks, here is the first lesson (.pdf).

When Does Class Start?

The class runs five times a year for six weeks in January, March, May, August and October. To learn more view the course description page and contact me to find out the exact date on when you can register.

SQL Injection is subset of the an unverified/unsanitized user input vulnerability, and the idea is to convince the application to run SQL code that was not intended. If the application is creating SQL strings naively on the fly and then running them, it’s straightforward to create some real surprises.

For people who use databases for web applications, the threat of attacks is great no matter how small or large your database is. It doesn’t matter what type of database you use either (SQL Server, ORACLE, MYSQL, etc.).

As long as there are hackers out there, your data is at risk.

Here is a great guide (.pdf) written by Martin G. Nystrom that the web developer, DBA or even website owner can benefit from to help them understand how data is vulnerable on the web and learn some of the “defenses” to try and prevent it.

I am teaching database-based ASP online class called ASP E-Commerce Database Basics at LVS Online.com.

This 6-week class will teach you how to interact with a database by displaying, retrieving and updating data. The class is a continuation from where I left off from my Basic Web Applications with ASP class.

The class is only $30 $15 and there are no other materials or software needed.

The class learning level is “intermediate” which means taking the basics you already know and developing a usable web application. The class uses a simple Microsoft Access database (provided), but you can use almost any type of database with minimal code changes.

Topics Covered:

Week 1: E-Commerce types; Overview of ADO; Connecting to our database
Week 2: SQL basics: SELECT, WHERE, ORDER BY, LIKE
Week 3: SQL continued: INSERT INTO and UPDATE; Managing our Products
Week 4: Recordsets and Pagination; Creating a Search
Week 5: Shopping Cart pt 1
Week 6: Shopping Cart pt 2; Checkout Process

The Online Store gives students a good example to use and refer to when they need to create their own database-driven dynamic web sites.

Here is the first lesson (.pdf) for you to see how it looks.

When Does Class Start?

The class runs five times a year for six weeks in January, March, May, August and October. To learn more view the course description page and contact me to find out the exact date on when you can register.

I only cover the basics of ADO in this class, but if you need addtional reference material here is an ADO Reference Guide (.pdf) by DevGuru.