Introduction to SQL Server
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Learn to query Microsoft SQL Server with T-SQL: select and filter rows, aggregate and join tables, edit text fields, and create and update tables.
Microsoft SQL Server keeps its data in tables that you reach through T-SQL, Microsoft’s own version of the SQL language. You choose columns, filter rows, summarize figures and combine related tables, practicing on sample data that includes a digital media shop’s artists and sales, Eurovision results and records of US power outages. At the end you build and change tables of your own.
What You Will Achieve
- Pull exactly the rows and columns a question needs, combining conditions with AND, OR and parentheses
- Summarize sales or counts per group and keep only the groups that meet a condition
- Clean up text fields by measuring their length and cutting out the characters you want
- Combine records spread across several tables into one result, and add, change or remove rows safely
Program Overview
SELECT Statements, Filtering, and Sorting
Queries that retrieve chosen columns, narrowed by conditions on numbers and text and then put in a useful order.
- Selecting one or more columns
- ORDER BY and WHERE on numeric and text data
- Working with NULL values
- AND, OR and parentheses on classic rock songs
Aggregate Functions, Strings, and Joins
Totals and counts across a table, text manipulation, grouped results, and queries that bring together matching rows from two or three tables.
- SUM, COUNT, MIN, MAX and AVG
- String length and left or right characters
- GROUP BY and HAVING
- INNER, LEFT and RIGHT joins with UNION and UNION ALL
CRUD Operations, Tables, and Variables
Building tables, adding, changing and deleting records, and storing values in variables before a closing exercise that uses all of it.
- CREATE tables and INSERT data
- UPDATE and DELETE statements
- DECLARE and SET for one or more variables
Certificate Awarded (Paid)
Job Outlook
Querying SQL Server tables is routine work for analysts and data professionals who need to pull, filter and summarize records kept in Microsoft databases, especially when the data has outgrown a spreadsheet.
Good for: Analysts used to Excel or similar tools who now need to query Microsoft SQL Server tables directly and want guided practice on realistic sample data.
Keep in mind: You learn SQL Server’s own dialect, T-SQL, so features practiced here such as DECLARE and SET for variables are not part of standard SQL.
Bottom line: Four short chapters of T-SQL practice on music sales, Eurovision and power outage data, closing with tables you create and edit yourself.
Frequently Asked Questions
What is T-SQL and how does it relate to standard SQL?
T-SQL is the version of SQL that Microsoft uses in SQL Server. It adds syntax and functions that standard SQL lacks, such as DECLARE and SET for working with variables, which the last chapter practices.
Which sample databases does the practice run on?
Most exercises run on the Chinook sample database, a digital media shop with artists, tracks and sales. Others use a classic rock song dataset, Eurovision voting data and records of US power outages.
Can I practice UPDATE and DELETE without damaging real data?
Yes. In the final chapter you create your own tables, insert rows into them, and then update and delete records in a safe practice environment.
How do I check my understanding as I go?
Each new concept or function is followed by short exercises that let you test what you just learned, so practice is spread through every chapter instead of saved for the end.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.