 . ')
No products in the cart.
Course Schedule
Overview
During this 5-day course, students will learn Transact-SQL as implemented in SQL Server 2008, 2012 and 2014. The course starts by establishing a foundation understanding of database concepts and terminology. Students are then prepared to use various Microsoft tools to submit queries and view the result.
Following a logical process for creating SQL queries from business requirements, students learn how to write a query based on the way SQL Server processes the SQL statement. This differs from most courses, which present SQL as a set of features. This approach uses the natural way of breaking down the problem into a logical set of steps. Each step can be validated before moving to the next step.
Finally, the course teaches the student how to use T-SQL statements inside common database objects like Views, Stored Procedures and User-Defined Functions.
Lectures that highlight and explain T-SQL concepts are reinforced with extensive demonstrations and hands-on labs.
Audience Profile
This course is intended for SQL Server Developers, Database Administrators, and System Engineers who are responsible for writing T-SQL queries for an application
At Course Completion
After attending this course, students will be able to:
- Describe the objects that make up a database, data relationships within the database and how databases guarantee uniqueness of defined objects.
- Understand different sublanguages of SQL.
- Use the SQL Server Management Studio
- Write a simple SELECT statement, returning all the columns and rows.
- Formulate and write a meaningful join strategy to bring together all necessary data.
- Utilize a subquery to reshape data before using it in a query
- Write a WHERE clause to filter the rows
- Control the display of data
- Write Transact-SQL queries and aggregated values
- Define the attributes of a database transaction and generate a result set
- Create a database view and in-line table value functions and execute simple scalar/multi-statement user-defined functions
- Write procedural logic for Stored Procedures and User-defined Functions
Outline
1. Database Concepts
2.Using the Tools
3. Getting the Data
4. Filtering the Data
5. What to Display
6. Aggregating the Data
7. Modifying the Data
8. Modules
9. Procedural Logic
Prerequisites
Before attending this course, students should have familiarity with programming and developing software using any language.
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.