.MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 4 hours | Size: 1.32 GBLearn how to interact with Databases using SQLWhat you’ll learnInstall a database serverRequest data from a tableCreate stored procedureModify a stored procedureAdd data to a tableModify existing data in a tableExtract data from multiple tablesAggregate dataRequirementsComputer and Internet connection are required.
DescriptionOur world is driven by data and a lot of that data is stored in databases.
In order to unlock the information and insights stored in databases, we need a way of asking for data.
One common language for asking about and modifying data in databases is SQL.
SQL in some form or another is used in database products across the spectrum.
From small SQLite databases in mobile devices to my MySQL servers, hosting data for blogs and other apps, to enterprise scale Oracle and Microsoft SQL server databases running multi-billion dollar corporations.
The goal for this course is to get you comfortable working with the basics of the language, using MySQL.
We’ll look at how to get information from more than one database table, and I’ll introduce some more features and functions of SQL.
After that, we’ll take a look at adding and modifying data in tables that already exist in a database.
This course will help prepare you to work with SQL in programming or data reporting applications, and it will provide a foundation for deeper learning about database administration, advanced SQL, and developing with data.
SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MongoDB, and PostgreSQL.
This course provides an introduction to this core programming language.
Learn how to request data from a database server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data.
Topics include:Installing MySQLWhat is SQL?Requesting for data with SELECTLimiting database responsesOrganizing responsesRequesting for data from two or more tablesUnderstanding join types and data typesUsing stored procedureRemoving duplicate recordsAdding and modifying data in a tableWho is the target audience?Beginners to SQLBeginners to MySQLAnyone who wants to learn something new
