mcAfee-secured website

Course name Databases Courses Create Use and Handle a MySQL Database from Scratch: Create, Use and Handle a MySQL Database from Scratch

Create Use and Handle a MySQL Database from Scratch Video Course

Create Use and Handle a MySQL Database from Scratch Video Course is developed by Databases Courses Professionals to help you pass the Create Use and Handle a MySQL Database from Scratch exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass Create, Use and Handle a MySQL Database from Scratch exam.

Curriculum For This Course

  • 1. Introduction to Course 1 Videos 00:03:51
    • Introduction to MySQL 03:51
  • 2. Getting the Development Environment Ready 7 Videos 00:47:59
    • Installation of MySQL Database Server in WIndows 11:28
    • Installation of MySQL Database Server in Ubuntu [Linux] 05:24
    • Installation MySQL Database Server in MAC OSX 09:44
    • Introduction to MySQL Console in WIndows 04:24
    • Introduction to MySQL Console in Ubuntu [Linux] 04:19
    • Introduction to MySQL Console in MAC OSX 08:25
    • Sectional Wrap-up 04:15
  • 3. Beginning with MySQL Basics 17 Videos 01:45:33
    • Creating a Database - CREATE DATABASE 07:03
    • Creating a Table - CREATE TABLE 10:08
    • Inserting Values into Table - INSERT INTO 09:57
    • Retrieving Values from Table - SELECT 04:22
    • Selecting Distinct Values from Column - DISTINCT 06:49
    • Selecting a Specific Data using WHERE Clause 05:12
    • Selecting with Multiple Identifiers Using AND 04:58
    • Selecting with One of Many Identifiers Using OR 05:03
    • Sorting the Data Using ORDER BY 05:24
    • Limiting the Data Retrieved Using LIMIT 08:54
    • Updating or Modifying Data in a Table Using UPDATE 05:53
    • Deleting a Data from a Table Using DELETE 06:32
    • Deleting a Table - DROP TABLE 02:38
    • Deleting all values in Table - TRUNCATE TABLE 03:09
    • DESCRIBE TABLE 04:21
    • Altering Table Structure - ALTER TABLE 03:41
    • Sectional Wrap-up 11:30
  • 4. Time to Jump in for More 9 Videos 00:48:56
    • Selecting Data with a Range - BETWEEN 05:17
    • Creating Alias Name for a Column - AS 03:58
    • Selecting Data which has one of Multitple Values - IN 03:40
    • Using LIKE and WILDCARDS 06:14
    • Copy Table with INSERT INTO SELECT 04:51
    • Copy a Table Struture - CREATE TABLE LIKE 04:26
    • Copy Table with Certain Columns - INSERT INTO SELECT 03:23
    • Combine the Tables - UNION 09:49
    • Sectional Wrap-up 07:18
  • 5. Few things that Keeps the Database in Shape 8 Videos 00:48:50
    • Keeping Database in Shape 04:38
    • PRIMARY KEY 04:43
    • UNIQUE KEY 02:51
    • FOREIGN KEY 09:36
    • NOT NULL 06:31
    • AUTO_INCREMENT 05:16
    • DEFAULT 08:31
    • Sectional Wrap-up 06:44
  • 6. Using Joins to Combine Tables 5 Videos 00:44:12
    • INNER JOIN 09:55
    • LEFT JOIN 07:21
    • RIGHT JOIN 07:28
    • FULL JOIN 11:27
    • Sectional Wrap-up 08:01