Course SQL SERVER Working with a Database II.
The SQL SERVER Working with a Database II course is intended for graduates of the SQL SERVER Working with a Database course to deepen their knowledge of working with data, or for users who have experience with SQL and would like to expand their knowledge.
Minimum input knowledge
SQL knowledge at the level of the SQL SERVER Working with a Database course.
Course dates SQL SERVER Working with a Database II.
Daily courses (2 days): 09:00 - 15:00
Course price: 300.00 / 369.00 EUR
without VAT / incl. VAT
Training syllabus SQL SERVER Working with a Database II.
Review of Knowledge from the Working with a Database I Course
- Review of basic commands - SELECT, CREATE, INSERT, UPDATE, DELETE, DROP
Primary Keys, Foreign Keys and Data Normalization
Data Operations
- Nested queries and subqueries
- Working with text functions - LTRIM, RTRIM, UPPER, LOWER, LEN
- Cleaning and manipulation of text data - LEFT, RIGHT, SUBSTRING, REPLACE, CONCAT, CHARINDEX, REPLICATE, STUFF
Data Types and Formats
- Conversion between data types - CONVERT, CAST, TRY_CAST, TRY_CONVERT
- Working with date and time formats - GETDATE, DATEADD, DATEDIFF, FORMAT
Joining and Combining Tables
- Types of JOIN operations - CROSS JOIN, SELF JOIN
Combining Results - UNION, UNION ALL, INTERSECT, EXCEPT
Temporary Tables and Storing Intermediate Results
- Common Table Expressions
Local and Global Temporary Tables
Other SQL Functions
- Window functions - ROW_NUMBER RANK, DENSE_RANK, NTILE
Creating a Custom Function
Advanced SQL Techniques
- Stored procedures, input parameters
- DDL Trigger, DML Trigger
- Transactions, explicit and implicit, COMMIT and ROLLBACK commands
Types of Locks and Their Use
Query Optimization
- Optimization of JOIN and WHERE conditions
Indexing, Simple and Composite Indexes
Discussion
Output knowledge
After completing the course, you will be able to work with data at the level of a data analyst in the SQL Server environment.
Recommended courses after completing SQL SERVER Working with a Database II.
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews SQL SERVER Working with a Database II.
Average rating