SQL Bootcamp for Beginners using Microsoft free tools

Install SQL Server Express with free Microsoft tools, compare editions, and verify hardware and software requirements. Download, install SQL Server Express and Management Studio, then reboot to enable connections.

Connect to the database engine using SQL Server Management Studio by entering the server name and Windows authentication, then open a new query.

Download and install Microsoft sample databases such as Adventure Works DW 2017 and Wide World Importers using SQL Server and SQL Server Management Studio, then restore databases from backup files.

Restore Adventure Works databases (2017 and 2016 compatibility) using Microsoft free tools or download the .bak file if needed, then list databases via master and sys.databases to view information.

Learn to access SQL Server help in SSMS, install offline documentation, and use comments in queries with line and block syntax, plus executing batches with go.

Discover data warehouse architecture that unifies unstructured, structured, and semi-structured data from CRM, ERP, and ecommerce into a single source of truth, with data marts, ETL, and Power BI visualization.

Explore database basics, including DBMS and relational DBMS, tables, tuples, records, columns, and fields; compare databases with spreadsheets while learning multi-user querying and reporting in SQL Server Express.

Learn how SQL Server Management Studio represents databases and objects, view properties and permissions, and customize the SSMS workspace while connecting to SQL Express.

Navigate SQL Server Express 2017 to manage databases and tables and build queries textually or graphically, then execute and inspect results and fields in Adventure Works Human Resources schema.

Explore data types and constraints in relational databases, including primary and foreign keys, column and table level constraints, and rules for not null, unique, check, default, and computed columns.

Explore views as virtual tables that expose only needed data through subset columns and secure permissions, and learn store procedures for server-side, scalable, maintainable data operations.

Open the exercise challenge resource, copy and paste it, then write and run queries such as select star from Adventure Works and fully qualify names from the dim customer table.

Explore the physical and logical query processing order in SQL, and see how the database executes from, where, group by, having, and order by after writing the select.

Learn the CRUD fundamentals: create, read, update, delete to manage data in databases and tables with insert, select, update, delete statements using SQL Server Express and SQL Server Management Studio.

Learn to create databases and a products table using sql, via code and graphical tools, with product id as primary key, and fields for name, price, and description.

Insert data into tables using insert into statements with and without column lists in SSMS, and review execution plans, row counts, and constraints.

Learn to delete tables and databases in SQL Server, check dependencies with views and stored procedures, and drop, detach, and reattach with backups.

Begin the SQL bootcamp with a hands-on CRUD exercise using Microsoft free tools. Create a database, build a product table, insert three records, then drop the table and database.

Learn to perform sql CRUD with Microsoft free tools by creating a products database, building a products table, inserting, updating, querying, and deleting records.

Master sql server management studio to query the Adventure Works 2017 person table, pick columns, generate select, insert, and delete scripts, and export data to another server.

Learn how the go statement splits statements into batches for safe execution, handle errors and primary key violations, and use aliases to rename columns in sql queries.

Discover how SQL processes queries, comparing logical and physical query processing orders and how clauses like select, from, where, group by, having, and order by drive execution.

Master the select statement to read data from tables, filter, and use group by having. Write fully qualified names and avoid select star in production to prevent performance issues.

Download and use the exercise challenge resources to practice SQL queries with the AdventureWorks database. Write and test queries, compare results with the solutions, and save your work for review.

Practice writing select queries on the Adventure Works DW 2017 database to display all columns from dim and fact tables, apply aliases, and handle two-word table names with brackets.

Learn how to use the distinct keyword to eliminate duplicates and count unique values, such as last names and territories, across tables.

Learn to complete SQL exercise challenges by downloading resource files, copying queries, and running simple selections on the Adventure Works database using Microsoft free tools.

Learn to display unique values using distinct across the adventure works database, returning distinct education, occupation, country region, promotion, scenario, subregion, and stock item data.

Learn to use the top keyword in SQL to limit rows by a specific number or percentage, combine it with distinct values and an optional order by clause.

Open the exercise challenge resource, copy and paste the file into your cycle, write and run queries like select from Adventure Works, then save and compare with the solutions lecture.

Show top ten resellers and products, top five employees, customers, and transaction types, and top ten suppliers in Adventure Works and Wide World Importers, with percent options and order by.

Explore predicates and operators in SQL, including boolean values and search conditions, with examples like between, not null, not in, and not like; learn comparison operators and combining them.

Discover how the where clause filters data with predicates to select, update, and delete rows, using examples from Adventure Works 2017 in SQL Server Management Studio.

Open the exercise challenge file from the resource section, copy-paste it, and write queries against the AdventureWorksDW2017 customer table. Save your work and compare results with the solutions lecture.

Master where clause predicates and basic filtering in SQL using Adventure Works and Wide World Importers datasets, covering date, quantity, color, size, and totals including tax.

Use the and keyword to combine two boolean expressions in a where clause, filtering results by both text and numeric criteria such as vacation hours greater than 40.

Download the exercise challenge resource from the lecture resources, copy and paste your queries, and run them against the Adventure Works database, then compare results with the solutions lecture.

