English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 03m | 227 MB
MySQL is one of the most popular database management systems for small- to medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as working with data types, operators, and string and mathematical functions. Plus, learn about the key differences between standard SQL and SQL as implemented by MySQL.
Topics include:
- Writing queries
- Creating and updating databases and tables
- Data types in MySQL
- Using MySQL built-in functions
- Working with string and mathematical functions
- Differences between MySQL and standard SQL
Table of Contents
1 Harness the power of MySQL
2 The exercise files
3 A brief overview of SQL
4 Database organization
5 Selecting rows
6 Selecting columns
7 Counting rows
8 Inserting data
9 Updating data
10 Deleting data
11 Joining queries across tables
12 Finding databases, tables, and columns
13 What are data types
14 The CREATE TABLE statement
15 Numeric types
16 Date and time types
17 String types
18 Enumeration types
19 The SERIAL type alias
20 Comparison operators
21 Logical operators
22 Arithmetic operators
23 Operator precedence
24 The CASE statement
25 The IF function
26 String comparisons
27 Regular expressions
28 String concatenation
29 Numeric conversions
30 Trimming and padding
31 Case conversion
32 Substrings
33 Soundex
34 Value functions
35 Basic math
36 Simple trigonometry
37 Logarithms
38 Radians and degrees
39 String contactenation
40 Quote marks
41 Integer division
42 Comments
43 Thank you
Resolve the captcha to access the links!