Description
About this Course
Prove your knowledge and skills in designing, building, maintaining and querying the next wave of cloud-ready database and information solutions.
Microsoft SQL Server is the heart of mission-critical environments. The Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development certification provides the necessary technical background and hands-on experience required to demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. This certification is intended for database administrators, database developers, as well as business intelligence enthusiasts.
Earning an MCSA SQL 2016 Database Development certification qualifies you for a position as a database developer and it is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).
Course Outline
-
- Introduction to Microsoft SQL Server
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping & Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Windows Ranking, Offset & Aggregate Functions
- Pivoting & Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
-
- Introduction to Database Development
- Designing and Implementing Tables
- Advanced Table Designs
- Ensuring Data Integrity through Constraints
- Introduction to Indexes
- Designing Optimized Index Strategies
- Columnstore Indexes
- Designing & Implementing Views
- Designing & Implementing Stored Procedures
- Designing & Implementing User-Defined Functions
- Responding to Data Manipulation via Triggers
- Using In-Memory Tables
- Implementing Managed Code in SQL Server
- Storing and Querying XML Data in SQL Server
- Storing and Querying Spatial Data in SQL Server
- Storing and Querying BLOBs & Text Documents in SQL Server
- SQL Server Concurrency
- Performance & Monitoring
Funding
Students following the MCSA SQL 2016 Database Development study programme can apply for the Get Qualified Scheme which will enable them to benefit from a tax credit of 70% of the costs incurred (ie. €1,120 will be refunded back for this course).
For further details and assistance on how to apply for this scheme, kindly contact us for an appointment.
Course Details
MODE OF STUDY
PARTTIME
DELIVERY METHOD
Lectures & Hands-On Practice
ENTRY REQUIREMENTS
Good Knowledge of English
NEXT STEPS
DURATION
81 Hours (27 Lessons of 3 Hours)
DAY(S)
Monday & Wednesday
TIME
6.00PM till 9.00PM
STARTING DATE
Monday 20th April 2020
END DATE
Wednesday 22nd July 2020
WHAT'S INCLUDED
- Training by a Microsoft Certified Trainer (MCT)
- Official Microsoft Courseware (Format: Paperback)
- Official Microsoft Virtual Labs
- Official Microsoft Presentations
- Official Microsoft Practice Tests
- Official Microsoft Exams
Price: € 1600
€
Prove your knowledge and skills in designing, building, maintaining and querying the next wave of cloud-ready database and information solutions.
Microsoft SQL Server is the heart of mission-critical environments. The Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development certification provides the necessary technical background and hands-on experience required to demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. This certification is intended for database administrators, database developers, as well as business intelligence enthusiasts.
Earning an MCSA SQL 2016 Database Development certification qualifies you for a position as a database developer and it is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).
-
- Introduction to Microsoft SQL Server
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping & Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Windows Ranking, Offset & Aggregate Functions
- Pivoting & Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
-
- Introduction to Database Development
- Designing and Implementing Tables
- Advanced Table Designs
- Ensuring Data Integrity through Constraints
- Introduction to Indexes
- Designing Optimized Index Strategies
- Columnstore Indexes
- Designing & Implementing Views
- Designing & Implementing Stored Procedures
- Designing & Implementing User-Defined Functions
- Responding to Data Manipulation via Triggers
- Using In-Memory Tables
- Implementing Managed Code in SQL Server
- Storing and Querying XML Data in SQL Server
- Storing and Querying Spatial Data in SQL Server
- Storing and Querying BLOBs & Text Documents in SQL Server
- SQL Server Concurrency
- Performance & Monitoring
Students following the MCSA SQL 2016 Database Development study programme can apply for the Get Qualified Scheme which will enable them to benefit from a tax credit of 70% of the costs incurred (ie. €1,120 will be refunded back for this course).
For further details and assistance on how to apply for this scheme, kindly contact us for an appointment.
MODE OF STUDY
PARTTIME
DELIVERY METHOD
Lectures & Hands-On Practice
ENTRY REQUIREMENTS
Good Knowledge of English
NEXT STEPS
DURATION
81 Hours (27 Lessons of 3 Hours)
DAY(S)
Monday & Wednesday
TIME
6.00PM till 9.00PM
STARTING DATE
Monday 20th April 2020
END DATE
Wednesday 22nd July 2020
WHAT'S INCLUDED
- Training by a Microsoft Certified Trainer (MCT)
- Official Microsoft Courseware (Format: Paperback)
- Official Microsoft Virtual Labs
- Official Microsoft Presentations
- Official Microsoft Practice Tests
- Official Microsoft Exams
Price: € 1600
€