No products in the cart.
Overview
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
FAQ
What if I have to reschedule my class due to conflict?
Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.
How do I enroll for this class?
Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.
What happens once I purchase a class?
You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.
What is your late policy?
If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.
What happens when I finish my class?
You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.