Description
SQL Training Course Specification
- What is a database?
- Different types of databases.
- On Promise vs On Cloud databases.
- Primary Keys and Foreign Keys.
- How to import data from an excel file into a database.
- How to import data from a csv file into a database.
- How to view imported data easily.
- How to use a Select Statement.
- How to use a Where statement.
- How to use an Order By clause.
- How to use a Group By clause and ways to summarise data.
- How to use a Having clause.
- Working with strings by using other SQL functions.
- How to define and use Case Statements.
- How to change data types with cast and convert functions.
- How to create a ranking in a table.
- Working with dates and times in SQL.
- The different types of joins and how they can be used.
- The best practises when joining tables together.
- How to use Insert Into statements.
- How to use Drop Table Statements.
- What are the advantages and disadvantages of using these.
- What is a Common Table Expression (CTE)?
- When should a CTE be used instead of a standard table and why?
- Sub Select statements and why they are useful.
- What is a View?
- When to create views rather than tables.
- How to create and update views.
- Designing a database.
- Normalisation of a Database.
- Indexing in a database. What is it and why are indexes useful?
- Creating Users and Controlling Access Security.
- Scheduling Jobs.
- Setting up Mail Alerts.
