MY SQL

admin
Last Update April 19, 2022
0 already enrolled

About This Course

Course Overview :

Goldstone Inc provides one of the best  My Sql Online Training.

This course provides students with a good overview of My SQL. Students will be able to install, run, tune, create and use databases. Basics of database applications will also be covered so that the student will have the tools to create database backed websites. MySQL is an open source relational database that is free for most users.

Prerequisites
  • Experience in basic computer literacy with previous experience with command-line programs.
  • Basic knowledge of database concepts is required.
  • Knowledge of data retrieval and reporting would benefit you.

Course Content

  • Basics of Relational Database
    • Brief History of SQL
    • Relational Databases
      • Tables
      • Rows
      • Columns
      • Relationships
      • Datatypes
      • Primary Keys
      • Foreign Keys
      • Relational Database Management System
    • Popular Databases
      • Commercial Databases
      • Popular Open Source Databases
      • Valid Object References
    • SQL Statements
      • Database Manipulation Language (DML)
      • The Database Definition Language (DDL)
      • Database Control Language (DCL)
  • Simple SELECTs
    • Introduction to the Northwind Database
    • Some Basics
      • Comments
      • Whitespace and Semi-colons
      • Case Sensitivity
    • Selecting All the Columns in all Rows.
    • Exploring the Tables.
    • Selecting only  Specific Columns
    • Sorting Records
      • Sorting By a Single Column
      • Performing Sorting By Multiple Columns
      • Performing Sorting By Column Position
      • Ascending and Descending Sorts
    • Sorting Results
    • The WHERE Clause and Operator Symbols
      • Checking for Equality
      •  Inequality
      • Checking for Greater or Less Than
      •  NULL Checking
      • WHERE and ORDER BY
    • Using the WHERE clause to check for equality or inequality
    • Using of WHERE clause to check for greater or less than
    • Checking for NULL
    • Using WHERE and ORDER BY together in queries
    • WHERE Clause and Operator Words
      • The BETWEEN Operator
      •  IN Operator
      •  LIKE Operator
      •  NOT Operator
    • More SELECTs with WHERE
    • Checking Multiple Conditions
      • AND
      • OR
      • Order of Evaluation
    • Writing SELECTs with Multiple Conditions
  • Advanced SELECTs
    • Calculated Fields
      • Concatenation
      • Mathematical Calculations
      • Aliases
    • Calculating Fields
    • Aggregate Functions and Grouping
      • Aggregate Functions
      • Grouping Data
      • Selecting Distinct Records
    • Working with Aggregate Functions
    • Built-in Data Manipulation Functions
      • Common Math Functions
      • The Common String Functions
      • Common Date Functions
    • Data Manipulation Functions
  • Subqueries, Joins and Unions
    • Subqueries
    • Joins
      • Table Aliases
      • Multi-table Joins
    • Using Joins
    • Outer Joins
    • Unions
      • UNION ALL
      • UNION Rules
    • Working with Unions
  • Conditional Processing with CASE
    • Using CASE
    • Working with CASE
  • Inserting, Updating and Deleting Records
    • INSERT
    • Inserting Records
    • UPDATE
    • DELETE
    • Updating and Deleting Records
  • Creating and Modifying Tables
    • Data Types
    • Creating Tables
      • NULL Values
      • Primary Keys
      • Foreign Keys
    • Creating Tables
    • Adding and Dropping Columns
    • Renaming Tables
      • SQL Server
      • Oracle and MySQL
    • Dropping Tables
  • Views
    • Creating Views
    • Dropping Views
    • Benefits of Views
    • Creating a View
  • Stored Procedures
    • Creating Stored Procedures
    • Dropping Stored Procedures
    • Creating a Stored Procedure
    • Benefits of Stored Procedures

 

Other Course Categories :

Programming Courses

Hr and Finance Courses

 

 

Your Instructors

admin

0/5
42 Courses
0 Reviews
1 Student
See more
sql
Free
Level
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare