MySQL Basics (HD video)

Course Description:

Any development system can not be separated from the support of the database, Java Web Development is the same, this section on Java Web Development, the basic knowledge of the database language MySQL, operating points, practical exercises, and so on a detailed introduction, with you uncover the mysteries of the Java database. Very suitable for Ling basic students.

650) this.width=650; "src=" http://cdn.aliyue.net/aliyue2.2Mysql%E5%9F%BA%E7%A1%80.jpg "alt=" MySQL Foundation "width=" 347 " "Height=" style= "height:auto;vertical-align:middle;border:0px;margin:0px auto;"/>

MySQL Basics

Course Catalogue:

• Introduction to the Database-8-1

• 2nd installation and configuration of database-8-2

• 3rd. SQL Statement Specification-8-3

• 4th related operations of the database-8-4

• Chapter 5th Introduction to data types supported in MySQL-8-5

• 6th. Introduction to the storage engine in MySQL-8-6

• 7th. mysql data table creation-8-7

• 8th test Data Type-8-8

• 9th. Test String Type-8-9

• 10th. Test String Type-8-10

• 11th. Test Date Time Type-8-11

• 12th Test PRIMARY Key-8-12

• 13th Test self-growth-8-13

• Chapter 14th non-null constraint-8-14

• 15th Test Default Value-8-15

• 16th. Test Uniqueness Constraint-8-16

• 17th. Renaming a data table-8-17

• 18th Add and remove fields-8-18

• 19th revision field-8-19

• 20th Chapter Add Delete Default-8-20

• 21st Chapter Add Delete primary Key-8-21

• 22nd Chapter Add Delete unique-8-22

• 23rd. Delete Data Sheet-8-23

• 24th. Insert record operation-8-24

• 25th update and deletion of records-8-25

• 26th. Query expression-8-26

• 27th. Conditional Enquiry-8-27

• 28th. Scope Enquiry-8-28

• 
  

• The 29th Chapter Fuzzy query-8-29

• 30th logical operator-8-30

• 31st Group Enquiry-8-31

• 32nd Group Query Mate aggregation Function-8-32

• 33rd. Having a statement to filter the results of a group two times-8-33

• 34th. Order BY to sort the results of the query-8-34

• 35th. Limit display number of bars by limit-8-35

• 36th. Update Delete App order BY and Limit-8-36

• 37th. Connection Enquiry-8-37

• 38th External Connection Query-8-38

• 39th foreign key operation-8-39

• 40th. Add Delete foreign key operation-8-40

• 41st Chapter Joint Enquiry-8-41

• 42nd Zhang Ziyi (query-8-42

• 43rd Zhang Ziyi (query form-8-43

• 44th Regular Expression query-8-44

• 45th use of the operator in MySQL-8-45

• 46th. Math Function Library-8-46

• 47th Chapter String Function Library-8-47

• 48th. Date-time Function-8-48

• 49th. Conditional judgment function and system function-8-49

• 50th other commonly used functions-8-50

• Chapter 51st use of Indexes-8-51

• 52nd Chapter phpMyAdmin Management database-8-52

• 53rd Chapter SQLyog Tool Introduction-8-53

============================================

: http://www.aliyue.net

Note: After opening the link, enter the content you want to download in the search box MySQL Basics (HD video)

=============================================

This article is from the "Xiao Yue Blog" blog, please be sure to keep this source http://aliyue.blog.51cto.com/11564403/1772615

MySQL Basics (HD video)