Meezan Bank Building, Sector 4, Naval Colony, Karachi.
Mon - Sat 09:00am to 09:00pm

MySQL Programming

Get the best training of MySQL Programming

MySQL Programming Course Detail


MySQL Programming

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

Enroll this Course

Course Duration 3 Month(s)

Course Lectures 36

ALL COURSES


CONTACT US


Contact Us

0

Address

Flat B1, Second Floor, Meezan Bank Building, Commercial Street Sector 4, Naval Colony, Hub River Road, Karachi.

Social