2015
Udemy
Hassan Azimi
06:15:03
English

A guide to work with MySQL and it's syntax, CRUD, data types, transactions, sub selects, views, and store routines.
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.

Udemy - Everything About MySQL Database (2015)
├── 01 Introduction
│ ├── 001 Welcome.mp4
│ ├── 002 What is MySQL.jpeg
│ ├── 002 What is MySQL.mp4
│ ├── 003 Using The Files.mp4
│ ├── 004 Installation Information.mp4
│ ├── 005 Setup a Package Manager.mp4
│ ├── 006 Setup Working Environment.mp4
│ └── 007 Changing Time Zone for MySQL.mp4
├── 02 MySQL Syntax
│ ├── 001 SELECT, Keyword, Expressions and Functions.mp4
│ ├── 002 Row Selection.mp4
│ ├── 003 Column Selection.mp4
│ ├── 004 ORDER BY ASC and DESC.mp4
│ ├── 005 WHERE Clause.mp4
│ ├── 006 LIKE and IN Clauses.mp4
│ ├── 007 REGEXP and RLIKE.mp4
│ ├── 008 Using INSERT INTO to Insert Data.mp4
│ ├── 009 Using UPDATE SET to Update Data.mp4
│ ├── 010 DELETE and DROP.mp4
│ ├── 011 Strings.mp4
│ └── 012 What is NULL.mp4
├── 03 Creating Database
│ ├── 001 CREATE and USE DATABASE.mp4
│ ├── 002 Using Tables.mp4
│ ├── 003 Using Indexes.mp4
│ ├── 004 Using Constraints.mp4
│ ├── 005 AUTO_INCREMENT, PRIMARY KEY and SERIAL.mp4
│ ├── 006 FOREIGN KEY.mp4
│ └── 007 ALTER TABLE.mp4
├── 04 Data Types
│ ├── 001 Data Type Introduction.mp4
│ ├── 002 Numeric Types.mp4
│ ├── 003 String Types.mp4
│ ├── 004 DATE and TIME Types.mp4
│ ├── 005 BIT.mp4
│ ├── 006 BOOLEAN Types.mp4
│ └── 007 ENUM and SET.mp4
├── 05 Functions
│ ├── 001 String Function.mp4
│ ├── 002 Numeric Functions.mp4
│ ├── 003 Date and Time Functions.mp4
│ ├── 004 Time Zone Support.mp4
│ ├── 005 DTAE_FORMAT Function.mp4
│ ├── 006 Grouping Functions.mp4
│ └── 007 Conditional Function.mp4
├── 06 Transactions
│ ├── 001 How To Use Transactions.mp4
│ └── 002 Transactions and Performance.mp4
├── 07 Triggers
│ ├── 001 Using TRIGGER.mp4
│ ├── 002 Using TRIGGER Preventing Auto Update.mp4
│ └── 003 Triggers and Transactions.mp4
├── 08 Views and Subselects
│ ├── 001 How To Use Subselect and SUBSTR.mp4
│ ├── 002 Searching Within a Result Set.mp4
│ ├── 003 How To Create VIEWs.mp4
│ └── 004 How To Create JOIN VIEW.mp4
├── 09 Routines
│ ├── 001 What Are Routines.mp4
│ ├── 002 MySQL Functions.mp4
│ └── 003 MySQL Procedures.mp4
└── 10 PHP Data Objects
├── 001 What is PDO.mp4
├── 002 PDO and Prepared Statement.mp4
└── 003 PHP and CRUD Application.mp4

https://www.udemy.com/everything-about-mysql-database/

Download File Size:1.01 GB

---