What you’ll study
-
Primary Database Design (Tables, Columns, Knowledge Sorts, Major Keys, Normalization)
-
Utilizing Microsoft SQL Administration Studio
-
SELECT Statements: Queries in opposition to single tables (Filtering, Ordering, Grouping)
-
DELETE: How you can take away knowledge from a database
-
INSERT INTO: How you can insert knowledge right into a desk
-
UPDATE: How you can replace current knowledge
-
Filter teams of knowledge utilizing the HAVING clause
-
General Database Improvement Greatest Practices
-
Creating Relationships and Overseas Keys
-
How you can question associated knowledge from a number of tables
-
Utilizing Combination Features in SQL
-
How you can export Question Outcomes to Excel
-
How you can craft SQL statements primarily based on actual eventualities
-
Create Complicated Database Objects (Saved Procedures, Features, Views, Triggers)
-
Backup and Restore Databases
-
Generate Database Scripts for Automation
-
How you can handle database customers and safety
Publish expires at 2:50pm on Saturday January twenty first, 2023