SQL Server 2017 Express Basics

Why take this course?
🛠️ SQL Server 2017 Express: Master the Basics with Our Updated Course! 🚀
Course Update Notice (4/3/2018): We're excited to announce that our course content has been fully updated to reflect the latest SQL Server 2017 features! As part of this update, we've already replaced 40 videos as of March 27th, and we're working diligently to replace all existing content over the next month. 🖥️🔄
Why Choose This Course?
- Comprehensive Updates: We're committed to bringing you the most current information. As of March 6th, 2017, reviews pertain to the older version of this course which is now being replaced.
- Interactive Learning: The new course includes questions directly integrated into the videos for a more engaging learning experience.
- High-Quality Audio: All audio recordings are now done with a professional studio microphone to ensure clarity and quality.
Is This Course Right For You?
- 🧙♂️ Not for Intermediate or Advanced Users: If you're already at an intermediate or advanced level in SQL, this course may not be the right fit. Please look for more advanced materials elsewhere.
- 🕒 Detailed Explanations: My explanations can be quite detailed, which might take longer than typical tutorials. Make sure this is your preferred learning style.
- 🎥 Real-World Focus: The course covers a variety of SQL topics in a practical context. For instance, indexes are discussed across multiple videos where relevant, as they're too extensive to be covered in one place.
Course Resources:
- Lesson Materials: You can find additional information and code samples under each lesson's resources. Make sure you know how to download these materials as I do not demonstrate the process within the course.
- AdventureWorks Databases: The course uses AdventureWorks2016CTP3, but you can also use AdventureWorks2017, which are both available in the lesson 2 resources. Both databases are functionally equivalent for this course.
Course Structure and Content:
- Detailed Video Breakdown:
- Videos range from 10 minutes in length to provide concise yet comprehensive information.
- All code is demonstrated using Microsoft SQL Server Management Studio.
- Execution plans are a recurring topic of discussion in multiple videos.
- Zooming effects are used to emphasize key points during explanations.
- The course does not cover joins, normalization, or stored procedures.
- Learning Approach: This course is structured for a full immersion experience, from start to finish. It's designed so that you get the most value out of the extensive information provided.
Who Should Enroll? If you enjoy detailed explanations and prefer a no-frills approach that focuses on real-world SQL Server 2017 applications, this course is for you! We recommend watching all videos from the beginning to ensure you grasp the full scope of content covered.
Your Instructors: Thank you, Tom and Adiv, for your dedication in keeping our course content up-to-date and informative. 🫠
Enroll Today! Join us on this SQL Server 2017 journey and transform the way you interact with databases. Remember to read through the curriculum to ensure this course aligns with your learning objectives and current skill level. We're here to help you take your SQL skills to the next level! 🎓✨
Course Gallery




Loading charts...