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

SQL Server

Get the best training of SQL Server

SQL Server Course Detail


SQL Server

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

Enroll this Course

Course Duration 2 Month(s)

Course Lectures 24

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