Feeds:
Posts
Comments

Posts Tagged ‘MySQL’

Here are few of the question I often receive -

  • Do you know anything besides SQL Server?
  • So how does it feel when the only thing which you know is SQL Server?
  • Have you worked in the past with any other programming language?

Actually, I find these questions very interesting as I do work with other technologies and I still do work with many other technologies besides SQL Server. Recently I got the opportunity to work with MySQL and have also built quite a lot of knowledge about the application as well. I found MySQL very interesting and easy to learn. It is the most popular database technology since the year 2008 and used by most numbers of database professionals in the world (including me). The latest version of MySQL is very popular and it is very easy to install on Windows Platform. One just has to download MySQL Installer and execute it. Just click next, next and you are done!

Though, MySQL is very easy I have noticed that not everyone knows it well. The pace of the software industry has changed and people change their expertise quite frequently based on the project they are assigned. There are two kinds of beginners in the industry 1) Those who have very little experience in the software industry and just beginning their career in this field. 2) Those who have plenty of the years of the experience but beginning their career in the particular technology. When you look at both the kinds of the people they both need training but they have different level of understanding of the subject matter.

Looking at this, I decided to build a beginners course on MySQL which addresses both the kinds of the people 1) Beginners with IT field and 2) Beginners with MySQL technology. I have build following beginners course on MySQL Technology. This is part 1 of the course and for anyone who wants to learn MySQL at express speed. The length of the course is 2 hours and 37 minutes, this means anyone can learn the fundaments of the MySQL in a very short period of the time.

You can watch this entire course of Fundamental of MySQL at Pluralsight. To watch the course, you will have to subscribe to Pluralsight library. If you do not have a subscription you can opt for a FREE Trial. If you go to the page and do not see any link enable, please login to Pluralsight and you should be able to watch this course.

Here is the video teaser which I have build for this course. Let me know what you think about it. Here is the content of the course.

  • Introduction to MySQL
  • Getting Started with MySQL and GUI Tool
  • Fundamentals of RDBMS and Database Designs
  • Introduction to MySQL Workbench
  • Data Retrieval Techniques
  • Data Modification Techniques
  • Summary and Resources

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

Read Full Post »

Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure. SSMA 2008 for MySQL v1.0 CTP1 provides an assessment of migration efforts as well as automates schema and data migration.

Download Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1

Download Microsoft SQL Server Migration Assistant 2005 for MySQL v1.0 CTP1

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure.

Download Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

Here is the quick link from where SQL Server 2008 Express Edition can be downloaded.

Download SQL Server 2008 Express Edition

You can download it with many additional details as described in following image. Click on above link to go to page and select desired version.

Additionally, please install SQL Server 2008 Express Service Pack 1.

You can read one of my previous article where I have covered SQL Server 2008 Express in detail SQL SERVER – SQL Server Express – A Complete Reference Guide.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

Guide to Migrating from MySQL to SQL Server 2008
In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server.

Guide to Migrating from Oracle to SQL Server 2008
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2008. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant (SSMA) 2008 for Oracle is explained in depth, with a special focus on converting database objects and PL/SQL code.

Guide to Migrating from Informix to SQL Server 2008
This white paper explores challenges that arise when you migrate from an Informix 11 database to SQL Server 2008. It describes the implementation differences of database objects and procedural code between the two platforms. Emulation of system functions is also discussed.

Guide to Migrating from Sybase ASA to SQL Server 2008
This white paper explores challenges that arise when you migrate from a Sybase Adaptive Server Anywhere (ASA) database of version 9 or later to SQL Server 2008. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms.

Guide to Migrating from Sybase ASE to SQL Server 2008
This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2008. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant, the best tool for this type of migration, can help resolve various migration issues.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

Older Posts »