0

  • An empty cart

    You have no item in your shopping cart

Smartthink Training Ltd (Ghana) - The Information Technology, Business & E-testing Hub

Enter your keyword

Course

MICROSOFT SQL DATABASE

MICROSOFT SQL DATABASE TRAINING TIMETABLE

DAYSDURATIONTIMELOCATION 
APRIL 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
MAY 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
AUGUST 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
SEPTEMBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
OCTOBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
NOVEMBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
DECEMBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

Course Outline

COURSE OUTLINE FOR MICROSOFT SQL DATABASE
RELATIONAL DATABASE CONCEPTS, SPECIFIC PRODUCTS

  1. SQL syntax rules
  2. Data definition, data manipulation, and data control statements
  3. Getting acquainted with the course database and editor

SQL SELECT STATEMENTS

  1. Clauses
  2. The SELECT clause: columns and aliases, where expressions, order by expressions how null values behave

SQL FUNCTIONS AND EXPRESSIONS

  1. Eliminating duplicates with DISTINCT arithmetic expressions
  2. Replacing null values C. Literals, concatenation, other string functions
  3. Numeric operations, including rounding
  4. Date and time functions F. Nested table expressions
  5. Case logic
  6. Other expressions in specific dbms products

SQL UPDATING

  1. The INSERT, UPDATE and DELETE statements
  2. Column constraints and defaults
  3. Referential integrity constraints

SQL JOINS

  1. Inner joins with original and SQL 92 syntax
  2. Table aliases
  3. Left, right and full outer joins
  4. Self-joins VI.

SQL SUBQUERIES AND UNIONS

  1. Intersection with IN and EXISTS
  2. Subqueries
  3. Difference with NOT IN and NOT EXISTS subqueries
  4. The purpose and usage of UNION and UNIONALL

SQL SUMMARIZATION

  1. The column functions MIN, MAX, AVG, SUM and COUNT
  2. The GROUP BY and HAVING clauses grouping in a combination with joining

Start On 2017-02-27
Duration 1 DAY
Price ₵400.00

Share our course