Channel Title: Database Star Channel Description: Are you looking to improve your database development and SQL skills? You've come to the right place. Learn how to improve these skills by watching the videos on my channel. You'll learn: - how to use many different SQL functions and features - how to design a database and normalise your database tables - how to set up different databases - how to use SQL Developer and other IDEs Plus much more! <video> Simplify Your Docker Commands With This Technique Description: 📝 Get your FREE cheat sheet of Docker commands: https://databasestar.mykajabi.com/lpkj-docker-cheat-sheet/?utm_source=viddesc&utm_medium=youtube&utm_campaign=183 🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=183 The commands for "docker run" can get quite complex, depending on your database and what parameters you want to provide. In this video, I'll explain a way you can greatly simplify these commands, and also make it easier to work with multiple databases and multiple versions. ⏱ TIMESTAMPS: 00:00 - Set up the file 03:01 - Run docker compose 04:15 - Connect to the database 05:18 - A different database 🔗 VIDEO LINKS: YML files used in this video: https://github.com/bbrumm/databasestar/tree/main/videos/183_docker_compose </video> <video> I Tried to Query 10 MILLION Rows in Postgres in 1 Second Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=190 🎓 Write faster SQL today: https://databasestar.mykajabi.com/get-write-faster-sql/?utm_source=viddesc&utm_medium=youtube&utm_campaign=190 I've got an SQL query that queries a table with more than 10m rows in a table. It runs pretty slowly, and in this video I'll try a range of techniques to get it to run in under 1 second. ⏱ TIMESTAMPS: 00:00 - Our data 01:58 - Our query 04:05 - Add indexes 05:22 - Union All 06:28 - Case 09:17 - Add a column 11:34 - Another index 🔗 VIDEO LINKS: Scripts shown in this video: https://github.com/bbrumm/databasestar/tree/main/videos/190_10m_postgres </video> <video> How to Install Oracle SQL Developer on M1 Mac Description: 📝 Save Time With Oracle SQL Developer: https://databasestar.mykajabi.com/lpkj-timesaver-sqldeveloper/?utm_source=viddesc&utm_medium=youtube&utm_campaign=204 🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=204 SQL Developer is Oracle's free SQL editor. It works on Windows and Mac - both the older Mac processors and the new M-series processors. In this video I'll show you how to download and install Oracle SQL Developer on an M-series Mac. 🔗 VIDEO LINKS: SQL Developer download: https://www.oracle.com/database/sqldeveloper/technologies/download/ </video> <video> Complete SQL Roadmap for Beginners Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign= 🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign= There can be a lot to learn with SQL and it can seem overwhelming. In this video, I'll share my suggested SQL roadmap, starting from the basic topics of "what is a database", and cover a range of SQL topics from beginner to advanced. ⏱ TIMESTAMPS: 00:00 - Basic SQL 01:57 - Intermediate SQL 04:17 - Advanced SQL 🔗 VIDEO LINKS: SQL Roadmap image: https://www.databasestar.com/sql-roadmap-diagram/ </video> <video> How to Connect to MySQL in VS Code and Run SQL Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=203 🎓 Master the SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=203 Are you running VS Code and want to connect to a MySQL database? You can do this within VS Code. In this video, I'll show you how to install an extension, connect to a database, run some SQL, how to avoid common issues such as the "max idle time NaN" error, and how to create a database if you don't have one. ⏱ TIMESTAMPS: 00:00 - Install the extension 02:07 - Create a connection 05:25 - Create a new database 08:15 - Connect and run SQL </video> <video> How to Create a Stored Procedure in Oracle PL/SQL Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=191 🎓 Learn how to write and read Oracle PL/SQL: https://databasestar.mykajabi.com/effective-plsql/?utm_source=viddesc&utm_medium=youtube&utm_campaign=191 Creating stored procedures in Oracle can improve the design of your overall system and improve data quality. In this video, I'll show you how to: - create a stored procedure in Oracle PL/SQL - run the stored procedure - view the DBMS Output in SQL Developer </video> <video> Build an IMDb Database with SQL Description: 📝 Get the Project Guide for this project here: https://databasestar.mykajabi.com/lpkj-sql-project-guide/?utm_source=pincom&utm_medium=youtube&utm_campaign=217 🎓 Master SQL Fundamentals: (SQL simplified): https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=217 After you learn the basics of SQL, the best way to get better is to practice. And creating a project is a great way to practice. In this video, I'll create an IMDB database using SQL. Watch the video to learn how I add many components of a movie into an SQL database, create and alter tables, add and update data, and write Select queries to see the data just like the web page would. ⏱ TIMESTAMPS: 00:00 - IMDB website 00:44 - Create the first table 04:46 - Insert some data 06:24 - Movie runtime 10:21 - Poster and trailer 12:31 - Ratings 17:16 - Interests and Description 21:15 - Director 23:32 - Writers and Stars 29:48 - Storyline 31:57 - Did You Know 33:38 - User Reviews </video> <video> Avoid This SQL Keyword For Better Queries Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=214 🎓 Master SQL Fundamendals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=214 There's a keyword that exists in SQL that can help... but I don't recommend using it. Find out what the keyword is, why I don't think you should use it, and what to do instead in this video. ⏱ TIMESTAMPS: 00:00 - Our query 00:58 - A different way 02:01 - Reasons 03:46 - My advice </video> <video> SQL Data Analysis Project: NBA Games & Teams Description: 📝 Get this Data Analysis Project Guide: https://databasestar.mykajabi.com/lpkj-data-analysis-projects/?utm_source=viddesc&utm_medium=youtube&utm_campaign=185 🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=185 There's a pretty comprehensive dataset available for the NBA, and in this video I'll use SQL to run some analysis on the data. You'll learn some team-level statistics for the NBA over time, such as the teams with the best and worst single-season record, the best record over 5 years, and the best and worst single-season turnaround. Adjustments I had to make during importing: - draft_history.organisation - default to 27 characters, needs at least 100 - game.team_name_home - default to 27 characters, needs at least 100 - game.team_name_away - default to 27 characters, needs at least 100 ⏱ TIMESTAMPS: 00:00 - Our data set 04:05 - Question 1 09:32 - Question 2 12:48 - Question 3 14:19 - Question 4 20:09 - Question 5 🔗 VIDEO LINKS: Kaggle data set: https://www.kaggle.com/datasets/wyattowalsh/basketball/data Importing CSV: DBeaver: https://www.youtube.com/watch?v=u2N4UEL8Lm8 MySQL Workbench: https://www.youtube.com/watch?v=6Td5dbUC4Wg SQL Developer: https://www.youtube.com/watch?v=GcB4_0Iz2Zw </video> <video> How to Install SQL Server Management Studio (SSMS) Description: 📝 Save Time With SSMS: https://databasestar.mykajabi.com/lpkj-timesaver-ssms/?utm_source=viddesc&utm_medium=youtube&utm_campaign=198 🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=198 In this quick video, you'll learn: - how to download SSMS (SQL Server Management Studio) from the Microsoft website - how to install it onto your Windows computer - how to connect to an SQL Server database you already have installed 🔗 VIDEO LINKS: SSMS Download: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 </video> <video> Is SQL Still Worth Learning in 2025? Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=212 🎓 Master SQL Fundamentals: (SQL simplified): https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=212 Is SQL still worth learning in 2025? It's been around for a while, but there are newer methods and technologies for storing data and working with data. In this video I'll explain whether or not SQL is still worth learning in 2025, and why I believe that. </video> <video> SQL UPDATE Statement Explained in 9 Minutes Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=215 🎓 Master SQL fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=215 The SQL Update statement will let you make changes to data in a table. In this video, you'll learn what the statement does, how to write a simple UPDATE statement in SQL, several other things the UPDATE statement can do, and how to avoid two of the most common mistakes when updating data. ⏱ TIMESTAMPS: 00:00 - Simple UPDATE statement 02:56 - Update multiple columns 04:16 - Update multiple rows 05:02 - Base on existing value 06:25 - Avoid common mistakes </video> <video> Stop Wasting Time Documenting Your Database Description: 📝 Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?utm_source=viddesc&utm_medium=youtube&utm_campaign=219 🎓 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_source=viddesc&utm_medium=youtube&utm_campaign=219 It takes a lot of effort to keep database documentation and Entity Relationship Diagrams up to date, or to investigate the tables and columns in your SQL editor. There is a better way, and I'll show you a tool you can use in this video. ⏱ TIMESTAMPS: 00:00 - The problem 01:42 - How to generate docs 07:48 - What else can you do? 🔗 VIDEO LINKS: How to install NodeJS: https://nodejs.org/en/download/package-manager DBDocs: https://dbdocs.io/ Docs as Code article: https://www.writethedocs.org/guide/docs-as-code/ </video> <video> How to Create a New User in Oracle Database Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=213 🎓 Master the SQL fundamentals: https://databasestar.mykajabi.com/sql-simplified/?utm_source=viddesc&utm_medium=youtube&utm_campaign=213 Are you having trouble creating a new user in Oracle, and getting either an "ORA-01017: invalid username/password; logon denied" error or an "invalid common user or role name" error? In this video, I'll show you why these errors are happening, how to successfully create a new user in an Oracle database, connect as this new user, and a range of issues you might encounter. ⏱ TIMESTAMPS: 00:00 - Why it's hard 01:51 - Create a new user 03:04 - Connect to the database 03:52 - Issue - no create session 04:38 - Issue - connect as SYSDBA 05:34 - Issue - connect to CDB as a PDB user 06:21 - Issue - invalid common user or role name 08:03 - Overview and scenarios </video> <video> How to Solve This Database Design Problem Description: 📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?utm_source=viddesc&utm_medium=youtube&utm_campaign=202 🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?utm_source=viddesc&utm_medium=youtube&utm_campaign=202 There's a type of design that is possible in software development but hard to do in a database. In this video, I'll explain what this design is called, what it means, several ways you can do it in a database, and what my suggestion is. ⏱ TIMESTAMPS: 00:00 - The problem 01:24 - Option 1 02:25 - Option 2 03:38 - Option 3 05:15 - Option 4 06:12 - Option 5 07:18 - Which is best? </video>

Contacts and Links

Description

Are you looking to improve your database development and SQL skills?
You've come to the right place.
Learn how to improve these skills by watching the videos on my channel. You'll learn:
- how to use many different SQL functions and features
- how to design a database and normalise your database tables
- how to set up different databases
- how to use SQL Developer and other IDEs
Plus much more!

Videos from channel