- Location: Bukit Merah - Central
- Duration: 5 Days
Course details
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.
Note: This course is designed for customers who are interested in learningSQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Course Outline
- Lesson 1: Introduction to Microsoft SQL Server 2014
- Lesson 2: Introduction to T-SQL Querying
- Lesson 3: Writing SELECT Queries
- Lesson 4: Querying Multiple Tables
- Lesson 5: Sorting and Filtering Data
- Lesson 6: Working wit SQL Server 2014 Data Types
- Lesson 7: Using DML to Modify Data
- Lesson 8: Using Built-In Functions
- Lesson 9: Grouping and Aggregating Data
- Lesson 10: Using Subqueries
- Lesson 11: Using Table Expressions
- Lesson 12: Using Set Operators
- Lesson 13: Using Window Ranking, Offset, and Aggregate Functions
- Lesson 14: Pivoting and Grouping Sets
- Lesson 15: Executing Stored Procedures
- Lesson 16: Programming with T-SQL
- Lesson 17: Implementing Error Handling
- Lesson 18: Implementing Transactions
Prerequisites
This course requires that you meet the following prerequisites:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Course Location
About New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
See all New Horizons Singapore courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Azure SQL Course GateSGD 17
SGD 203Duration: Upto 1 Hour - Querying Microsoft SQL Server 2012 Global EdulinkSGD 185
SGD 1,279Duration: Upto 16 Hours
