Course SQL SERVER Working with a Database I.

Getting Familiar with the Microsoft SQL Server Environment

• Installation of SQL Server and SQL Server Management Studio
• Creating a database
• Creating a table, data types
• Entering data into a table
• Changing data
• Displaying a table
• Deleting a table

Connection with MS Excel and MS Access

Creating and Editing Databases

• Relational relationships between tables
• Primary keys, foreign keys
• Ensuring data integrity
• Database diagram
• Creating views, advantages of their use

Creating a Backup

SQL Language Syntax

• SELECT, CREATE TABLE, INSERT, UPDATE, DROP TABLE commands
• Filtering data using the WHERE command
• Logical operations
• Creating compound conditions using AND and OR
• NOT, IN, BETWEEN commands
• LIKE operator and using wildcard characters
• Sorting using the ORDER BY command
• Changing table columns using the ALTER TABLE command
• Deleting rows using the DELETE command
• Setting constraints for columns
• Joining tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN commands
• Aggregate functions - SUM, AVG, COUNT, MIN, MAX