A Database Crash Course!

What are databases? Today, in under half an hour, we crash course through the most important aspects of what a database is and what kind of operations can be carried out on them! Have basic SQL figured out? Then try some more advanced techniques, where we combine tables, and even use multiple SQL queries together: https://www.youtube.com/watch?v=QziwC_ltqyA = Resources = SQLite Browser: http://sqlitebrowser.org/ Database downloads: https://drive.google.com/drive/folders/0B2Ia5aQpQ8CnN2prbVV0VzBWOVE?resourcekey=0-5fwOo5ikFBxg-YdA6BiNKw&usp=sharing = Contents = 0:00 Introduction 1:00 Contents Page 2:16 What is a Database? 3:05 Database Software 4:24 Description of the software we will use (SQLite Browser) 5:59 Crash Course on Database structure and contents 7:14 Program and Database Overview 8:06 SELECT Statements 9:14 Using WHERE with SELECT 10:45 Sorting results using ORDER BY with SELECT 11:15 Using functions to further process results of SELECT 11:50 INSERT Statement 13:01 DELETE Statement 14:23 UPDATE Statement 15:27 CREATE TABLE Statement 17:10 Intermediate SQL 18:52 SELECT from multiple tables 19:49 Filtering the result to get only relevant rows 20:30 Aliasing tables 21:03 Filtering columns 21:40 Performing math in a SELECT statement 22:37 Aliasing columns 23:25 Grouping similar rows 23:44 Using functions alongside grouping 24:33 Applying the same to a larger table 25:29 Things we haven't discussed 26:43 Outtro = Licensing = Some scenes from this video contain data from the following Wikipedia pages: https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations) https://en.wikipedia.org/wiki/List_of_time_zones_by_country As such, this video is licensed under the Creative Commons Attribution-ShareAlike 3.0 Unported license. For the full text of the license, please refer to the following URL: https://creativecommons.org/licenses/by-sa/3.0/legalcode = 0612 TV = 0612 TV, a sub-project of NERDfirst.net, is an educational YouTube channel. Started in 2008, we have now covered a wide range of topics, from areas such as Programming, Algorithms and Computing Theories, Computer Graphics, Photography, and Specialized Guides for using software such as FFMPEG, Deshaker, GIMP and more! Enjoy your stay, and don't hesitate to drop me a comment or a personal message to my inbox =) If you like my work, don't forget to subscribe! Like what you see? Buy me a coffee → http://www.nerdfirst.net/donate/ 0612 TV Official Writeup: http://nerdfirst.net/0612tv More about me: http://about.me/lcc0612 Official Twitter: http://twitter.com/0612tv = NERDfirst = NERDfirst is a project allowing me to go above and beyond YouTube videos into areas like app and game development. It will also contain the official 0612 TV blog and other resources. Watch this space, and keep your eyes peeled on this channel for more updates! http://nerdfirst.net/ ----- Disclaimer: Please note that any information is provided on this channel in good faith, but I cannot guarantee 100% accuracy / correctness on all content. Contributors to this channel are not to be held responsible for any possible outcomes from your use of the information.