تفاصيل الدورة
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
نبذة عن معهد 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
عرض الجميع دورات New Horizons Singapore- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- SQL – Master SQL Database Queries Course Central31 SGD
181 SGDمدة الدورة التدريبية: Upto 2 Hours - Microsoft SQL Server for Beginners Alpha Academy34 SGD
310 SGDمدة الدورة التدريبية: Upto 4 Hours
