1 / 25

Microsoft SQL Server Overview: Product, Courses & Background

Microsoft SQL Server Overview: Product, Courses & Background. By George Squillace New Horizons Great Lakes Husband, Dad, Coach, MCT , MCSE, MCDBA MCITP – SQL 2008 Business Intelligence Development MCITP – Database Administration MCTS – Database Development

kaili
Download Presentation

Microsoft SQL Server Overview: Product, Courses & Background

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Microsoft SQL ServerOverview:Product, Courses & Background By George Squillace New Horizons Great Lakes Husband, Dad, Coach, MCT, MCSE, MCDBA MCITP – SQL 2008 Business Intelligence Development MCITP – Database Administration MCTS – Database Development MCITP – Enterprise Messaging Administrator on Exchange 2007 MCITP – Enterprise Administrator on Windows Server 2008 MCTS – Vista Deployment CompTIA A+, Network+

  2. Product knowledge is in high demand • The product is becoming increasingly entrenched • It’s market share is growing • The need to learn the product is in high demand. • The following Microsoft products require some edition of SQL Server • SharePoint • System Center Configuration Manager (SCCM) • System Center Virtual Machine Manager (SCVM) • System Center Operations Manager (SCOM) • System Center Data Protection Manager (SCDPM) • ForeFront Endpoint Protection • Microsoft Dynamics CRM • More confidently sell high margin courses that are not provided by many vendors. • Be able to respond to customer questions more rapidly. • Make better course recommendations. • Grow in your career skills. Why should you care about selling SQL Server courses?

  3. SQL (Structured Query Language) is a data-oriented programming language • SQL is an industry standard (ANSI, ISO) • SQL permits a nearly universal method of querying (interacting with and changing) database data • Most popular database servers support their own form of SQL (Microsoft’s is “Transact-SQL” or “T-SQL”) • Microsoft SQL Server is a software product What is “SQL”, Anyway?

  4. The least amount of SQL code that can successfully be submitted for processing is a statement. Statements are organized in to statement categories, such as “DML” and “DDL”. • Database Administrators would use most or all categories of SQL statements. • Database Developers would use most or all categories of SQL statements. • Ad hoc query writers and report writers would primarily use the SELECT DML statement.

  5. SQL Server was originally a product by Sybase • Microsoft joint-developed the product early on but later severed ties to Sybase • There have been many versions of the product • Having gone through many versions and refinements SQL Server is a mature, robust, & stable product • SQL 2012 was released on April 1, 2012. Reference: http://en.wikipedia.org/wiki/Microsoft_Sql_Server A bit of Microsoft SQL Server Product History

  6. There are many installable components to the SQL Server product • All these features are included with the price (depending on the Edition purchased) What SQL Server is best known for, the relational database service. SQL Server ComponentsIn other words, “What does this product do? Reference: http://www.e-squillace.com/tech/screenshotgallery/SQL/SQL2008/SQL2008_InstallScreenshots/Step9a-FeatureSelection_Empty.JPG

  7. www.microsoft.com/express • There are also free editions of the Visual Studio Windows and Web development tools! • The free edition of SQL Server (SQL Server Express Edition) and the free versions of Visual Studio are found at the URL above SQL Server for free?

  8. Next: Let’s look at application architecture…

  9. “Front-End” Custom Programming v. “Back-End” Custom Programming Compare this model to: Microsoft Access FileMaker FoxPro • Front-End Application Design • Custom Windows application using Visual Studio or alternatives • Custom Web application using Visual Studio or alternatives • Many Custom-made Applications Involve a Database • Back-EndDatabase Design • Built Using Transact-SQL and/or GUI Tools • Stored Procedures • Views • Functions • Triggers Reference: Database Construction Building Blocks Diagram

  10. Example of a Custom Data-drivenWindows Application

  11. Example of a Custom Data-drivenWeb Application

  12. Database Administrator (DBA) (including “Accidental DBAs”) • Database Developers • Business Intelligence Developers • Report Writers / Developers • OLAP (Online Analytical Processing) and Data Mining Developers and Users • ETL Developers (Extract, Transform, & Load) • Business Analysts List of Job Roles which are Candidates for SQL Server Training

  13. 2778A – Writing Queries Using SQL Server 2008 Transact-SQL (3-days) • Target: All data professionals (DBAs and Devs), Report Writers, Business Analysts • The SQL 2012 successor is course 10774A (five days) • 6231B – Maintaining a SQL Server 2008 Database (5 – days) • Target: Database Administrators (DBAs) • The SQL 2012 successor is course 10775A (five days) • 6232B – Implementing a SQL Server 2008 Database (5 – days) • Target: Database developers (Devs) • The SQL 2012 successor is course 10776A (five days) • We also offer courses from the courseware library, such as 50400 Core SQL Server 2008 Courses Ask: What do you need to know about the “B” revisions of these courses?

  14. From Wikipedia: Business intelligence (BI) is a businessmanagement term which refers to applications and technologies which are used to gather, provide access to, and analyze data and information about company operations. • Business intelligence systems can help companies have a more comprehensive knowledge of the factors affecting their business, such as metrics on sales, production, internal operations, and they can help companies to make better business decisions. • So, BI is about making better decisions. • Use ToolsàGet FactsàDraw ConclusionsàImplement Changes. Definition: What is Business Intelligence (BI)?

  15. 6234A – Implementing SQL Server Analysis Services (3-days) (If taking more than one BI course take this last!) • Working with Multidimensional Databases (rather than Relational) and Data Mining) • 6235A– Implementing SQL Server Integration Services (3-days) • Transferring and Transforming Data (a.k.a., ETL, “Extract, Transform, & Load”) • 6236A– Implementing SQL Server Reporting Services (3-days) • Data Presentation Platform Business IntelligenceSQL Server Courses These course revisions are more tool-oriented than task-oriented, which (fortunately) changes in the SQL 2012 courses. • These courses are combined into two, five day courses in SQL 2012; courses 10777A and 10778A.

  16. Reference: SQL Server 2008 Certification Paths diagram

  17. Increases product knowledge • Increases competency; can solve more and different kinds of problems • Increases confidence • May lead to other job opportunities within and outside of your current organization • “You don’t know where you’ll be working next Monday, so pack a parachute!” -me Why Certify?

  18. SQL 2008 BI Exams • Case study, my MCTS BI exam v. my MCITP BI exam(Very challenging…my MCITP BI exam was 88 lengthy story problems, three full hours long) • Remember, the BI exams cover all three functional BI areas, and test over Analysis Services disproportionately, which is the most challenging of the three areas! • On my website homepage there is a link called “Strategies for Passing Certification Exams”. A Few Specifics on SQL BI Certifications & Exams

  19. Basic Windows User Interface Knowledge • Basic Windows Server Operating System Knowledge • User and Group Accounts • Services and Service Accounts • File System and Shared Folder Permissions • Background Relational Database Experience • (Microsoft Access experience “counts”) SQL ServerCourse Prerequisites

  20. Basic Windows User Interface Knowledge • Basic Windows Server Operating System Knowledge • Background Database Experience • (Microsoft Access experience “counts”) • SQL Server Administration and Possibly Programming Experience • Course 2780 or 6231 • Course 2779 or 6232 • Basic Query Writing Knowledge • Course 2778 Suggested BI Course Prerequisites

  21. Microsoft released SQL 2008 R2(the second SQL 2008 release, also known as version 10.5) in April 2010. • As of yet there are no plans to release SQL 2008 R2-specific business intelligence course versions. • Miscellaneous note: Microsoft offers free versions of SQL Server and Visual Studio with smaller feature sets. These are called Express Editions. What about SQL 2008 R2?

  22. Microsoft SQL Server homepage • www.microsoft.com/sql • Microsoft Learning homepage • www.microsoft.com/learning • My website • Homepage • www.e-Squillace.com (Search button, Test taking tips link) • Diagrams • www.e-Squillace.com/tech/techdiagrams (several SQL and SQL BI diagrams) • Screenshot Gallery • www.e-Squillace.com/tech/screenshotgallery (look in the SQL screenshot category; a SQL BI category exists too) • SQL Server reference homepage • www.e-Squillace.com/tech/techreference/sql(a huuuuge amount of links) • SQL Server BI reference homepage • www.e-Squillace.com/tech/techreference/sqlbi/sqlbi.htm (also a huuuuge amount of links) • My Library Books (click on this link) • List of SQL Server User Groups in the Great Lakes Region, such as… • Chicago.SQLPass.org September 17, 2011 Resources (for you and your clients)

  23. Learn & study? • Download? • Call a client with a recommendation or new opportunity? • Flee? • Other? What Are Your Action Items? Reference: Suggested Action Items List

  24. Thank you for your time!

More Related