Product Description
With this course you’ll take your database programming skills to a new level, learning all the details about programming and designing your database with T-SQL. It starts from the basics and then moves on towards more advanced topics.
Although the main goal of this course is not to prepare certifications, if you work hard you can use this course as a preparation to pass the 70-461: Querying Microsoft SQL Server 2012 and 70-464: Developing Microsoft SQL Server 2012 Databases Microsoft Official Exams in your path to become a SQL Server Certified Professional or Systems Engineer.
You will love this!
The course is more than just canned videos for you to watch. All the study and training resources are 100% campusMVP.Net original. Our experts have created new course contents from scratch. It includes theory, practice videos, code examples and continuous MVP/MCT trainer support to help you progress and answer all your doubts.
Become an expert! Why is a campusMVP.Net course better than regular in-company or classroom training?
Upon completing the course, you can download all the theory materials in PDF format so that you can use them for future reference. These resources are printable, include navigation and are indexed for search purposes.
Course Features
- Course access period: 3 months (12 weeks)
- Course length: 57 hours (although this depends greatly on your current skills)
- Dedication time needed: 4-5 hours per week.
- Level: intermediate
- We include a downloadable campusMVP.Net achievement diploma
- One-to-one coaching by expert MVP/MCT trainers to answer questions and doubts throughout the course
If you have any questions or doubts, we are eager to help you. Just ask!
Outline
The content consists of six comprehensive modules:
- Working with Database Objects
- T-SQL and Programmability
- Working with Indexes
- Working with Transactions
- SQL Server Security
- SQL Server Troubleshooting
Student profile requirements
It is assumed that the students know the fundamentals of the databases and have a bare minimum working knowledge of any Relational Database System such as MySQL, Oracle, or SQL Server.
Summary
This course offers all the resources you need to study SQL Server 2012 in depth:
- 3 month access to complete the “Hands on SQL Server 2012: Expert Programming and Design” course. Study 24×7, practice at your own pace and from wherever you want.
- 3 months of expert coaching and trainer support: the MVP/MCT expert that has developed the course content is the same person available throughout the certification exam training course to answer every single question and doubt you might come up with while completing this training.
- Study methodology: we give insight and advice on how to study this course.
- The right amount of theory needed, just enough and no more :-). This course is designed towards real-world developing skills, with coding examples and exercises. At campusMVP.Net we always balance theory with practice.
- Precise practice videos that go straight to the point to explain the most important features visually.
- Coding examples for you to download and run on your computer.
- Course self-evaluation test.
- Downloadable certificate of completion upon passing the final course exam.
Theory material is downloadable in PDF upon completing the course. Once you have passed the course exam you can download the course resources for future reference use: theory, developing tips and expert advice.
Your Trainer
Alessandro Alpi
SQL Server MVP
Alessandro works as Systems Engineer and .NET Developer since 2000. He has extensive experience working in web solutions, Windows applications and services. Presently, he works full time as a DBA/DB Developer with the latest SQL Server versions.
As a dotnethell.it blogger, he’s a very active member of the community.
He is also a Microsoft Certified Trainer, MCITP and MCPD.
Meet the course trainer in our blog.
Course Syllabus
The contents have been created from a practical point of view. You will find explanatory videos as well as code samples at the end of each module to reaffirm what has been learned. The source code for the examples is available for downloading.
Throughout the duration of the course you will have one of the leading experts within this field available to solve your questions or doubts.
MODULE 1: Working with Database Objects
1.1: DEMO: Using SQL Server Management Studio
1.2: Understanding Tables
1.3: Data Types in SQL Server
1.4: DEMO: Creating and Modifying Tables using SSMS Designers and T-SQL
1.5: Tables and Columns Options
1.6: DEMO: Setup Options on Columns using Designers and T-SQL
1.7: Understanding Constraints
1.8: DEMO: Creating and Modifying Constraints using SSMS and T-SQL
1.9: Understanding Views
1.10: DEMO: Creating the Three Kind of Views
1.11: Understanding Synonyms
1.12: Understanding Triggers
1.13: DEMO: Creating and modifying DML Triggers
1.14: Summary
MODULE 2: T-SQL and Programmability
2.1: Modifying Data with DML
2.2: DEMO: DML Samples
2.3: Working with Queries and Subqueries
2.4: DEMO: Recursion with Common Table Expressions
2.5: Extending the Resultsets
2.6: Extending the Resulsets Manipulating Data Sets
2.7: DEMO: Usage of INNER and OUTER Joins
2.8: Temporary Objects
2.9: DEMO: Split Queries Step by Step with Temp Tables
2.10: Coding with T-SQL Constructs
2.11: Working with Stored Procedures
2.12: Working with Functions
2.13: DEMO: Create and Modify Stored Procedures and Functions
2.14: CLR Assemblies
2.15: Summary
MODULE 3: Working with Indexes
3.1: Types of Indexes
3.2.- Special Types of Indexes
3.3: DEMO: Create Indexes with SSMS and T-SQL
3.4: Optimizing Indexes
3.5: DEMO: Rebuild and Reorganize Indexes via SSMS
3.6: Statistics and Execution Plans
3.7: DEMO: Indexes and Execution Plan
3.8: Summary
MODULE 4: Working with Transactions
4.1: Types of Transactions
4.2: DEMO: Transactions Management with Error Handling
4.3: The Isolation Levels
4.4: Locks and Lock Escalation
4.5: DEMO: Pessimistic Access vs Optimistic Access
4.6: Understanding Deadlocks
4.7: DEMO: Simulating and Profiling a Deadlock
4.8: Summary
MODULE 5: SQL Server Security
5.1: Server Login and Database Users
5.2: The Server Roles
5.3: The Database Roles
5.4: DEMO: Creating Logins and Mapping Users
5.5: Application Roles
5.6: DEMO: Data Control Language in Action
5.7. Security on programmability objects
5.8. Summary
MODULE 6: Monitoring and Troubleshooting
6.1. The System Monitor
6.2. The SQL Server Profiler
6.3. DEMO: Using Perfmon and Profiler Together
6.4. The Activity Monitors
6.5. The Database Tuning Advisor
6.6. DEMO: Using the DTA
6.7. Understanding Dynamic Management Views and Functions
6.8. Summary
What others are saying about this course
It has been a pleasure for me to review Alessandro’s course. The ‘Hands on SQL Server 2012: Expert Programming and Design’ course provides coverage of everything you need to know about programming with SQL Server 2012.
The course is designed for a variety of skill levels, so the beginners can learn SQL Server fundamentals chapter after chapter in a comprehensive way; more experienced developers can improve their knowledge through a lot of external links to study the subject in depth.
The course is well written, easy to follow and includes detailed descriptions, often with a short video, to get an understanding of what SQL Server programming is.
Luca Bianchi
Microsoft MVP SQL Server
The videos were very clear, the examples were good, and there weren’t indications of a lot of “fixes” added to the content. I’ve seen some videos by non-native speakers where the video was very choppy video because they made so many corrections and amendments. This is not the case in this course.
Kevin Kline
SQL Server MVP
Luca Bianchi – :
It has been a pleasure for me to review Alessandro’s course. The ‘Hands on SQL Server 2012: Expert Programming and Design’ course provide coverage of everything you need to know about programming with SQL Server 2012.
The course is designed for a variety of skill levels, so the beginners can learn SQL Server fundamentals chapter after chapter in a comprehensive way; more experienced developers can improve their knowledge through a lot of external link to study the subject in depth.
The course is well written, easy to follow and include a detailed description, often with a short video, to get an understanding of what SQL Server programming is.
Luca Bianchi
Microsoft MVP – SQL Server
Kevin Kline – :
The videos were very clear, the examples were good, and there wasn’t indications of a lot of “fixes” added to the content. I’ve seen some videos by non-native speakers where the videos had very choppy video because they made so many corrections and amendments. This is not the case in this course.
Kevin Kline
SQL Server MVP