MySQL Advanced Topics

Focused View

Bill Weinman

1:10:26

8 View

01 - Introduction

01 - Take MySQL to the next level.mp4

00:47

02 - Exercise files.mp4

02:18

02 - 1. Indexes

01 - Why index.mp4

01:37

02 - Creating an index.mp4

04:39

03 - Showing indexes.mp4

02:20

04 - Dropping indexes.mp4

01:26

05 - Multi-column indexes.mp4

02:33

03 - 2. Views and Subqueries

01 - Creating a subquery.mp4

03:56

02 - Searching within a result set.mp4

02:40

03 - Creating a view.mp4

02:36

04 - Creating a joined view.mp4

01:58

04 - 3. Stored Routines

01 - About stored routines in MySQL.mp4

01:53

02 - Creating a stored function.mp4

06:03

03 - Creating a stored procedure.mp4

05:33

04 - Language extensions.mp4

02:28

05 - 4. Transactions

01 - What are transactions.mp4

02:00

02 - Data integrity.mp4

03:42

03 - Performance.mp4

02:48

06 - 5. Triggers

01 - Updating with triggers.mp4

03:12

02 - Preventing updates.mp4

02:37

03 - Example Timestamps.mp4

03:46

07 - 6. Foreign Keys

01 - About foreign keys.mp4

01:57

02 - Creating foreign key constraints.mp4

03:52

03 - Deleting and changing foreign keys.mp4

03:09

08 - Conclusion

01 - Thank you.mp4

00:36

Description

Get more out of the world’s most popular RDMS. Learn to take full advantage of some of the more advanced features in MySQL, including views, transactions, triggers, and stored procedures. In this course, Bill Weinman helps you take your MySQL skills to the next level. Discover how to facilitate rapid lookups with indexes, search for data in a result set provided by another select statement with subselects, and put database-intensive operations into stored functions and procedures for faster, more modular, and more efficient programming. Plus, learn how to ensure data integrity with transactions and cross-reference distributed data with foreign key constraints. These techniques allow you to create more performant and stable databases for all your development projects, from web applications to data warehouses.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Bill Weinman

Instructor's Courses

I 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 Learning

LinkedIn 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.