SQL Intermediate 2-Day Course, Manchester OR Online

Schedule

Mon Aug 06 2018 at 11:00 am to Mon Sep 02 2024 at 04:00 pm

UTC+01:00

Location

82 King St | Manchester, EN

Advertisement
Excellent SQL Course for advanced topics, more and more people are now attending this useful course.
About this Event

SQL Intermediate 2-Day Course

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

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

 

Advertisement

Where is it happening?

82 King St, 82 King Street, Manchester, United Kingdom

Event Location & Nearby Stays:

Tickets

GBP 300.00 to GBP 600.00

PCWorkshops

Host or Publisher PCWorkshops

It's more fun with friends. Share with friends

Discover More Events in Manchester

Trafford Rounders Tournament
Wed Jul 17 2024 at 06:15 pm Trafford Rounders Tournament

Urmston Grammar School (Moorside Rd Entrance) via Urmston Sports Club

TOURNAMENTS SPORTS
Bachata Class and Social - Guest Teachers Roberto & Yoana
Wed Jul 17 2024 at 06:15 pm Bachata Class and Social - Guest Teachers Roberto & Yoana

Terrace NQ

WORKSHOPS PARTIES
Ania Card and Amy Twigg in conversation with Lara Williams
Wed Jul 17 2024 at 06:30 pm Ania Card and Amy Twigg in conversation with Lara Williams

Blackwell's Bookshop

ART LITERARY-ART
MCR Connect
Wed Jul 17 2024 at 06:30 pm MCR Connect

Dukes 92 - Bar & Restaurant

Floripa Manchester \/\/ Commercial | Latin | Urban | House \/\/ Every Wednesday \/\/ Get Me In!
Wed Jul 17 2024 at 07:00 pm Floripa Manchester // Commercial | Latin | Urban | House // Every Wednesday // Get Me In!

Floripa Manchester

ENTERTAINMENT MUSIC
Alkaline Trio
Wed Jul 17 2024 at 07:00 pm Alkaline Trio

O2 Ritz Manchester

MUSIC ENTERTAINMENT
Life Drawing with HOP - ANCOATS - WED 17TH JULY
Wed Jul 17 2024 at 07:00 pm Life Drawing with HOP - ANCOATS - WED 17TH JULY

23 Radium Street,Ancoats,M4 6AY,GB

ART FINE-ARTS
Neurowavy Meetup
Wed Jul 17 2024 at 07:00 pm Neurowavy Meetup

Station South

MEETUPS
SQL Intermediate 2-Day Course, Manchester OR Online
Mon Aug 06 2018 at 11:00 am SQL Intermediate 2-Day Course, Manchester OR Online

82 King St

WORKSHOPS VIRTUAL
Oracle SQL Fundamentals 3-day Course, Manchester OR Online
Mon Sep 03 2018 at 11:00 am Oracle SQL Fundamentals 3-day Course, Manchester OR Online

82 King St

WORKSHOPS VIRTUAL

What's Happening Next in Manchester?

Discover Manchester Events