Demonstrates SQL exercise solutions using where and and across the Adventure Works DW 2017 dataset, selecting columns from account, currency, employee, city, and order tables with targeted filters.

Explore how the where clause filters data in SQL with or and operators, and examine boolean expressions, operator precedence (and evaluated first), and combining conditions across example names.

Open the exercise challenge resource from the lecture materials and practice writing SQL queries against the Adventure Works dataset. Save your results and compare them with the solutions lecture.

Practice sql filtering with where and or on the adventure works database, selecting employees by gender, marital status, and hire date, then explore related tables and conditions.

Learn to filter data using the in predicate to match multiple values in a column, with examples selecting first name, last name, and email.

Download the exercise challenge file from the lecture resources, write and run SQL queries against the Adventure Works DW 2017 database, and save your results to compare with the solutions.

Demonstrates using the IN predicate to filter data across adventurer's gw 2017 datasets, covering employee education and occupation, geography by state, names, stock item colors, and package descriptions.

Learn how the between operator filters data by range, with examples such as between 0 and 2 and between M and P. Discover its cleaner syntax and faster execution.

Open the exercise challenge file from the resource section, download the resource, write queries on the Adventure Works database using fully qualified names, then save and compare.

Master SQL between filters with practical exercises on customer birth dates, product prices, employee names, stock item prices, and order dates.

Learn how to use the like filter with %, _, and bracket patterns to match names and phone data in Adventure Works, with practical first and last name examples.

Open the exercise challenge resource, download the file, and paste it into the cycle. Write queries against Adventure Works with fully qualified names and the customer table, then save.

Discover how the like operator uses percent and underscore wildcards to filter data by start with, end with, and contains patterns in SQL.

Learn how to filter data with where clauses using not in, not between, and not like in SQL, with examples that exclude ranges and keep all other rows.

Practice hands-on sql queries with downloadable exercise challenges using the Adventure Works database. Download, copy, and paste resource files to complete each cycle, then compare results with the solutions lecture.

Showcase sql not conditions with not in, not between, not exists, and not like across customers, orders, and stock items, using Adventure Works and White Importers datasets.

Learn to sort query results with order by, choosing ascending or descending order for specified columns. See examples sorting by list price, product name, and color.

Download the exercise resources, copy the file into your workflow, and write and run SQL queries against the Adventure Works database, then compare results with the provided solutions.

Sort result sets with the order by clause to arrange data from Adventure Works 2017, demonstrating ascending and descending sorts by last name, hire date, color, and city.

Learn to sort data using order by with offset and fetch to limit results. Use fetch or offset instead of top to return the first 10 rows in examples.

Download resources for each exercise challenge, copy and paste into the challenge file, and practice writing and executing sql queries using Adventure Works customer table to verify results.

Master paginate results with order by, offset, and fetch in SQL Server Management Studio by solving practical exercises on employees, products, and cities using 2017 features.

Explore aggregate functions in SQL, focusing on COUNT to summarize data across rows, including COUNT(*), COUNT(DISTINCT expression), and COUNT(ALL), and understand how nulls and duplicates affect totals within groups.

Open and download the exercise challenge file from the resource section, then practice writing and running SQL queries against Adventure Works using qualified names, and compare results with the solutions.

Learn to use the aggregate count function in SQL with Adventure Works data, counting records by gender and hire date, product key range, and stock item color.

Master the sum aggregate function to total numeric columns, group by territory id, and order by territory to reveal territory-level totals, including total due and freight.

Open the exercise challenge file from the resource section and practice writing queries on the Adventure Works database, including selecting from the customer table.

Learn to use aggregate sum in SQL with free Microsoft tools, calculating total income, sales, quantity, and 2015 profit across Adventure Works and Wide World Importers.

Apply the average aggregate function to compute average values from a column, using group by and having to summarize data, with examples like average order per customer.

Download the exercise resource, copy and paste the challenge file to bottom of cycle, then practice writing and running queries against Adventure Works, comparing results in the solutions lecture.

Learn to compute averages with SQL's aggregate function avg, handling nulls and using filters, through examples like average yearly income, post-2013 sales, and average profit by year.

Learn to use aggregate functions to compute the minimum and maximum values in a column, with practical examples on tax rate and list price.

Download the resource file from the lecture resources, complete the exercise challenges by writing and running SQL queries against the Adventure Works database, and compare results with the solutions lecture.

Use min and max aggregations to fetch the smallest and largest values in SQL. See examples across sales amount, yearly income, and stock quantities from Adventure Works and master databases.

Learn how to group data by a column using group by, then apply aggregates such as sum and average per group, illustrated with customer totals and yearly orders.

Download the exercise resource, paste it into your file, and write queries against the adventure works dw2017 database, using fully qualified names.

Learn to use group by to aggregate data across product key, color, and product model, computing sums, averages, counts, and min/max of sales and prices, with sorting.

Learn to use group by and having to filter aggregated results, with examples of average total by customer, territory, and year.

Open and download the exercise challenge resource, then practice writing queries against the Adventure Works dataset, copying results to the file and comparing with the solutions lecture.

Master grouping data with group by and having, using aggregate functions like sum, average, and count on sales and order data, including order date key, product, and customer insights.