Basics of SQL Server from scratch and Database Concepts

This course will take you from novice to expert level in SQL development using SQL server

Created by: Robert Meldrum
Consultant data engineer and computational physicist

What Will I Learn?

• Setup SQL Server and use SQL Server management studio (SSMS) and azure data studio to write queries.
• Setup an Azure cloud instance of SQL Server.
• Select, sort and filter data with an understanding of the order of precedence.
• Modify data with string, date, and maths functions.
• Convert data types and apply decision logic.
• Aggregate and group data both to the entire table and in line with windows functions.
• Facilitate more complex requirements with sub-queries.
• Structure of table relationships and cardinality.
• Join tables together with the INNER, OUTER, FULL and CROSS joins.
• Union multiple data sets together.
• Understand OLTP and OLAP data architectures along with 3rd Normal Form and ACID transactions.
• CREATE, ALTER, and DROP a database, table, and schema.
• Add column, primary and foreign key constraints to a table.
• Indexes for use in query optimisation.
• Insert, update, and delete data into a table.
• Advanced features including views, stored procedures, functions, locks, transactions, cursors, and triggers.
• Import, export and alter JSON and XML data structures into and out of tables.

Requirements

• The course assumes no pre-existing knowledge and will take you through each step. For those who already have some coding or SQL experience, your knowledge will be expanded, and you will obtain a more in-depth understanding of SQL development and database concepts.

Target audience

• This course is for anyone who works with data. You may be a BI developer, data engineer, data analyst, data scientist, web developer, computer programmer, student, or work in a non-technical area such as finance but you need to extract and manipulate data from a database. The course will develop those with some or no knowledge into SQL experts.