SQL Practice: Dropping Tables and Managing Schema Changes

Focused View

Walter Shields

30:12

0 View

01 - Introduction

01 - Course introduction.mp4

00:43

02 - What you should know.mp4

01:18

03 - How to use CoderPad.mp4

02:46

02 - 1. Introduction to Schema Changes

01 - Overview of schema changes.mp4

01:56

03 - 2. Dropping Tables

01 - Considerations and constraints in dropping tables.mp4

03:24

02 - Solution Syntax and usage of DROP TABLE.mp4

02:00

04 - 3. Modifying Table Structures

01 - ALTER TABLE syntax and usage.mp4

02:51

02 - Solution Adding and dropping columns.mp4

02:18

05 - 4. Advanced Schema Modifications

01 - Solution Renaming tables and columns.mp4

02:44

02 - Solution Changing data types of columns.mp4

01:59

06 - 5. Best Practices for Schema Management

01 - Planning and documenting schema changes.mp4

01:56

07 - 6. Dropping and Modifying Tables

01 - Solution Dropping tables.mp4

03:30

02 - Solution Modifying table structures.mp4

02:47

08 - Conclusion

Description

Are you looking to take your SQL knowledge to the next level? This course was designed for you. With interactive Code Challenges powered by CoderPad, you'll learn how to drop tables and manage schema changes to optimize your databases, gaining practical experience with in-demand SQL skills. Instructor Walter Shields covers the basics of using the DROP TABLE statement to remove tables, managing schema changes with ALTER TABLE statements, and ensuring data integrity and performance. By the end of this course, you’ll be prepared to manage and optimize your database schema efficiently.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Walter Shields

Instructor's Courses

Walter Shields is known as a Best-Selling Author, Mentor and SME in Data Analytics. He has over 25 years of experience training students and managing data systems for startups to Fortune 500 companies, from law to healthcare to big-box retail. Through his educational books and courses, Walter reaches a growing number of students and corporate organizations, training them to master skills and tools in data management, analysis, and visualization. An expert in data analysis training & solutions, Walter is a published and Best-Selling Author of “SQL Quickstart Guide”. Current partnerships include: • Manning Publishing - New Data Analytics book to be published in 2023 • LinkedIn Learning Course Author - SQL and Data Analytics course to be released in 2023 • Microsoft Learn Partner - Power BI Data Visualization courses With his passion for teaching, Walter continues to create simplified, uncomplex, fun and effective ways for his students to confidently command skills in data analytics.

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.