MySQL is by far the most popular database management system for small- to medium-sized web projects. Only the proprietary Oracle database and the small embeddable SQLite are more widely deployed. MySQL is named after the eldest daughter of Ulf Michael Widenius, the main author of the original version of MySQL whose daughter's name is My.
MySQL routines the Structured Query Language also known as SQL to define, update and query the database. SQL is used on fundamentally all major relational database systems, on many platforms and in many applications. I will cover the necessary skills to use and program a database using MySQL. It is the nature of database management systems that there is marvellous divergence between how SQL is implemented in each system. Most of this course is keen on showing you how SQL is implemented by MySQL and how it can be used effectively in your database applications.
In this course, I will provide clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. We will start with the basic syntax of SQL as it's implemented by MySQL. I will explain how to use the select statement, and how to create, update, and delete data from your tables. I'll show you specifically where the MySQL version of SQL differs from the standard, and how to get the most out of MySQL specific dialect.
I also will explore the
Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.
I will cover creating and deleting databases, data types, transactions, sub selects, views, and stored routines. And finally, I will show you a full working CRUD application. CRUD is an acronym for Create, Read, Update and Delete. MySQL is one of the most widely deployed database management systems in the world. Understanding MySQL will serve you well in your database applications.
Hi My name is Amir Hassan Azimi and I am a software engineer and a web developer. My second job is to produce videos about technology and computers for people all over the world. I have first class degree with Honours one of the top universities in London and I am working towards the best technologies about software, coding and he web. I understand most of the programming languages mainly web based languages. I continuously enjoy learning new technologies exclusively programming languages by watching tutorials instead of reading books and this is not mean I don't read books at all. Subsequently, reading a lot of books about computers and watching more video lectures about programming and web developing, I educated a lot of new subjects and I decided to make the professional tutorials. I am obsessed with everything about computers and fascinated by everything about programming which leads me to build things like a puzzle. By reading books I noticed they do not have that impression, sense and excitement similar to videos. I do not mean they are useless, what I mean is they are far away from fun, practical, excitement and walking through each lesson. I noticed something else and that was lack of video tutorials about computing for Persians and Farsi speaking people and that must be because of low Internet speed and Internet censorship. I found Udemy is not censored in Iran but YouTube is and that was a great news for me, which made my students asking me to find a way to allow them to download my videos. I am sure some people do not learn only by reading as some people do. Most people who computing is their career are practical people rather than people with humanity subjects, one them is myself. I am a practical person, I learn by watching. Therefore, I decided to make video tutorials. Today I am the only best Persian tutorial source for all Persians and the only one who makes really professional tutorials with great video and audio quality. If you watch my tutorials you will notice I really care about every single video tutorials I make and I have so much respect to Udemy academy which I think it is one of the best ideas.