Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Up and Running with MySQL Development [repost]

Posted By: ParRus
Up and Running with MySQL Development [repost]

Up and Running with MySQL Development
WEBRip | English | MP4 + Project Files | 1280 x 720 | AVC ~48.8 kbps | 15 fps
AAC | 128 Kbps | 44.1 KHz | 1 channel | 2h 57mn | 337 MB
Genre: Video Tutorial / Development, Programming

Get a simple introduction to MySQL—without the overhead. Sheeri K. Cabral introduces the vocabulary and tools for MySQL, the world's most popular open-source database that powers everything from your neighbor's blog to Internet giants like Facebook. The goal of this course is to get you interacting with data and understanding just why databases are better. Most of the work is done at the command line, as Sheeri teaches you how to create a new database, build tables, read and edit database records, and use functions to query data. She also issues a series of challenges along the way that allow you to test your skills and compare your results with hers.
Content:
Introduction
Welcome
What you should know before watching this course
Easy ways to play with MySQL
Using the exercise files

1. Database Basics
Databases vs. spreadsheets
Relational databases vs. flat files
Normalizing databases
Common database acronyms

2. MySQL Basics
Understanding MySQL terminology: Database, table, row, column, and field
Finding information about your database with SHOW
Exploring MySQL data types
NULL values
Understanding declarative language
Challenge: Explore the built-in databases
Solution: Explore the built-in databases

3. Creating and Changing Tables
Creating a database
Exploring table creation with SHOW CREATE TABLE
Creating and altering a table with CREATE and ALTER
Reading from a table with SELECT
Adding data to a table with INSERT
Additional INSERT methods
Modifying data in a table with UPDATE
Additional UPDATE methods
Removing rows from a table with DELETE and TRUNCATE
Challenge: Build the address book database
Solution: Build the address book database

4. More Advanced Querying
Basic functions
Date and number functions
String functions
Comparing strings and numbers with operators
Arranging items with GROUP BY clauses
Sorting results
Challenge: Using date and string functions
Solution: Using date and string functions

5. Inserting and Replacing Records
Updating values if they already exist with INSERT…ON DUPLICATE KEY UPDATE
Replacing information with the REPLACE statement
Ignoring values if they already exist with INSERT IGNORE
Challenge: Adding new information, even if it already exists
Solution: Adding new information, even if it already exists

6. Joining Tables
Joining tables with matching fields using INNER JOIN
Joining tables regardless of matching data using OUTER JOIN
Challenge: Creating reports with JOIN
Solution: Creating reports with JOIN

Conclusion
Next steps

also You can look my other last: Programming-posts

General
Complete name : 158373_01_04_XR15_CDA.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 7.72 MiB
Duration : 6mn 0s
Overall bit rate mode : Variable
Overall bit rate : 180 Kbps
Encoded date : UTC 2014-03-28 20:44:30
Tagged date : UTC 2014-03-28 20:44:30
Writing library : Apple QuickTime
Copyright : lynda.com

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 6mn 0s
Bit rate : 48.8 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.004
Stream size : 2.10 MiB (27%)
Language : English
Encoded date : UTC 2014-03-28 20:44:30
Tagged date : UTC 2014-03-28 20:44:30

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 5mn 59s
Bit rate mode : Variable
Bit rate : 128 Kbps
Maximum bit rate : 131 Kbps
Channel(s) : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 5.49 MiB (71%)
Language : English
Encoded date : UTC 2014-03-28 20:44:30
Tagged date : UTC 2014-03-28 20:44:30

Screenshots

Up and Running with MySQL Development [repost]

Up and Running with MySQL Development [repost]

Up and Running with MySQL Development [repost]

For more Exclusive material, Visit my AH-blog

Up and Running with MySQL Development [repost]