Quality Seal Emagister EMAGISTER CUM LAUDE

Database Fundamentals

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • 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.

Important information

Opinions

R

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.

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


Compare this course with other similar courses
See all