Objectives : 
- Master the main features of Photoshop
- Know how to touch up an image
- Design montages and create effects using layers and filters

Objectives : 
- Master non-destructive work in Photoshop
- Know how to create complex edits and clipping
- Use automation tools in batch processing

Objectives : 
- Master the main features of Photoshop
- Know how to touch up an image
- Design compositions and create effects using layers and filters
- Master non-destructive work in Photoshop
- Know how to create complex edits and clipping
- Use automation tools in batch processing

Objectives : 
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Protect data with encryption and auditing
- Describe recovery models and backup strategies
- Back up data SQL Server databases
- Restore SQL Server databases
- Automate database management
- Configure security for SQL Server agent
- Manage alerts and notifications
- Manage SQL Server via PowerShell
- Trace access to SQL Server
- Monitor SQL Server infrastructure
- Troubleshoot SQL Server infrastructure
- Import and export data

Objectives : 
- Describe key features and components of SQL Server
- Describe T-SQL and logical predicates
- Write SELECT queries
- Write queries on multiple tables
- Write SELECT queries to sort and filter data
- Describe usage data types in SQL Server
- Write DML queries
- Write queries that use built-in functions
- Write sub-queries
- Create and implement views and functions of table values
- Use the set of operators to combine query results
- Use classification, shift and aggregation functions
- Transform data using pivot, unpivot, roolup and cube
- Create and execute stored procedures
- Program with T-SQL
- Set up management of error
- Implement transactions

Objectives : 
- Describe key features and components of SQL Server
- Describe T-SQL and logical predicates
- Write SELECT queries
- Write queries on multiple tables
- Write SELECT queries to sort and filter data
- Describe usage data types in SQL Server
- Write DML queries
- Write queries that use built-in functions
- Write sub-queries
- Create and implement views and functions of table values
- Use the set of operators to combine query results
- Use classification, shift and aggregation functions
- Transform data using pivot, unpivot, roolup and cube
- Create and execute stored procedures
- Program with T-SQL
- Set up management of error
- Implement transactions

Objectives : 
- Knowing how to create databases and database files
- Knowing how to create stored procedures and functions
- Knowing how to implement managed code in the database
- Knowing how to implement data integrity in Microsoft SQL Server 2016
- Understand how to use indexes to guarantee the performance of the database
- Knowing how to use Transact SQL to handle exceptions, create triggers
- Learn to use SQL Server’s specialized data types to manipulate hierarchical XML data or to manage spatial location data

Objectives : 
- Understand how to install or update a SQL Server instance
- Have the necessary skills for database maintenance
- Know how to optimize aspects relating to information storage
- Be able to migrate a local database to SQL Azure