Introduction to SQL Server 2012
- Introduction to SQL Server 2012
- RDBMS - An Introduction
- SQL Server 2012
- SQL Server Components
- SQL Server Tools
- SQL Server Management Studio
- Managing Databases
- SSMS Windows
- Demo - Exploring SSME
- Understanding Database Objects
- Demo - Creating Database Objects using SSMS
- Conclusion
- Quiz
Working with T-SQL
- Working with T - SQL
- Demo Viewing a Table Structure
- Querying
- T - SQL
- Demo Writing a Simple Query
- Managing Database Objects
- Demo - Add, Modify, and Delete Database Objects
- Constraints
- Demo - Adding Constraints
- SELECT
- Demo - Querying Data from Tables
- CASE
- Demo - Advanced Queries
- Conclusion
- Quiz
Understanding SQL Data Types
- Understanding SQL Data Types
- String Types
- MAX Setting
- Demo - Using Character, UNICODE, and Binary Strings
- Numeric Types
- Demo - Working with Numeric Data
- Date and Time
- Demo - Working with Date and Time
- Advanced Data Types
- Demo - Exploring Some Advanced Data Types
- Conclusion
- Quiz
Sorting and Filtering
- Sorting and Filtering
- Sorting with ORDER BY, and Performing Multiple Column and Ascending - Descending
- Extended Capabilities for Sorting
- Demo - Using TOP, OFFSET, and FETCH
- Filtering Results
- Demo - Filter using WHERE, and Different Predicates and Operators
- Advanced Filtering
- Demo - Unicode, ANY, and ALL filters
- Conclusion
- Quiz
Query Multiple Tables using JOINs
- Query Multiple Tables using JOINs
- Multiple Tables
- Demo - Querying Multiple Tables without a JOIN
- Using JOIN
- Simple Join
- Demo - Using Implicit Join between Tables
- JOINs
- Demo - Using CROSS, INNER, and OUTER JOINs
- Advanced JOINs
- Demo - Using MERGE, HASH, and LOOP
- Conclusion
- Quiz
Modifying Table Data
- Modifying Table Data
- Demo - Using Different Forms of INSERT to Add Data to a Table
- Other Methods to Add Data
- Demo - Using Bulk Adding Methods
- Modifying Data in a Table
- Demo - Modifying Data with UPDATE
- Removing Data from Tables
- Demo - DELETE and TRUNCATE Data from Tables
- Synchronizing Data between Tables
- Demo - Synchronizing Data using MERGE
- Conclusion
- Quiz
Programming in SQL Server
- Programming in SQL Server
- Function Categories
- String Functions
- Conversion Functions
- Logical Numeric Functions
- Date and Time Functions
- Demo - Using Different Functions in SQL Server
- Working with Groups and Aggregates
- Aggregate Functions
- Demo - Grouping and Using Different Aggregates
- Variables and Batches
- Demo - Using Variables and Batches
- Control Flow Statements
- Demo - Using Control Flow Statements
- Working with Stored Procedures
- Demo - Working with Stored Procedures
- Conclusion
- Quiz
Writing Advanced Queries in T-SQL
