SQL Intermediate 2-Day Course, Manchester, Online
Event Information
Description
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.
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.
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
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).
Joins:
Session 7:
Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints.