- 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 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Course Outline
- Lesson 1: Introduction to Microsoft SQL Server 2012
- Lesson 2: Getting Started with SQL Azure
- Lesson 3: Introduction to T-SQL Querying Lesson 4: Writing SELECT Queries
- Lesson 5: Querying Multiple Tables
- Lesson 6: Sorting and Filtering Data
- Lesson 7: Working with SQL Server 2012 Data Types
- 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: Querying SQL Server Metadat
- Lesson 16: Executing Stored Procedures
- Lesson 17: Programming with T-SQL
- Lesson 18: Implementing Error Handling
- Lesson 19: Implementing Transactions
- Lesson 20: Improving Query Performance
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 coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL – Master SQL Database Queries Global CoursesAED 56
AED 514Duration: 2 Hours - SQL Global CoursesAED 56
AED 514Duration: 2 Hours
