Course overview
If you’ve ever considered having a career involving SQL but felt you lacked the knowledge or skills to launch your career, this might be what you’re looking for. This course bundle is aimed at absolute beginners who want to start a career in SQL or just develop their skills in this area. The course assumes you have no technical knowledge of SQL.
The course starts off with a series of beginner-level courses in SQL, then advances to higher level Microsoft certification courses. The purposes of the beginner-level courses are not only to give you an introduction to SQL but to prepare you to progress to the next study level involving the Microsoft MCSA courses. By completing the two MCSA exams from these courses, you’ll earn the globally recognised Microsoft MCSA in SQL 2016 Database Administration certification.
Upon completion of this course, you’ll receive a Microsoft MCSA ‘Acclaim’ badge in SQL 2016 Database Administration that you can add to your CV or social media profile for prospective employers to see. As explained above, you’ll also receive a Microsoft certification validating your SQL skills.
Recognition
Study method
- Online
- Blended
- In-class
Duration study load
This course bundle comprises of 50+ hours of video tutorials, as well as 25+ hours of live practice lab material; and 50+ hours of practice test material. Revision for each exam will take a minimum of 2 weeks. We recommend you spend at least 8 hours on the course per week to be able to finish it within 12 months or sooner. You will have full access to the course material and resources for 12 months and must take your exams within this period.
Course features
- Expert instructor-led training
-
Visual demonstrations & multimedia presentations
-
Quizzes & exam simulators
- Flash cards & educational games
-
Navigation & controls
Features of MeasureUP practice tests:
- Questions are similar to exam questions, allowing you to test your knowledge of exam objectives
- Detailed explanations for both correct and distractor answers reinforce the material
- ‘Study Mode’ covers all objectives ensuring topics are covered
- ‘Certification Mode’ (timed) prepares students for exam taking conditions
- Instant, drill-down score reports tell you exactly the areas to focus on
Assessment
Certification exams included:
- Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure (MCSA: 1 of 2 exams)
- Microsoft 70-765 Provisioning SQL Databases (MCSA: 2 of 2 exams)
MeasureUP practice tests included:
- Microsoft 70-764 SQL 2016 Administering an SQL Database Infrastructure (MCSA: 1 of 2 exams)
- Microsoft 70-765 Provisioning SQL Databases (MCSA: 2 of 2 exams)
Materials
Your course can be done from anywhere in the world. If you decide to move to a different city or even country, you can continue with the course from wherever you are. All you need is a device such as a desktop computer, laptop, tablet, smartphone, and an internet connection.
Delivery
Courses included in this bundle
What is an MCSA?
What is SQL?
Subjects
- Getting Started
- Advanced Search Functions
- Searching Multiple Tables
- Creating and Structuring Databases
- Special Data Functions and Instructions
- Working with Dates
- SQL Functions
- SQL – Basics Training – Assessments
- Section 1: Relational Databases
- Section 2: SQL Querying
- Section 3: Your First Queries
- Section 4: Filtering Your Results
- Section 5: Consolidating Your Data
- Section 6: Grouping Your Data
- Section 7: Joining Tables
- Section 8: Subqueries
- Section 9: Manipulating Your Data
- Section 10: Transaction Control
- Section 11: Creating Database Objects and Adding Business Logic
- Section 12: Lab Solutions
Module 1: T-SQL Querying Concepts
- Lesson 1: SQL Dialects
- Lesson 2: Formatting
- Lesson 3: ASCII vs Unicode
- Lesson 4: Data Types
- Lesson 5: NULL
- Module Summary
- Knowledge Check
Module 2: Select, From, Where and Order By Clauses
- Lesson 1: Getting Started
- Lesson 2: Case-Sensitive Collation
- Lesson 3: Aliasing Columns and Tables
- Lesson 4: Filtering Records with the Where Clause
- Lesson 5: Sorting Result Sets
- Module Summary
- Module 1: Using the SQL Server Import and Export Wizard | Importing and Exporting Data
- Module 2: Creating a Simple ETL Package | Create Project and Basic Package
Module 1
- Using the SQL Server Import and Export Wizard | Importing and Exporting Data
- Module 2: Creating a Simple ETL Package | Create Project and Basic Package
Module 2
- Creating a Simple ETL Package | Adding Looping
- Creating a Simple ETL Package | Adding Logging
- Creating a Simple ETL Package | Adding Error Flow Redirection
- Creating a Simple ETL Package | Adding Package Deployment Configuration
- Creating a Simple ETL Package | Using Project Deployment Parameters
Module 3
- Deploying Packages Using The Package Deployment Model | Preparing to Create the Deployment Bundle
- Deploying Packages Using The Package Deployment Model | Creating the Deployment Bundle
- Deploying Packages Using The Package Deployment Model | Installing Packages
- Module 1: Encryption
- Module 2: Configure Data Access and Permission
- Module 3. Configure Auditing
- Module 4: Develop a Backup Strategy
- Module 5: Restore Databases
- Module 6: Manage Database Integrity
- Module 1: Deploy a Microsoft Azure SQL Database
- Module 2: Plan for SQL Server Installation
- Module 3: Deploy SQL Server Instances
- Module 4: Deploy SQL Server Databases to Azure Virtual Machines
- Module 5: configure Secure Access to Microsoft Azure SQL Databases
- Module 6: Configure SQL Server Performance Settings
- Module 7: Manage SQL Server Instances
- Module 8: Manage SQL Storage Module 9: Perform Database Maintenance
About Hudson
In the confusing world of e-learning, Hudson is quite simply one of the best at what they do. Why? Because they offer first-class customer service. The Hudson Learning Center puts their customers’ needs before anything else. If there’s something they can do to help you, Hudson will climb mountains to do it.
The Hudson online courses, certifications, and diplomas are highly effective, offering a whole range of features designed to get you certified faster. Some of these incredible features include video and audio based training so you can see and hear your tutor, 24/7 online tutor support, and online labs to practice your skills in a simulated environment.
Come and give Hudson a try. They’ll change the way you think about learning.
