SQL for Developers

Audience Profile

This course is for anyone who wants to learn how to work with a SQL Server database, regardless of prior programming experience. This includes…

Anyone who wants to learn standard SQL
Anyone who wants to understand how relational databases work
Anyone who wants to become a SQL developer
Experienced developers who want to use SQL to improve the functionality and performance of their apps
Data analysts who want to write SQL statements that retrieve the data they need in an efficient way
Developers who need to design, create, and maintain a database

Anyone who wants to take the first step toward becoming a database administrator (DBA)

Outline

Section 1 – Introduction to SQL
Relational Databases and SQL
Microsoft SQL Server Management Studio

Section 2 – Essential SQL Skills
How to retrieve data from one table
How to retrieve data from multiple tables
How to code summary queries
How to code subqueries
How to insert, update, and delete data
How to work with data types
How to use functions

Section 3 – Database Design and Implementation
How to design a database
How to create and maintain a database with SQL
How to create and maintain a database with Management Studio

Section 4 – Advanced SQL
How to work with views
How to code scripts
How to code stored procedures, functions, and triggers
How to manage transactions and locking
How to manage database security

Section 5 – An Introduction to Azure
How to use Azure Data Studio
How to work with Azure SQL

Section 6 [Optional] – Connecting SQL Server to an Application
Connection strings
.NET / Java SQL objects
Connecting and calling the application