Microsoft SQL Server Overview Product Courses Background by
Microsoft SQL Server Overview: Product, Courses & Background by George SQUILLACE August 23, 2018
George SQ UILLLACE SQL ” is in the name! “SQL n Husband & Dad n Twenty Five Years of New Horizons service For fun: (no particular order) (June 2016) n n n Movies Reading Bicycling (road / city / trail) Travel Music / Acoustic Guitar Computers Aircraft ~30 years in Information Technology Microsoft Certified Trainer (MCT) since 1997 99 times in the exam booth! Microsoft SQL Server certifications MCSE: Business Intelligence MCSE: Data Platform MCSA Microsoft Virtual Academy presenter SQLSaturday presenter Certified in every version of SQL Server since SQL 2000 Certified in every version of Windows Server from NT 4. 0 – Windows Server 2008 + " George. Squillace@NHLS. com www. e-Squillace. com
high demand (and a zillion third-party applications) high margin courses questions recommendations • Grow
programming language • Microsoft SQL Server software product
Reference: “Microsoft SQL Server” at Wikipedia Trivia: How many developers at Microsoft work on SQL Server? 2, 000
What SQL Server is best known for, the relational database service. Reference: http: //tinyurl. com/pa 5 e 8 zp
Enterprise Edition feature Trial Edition • Now free! SQL Server Express Edition Visual Studio development tools Community Edition
Pragmatic Works
Microsoft Official Curriculum (MOC) SQL Server 2016/2017 Course Portfolio – Core Courses • 10985 C – Introduction to SQL Databases • 3 days [relational database design, normalization • 20761 C – Querying Data with Transact-SQL • 5 days • 20762 C – Developing SQL Databases • 5 days • 20764 C – Administering a SQL Database Infrastructure • 5 days, no installation • 20765 C – Provisioning SQL Databases • 5 days, includes SQL Serverinstallation, database creation and storage management • 20767 C – Implementing a SQL Data Warehouse • 5 days, data warehouse design, SSIS, DQS, MDS, Azure SQL Data Warehouse • 20768 C – Developing SQL Data Models 3 days, focus on SSAS multidimensional and tabular data models and one module on data mining
Microsoft Official Curriculum (MOC) SQL Server 2016/2017 Course Portfolio – BI and other Courses • 10986 B – Updating Your Skills to SQL Server 2016 • 3 days • 10987 C – Performance Tuning and Optimizing SQL Server Databases • 4 days • 10988 C - Managing SQL Business Intelligence Operations • 3 days • 20778 B – Analyzing Data with Power BI • 3 days, somewhat revised new course, formerly 10998 [two days] • 10990 C – Analyzing Data with SQL Server Reporting Services • Revision “C” is 5 days • Consider also the combination 55123 and 55128 for those that only need report development skills and focus on Report Builder as the development tool. • 20467 D - Designing Business Intelligence Solutions with Microsoft SQL Server • 5 days
Other query course alternatives are: • SQL Querying - Fundamentals formerly Level 1 • SQL Querying - Advanced formerly Level 2
BI to make more rapid, better quality business decisions Tools Facts Conclusions Changes
• Often, the foundation of a reporting and business intelligence solution
10986 Reporting Services 2016 10998
User Interface Knowledge Accounts • Services Permissions • Relational Database Experience helps a lot Database Structure of a Relational
The Fangorn Forest
This diagram represents the former “mis-alignment” between courses and exams; now exams and courses match more closely…mostly.
extremely challenging
Resources Download and distribute this to your clients from the linked picture below. SQL Server Microsoft Learning Homepage Diagrams Screenshot Gallery Refer your clients to the PASS-sponsored Detroit and Lansing SQL Server user groups (SPID and GLASS) SQL Server reference SQL Server BI reference product knowledge sessions video Power BI bookmark file this link blog posts There are Detroit and West Michigan Power BI user groups chapters also.
Reference: Suggested Action Items List
Don’t forget to wear an Aloha shirt on Aloha shirt Fridays!
- Slides: 23