Overview
Microsoft SQL Server is a relational database management system that works as a database server, storing and retrieving data for multiple software applications running on a single computer or on other computers across a network.
This will equip learners with the technical skills they need to write basic Transact-SQL queries for Microsoft SQL Server 2012/2014. The course serves as a foundation to all SQL server-related fields such as Database Development, Database Administration and Business Intelligence. The course will cover all the new features in SQL Server 2014, along with the SQL Server data platform’s most important capabilities.
This course will prepare learners to take Querying Microsoft SQL Server 2012 examination conducted by Microsoft.
Why this
course?
- Database Developers
- Database Administrators
- Business Intelligence professionals
- SQL developers
- Database architects
- Programmers
- Application developers
- Business analysts
- Technical writers
What You'll Learn
- Writing SELECT queries
- Sorting and filtering data
- Querying multiple tables
- Describing the applications of data types in SQL Server
- Using built-in functions
- Modifying data with Transact-SQL
- Grouping and aggregating data
- Working with set operators
- Working with subqueries
- Working with table expressions
- Implementing grouping and pivoting sets
- Working with window ranking, offset and aggregate functions
- Programming with T-SQL
- Executing stored procedures
- Implementing transactions
- Implementing error handling
Curriculum
- Create and alter tables using T-SQL syntax (simple statement)
- Create and alter views
- Design views
- Create and modify constraints
- Create and alter DML triggers
- Query data by using SELECT statements
- Implement sub-queries
- Implement data types
- Implement aggregate queries
- Query and manage XML data
- Create and alter stored procedures
- Modify data by using INSERT, UPDATE and DELETE statements
- Combine datasets
- Work with functions
- Optimize queries
- Manage transactions
- Evaluate use of row-based operations vs set-based operations
- Implement error handling
