SQL Queries and Data Analytics 1-Day Workshop

Memo

SQL Queries 1-Day CourseProvides the knowledge and skills needed to retrieve and analyse data held in a database.  Who Should AttendAnyone who needs to understand and use SQL to manipulate a database. There are no formal pre-requisites for this course, although an understanding of databases and exposure to information technology in general would be useful.  Course OutlineRelational Database ConceptsWhat is a Relational Database?Tables, Rows and ColumnsIndexes, Primary Keys and Foreign KeysData TypesThe Data DictionaryGetting StartedSQL Language EssentialsThe Select StatementThe Select and From ClausesConditions and the Where ClauseThe Order By ClauseArithmetic OperationsColumn AliasesPractical ExercisesSummarizing and Grouping DataAggregate FunctionsThe Group By ClauseThe Having ClausePractical ExercisesQuerying Multiple TablesJoining Tables with Inner JoinsColumn Qualification and Table AliasesOuter Joins, Self Joins, Alternative Join SyntaxPractical ExercisesAdditional SQL FeaturesCombining QueriesThe Union, Intersect and Minus OperatorsBasic SubqueriesPractical Exercises INCLUDED: What can/can't I bring to the event?You can bring your own Laptop - let us know beforehandYou can bring your own data and examples - let us know beforehandRefreshments: Tees, coffees and light refreshments are included in the priceCertificates:  You will get attendance certificatesIncluded: Notes. Query examples and exercises. After course support: 2-hours online revision session