MICROSOFT SQL DATABASE - Image 1

MICROSOFT SQL DATABASE

MICROSOFT OUTLOOK

£400.00

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).

Category:

Description

MICROSOFT SQL DATABASE TRAINING TIMETABLE

DAYSDURATIONTIMELOCATION
APRIL 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
MAY 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
AUGUST 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
SEPTEMBER 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
OCTOBER 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
NOVEMBER 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
DECEMBER 2020
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).

[academia_heading title=”Course Outline”]
[academia_course_sections title=”COURSE OUTLINE FOR MICROSOFT SQL DATABASE”][academia_course_lesson title=”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

[/academia_course_lesson][academia_course_lesson title=”SQL SELECT STATEMENTS “]

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

[/academia_course_lesson][academia_course_lesson title=”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

[/academia_course_lesson][academia_course_lesson title=”SQL UPDATING “]

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

[/academia_course_lesson][academia_course_lesson title=”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.

[/academia_course_lesson][academia_course_lesson title=”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

[/academia_course_lesson][academia_course_lesson title=”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

[/academia_course_lesson][/academia_course_sections]