SQL Server
70-462: Administering Microsoft SQL Server 2012
- Plan, install, and troubleshoot SQL Server 2012 and SQL Server databases
- Working knowledge of SQL Databases, the concept of the transaction log, SQL Server 2012 database recovery, backup and restoration
- SQL Server 2012 security models, logins and users
13h
0
63
70-764: Administering a SQL Server 2016 Database Infrastructure
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
24h
0
49
70-761: Querying Data with Transact-SQL
- Describe key capabilities and components of SQL Server
- Describe T-SQL, sets, and predicate logs
- Write a single table SELECT statement
20h
0
0
70-762: Developing SQL Databases
- Design and implement tables.
- Advanced table designs.
- Ensure data integrity through constraints.
25h
0
0
70-778: Analyzing and Visualizing Data with Microsoft Power BI
- Perform Power BI desktop data transformation
- Describe Power BI desktop modelling
- Create a Power BI desktop visualization
33h
0
0
DP-300: Administering Relational Databases on Microsoft Azure
- Understand the differences between Azure SQL offerings and how best to leverage their features
- Implement a secure database environment
- Monitor database and server performance
6h 10m
0
17