SQL Programming Essentials (using MySQL) Posted on January 31, 2015February 5, 2018 by matthew A course on learning the SQL commands using MySQL Course Information Categories: Active Course Instructor matthew Author FREE COURSE FREE Introduction Introduction to SQL Installing and configuring MySQL Working with databases and tables Creating a database Creating tables Table data types Table constraints Creating, Retrieving, Updating, and Deleting (CRUD) records Adding records into a table Updating records in a table Deleting records from a table Querying the Data Creating basic queries Advanced comparison operators List of distinct values Selecting fields from multiple tables Running with an alias Calculated Data and Useful Functions Calculating fields on the fly Using aggregate functions Grouping the results of aggregate functions Using scalar functions Formatting the now time Table Modifications Altering the structure of a table Faster searching with indexes Virtual tables called views Duplicating tables Joining Tables Inner joining tables Left and right joining tables Full outer joining tables