Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Don't Make These 10 SQL Mistakes

developedbyed via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore a comprehensive 19-minute video tutorial on avoiding common SQL mistakes. Learn best practices for efficient querying, including proper use of SELECT statements, effective indexing, and protection against SQL injection. Discover how to design effective tables, handle NULL values, and properly update records. Delve into the importance of transactions, the differences between WHERE and JOIN clauses, and when to use WHERE versus HAVING. Gain insights on MongoDB as an alternative to traditional SQL databases. Enhance your database management skills and write more efficient, secure SQL code.

Syllabus

Intro
SELECT *
Effective Indexing
SQL Injection
Effective Tables
IS NULL
UPDATE record
Transcations
Brilliant
WHERE and Joins
WHERE and HAVING
MongoDB

Taught by

developedbyed

Reviews

Start your review of Don't Make These 10 SQL Mistakes

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.