DataCamp: SQL Server Developer Certificate - Githubissues

dannydore / career-development

Career development

0 stars 0 forks source link

DataCamp: SQL Server Developer Certificate #3

Open dannydore opened 4 months ago

dannydore commented 4 months ago

https://www.datacamp.com/tracks/sql-server-developer

[x] Introduction to SQL Server
[ ] Introduction to Relational Databases in SQL
[ ] Intermediate SQL Server
[ ] Time Series Analysis in SQL Server
[ ] Functions for Manipulating Data in SQL Server
[ ] Database Design
[ ] Transactions and Error Handling in SQL Server
[ ] Writing Functions and Stored Procedures in SQL Server
[ ] Building and Optimizing Triggers in SQL Server
[ ] Improving Query Performance in SQL Server

dannydore commented 2 months ago

Completed "Introduction to SQL Server"! Highlights:

SELECT statements with FROM & WHERE clauses
ORDER BY keyword
Aggregate functions SUM(), COUNT(), MIN(), MAX(), AVG()
String functions LEN(), LEFT(), RIGHT(), CHARINDEX(), SUBSTRING(), REPLACE()
HAVING clause
Joins INNER JOIN, LEFT & RIGHT joins
Unions UNION & UNION ALL
CRUD (CREATE, READ, UPDATE, DELETE)
Data types (Date, Numeric, Strings)
Variables (DECLARE, SET)
Temporary tables