Here’s a list of slides I’m developing for the MySQL talk I’m giving at VSLive next month. This talk is intended for developers who are proficient with .NET and some kind of relational database but with with little or no exposure to MySQL. I am pretty sure that the talk is going to be 60 minutes in duration, so 30-40 slides should be about right.
Did I leave anything important out? Let me know in comments — thanks!
- What is MySQL?
- Meta: About Open Source Software
- Obtaining MySQL
- Installing MySQL
- Configuration
- Jeffrey’s my.ini File
- Gotcha: Security Settings
- Command-Line Tools
- MySQL GUI Tools
- Visual Studio Integration
- MySQL Administrator
- MySQL Query Browser
- Creating a schema
- Pluggable Storage Engines
- Data Types
- Enumerations
- Gotcha: Set DATETIME Defaults
- Unicode Support
- MySQL Query Manager
- MySQL ODBC Driver ("it exists")
- MySQL ADO.NET Provider
- Creating a DataReader
- DataReader with Parameters
- DataSet
- Subselects
- Use LIMIT N instead of TOP N
- Stored Procedures
- Transactions
- Triggers
- Clustering
- Replication
- Architecting for Scalability
- References
Related posts:
Jeffrey,
Is it possible for you to video this talk? I’d love to put it up (with proper credits to you of course!) at http://www.technocation.org as a video resource (Technocation would pay for the bandwidth and such).
If you have a video camera but not a way to digitize it, I have that capability for a regular DV tape (just send it to me), or a VHS-C (or HG/Super HG) tape — basically, I think any of the compact analog tape (that’s approximately 3.5″ x 2.5″)).
Anyway, let me know — if you can’t video, can you audio record? E-mail me (if my e-mail didn’t come through, check out http://www.sheeri.com for my contact info…
How about “Why/when should you use MySQL instead of MSSQL on .NET?” and “Why/when would it be a bad choice?”
I don’t think that VSLive makes any of their content available online — they want you to attend the conference. It’s possible that if the talk is well received they will ask me to give it again at their other conferences later in the year.
I’m actually going to steer clear of MySQL/MS SQL comparisons, mainly because I’m a little out of date on MS SQL. (I haven’t used the 2005 version at all.)