Querying Microsoft SQL Server For Beginners

Learn SQL Server with this comprehensive, hands-on course! Also known as Sequel, this tutorial guides you through the entire process of installing and interacting with a SQL Server database. We'll walk you through a step-by-step installation of SQL Server Express 2014 (a free download), using the AdventureWorks 2014 database as our practical example.

You'll master T-SQL (Transact-SQL) starting with fundamental SELECT statements and progressing to advanced techniques. Discover how to efficiently retrieve, filter, group, and sort data from your database. This course provides the essential knowledge and skills to query SQL Server databases effectively.

Gain familiarity with SQL Server Management Studio (SSMS) 2014, the powerful management tool for administering and managing SQL Servers.

What You Will Learn:

• SQL Server Installation: Learn how to download and install SQL Server on your system.
• Sample Database Setup: Download and install the AdventureWorks 2014 database for practical exercises.
• SQL Server Management Studio (SSMS) Installation: Get hands-on with SSMS 2014, the primary tool for managing your SQL Server.
• Database Fundamentals: Understand the core concept of what a database is.
• Primary Keys: Learn how to ensure data uniqueness using primary keys.
• Data Sorting: Master techniques for ordering data effectively.
• Data Grouping: Discover how to aggregate and summarize data.
• Data Filtering: Refine your queries to retrieve specific data subsets.
• Data Retrieval: Learn how to extract data from a SQL Server database.
• Record Counting: Efficiently count the number of records in a table.

This video-based course is approximately 2 hours long and features plenty of practical, hands-on examples to help you follow along and build your SQL Server skills. Perfect for beginners looking to learn SQL and database querying.