Course info

Rating

(720)

Level

Intermediate

Updated

Apr 29, 2013

Duration

2h 37m

Description

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as write basic data retrieval and data modification queries.

Section Introduction Transcripts

Installations and GUI ToolsThis is Pinal Dave for Pluralsight. In this module we'll get started with MySQL and GUI Tool. This is Fundamentals of MySQL Course so we are assuming that we are all beginners. The biggest issue with any beginner is to start and get going. Similarly, the biggest issue with any developer is to install the product, configure it, and get started with it. MySQL installation is very simple and if any developer is not starting learning MySQL because he or she thinks that installation is very complicated or difficult, I personally do not agree with it. In this course, we will install MySQL and all related tools live. We will see how easy and fast the entire process is. Additionally, we will also install and get started using MySQL Workbench. It is the most popular GUI Tool to work with MySQL.

Fundamentals of RDBMS and Database DesignsHi, this is Pinal Dave for Pluralsight. In this module, we will cover Fundamentals of RDBMS and Database Designs. In the last module, we learned how to install MySQL and GUI Tool, MySQL Workbench. Before we start with MySQL Database architecture design and object creation, it is a good idea to understand Fundamentals of RDBMS and Database Design. In this module, we will understand what is Client/Server System architecture, how Web Application Server and Database work together. Additionally, quickly we will see History of Relational Database Model and right after that we will understand Key Concept of RDBMS. We will understand what is table, column, rows, cells, and a few other key concepts.

Introduction MYSQL WorkbenchHi, this is Pinal Dave for Pluralsight. In this module, we will understand how MySQL Workbench works and various features of it. In an earlier module, we had a little bit introduction to MySQL Workbench. In this module, we will understand MySQL Workbench a little bit more in depth. Now, the next logical step is to learn about coding and building the database. However, before we move to that one, we need to learn about how we can use MySQL Workbench efficiently to build a work database. MySQL Workbench is a Visual Database Design Tool. It is a three main workspace. One is Development, second is Design, and third is Administration. In this module, we will understand each of them a little bit; however, we will spend more time on development-related features of MySQL Workbench.

Data Retrieval TechniquesHi, this is Pinal Dave for Pluralsight. In this module, we will discuss about various Data Retrieval Techniques. For any IDBMS, data retrieval is the most essential task. In an earlier module, we learned we can use MySQL Workbench to retrieve and modify data. MySQL Workbench is a great tool for developers who have to deal with the data. For any application, you have to write scripts in SQL to retrieve or modify data. SQL stands for Structure Query Language. In this module, we will learn how to code SELECT statement and retrieve data. It is very important to have proper understanding of how SELECT statement works and its building blocks. All the concepts, which we learn about SELECT statement, applies to update and delete statements, which we will explore in the next module of data modification. Let's start to understand the basics of SELECT statement and it's most essential building blocks -- WHERE, ORDER BY, and LIMIT.

Data Modification TechniquesHi, this is Pinal Dave for Pluralsight and in this module, we will discuss about Data Modification Techniques. Our major focus in this module will be on INSERT, UPDATE, and DELETE Statement. With UPDATE and DELETE, we will be also using WHERE clause. All the operators and phrases, which we have learned in an earlier module, will apply over here as it is. Each of the statements have two clear distinct areas. The first area is how to modify a single row and second area is how to modify multiple rows. Also, it's not a good idea to modify your live data. For the same reason, I'll be creating a sample table and will be doing all the operations on top of sample table. Let's start with INSERT Statement.

Summary and ResourcesHi, this is Pinal Dave for Pluralsight. In this module, we will talk about Summary and Resources. So far, we have learned Installation of MySQL Server, MySQL Workbench, and MySQL Sample Databases. All of these components and all other components are installed by default. Later, we learned MySQL Workbench and three of its major sections -- SQL Development, where we connected to existing database and ran SQL queries; Data Modeling, where we created and managed EER models; Server Administration, where we configured Database Server and set up user accounts. Later, we spent time on Relational Database Management System and Database Design Concepts. We also learned in depth various techniques for data retrieval. In Data Retrieval Techniques, we focused on SELECT, WHERE, ORDER BY, and LIMIT clauses. Finally, we spent a lot of time on Data Modification Techniques. We learned how we can modify our data using INSERT, UPDATE, and DELETE. Well, here are a few of the important resources. Well, I thank you very, very much for spending time learning with me, MySQL Fundamentals Part 1. In Part 2 of MySQL Introduction, we will learn Joins, Functions, Views, Transactions, Stored Procedures, Stored Functions, Triggers and Events. Thank you and we will meet in MySQL Introduction Part 2.