Archive for the ‘MySQL’ Category

MySQL Advanced Closed Captioned Training Video – Backup and Restoring Databases

Friday, July 15th, 2011

In this important closed captioned video tutorial from our Advanced MySQL Course, we show you how to do backups and restore your data with the help of the MySQL Dump function!

We are happy to announce that we are well on our way to closed captioning all of our Web Design and Web Programming related video training courses.

To find courses on PHP, check out our Killersites Video Tutorial Library!

Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
killersites.com

Tags: , ,
Posted in MySQL Closed Captioned Videos | Comments Off

MySQL Advanced Closed Captioned Training Video – Introducing Many to Many

Monday, July 11th, 2011

In this closed captioned video tutorial, we teach you about many to many relationships in your tables. From our Advanced MySQL Course!

We are happy to announce that we are well on our way to closed captioning all of our Web Design and Web Programming related video training courses.

To find courses on PHP, check out our Killersites Video Tutorial Library!

Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
killersites.com

Tags: , ,
Posted in MySQL Closed Captioned Videos | Comments Off

MySQL Advanced Closed Captioned Training Video – Joins with Constraints

Friday, July 8th, 2011

In this closed captioned video tutorial, we teach you how to create constraints to give your data integrity, as well as left and right (inner and outer) Joins. From our Advanced MySQL Course!

We are happy to announce that we are well on our way to closed captioning all of our Web Design and Web Programming related video training courses.

To find courses on PHP, check out our Killersites Video Tutorial Library!

Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
killersites.com

Tags: , ,
Posted in MySQL Closed Captioned Videos | Comments Off

MySQL Advanced Closed Captioned Training Video – Introducing Joins

Monday, July 4th, 2011

In this closed captioned video tutorial, we teach you about Joins, what they are in a relational database and how to perform more advanced operations in MySQL! From our Advanced MySQL Course.

We are happy to announce that we are well on our way to closed captioning all of our Web Design and Web Programming related video training courses.

To find courses on PHP, check out our Killersites Video Tutorial Library!

Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
killersites.com

Tags: , ,
Posted in MySQL Closed Captioned Videos | Comments Off

MySQL Advanced Training Video – Introducing MySQL Search Part 1

Wednesday, December 29th, 2010

In this MySQL Search video tutorial from our MySQL, SQL & PHP course, we start to show you how to leverage the MySQL search engine!

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

MySQL Advanced Training Video – Backup & Restoring Databases

Monday, December 27th, 2010

In this important video tutorial from our MySQL, SQL & PHP course, we show you how to do backups and restore your data with the help of the MySQL Dump function!

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

MySQL Advanced Training Video – Timestamps, Dates & Ordering Part 1

Friday, December 24th, 2010

This is the beginning of a 3 part video tutorial series, where we teach you about timezones, date intervals and date functionality using MySQL. Also, adding delays and expiration dates for the publishing of content. From our MySQL, SQL & PHP course!

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

MySQL Advanced Training Video – Building Table Views Part 1

Wednesday, December 22nd, 2010

In this exciting video of a 2 part series, we go more in depth with many to many relationships, extending them, as well as showing you how to create various views of your data! From our MySQL, SQL & PHP course.

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

MySQL Advanced Training Video – Introducing Many-to-Many Part 1

Monday, December 20th, 2010

This is the first video tutorial in a 3 part series, where we teach you about many to many relationships in your tables. From our MySQL, SQL & PHP course!

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

MySQL Advanced Training Video – Joins & Constraints Part 1

Friday, December 17th, 2010

This is part 1 in a 2 part series, where we teach you how to create constraints to give your data integrity, as well as left and right (inner and outer) Joins. From our MySQL, SQL & PHP course!

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

MySQL Advanced Training Video – Introducing Joins Part 3

Wednesday, December 15th, 2010

This is part 3 in a 3 part series, where we continue to teach you about Joins using MySQL. From our MySQL, SQL & PHP course!

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

MySQL Advanced Training Video – Introducing Joins Part 2

Monday, December 13th, 2010

This is part 2 in a 3 part series, where we continue to teach you about Joins using MySQL. From our MySQL, SQL & PHP course!

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | 2 Comments »

MySQL Advanced Training Video – Introducing Joins Part 1

Friday, December 10th, 2010

This is the first video in a 3 part series, where we teach you about Joins, what they are in a relational database and how to perform more advanced operations in MySQL! From our MySQL, SQL & PHP course.

To find more courses on Web Programming, check out our Killersites Video Tutorial Library!
Note that all of our videos are in a higher quality when purchased from our Killer Video Store or by subscription to our Video Tutorial Library!

Thanks,

Jody
Killersites.com

Tags: , ,
Posted in MySQL Videos | No Comments »

PHP CRUD Video Course – Part 2

Wednesday, June 2nd, 2010

Hi,

In our continued aim to transform you web guys into full-fledged web programmers, we have yet another cool video tutorial series … this time on basic PHP and MySQL interaction, something the nerds refer to as CRUD.

Check out the second video from the screencast series:

More free samples from this course coming soon.

Stefan Mischook
www.killerphp.com

Posted in MySQL, PHP Videos | 2 Comments »

PHP CRUD Video Course – Introduction.

Tuesday, June 1st, 2010

Hi,

In our continued aim to transform you web guys into full-fledged web programmers, we have yet another cool video tutorial series … this time on basic PHP and MySQL interaction, something the nerds refer to as CRUD.

Check out the first video from the screencast series:

More free samples from this course coming soon.

Stefan Mischook
www.killerphp.com

Posted in MySQL, PHP Videos | No Comments »

Video: MySQL and SQL Joins Part 2

Thursday, March 11th, 2010

Database Image

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

Tags:
Posted in MySQL | No Comments »

New Video: MySQL and SQL Joins Part 1

Wednesday, March 10th, 2010

Database Image

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

Tags:
Posted in MySQL, PHP Videos | 2 Comments »

MySQL video tutorials coming out.

Thursday, March 4th, 2010

Database Image

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

Tags:
Posted in MySQL, News | No Comments »

What are ORM Frameworks – the video!

Tuesday, December 15th, 2009

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

Posted in Advanced PHP, MySQL, PHP Videos | 3 Comments »

What are ORM Frameworks?

Tuesday, December 8th, 2009

Database Image

In the following article we will learn a few things about ORM frameworks:

  • What they are.
  • What they do.
  • When and why to use them.
  • And finally, what ORM options PHP’ers have.

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.

(more…)

Posted in Advanced PHP, MySQL, Object Oriented PHP, PHP Videos | 4 Comments »

« Older Entries
 

Top of page  go to top of page