Database Fundamentals
-
The training delivered was excellent . It was with live examples and very easy to learn.
← | →
Course
Online
Description
-
Type
Course
-
Methodology
Online
Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.
Reviews
-
The training delivered was excellent . It was with live examples and very easy to learn.
← | →
Course rating
Recommended
Centre rating
Rajesh Wagh
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Database
Course programme
- Database Fundamentals (Exam no 98-364)
- 00 - Introduction
- 0.1 Introduction
- 01 - Database Fundamentals Introduction
- 1.1 Database Fundamentals
- 1.2 Introduction To Databases
- 1.3 Sql Storage
- 1.4 Most Common Database Objects
- 1.5 Sql Language
- 1.7 Quiz
- 02 - Working with Database Objects
- 2.1 Working With Database Objects
- 2.2 Introduction To Data Types
- 2.3 Demo Working with Tables
- 2.4 Working with Tables
- 2.5 Demo Working with Views
- 2.6 Working with Views
- 2.7 Creating Stored Procedures
- 2.8 Demo Creating Stored Procedures
- 2.9 Demo Working with Functions
- 2.10 summary
- 2.11 Working with Functions
- 2.12 Quiz
- 03 - Working with Data
- 3.1 Database Fundamentals
- 3.2 Demo Querying Data
- 3.3 Querying Data
- 3.4 Advanced Query
- 3.5 Demo Advanced Query
- 3.6.Demo Inserting Data
- 3.7 Inserting Data
- 3.8 Demo Updating Data
- 3.9 Updating Data
- 3.10 Deleting Data
- 3.11 Demo Deleting Data
- 3.12 Summary
- 3.13 Quiz
- 04 - Using Constraints
- 4.1 Database Fundamentals
- 4.2 Demo Index Maintenance
- 4.3 Demo Using Key
- 4.4 Working With Keys
- 4.5 Understanding Data Storage
- 4.6 Clustered Index
- 4.7 Demo Clustered Index
- 4.8 Using Nonclustered Indexes
- 4.9 Normalization
- 4.10 Summary
- 4.11 Quiz
- 05 - Database Security
- 5.1 Database Fundamentals
- 5.2 Demo Working with server logins
- 5.3 Server Logins
- 5.4 Database Users
- 5.5 Demo Database Users
- 5.6 Demo Schema Introduction
- 5.7 Schema Introduction
- 5.8 Demo Using roles
- 5.9 Server and Database Roles
- 5.10 Demo Working with Permissions
- 5.11 Summary
- 5.12 Quiz
- 06 - Disaster Recovery
- 6.1 Database Fundamentals
- 6.2 Introduction to Disaster Recovery
- 6.3 Database Backup
- 6.4 Database Restore
- 6.5 Demo Restoring the database
- 6.6 Demo Database Backup
- 6.7 Summary
- 6.8 Quiz
- 00 - Introduction
Additional information
What is the course all about?
SQL Server Certification is the most coveted credential for SQL server users which authenticate their knowledge and skills to optimize the use of SQL Server 2012 to the fullest. Simplilearn offers various SQL Server Online Certification Trainings which can be chosen depending upon the specific usage of the SQL Server 2012.Who should do this certification?
Solution developers, Database developers, Architects and IT Professionals who want to understand new features and capabilities in SQL Server 2012 are best suited for the certification training.What are the career benefits in-store for you?
- Globally recognized standard for IT professionals that validates their expertise with the Microsoft SQL Server training and certifications
- Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions
- Add real value to your professional development
Database Fundamentals
Price on request
Add similar courses
and compare them to help you choose.
Training by subject