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

SQL Server

Get the best Online training of SQL Server

SQL Server Online Course Detail


SQL Server offered at The Protec Computer Institute Naval Colony Karachi.

Curriculum


the ProTec provides best training of SQL Server database,This course offered by the Protec helps new and intermediate database programmers to understand SQL Server setup and commands , After learning this course student will able to design database for any Application.
  1. Brief History of SQL
  2. Relational Databases
    • Tables
    • Rows
    • Columns
    • Relationships
    • Datatypes
    • Primary Keys
    • Foreign Keys
  3. SQL 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


MySQL Programming

MySQL Programming

Duration: 2 Month(s)

View Course

ALL ONLINE COURSES


Leave a Message
0