Database Fundamentals

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More

Important information

Typology Course
Methodology Online
  • Course
  • Online
Description

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.

Opinions

4.5
Course rating
100%
Recommended
4.5
excellent
Centre rating

Reviews on this course

R
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

Reviews on other courses at this centre

Certified Six Sigma Green Belt

G
Girish Ravi
4.5 21/12/2015
What I would highlight: I can say you simply learn here as learning is made simple. Good experienced trainers, lots of options to learn from - online, virtual classroom etc. Learning never stops when you are associated with Simplilearn. So many courses to choose from across project management, quality, technology, business etc. Got my PMP credentials too through Simplilearn and journey continues. Am happy I chose Simplilearn. Happy Learning.
What could be improved: Nothing
Would you recommend this course?: Yes

Microsoft® Project 2013

S
Subhojit Chak
4.0 15/12/2015
What I would highlight: I have just started my courses with Simplilearn and their support is awesome and very prompt. The faculty too is very good. I can rate as a very good quality professionally handled... corporate training.
What could be improved: Nothing
Would you recommend this course?: Yes

Holiday PPC Advertising

N
Nagarjuna DN
5.0 15/12/2015
What I would highlight: "Getting a high quality training from industry expert at your convenience, affordable with the resources you need to master what you are learning. "
What could be improved: Nothing
Would you recommend this course?: Yes

2D Video Game Character Animation for Beginners

K
Krati G
5.0 14/12/2015
What I would highlight: Simplilearn is Simply trustworthy and reliable institute for learning. It has helped me get a good understanding of the concepts of Digital Marketing.
What could be improved: Nothing
Would you recommend this course?: Yes
See all

Achievements for this centre

2017
2016

How do you get the CUM LAUDE seal?

All courses are up to date

The average rating is higher than 3.5

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 2 years

What you'll learn on the course

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


Students that were interested in this course also looked at...
See all