MS SQL Server Intermediate Course, 3 Days Data Ana Miscellaneous

ms_sql_server_intermediate_course_3_days_data_ana


SQL Intermediate 3-Day Course: With MS SQL Server, one can use data queries to easily and quickly retrieve valuable information, trends, sum

SQL Course Description:

Session 1: Database Concepts
Revision of database basics. What is a database? Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys
Session 2: Using the SQL client
SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements
Session 3: Basic SQL SELECT statement
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).The ORDER BY clause, Column aliases, Arithmetic expressions, Working with Null: (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”), Precedence of operators
Session 4: LIMIT / TOP , DISTINCT , SQL AGGREGATE Functions: Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Rollup with Group By, Having.
Session 5: SQL Subqueries, Basic Subqueries, Nested Subqueries, CTE Tables.
Sessions 6: Joins:
SQL Cartesian products;
SQL Joins (Inner join, Left join, Right join, Full join) Table aliases;
Natural joins;
Multi-table joins;
Union, Union All, Except, Intersect.
Session 7: Functions:
SQL Numeric Functions (ABS, SIGN, MOD, etc.)
SQL Built-In String Functions (Locate, Left, Right, Concatenate, etc),
SQL Built-in DATE and TIME functions.
Session 8: SQL Views (Create, alter and drop), Stored Procedures with Input and Output parameters
Session 9: Creating Databases and Tables
Session 10: SQL Indexes.
Session 11: Managing Data: Inserting rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
Session 12: SQL Server Access Control: Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges.
Session 13: Import data into SQL and Export from SQL.

Venue: PCWorkshops, Golden Cross House, 8 Duncannonn Street, London, WC2N 4JF

Price

SQL Intermediate 3-Day Seminar: GBP 800.0
SQL Intermediate 3-Day Seminar Early Bird: GBP 750.0

Links:

Website: https://go.evvnt.com/583576-0?pid=269
Tickets: https://go.evvnt.com/583576-1?pid=269
Facebook: https://go.evvnt.com/583576-2?pid=269

More details


Date(s)3 - 5 Feb 2020
WebsiteVisit website
VenuePCWorkshops
AddressGolden Cross House, 8 Duncannonn Street, London, Greater London,
WC2N4JF

Explore localWhat's on in London
 Local tourist information guide
Other eventsWhat's on at PCWorkshops


Main photo may be copyright © LoveEvvnt


Nearest Hotels

Chandos house

ROOMS FROM£0
92mAWAY
0

Located 200 metres from Trafalgar Square, Chandos house offers accommodation in London. Guests benefit from terrace. Free WiFi is available throughout the property.

Postcode: WC2N 4HS
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Club Quarters, Trafalgar Square

ROOMS FROM£128.52
143mAWAY
4

Just off Trafalgar Square, Club Quarters has an elegant brasserie and boutique rooms with free Wi-Fi. The National Gallery and Nelsons Column are a 2-minute walk away..

Postcode: WC2N 5BY
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

The Grand at Trafalgar

ROOMS FROM£128.52
146mAWAY
4

Just off Trafalgar Square, in Central London, this beautifully restored Victorian building houses a 4-star luxury hotel offering free Wi-Fi and elegant air-conditioned rooms..

Postcode: WC2N 5BY
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Covent Garden Apartments

ROOMS FROM£183.2
163mAWAY
0

Situated just a few metres from Trafalgar Square, Covent Garden Apartments offer self-catering accommodation in Central London. The property is 100 metres from Charing Cross and 200 metres from Embankment on the River Thames..

Postcode: WC2N 6NE
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Citadines Trafalgar Square

ROOMS FROM£182
188mAWAY
4

Citadines Trafalgar Square London offers modern, self-catering accommodation in central London. Trafalgar Square is just 150 metres away, and Embankment Underground Station is a 2-minute walk..

Postcode: WC2N 5EA
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

The Trafalgar Hilton

ROOMS FROM£191.2
219mAWAY
4

This deluxe 4-star hotel is on Londons famous Trafalgar Square, just half a mile from Westminster. There is a roof-top bar with spectacular views of the Square..

Postcode: SW1A 2TS
Distance from PCWorkshops:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

View all hotels near PCWorkshops


Your comments:

comments powered by Disqus

Disclaimer: This event is not organised by BritEvents, and we cannot be held responsible for the accuracy of the information provided, errors, or omissions. Always check the information provided before you book tickets.

Event Details

Date3 - 5 Feb 2020
Time(s)11:00 AM - 6:00 PM
CostSee full price details in event description
VenuePCWorkshops
Golden Cross House, 8 Duncannonn Street
London
Greater London
WC2N4JF
Phone02071646359
CategoryMiscellaneous


LoveEvvnt

Added
18 Jan 2020

Contact organiser

View full profile