MySQL Essential Training
Focused View
Bill Weinman
1:58:35
10 View
01 - Harness the power of MySQL.mp4
00:56
02 - The exercise files.mp4
01:25
01 - A brief overview of SQL.mp4
04:28
02 - Database organization.mp4
02:51
03 - Selecting rows.mp4
05:47
04 - Selecting columns.mp4
02:21
05 - Counting rows.mp4
03:05
06 - Inserting data.mp4
03:26
07 - Updating data.mp4
04:12
08 - Deleting data.mp4
04:10
09 - Joining queries across tables.mp4
03:57
10 - Finding databases, tables, and columns.mp4
01:24
01 - What are data types.mp4
04:36
02 - The CREATE TABLE statement.mp4
03:05
03 - Numeric types.mp4
05:24
04 - Date and time types.mp4
03:40
05 - String types.mp4
03:03
06 - Enumeration types.mp4
03:58
07 - The SERIAL type alias.mp4
02:53
01 - Comparison operators.mp4
03:57
02 - Logical operators.mp4
04:37
03 - Arithmetic operators.mp4
01:27
04 - Operator precedence.mp4
02:46
05 - The CASE statement.mp4
02:29
06 - The IF function.mp4
01:18
01 - String comparisons.mp4
02:26
02 - Regular expressions.mp4
02:19
03 - String concatenation.mp4
02:15
04 - Numeric conversions.mp4
02:04
05 - Trimming and padding.mp4
03:15
06 - Case conversion.mp4
02:01
07 - Substrings.mp4
01:34
08 - Soundex.mp4
02:38
01 - Value functions.mp4
03:16
02 - Basic math.mp4
02:08
03 - Simple trigonometry.mp4
01:28
04 - Logarithms.mp4
01:52
05 - Radians and degrees.mp4
00:28
01 - String concatenation.mp4
01:22
02 - Quote marks.mp4
01:53
03 - Integer division.mp4
02:22
04 - Comments.mp4
02:55
01 - Thank you.mp4
01:04
Description
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.
More details
User Reviews
Rating
average 0
Focused display
Category
Bill Weinman
Instructor's CoursesI cleverly manipulate unsuspecting electrons to teach you about technology and other cool things.
I'm primarily an educator, I teach online courses and write books on computer languages and programming.
I built my first computer in 1972, using an Intel 4004 4-bit microprocessor and parts from a local Radio Shack. Over a 45+ year career, I've consulted for major corporations, including NASA, IBM, Bank of America, the US Navy, and KWHY-TV, where I designed the world’s first broadcast lower-third stock ticker.
I've written popular books and courseware on C, C++, Perl, Python, SQL, and more. My courses have consistently been ranked in the top-10 on lynda.com and Linkedin Learning’s training sites.
// Students: Please do not direct message me on Linkedin for technical support with my lynda.com/Linkedin Learning courses. I rarely see my Linkedin messages. You may tag me in a post or use the course Q&A system.
// Recruiters: Please do not contact me for captive positions. I occasionally do some consulting, but mostly I am booked at least a year in advance.
If you need to contact me directly, please see my web site https://bw.org/contact
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 43
- duration 1:58:35
- English subtitles has
- Release Date 2024/05/19
