Home >> Training & Placement >> My SQL >> View

Microsoft SQL Server Training.


02 Nov, 2018
157
MS SQL Server Training in The University of Miami

This course will cover the following topics to prepare students for the 70-432 SQL Server 2008 Implementation and Maintenance exam: how to install and configuring SQL Server 2008, maintaining SQL Server instances, managing SQL Server security, maintaining

Course Offered

This course will cover the following topics to prepare students for the 70-432 SQL Server 2008 Implementation and Maintenance exam: how to install and configuring SQL Server 2008, maintaining SQL Server instances, managing SQL Server security, maintaining a SQL Server database, performing data management tasks, monitoring and troubleshooting SQL Server, optimizing SQL Server performance, and implementing high availability.

Course content:

Lesson 1: Installing Microsoft SQL Server
Introduction
Installing Microsoft SQL Server-Part 1
Installing Mircosoft SQL Server-Part 2
Choosing A Collation Setting
Installing Microsoft SQL Server Demo
Lesson 2: Navigating SQL Server
1 Navigating SQL Server
2 Management Studio Demo
3 SQL Server Configuration Manager
4 SQL Server Configuration Manager Demo
Lesson 3: Data Types
1 Data Types
Lesson 4: Databases
1 Databases
2 Creating A Database
3 Creating A Database Demo
Lesson 5: Tables
1 Tables
2 Sparse Columns
3 Creating A Table Demo
Lesson 6: Views
1 Views
2 Creating A View Demo
Lesson 7: Constraints
1 Constraints
2 Creating A Contsraint Demo
Lesson 8: Store Procedures
1 Store Procedures
2 Common Language Runtime
3 Store Procedures Demo
Lesson 9: Functions
1 Functions
2 Three Function Types
3 Functions Demo
Lesson 10: Service Broker
1 Service Broker
2 Using Service Broker
Lesson 11: Data Integrity
1 Data Integrity

11.2 Planning And Education (demo to be recorded)

Oct 26 2018

Oct 29 2018

Oct 30 2018

Oct 31 2018

Nov 1 2018

Nov 2 2018
Submit Your Comment
Subscribe for newsletter
FL NRI's Chat (0 Users Online)