SQL Queries and Data Analytics 1-Day Workshop

Memo

SQL Queries 1-Day Course Provides 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 Concepts What is a Relational Database?Tables, Rows and ColumnsIndexes, Primary Keys and Foreign KeysData TypesThe Data DictionaryGetting Started SQL Language Essentials The Select StatementThe Select and From ClausesConditions and the Where ClauseThe Order By ClauseArithmetic OperationsColumn AliasesPractical Exercises Summarizing and Grouping Data Aggregate FunctionsThe Group By ClauseThe Having ClausePractical Exercises Querying Multiple Tables Joining Tables with Inner JoinsColumn Qualification and Table AliasesOuter Joins, Self Joins, Alternative Join SyntaxPractical Exercises Additional SQL Features Combining 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 URLs:Tickets: https://go.evvnt.com/581302-1?pid=5569Facebook: https://go.evvnt.com/581302-2?pid=5569 Prices:SQL Beginners 1-Day Seminar: GBP 380.0,SQL Beginners 1-Day Seminar Early Bird: GBP 350.0 Speaker: Sarah Barnard Time: 11:00 - 18:00 Venue Details: PCWorkshops, Golden Cross House, 8 Duncannon Street, London, City of Westminster, WC2N 4JF, United Kingdom