Loading…

SQL Programming Essentials (using MySQL)

matthew

A course on learning the SQL commands using MySQL

Course Information

Categories:

Course Instructor

matthew matthew Author
 

FREE COURSE

FREE
 
Enroll

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

Leave a Reply