SQL Intermediate 3-Day Course: With MS SQL Server, one can use data queries to easily and quickly retrieve valuable information, trends, sumSQL 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
SQL Intermediate 3-Day Seminar: GBP 800.0 SQL Intermediate 3-Day Seminar Early Bird: GBP 750.0
AddressGolden Cross House, 8 Duncannonn Street, London, Greater London,
Explore localWhat's on in London
Local tourist information guide
Other eventsWhat's on at PCWorkshops
Main photo may be copyright © LoveEvvnt
Located 200 metres from Trafalgar Square, Chandos house offers accommodation in London. Guests benefit from terrace. Free WiFi is available throughout the property.
Club Quarters, Trafalgar Square
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..
Covent Garden Apartments
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..
Citadines Trafalgar Square
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..
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.