SQL Intermediate 2-Day Course, Manchester. Classroom or Virtual Classroom.

SQL Intermediate 2-Day Course, Manchester. Classroom or Virtual Classroom.
Image from eventbrite.com
Thu 11 June 2020
Thursday 11 June 2020
11:00 AM - 6:00 PM
Ended

SQL Intermediate 2-Day Course

Because of the Corona-Virus Situation, we offer the courses online only until further notice.

Duration: 2 consecutive days, the first thereof listed

By storing data in SQL, one can easily and quickly, with the use of queries, retrieve valuable information, trends, summaries, statistics and insights from your company data.     
In this SQL Course you will learn how to get valuable information, trends, summaries, statistics and insights from your company data using SQL.
This course is ideal for managers and data analysts who need to get business intelligence from data

Virtual Classroom: You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket. 

Course Overview:

Candidate who would like to gain a basic understanding of a SQL database and SQL commands and move on the next stage. The content of the course covers the topics required for the Certified SQL Developer I examination.

Prerequisites: Familiarity with relational database concepts is helpful but not required. No existing knowledge on SQL is required, but will help.
.
 SQL Course Desciption
Session 1: Database Concepts
Brief revision of  database basics. Tables, rows and columns, Indexes, primary keys, foreign keys, Supported data types, table types. 
Session 2: Using the SQL client
Selecting a database, 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.LIMIT / TOP. Distinct.

  Session 4: Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”),
  Session 4:SQL AGGERGATE Functions: 
Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Having.
Joins: SQL Cartesian products, SQL Joins (Inner join, Left join, Right join, Full join) Table aliases.   Multi-table joins   Union, Union All, Except, Intersect   Session 5: Built-in Functions: SQL Numeric Functions (ABS, SIGN, MOD, etc.) String Functions (Locate, Left, Right, Concat, etc.) DATE and TIME functions. Formatting numbers and dates. Converting.   Session 6: SQL Subqueries, Basic Subqueries, Nested Subqueries, CTE Tables.
Session 7: SQL Views (Create, alter and drop) Stored Procedures  (Create, alter and drop, Input and Output parameters)  Custom Functions  (Create, alter and drop)
Session 8: Managing Data:
Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints.
Session 10: SQL Indexes. Session 9:Creating Databases and Tables. Session 11:Import data into SQL and Export from SQL.  Session 12: Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line.

 

289 Views - 12/06/2020 Last update
trade shows courses
PCWorkshops Manchester
Regus, Manchester, Manchester, GB
Event from
eventbrite.com

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

Regus, Manchester, Manchester, GB

Browse other venues in Manchester
Discover now


Discover more events in Manchester
Discover now



PCWorkshops Manchester
Regus, Manchester, Manchester, GB
Event from
eventbrite.com


Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
  1. Manchester
  2. PCWorkshops
  3. SQL Intermediate 2-Day Course, Manchester. Classroom or Virtual Classroom.
 
 
 
 
Your changes have been saved.