[email protected] 0300-2234179
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.
Section 1: Relational Database Basics
  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

Enroll this Course

Course Duration 2 Month(s)

Course Lectures 24

Popular Courses
FreeLancingFreeLancingCITCITADITADITCoding for KidsCoding for KidsWeb DevelopmentWeb DevelopmentOffice AutomationOffice AutomationGraphic DesigningGraphic DesigningContent WritingContent WritingC# ProgrammingC# ProgrammingJava ProgrammingJava ProgrammingEnglish Language (Pre-Advance Level)English Language (Pre-Advance Level)Computer BasicsComputer BasicsMySQL ProgrammingMySQL ProgrammingWeb DesigningWeb DesigningC++ ProgrammingC++ Programming

ALL ONLINE COURSES

Learn Foundation Maths

Duration: 2 Month(s)

Foundation Maths is the course designed for the students who lacks the proficiency of basic mathematics concepts, the Foundation Maths course at The Protec Professional Training Institute will enhance students capabilities to understand basic Mathematics concepts like Powers, Roots, Logarithms, Sorting, Sets theory, Odd Even numbers, Graphs, Equations, Trigonometry, Angles, logical operators (Discrete Maths), Probability and Stats, logical reasoning and many other basic maths concepts.

Learn English Language (Advance Level)

Duration: 4 Month(s)

Learn English Language with The Protec English Language Institute (TP-ELI), Advance level English Language course includes Towards advance, English you need, Grammar, Vocabulary,Audio and video practices. The Protec Professional Training Institute is the best Computer and English Language Institute in Naval Colony, Karachi.

Learn English Language (Pre-Advance Level)

Duration: 4 Month(s)

Learn English Language with The Protec English Language Institute (TP-ELI), Pre-Advance level English course includes Intermediate level, Upper intermediate level, Grammar, Vocabulary, Audio and video practices The Protec Professional Training Institute is the best Computer and English Language Institute in Naval Colony, Karachi.

Learn English Language (Basic Level)

Duration: 4 Month(s)

Learn English Language with The Protec English Language Institute (ELI), Basic level English course includes, English my way, Lower intermediate, Grammar, Vocabulary,Audio and video practices The Protec Professional Training Institute is the best Computer and English Language Institute in Naval Colony, Karachi.

Learn Advanced Web Development

Duration: 6 Month(s)

Advanced Web Development is the course offered at The Protec, that offers learning of advance web technologies like Codeigniter, Laravel, Wordpress and Magento. having demonstrate-able knowledge of php, mysql javascript, html, css are the pre requisite for this course.

Learn Video Editing

Duration: 3 Month(s)

Video Editing Course at The Protec Professional Training, Naval Colony offers hands on professional Computer training in Video Editing Software like Corel Video Studio, Adobe Premiere and Adobe After Effects, after completing this course student will be able to Edit Professional Videos for advertisement agencies or for TV and drama making industries.

Learn Magento E-Commerce

Duration: 2 Month(s)

The Protec Professional Training Institute offers professional Magento Course that is an open source platform written in PHP for E-Commerce, this course is for Industry Professionals who want to develop quality and reliable E Commerce platforms for their clients in a quick. our students get exposure by working on live industry projects.

Learn Search Engine Optimization

Duration: 2 Month(s)

A Search Engine Optimization (SEO) Specialist analyzes, reviews and implements changes to websites so they are optimized for search engines. This means maximizing the traffic to a site by improving page rank within search engines.

Learn Content Writing

Duration: 2 Month(s)

Content Writers at The ProTec can produce a wide variety of content for the Web, from articles and reviews to game scripts. Most Web content writers are self-employed and work as freelancers.

Learn Mobile Application Development

Duration: 6 Month(s)

Mobile Application Development Course is designed to equip the young generation with market oriented Android and IOS development, in this course students will learn how to develop Android and IOS apps the course will start from the basics of programming using Java

Learn Office Automation

Duration: 3 Month(s)

The ProTec Offers Office Automation course which is best to find Computer Operator Job in Multinational Companies, We provide Best training which help individuals develop and nurture their competencies which they want to excel in, in order to get highly paid jobs.

Learn FreeLancing

Duration: 1 Month(s)

Learn with The ProTec, How to become freelancer, how to find clients and work, market yourself, get paid online and grow your business.

Learn MySQL Programming

Duration: 2 Month(s)

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.

Learn PHP Development

Duration: 3 Month(s)

This course aims to make students able to develop dynamic websites. the ProTec provides best training of PHP development and mysql database,This course offered by the Protec helps new and intermediate programmers to understand PHP and mySQL, After learning this course student will able to design and developed complete web Application.

Learn CIT

Duration: 6 Month(s)

Certification in information technology (CIT).This course aims to provide students basic to advance knowledge of information technology,MS Office HTML5 & CSS3. the ProTec provides best training of CIT course,This course is for new and intermediate students,After successfully completion of CIT course student will able to avail IT Job like Computer Operator, & Web-Designer.

Contact

Mob: 0300-2234179
Email: [email protected]

Social

Leave a Message
0