Created by John Elder | Published 11/2019Duration: 7 hours | Video: h264, 1280×720 | Audio: AAC, 44 KHz, 2 Ch | 6.3 GBGenre: eLearning | Language: English + Sub | 103 LecturesLearn MySQL, POSTGRES, SQLite, and Microsoft SQL Server The Fast and Easy Way!What you’ll learnUnderstand how to use MySQL Databases With PythonUnderstand how to use PostgreSQL Database with PgAdmin 4Understand how to use SQLite Databases With PythonUnderstand and Use Microsoft SQL ServerUnderstand the basics of what a Database can doYou’ll Learn How To Create a Database and TableHow to put data in and take data outHow to update and delete data from the databaseHow to explore what’s in the database whenever you wantHow to create basic reports with the data from your databaseRequirementsYou don’t need any prior database experience, I’ll walk you through everythingYou don’t need any special tools, we’ll download everything we need for free. You just need a Windows, Mac, or Linux computerDescriptionIn this course we’ll learn the MySQL Database, the POSTGRES Database, the SQLite Database, and the Microsoft SQL Server from an absolute Beginner level all the way to Advanced in no time at all!This course is aimed at the absolute beginner, you don’t need any coding or database experience at all!We’ll start out by downloading and installing each of these databases – all for free.
This will give you all the tools you need to start writing and running code for your databases.
Then, we’ll dive into very basic database concepts. Things like:What Is A DatabaseHow To Install Each DatabaseHow To Install Git Bash TerminalHow To Connect To Your DatabaseHow To Create A DatabaseAfter that, we’ll move into more intermediate topics like:How To Create A TableHow To Insert One Record Into TableHow To Insert Many Records Into TableUnderstanding Data TypesHow To Select Data From TableHow To Format Our ResultsHow To Use The Where ClauseHow To Use The Like Clause and WildcardsHow To Use AND and ORHow To Updating RecordsHow To Limit and Order ResultsHow To Delete RecordsHow To Delete (Drop) A Table And BackupsFinally we’ll finish up with more advanced topics like:Foreign KeysInner JoinsJoin Where HacksAnd More…We’ll learn all of those things for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
We’ll start with MySQL, and then move over to PostgreSQL, then hit SQLite before finishing up with Microsoft SQL Server.
This is a bundle course of four of my other popular courses.
These databases are four of the greatest databases to learn, and learning has never been this easy! They’re the most popular and in demand for a reason! Let’s learn some databases!I’ll see you on the inside!-John ElderWho this course is for:Anyone who wants to use the MySQL Database with PythonAnyone Who Wants To Learn SQL ServerAnyone who wants to use the PostgreSQL database with the PgAdmin 4 InterfaceAnyone who wants to use the SQLite Database with Python
