Post has attachment
We’re moving onward in our MySQL Journey! This episode will take a look at many useful features of the language and how you can use them. As always, we’ll simply be operating on the data that we already have in the friends table we’ve been working with so far. We’ll cover features like group by and aggregate functions. They typically go together, much like peanut butter and jelly. In addition to this, we’ll look at things such as group_concat, having, and order by. Sort orders are important as well so we will look at sorting in ascending order as well as descending order. Lastly, testing out queries using the limit, offset, and functions with order by will be reviewed. Let’s do it!

http://vegibit.com/mysql-group-by-having-limit-offset-and-more/

Post has attachment
MySQL Operators are your friend in fact. In MySQL, just as in all programming languages, we have these nifty little things called operators. Operators are pretty darn important, as they allow us to perform meaningful operations on our data. Some of the MySQL operators include LIKE, LIKE%…%, NOT LIKE, =, !=, REGEXP, REGEXP^…$, NOT REGEXP, =”, !=”, IN(…), NOT IN(…), BETWEEN, NOT BETWEEN, IS NULL, and IS NOT NULL. Wow, that’s a lot of operators. Yep, it sure is. You might be wondering, so how the heck am I going to use all of these operators and what are they good for? Those are great thoughts, and we’ll jump right into some of the more common use cases now.

http://vegibit.com/what-are-mysql-operators/

Post has attachment
MySQL has many built in functions for dealing with strings. Many times, we can perform these operations using whatever programming language we happen to be using with MySQL such as PHP. Other times however, it is really helpful to be able to manipulate strings right in our MySQL statements. In this episode we’ll take a look at working with strings and doing things like setting them to all upper or lowercase, reversing their order, replacing characters with other characters, gluing strings together with concatenation, and much more. Let’s get right to it!

http://vegibit.com/working-with-common-mysql-string-functions/

Post has attachment
It’s been a great MySQL tutorial series so far and now we’re going to dig even further into the language. The introduction to MySQL, data types, declarative nature, and using data manipulation language is a great foundation to start practicing some queries that are just slightly more advanced. Don’t worry, we’re taking baby steps here but there are a bunch of concepts that we need to get our feet wet with. In this episode we’ll be taking a closer look at things like common functions, math operations, dates and times, and lots more. Let’s jump right into the action.

http://vegibit.com/mysql-function-tutorial/

Post has attachment
So far we’ve been hitting what is arguably the more mundane aspects of dealing with Database Administration. This would be the DDL or data definition language portion of working with MySQL. It is by using DDL that we are able to build and modify your databases and tables. Of course this is needed stuff, we need a database and some tables before we can start inserting, reading, updating, and deleting some information. Once we do have our database and tables in place however, we are ready to start applying some DML or data manipulation language commands to work with the actual data. Let’s get cooking!

http://vegibit.com/getting-started-with-data-manipulation-language-in-mysql/

Post has attachment
In this MySQL Series, we first have been taking a look at MySQL and SQL in general from a high level view. With the vocabulary, acronyms, and theory now out of the way, we can not focus on putting pen to paper so to speak. This is where the MySQL Rubber hits the road. We’re going to start working with databases and tables in MySQL, for without them, we’re not going to be able to store or retrieve much data. Let’s dig in.

http://vegibit.com/creating-databases-and-tables-in-mysql/

Post has attachment
We’ve been covering a lot of information about database technology, terms, and ideas so far. Soon we will be diving in to using data manipulation language to insert, update, and delete data in various databases we’ll create. Before we get to that point, we need to take a look at a key aspect of the Structured Query Language in general. This would be the fact that SQL is a Declarative Language, which is very much a different animal altogether from a procedural language. You are most likely much more familiar with procedural approaches in computing. This is why in this episode, we’ll take a closer look at what it means to be a Declarative Language, and how we will need to adjust our thinking to best make use of it.

http://vegibit.com/the-declarative-nature-of-sql/

Post has attachment
Not all data is created equal! We know from working with variables in PHP and JavaScript that variables can hold all kinds of data. MySQL is not different in this sense. The various data types in MySQL will have an impact on how much space on disk the database will use. They will also have an impact on performance. If the data types in use for your fields are not optimized, you could run into a slow running application, with your database being the bottleneck. Now that we have a good Introduction to MySQL under our belt, let’s take a closer look at data types in MySQL and wrap our arms around the nuts and bolts of how they work.

http://vegibit.com/data-types-in-mysql/

Post has attachment
MySQL is the world’s most popular open source database and powers all kinds of different applications in the technology industry. Of course the blogging platform WordPress uses MySQL as it’s database technology, but MySQL goes far beyond just basic blog applications. Some of the biggest names in technology today make use of MySQL, including Twitter, Facebook, Etsy, and more. We also love working with MySQL when writing PHP either natively, or with a great framework like Laravel or Codeigniter. These frameworks do a great job of hiding away the details of how MySQL is working behind the scenes. While this is great, it is really important to have a good grasp of the fundamentals. This series of articles will do just that, dig into the nuts and bolts of what MySQL is, how it works, and how we can leverage its power.

http://vegibit.com/introduction-to-mysql/
Wait while more posts are being loaded