Exam 70-761: Querying Data with Transact-SQL
by Mark Long
Start the free chapterThis course is designed to help administrators, report writers, application developers and others who need to understand the basics of Transact-SQL. SQL Server is used to create and maintain databases, data warehouses, data reporting, business intelligence, data integration, and more.
Course content
Welcome/Intro7 lessons
Getting Setup7 lessons
- Getting SQL Server Express6:581 credit or ad
- Installing SQL Server Express pt. 16:551 credit or ad
- Installing SQL Server Express pt. 23:361 credit or ad
- Verifying the Installation5:481 credit or ad
- Getting SQL Server Management Studio3:421 credit or ad
- Management Studio Tour7:031 credit or ad
- Attaching the Sample dB7:041 credit or ad
General Database Information7 lessons
Transact SQL Language Basics15 lessons
- T-SQL Coding Basics pt. 17:141 credit or ad
- T-SQL Coding Basics pt. 25:171 credit or ad
- Lets Store Something2:181 credit or ad
- Creating a Database using T-SQL6:351 credit or ad
- Creating a Database Graphically5:451 credit or ad
- The Database File4:471 credit or ad
- The USE Command4:441 credit or ad
- Creating a Table5:101 credit or ad
- Creating a Table using T-SQL6:571 credit or ad
- Creating a Table Graphically4:511 credit or ad
- Modifying a Table2:091 credit or ad
- Using ALTER TABLE2:531 credit or ad
- Modifying a Table Graphically5:031 credit or ad
- Constraints and Defaults6:441 credit or ad
- Script Files4:461 credit or ad
Basic Select Statement11 lessons
- Basic SELECT Statement pt. 16:311 credit or ad
- Basic SELECT Statement pt. 26:521 credit or ad
- Adding Comments6:471 credit or ad
- Using ORDER BY4:431 credit or ad
- Column Aliasing6:031 credit or ad
- Concatenation in TSQL pt. 16:331 credit or ad
- Concatenation in TSQL pt. 26:281 credit or ad
- Filtering with Predicates pt. 17:001 credit or ad
- Filtering with Predicates pt. 22:471 credit or ad
- Graphical Queries5:491 credit or ad
- Understanding NULL6:521 credit or ad
Working with Data8 lessons
Advanced Select Statements12 lessons
- Using DISTINCT pt. 16:551 credit or ad
- Using DISTINCT pt. 22:521 credit or ad
- Using LIKE and IN pt. 16:371 credit or ad
- Using LIKE and IN pt. 26:031 credit or ad
- COUNT, SUM, & AVG7:191 credit or ad
- Using CASE Expressions pt. 16:231 credit or ad
- Using CASE Expressions pt. 24:511 credit or ad
- SELECT INTO Clause6:231 credit or ad
- INSERT SELECT5:121 credit or ad
- Using UNION7:061 credit or ad
- Using INTERSECT and EXCEPT6:311 credit or ad
- OFFSET and FETCH5:471 credit or ad
Grouping and Aggregating Data4 lessons
Relational Basics7 lessons
Programming Objects9 lessons
- Stored Procedure Basics6:281 credit or ad
- Creating Stored Procedures4:131 credit or ad
- Using Parameters with Stored Procedures5:381 credit or ad
- Using Output Parameters6:341 credit or ad
- Understanding Temporary Tables6:381 credit or ad
- Understanding Table Variables6:441 credit or ad
- Temp Table vs. Table Variables3:551 credit or ad
- Common Table Expressions pt. 13:361 credit or ad
- Common Table Expressions pt. 27:141 credit or ad