Page |
SQL101V2 - Introduction to Transact-SQL
You’ll gain a foundation understanding of a SQL Server database and use the tools available to discover the database definition, submit queries and view results. We teach students how to write a query the same way that SQL Server processes a SQL statement – following a step-by-step process for creating SQL queries from business requirements
|
MS-DP-080T00 - Transact-SQL Querying - LRS Education Services
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
|
SQL250 - Transact-SQL for Developers - LRS Education Services
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 ...
|
MS-DP-300T00 - Administering Relational Databases on Microsoft Azure
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based ...
|
SSRS795 - SQL Server Reporting Services (SSRS) – Authoring, Deploying ...
This course is an overview of how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. It also reviews Data Modeling, mobile reports and report mapping for ...
|
TTSQL005 - TTSQL005: Next Level SQL Programming (with Advanced SQL Topics)
Advanced SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. This is an intermediate and beyond ...
|
How Many Days Since Previous/First Order? | LRS Education Services
Some of the most popular courses we teach are the ones dealing with writing SQL queries against SQL Server. Recently I had some students ask how, for each order, can I see the number of days since the customer’s most recent order, as well as the number of days since the customer’s first
|
Microsoft Certification MCSA, MCSE, MCSD | LRS Education
MSSC-900T00: Microsoft Security, Compliance, and Identity Fundamentals — Instructor was excellent. Very knowledgeable and had good real life examples to support the material. CompTIA® Project+® — With no background knowledge on project management, the entire class was beneficial. I’ve learned better ways to organize and execute projects.
|
MS-DP-420T00 - Designing and Implementing Cloud-Native Applications ...
CompTIA A+: A Comprehensive Approach — You could tell that the instructor really knew the material and wasn’t just reading from a book.I plan to study and pass both parts of the exam and I will literally use this information daily on my job as IT technician.
|
Microsoft’s New Certification Path: Introducing Microsoft Certification ...
CompTIA A+: A Comprehensive Approach — You could tell that the instructor really knew the material and wasn’t just reading from a book.I plan to study and pass both parts of the exam and I will literally use this information daily on my job as IT technician.
|
Microsoft Certification Improvements | LRS Education Services
Microsoft announced some welcome changes to their certification programs this last week of September 2016. Before we review the changes, though, I would like to discuss the benefits of certification in general.
|
Get a FREE Upgrade Exam from Microsoft! | LRS Education Services
CompTIA A+: A Comprehensive Approach — You could tell that the instructor really knew the material and wasn’t just reading from a book.I plan to study and pass both parts of the exam and I will literally use this information daily on my job as IT technician.
|
TT20483 - Programming in C# | Creating Applications in C# and .Net Core
This independent course aligns with the topics and skills in Microsoft Official Curriculum (MOC) course 20483. Working in a dynamic, intensive coding environment you will learn to: Describe the core syntax and features of Visual C#. Create methods, handle exceptions, and describe the monitoring requirements of large-scale applications.
|
Spring 2019 Newsletter | LRS Education Services
Penny looks forward to sharing knowledge about the newest solutions including CompTIA Network+, Windows Server, Microsoft Exchange, Skype for Business, Office 365 and Azure. Read the latest from the LRS Education Services Blog Microsoft 365 Threat Intelligence Business Analytics with Microsoft Power BI To Beat a Hacker You Need to Think Like One!
|
CCER - Reporting Cisco Contact Center Enterprise (CCER)
Prerequisites The knowledge and skills that students are expected to have before attending this course are: Basic knowledge of computer networking components – Windows A/D, SQL Server and components (servers, routers, switch) is helpful but not required Understanding of Cisco Packaged Contact Center Enterprise components and call flows Experience administering Cisco Packaged Contact Center ...
|
TT20486 - C# Intermediate - Developing ASP.Net Core MVC Web Applications
This skills-focused course aligns with Microsoft's 20486. In this 5-day course, the professional web developers will learn to develop advanced ASP.NET Core MVC applications using .NET Core tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application.
|
CCEI - Implementing Cisco Contact Center Enterprise (CCEI)
Prerequisites The knowledge and skills that students are expected to have before attending this course are: Advanced knowledge of computer networking components – Windows A/D, SQL Server, and components Understanding of IP networks Strong understanding of Cisco Packaged Contact Center Enterprise functionality Advanced experience administering of Cisco Packaged Contact Center Enterprise ...
|
TT8500-N - Securing .Net Web Services - Web Services Security in .Net
Prerequisites This is an intermediate -level .Net secure programming course, designed for experienced .Net developers who wish to get up and running on developing well defended software applications.
|
TT8320-N - .Net Secure Coding Camp - Attacking and Securing .Net Web ...
Lesson: Unvalidated Data Buffer Overflows Integer Arithmetic Vulnerabilities Unvalidated Data: Crossing Trust Boundaries Defending Trust Boundaries Whitelisting vs Blacklisting Lab: Defending Trust Boundaries Lab: Applying Regular Expressions Lesson: A1: Injection Injection Flaws SQL Injection Attacks Evolve Drill Down on Stored Procedures ...
|
ATCEH12 - CEH v12: Certified Ethical Hacker Training Course
CEH v12 continues to introduce the latest hacking techniques and the most advanced hacking tools and exploits used by hackers and information security professionals today. The Five Phases of Ethical Hacking and the original core mission of CEH remain valid and relevant today: “To beat a hacker, you need to think like a hacker.”.
|
ICCE - Integrating Cisco Enterprise Chat & Email with UCCE (ICCE)
In this 5-day hands-on course students will discover how to deploy Cisco Enterprise Chat and Email into an existing Enterprise Contact Center environment. The course covers the details needed to prepare an both UCCE and ECE environments for the integration and configurations steps required to do the actual integration.
|
Storage Spaces Direct | LRS Education Services
Storage Spaces Direct, or S2D, is a feature introduced by Microsoft in Windows Server 2016 that makes it possible to easily enable the creation of highly-available (HA) storage systems with local storage. The primary goals of S2D are to help simplify the deployment and management of software-defined storage systems as well as to open the use of new classes of disk devices like SATA and NVMe ...
|
Speed2Knowledge Courses with LRS Education Services
S2K20331-1 - Implementing Microsoft SharePoint Server 2013 at the Site Collection Level S2K20341-1 - Understanding Message Transport, High Availability and Disaster Recovery in Exchange Server 2013 ... S2K20461-1 - Querying and Modifying Data in Microsoft SQL Server S2K20463-1 - Using SSIS with Microsoft SQL Server S2K20480-1 - Transitioning to ...
|