MA-SQLDEV: SQL for Developers
About this Course
Welcome to our intensive 4-day SQL for Developers course using Microsoft SQL Server. Designed to equip developers with the fundamental skills and advanced techniques needed to master SQL, this comprehensive program provides a deep dive into database querying and management. Whether you’re a beginner looking to establish a strong foundation or a seasoned developer seeking to enhance your proficiency, this course offers hands-on instruction, real-world scenarios, and practical exercises to elevate your SQL expertise. Get ready to unlock the power of databases and propel your development career forward in just four days!
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)
At Course Completion
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