Database Web Development with ASP.NET Class
Post on June 10th, 2009
This course will be re-created to include new material from two other classes for a 10-lesson class.
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.
From ASP.NET, Closed Online classes
3 Comments ‘
1.
Donna Vetters permalink
Although I am a professional voice artist on the side my 9-5 job decided to fund me to become a programmer. This was the second course I took with LVS and Frank and I could not be happier with the results.
I took some of my introductory classes with my community college online and I didn’t have problems starting with Frank and LVS because Frank was very patient and helpful throughout. Even when I had problems with uploading to hosting sites we worked around that together and I was able to get a really good grasp of the basics, as well as in this Web Development class, some of the advanced techniques.
I have been recommending LVS and Frank to many of my collegues who are looking to learn how to do data analysis as well as programming skills because you just can’t beat the price and the level of attention you get for that price. I will keep coming back to learn more!
Thanks Frank for all your help and pearls of wisdom!
Reply
2.
Patti permalink
Hi,
I got so much out of this course felt should write about it.
I took the Database Web Development with ASP.NET Class and the previous ASP.NET classes from Frank at lvsonline. This course was for filled with information on connecting the database to your asp.net pages and how they communicate with each other. The reading is easy to understand and not boring and samples files are included.
I’ve spent money to learn asp.net on books and another online course that cost $295. I learned so much more from this course and hello it’s only $25!
When I got stuck on a lesson assignment Frank was very helpful and I figured things out with his help. I didn’t get that from a book. Knowing that someone is there to move me along was extremely valuable.
You will need to spend time on each lesson and if you do you will have the knowledge of asp.net connecting to a database and your wallet will still have money in it:)
Sometimes most expensive is not the best. This is the case for this course and Frank’s other asp.net courses. I’ve taken them all and learned a lot.
Patti Byrne
lvsonline student
Reply
o
permalink
Thanks Patti!
It was a pleasure having you as a student for my classes.
Leave a Reply
Name (required): Email (required): Website: Comment:
Note: XHTML is allowed. Your email address will never be published.
ActionScript 3.0 Basics for Designers
Understanding T-SQL using SQL Server
jQuery: Enhancing Web Development
Introduction to ASP.NET Web Development
JavaScript Programming: From Basics to DOM
All online classes are available for download via PayPal. All lessons (.pdf) are emailed by instructor within 48 hours of purchase. Questions can be posted on the site or emailed directly via the contact page.
The Understanding WordPress and Learning Drupal courses run continuously and is paid through this site, so you can register at any time.
Recent Posts
·HTML5 and CSS3
·How to Install the Drupal AMP Stack from Acquia
·Lost Drupal Login Box ” oops!
·Learning Drupal Online Courses
·ActionScript 3.0 Basics for Designers Class
·Understanding T-SQL using SQL Server Class
·jQuery: Enhancing Web Development Class
·Beginning ASP.NET AJAX Web Development Class
·AJAX 101 ” part 2
·JavaScript Magazine ” JsMag
·AJAX 101 ” part 1
·Database Web Development with ASP.NET Class
·Creating Even Faster Websites Podcast
·Understanding WordPress: Top Ten SEO Tips
·Understanding WordPress Online Courses
Categories
·Adobe Flash (9)
·Ajax (4)
·ASP (2)
·ASP.NET (8)
·Closed Online classes (4)
·CSS (11)
·Dreamweaver (2)
·Drupal (2)
·Fun (1)
·HTML (4)
·Interviews (6)
·JavaScript language (1)
·JavaScript topics (24)
·jQuery (6)
·Online classes (7)
·PHP (8)
·Podcasts (9)
·SQL (2)
·Video tutorials (7)
·Web conferences (2)
·Web stuff (13)
·WordPress (2)
Popular tags
“John Resig” ActionScript 3.0 Adobe Flash Ajax Apache ASP ASP.NET blogging C# Christian Heilmann Class Classes and Training CSS Database DOM Dreamweaver Flash CS3 Functions Hover Effect Interview JavaScript topics Jeremy Keith jQuery Learning libraries LVSOnline MySQL Online classes PHP Podcast Presentational Markup presentations SQL Server Styling tutorials video tutorials Web conferences Web Design Web Development Web Training WordPress XHTML XML XSLT Yahoo
Notable Blogs
·Aaron Newton
·Airtight Interactive
·Ajaxian
·Alex King
·Andy Budd
·Andy Clarke
·Andy Rutledge
·Bob Easton
·Brian Goldfarb
·Cameron Adams
·Cameron Moll
·CartoonSmart
·Chris Heilmann
·Dan Simard
·Dan Wahlin
·David Stiller
·Dustin Diaz
·Eric Meyer
·Geoff Stearns
·Independents Hall
·Jacob Seidelin
·James Edwards
·Jeremy Keith
·John Musser
·John Resig
·Jonathan Christopher
·Jonathan Snook
·JSMag
·Justin Palmer
·Matt Snider
·Michael Mahemoff
·Milan Negovan
·Molly Holzschlag
·Nate Koechley
·Paul Boag
·Peter-Paul Koch
·Robert Nyman
·Roger Johansson
·Samuel Ryan
·Sarah Lacy
·Saul Rosenbaum
·School of Flash
·Scott Andrew LePera
·Scott Guthrie
·Scott Mitchell
·Scott Schiller
·Shaun Inman
·Steve Sharrock
·Tina Su
·Understanding WordPress
·WebAppers
About
This site started back in September 2005 as an online resource for my training at a local computer club. The material was based upon taching people how to do web programming with JavaScript.
It then expanded over the years to offer online classes (in JavaScript and ASP.NET) to anybody as well as more of a wider range of topics inlcuding HTML, CSS, PHP, ASP.NET, Flash, etc.
Feel free to contact me if you have any question on the online classes I offer or material covered.
Flickr
Search