SQL Server Intermediate 3-day Course with PCWorkshops
Event on 2017-07-05 11:00:00
Learn how to get valuable information, trends, summaries, statistics and insights from your company data. The data might be anything from a Small CRM to online sales or search stats, to the vast amounts of information in a corporate network.
This course is ideal for managers who need to get business intelligence from their data, or data analysts who should provide such information.
Prerequisites: No existing knowledge on SQL is required. – Beginners and Intermediate in one course
Duration: 3 days. Max group size is 4.
*Session 1: Database Concepts
What is a database? Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
*Session 2: Using the SQL client
SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts
*Session 3: Basic SELECT
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators
*Session 4: LIMIT, UNION and AGGERGATE Functions
The LIMIT clause, Union, Union all, Aggregate, GroupBy , Rollup with group By, Having.
*Session 5: Subqueries and Joins
Subqueries, Cartesian products, Joins with original syntax, Table aliases, Natural joins, Join using, Join on, Multi-table joins
*Session 6: Numeric and Character Functions
*Session 7: DATE, TIME and Other functions
*Session 8: Databases and Tables
*Session 9: Indexes and Views
*Session 10: Managing Data
Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits
*Session 11: Access Control
Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges
*Session 12: Import and Export
Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line
Also included in the price:
Certificate on completion (assessment based)
Practical Class exercises, Homework / Revision work
To assist after the course : >> 1-1 mentoring, online via Skype, online videos
at London Connections
8 Northumberland Avenue
Charing Cross, United Kingdom