Database Fundamentals

4.5
1 opinion
  • The training delivered was excellent . It was with live examples and very easy to learn.
    |

Course

Online

Price on request

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.5
  • The training delivered was excellent . It was with live examples and very easy to learn.
    |
100%
4.5
excellent

Course rating

Recommended

Centre rating

Rajesh Wagh

4.5
19/03/2014
What I would highlight: The training delivered was excellent . It was with live examples and very easy to learn.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017
2016

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

Course Preview
  • 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

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