SQL Intermediate 3-Day Course
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. The data might be anything from a simple shopping list to a picture gallery to the vast amounts of information in a corporate network.
Why use SQL: Retrieve data simply quickly and easily. Make sense of your data. MySQL is cost effective (open source database) Secure and Cross-Platform cost of maintenance is pretty low and a favored option for small and medium sized companies.
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.
No existing knowledge on SQL is required. You should have basic computing knowledge. Familiarity with relational database concepts is helpful but not required.
SQL Course summaryIn 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.
SQL Course Desciption
Session 1: Database Concepts To assist with the SQL aspects of the SQL Course we also cover database basics. 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 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 (=!=>
Session 4: LIMIT / TOP UNION Queries and SQL AGGERGATE Functions The LIMIT and TOP clauses Aggregate (Sum Average Maximum Minimum Count) Group By Rollup with Group By Having.
Session 5: SQL Subqueries Basic Subqueries Nested Subqueries CTE Tables
Joins: SQL Cartesian products SQL Joins (Inner join Left join Right join Full join) Table aliases Natural joins Join using Join on Multi-table joins Union Union All Except Intersect
Session 6: SQL Numeric Functions (ABS SIGN MOD etc.) and String Functions (Locate Left Right Concat etc) DATE and TIME functions
Session 7: SQL Views (Create alter and drop) Stored Proecdures with Input and Output parameters
Session 8: Creating Databases and Tables
Session 9: SQL Indexes 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: SQL Server Access Control Creating users Renaming users Dropping users Granting privileges Revoking privileges
Session 12: Import data into SQL and Export from SQL
Exporting using SQL Importing using SQL Exporting from the command line Importing from the command line
Tickets for SQL Intermediate 3-Day Course, Online Instructor-led can be booked here.