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

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

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

  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

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

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

  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

  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