Logo of The ProTec Professional Training Institute
The Protec is registered with STEVTA and Affiliated with TTB Sindh

MySQL Programming

Get the best Online training of MySQL Programming

MySQL Programming Online Course Detail


MySQL Programming offered at The Protec Computer Institute Naval Colony Karachi.

Curriculum


the ProTec provides best training of mySQL database,This course offered by the Protec helps new and intermediate database programmers to understand mySQL setup and commands , After learning this course student will able to design database for any Application.
  1. Brief History of mySQL
  2. Relational Databases
    • Tables
    • Rows
    • Columns
    • Relationships
    • Datatypes
    • Primary Keys
    • Foreign Keys
  3. mySQL Statements
    • Database Manipulation Language (DML)
    • Database Definition Language (DDL)
    • Database Control Language (DCL)
  1. Introduction to the Northwind Database
  2. SELECTing All Columns in All Rows
  3. Exploring the Tables
  4. SELECTing Specific Columns
  5. Sorting Records
    • Sorting By a Single Column
    • Sorting By Multiple Columns
    • Sorting By Column Position
    • Ascending and Descending Sorts
  6. The WHERE Clause and Operator Symbols
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • WHERE and ORDER BY
  7. The WHERE Clause and Operator Words
    • The BETWEEN Operator
    • The IN Operator
    • The LIKE Operator
    • The NOT Operator
  8. More SELECTs with WHERE
  9. Checking Multiple Conditions
    • AND
    • OR
    • Order of Evaluation
  10. Writing SELECTs with Multiple Conditions
  1. Calculated Fields
    • Concatenation
    • Mathematical Calculations
    • Aliases
  2. Calculating Fields
  3. Aggregate Functions and Grouping
    • Aggregate Functions
    • Grouping Data
    • Selecting Distinct Records
  4. Working with Aggregate Functions
  5. Built-in Data Manipulation Functions
    • Common Math Functions
    • Common String Functions
    • Common Date Functions
  6. Data Manipulation Functions
  1. Subqueries
  2. Joins
    • Table Aliases
    • Multi-table Joins
  3. Using Joins
  4. Outer Joins
  5. Unions
    • UNION ALL
    • UNION Rules
  6. Working with Unions

Courses you may like


SQL Server

SQL Server

Duration: 2 Month(s)

View Course

Enroll this Course

Course Duration 2 Month(s)

Course Lectures 24

ALL ONLINE COURSES


Leave a Message
0