Microsoft SQL Database Bootcamp: Get Microsoft Certified
What you'll learn
- Understand how SQL data is stored
- Know how to create and manipulate tables
- Create Stored Procedures and Functions
- Understand Normalization
- Be able to backup and restore a database
Requirements
- Microsoft SQL Server 2008 (Download a Free Trial)
Description
If you have always wanted to learn about SQL databases but didn't know where to start this course is for you.
We start at the very basics and walk you through all the configurations step-by-step. You learn:
- How data is stored in tables
- Understand Relational Database Concepts
- Understand Tables and How to Create Them
- Insert, Delete and Update Data
- Database Security Concepts
- Database Backups and Restore
All examples are configured on Microsoft SQL Server 2008 which you can download via a free trial. This is the edition you will be tested on if you choose to take the Microsoft MTA Database Exam (98-364). You can follow along with the instructor and create your own database.
This is your first step to becoming a database engineer. It leads to the MCSA or MCSE Data Platform certifications.
The course is delivered by Microsoft Expert Toby Lawrence who has taught thousands of students from all over the world on Microsoft subjects.
Who this course is for:
- Beginners who want to learn the basics of Microsoft SQL Server
- Anyone who wants to pass the Microsft Technology Associate Exam - Database
- Anybody who wants to work as a database engineer
Instructor
- 4.1 Instructor Rating
- 1,027 Reviews
- 12,787 Students
- 7 Courses
We are a team of highly skilled and passionate IT engineers. Our full time jobs range from network architect, designer, security consultant, virtualization engineer, voice engineer, project manager and web developer. Our qualifications range from MCSE, JNCIE to dual Cisco CCIE.
Although most people teaching out there are IT trainers we are IT engineers who also train. There is a big difference as you will see and with over 1000,000 students trained through our classroom IT courses, books and videos you can feel assured that you are in safe hands.
Let us share our real world expertise with you so you not only pass the exam but have the confidence to apply your skills in the real world. Whether you want to work on a help desk or become the go to IT expert for your field we have a course for you.
IT is a rewarding and demanding career and there is a huge demand for skilled people to support small to very large companies. No matter what your age or skill level, there will be a role for you if you are qualified and passionate.
We are looking forward to helping you pass your exam and land your dream IT job.