Hi,
We continue from where we left off in part 1 of our video on SQL joins. Still setting up things to do our SQL work, in this particular video, we continue to build our MySQL table.
The video:
There will be several other sample videos to come, but if you want them all NOW, (at the risk of being a shameless self promoter!) you can pick the entire 4hrs of the MySQL and SQL course in the killer video store.
Thanks,
Stefan Mischook
www.killerphp.com
Hi,
I just released the first of many videos on more advanced SQL and MySQL than we’ve covered before. From the courses description:
This course teaches you the very basics of MySQL, SQL then shows you how to use PHP with them. Once you have that under your belt, we jump into more advanced SQL and MySQL.
In this free sample video, we prepare our environment (MySQL) so we can start working with on SQL join queries:
There will be several other sample videos to come, but if you want them all NOW, (at the risk of being a shameless self promoter!) you can pick the entire 4hrs of the MySQL and SQL course in the killer video store.
Thanks,
Stefan Mischook
www.killerphp.com
Hi,
I haven’t been working on killerphp for a little while because of work on other websites in the killersites network … OK, and other things too.
… Xbox can take up a lot of time!!
What’s news?
Well, we have a whole slew of advanced MySQL videos coming out within a week. We will be covering some more advanced topics not covered in our PHP basics video course.
As usual, many of the videos will be posted here for free and many others will be available via our video tutorial subscription service and also as a complete stand-alone screencast course for download or on DVD.
Thanks,
Stefan Mischook
www.killerphp.com
Hi,
I decided to create a video based on my recent article on ORM frameworks. I shot this in HD … so select the HD option if you got big pipes.
Let me know what you think.
Stefan Mischook
In the following article we will learn a few things about ORM frameworks:
Let’s start …
If you’re working with PHP, you will certainly find yourself working with relational databases (like MySQL) sooner or later. Anyone who has ever built a reasonably complex web application knows, that the SQL can get really hairy at times – especially when you consider all the data filtering that you have to deal with!
ORM frameworks to the rescue!
ORM is yet another nerd-acronym, it is short for Object Relational Mapping. In a nutshell, an ORM framework is written in an object oriented language (like PHP, Java, C# etc…) and it is designed to virtually wrap around a relational database. If you look at the name (ORM), it basically translates into: mapping objects to relational tables.
There are many different competing ORM frameworks out there, because many nerds have their own ideas as to how to best do things – nothing new here! But you know what, some of these nerds are right … not all ORM frameworks are created equal.
Hi,
I just released a podcast that introduces you to the basics of databases. Targeted at total beginners, I look at the three types of databases out there along with some other foundation stuff so that when you get into database driven websites .. you will hit the ground running.
Check it out:
For reasons I cannot explain, I’ve placed the podcast/audio session in the killersites.com magazine.
Thanks,
Stefan Mischook
www.killersites.com
www.killerphp.com
Hi,
I’ve finally released my first video on using SQL statements in PHP pages. This is the next step after connecting to a MySQL database.
I hope you find the videos useful.
Stefan Mischook
www.killerphp.com
Hi,
I’ve managed to upload new video tutorials on SQL basics. At this point, I’ve covered the four big SQL statments:
You can view the videos here: Basic SQL Statements Video Tutorials.
Now that we have that covered, my next videos will be on using PHP to connect to and work with MySQL.
Thanks,
Stefan Mischook
www.killerphp.com
Hi,
I’ve just put up a new sub-section on SQL – the language of relational databases.
This is beginners stuff, so if you’re a know-it-all nerd, you can ignore this. On the otherhand, if you’re new to the database thing (mySQL for example) then these first couple of videos should help you get started.
Videos out so far:
- Introduction to SQL
- Introduction to the SQL ‘insert’ statement.
I plan on having a bunch of new videos out soon that cover:
My goal is to not turn you guys into database gurus, rather, I want to just give you enough so we can get you going with PHP and mySQL.
Thanks,
Stefan Mischook
www.killerphp.com
Hi,
I finally got around to creating a new section dedicated to teaching basic MySQL.
At this time, I only have a few videos on basic database theory and phpMyAdmin … the most commonly used administrative program for MySQL.
But I have several others in the works.
Thanks,
Stefan Mischook
www.killerphp.com
