SQL Server Lecture 1
•Download as PPTX, PDF•
2 likes•2,603 views
The document outlines a lecture on SQL Server 2008 that includes reviewing database concepts, installing and configuring SQL Server 2008, introducing SQL Server services and Management Studio, and how to create databases and tables. It discusses database concepts like entities, attributes, and normalization, and covers installing SQL Server in 14 steps, configuring SQL services, and connecting to SQL Server remotely.
SQL Server Lecture 1
- 1. SQL Server 2008 Lecture 1 Hazem Torab CEO, Founder Enozom Software
- 2. Agenda • Reviewing Database Concepts • Conventions • SQL Server2008 Overview • Installing and Configuring SQL Server 2008. • Introducing SQL Server 2008 services. • Introducing Management Studio. • Introducing built-in Database. • Creating Databases and Database Files.
- 3. Database Concepts • Entities • Attributes • Relations • Normalization • De-Normalization
- 4. Conventions • Database Names • Table Names • Attribute Names • Procedure Names • Spaces and Reserved Words
- 5. SQL Server Overview • SQL Server Editions – Express – Web – Workgroup – Standard – Enterprise
- 7. SQL Server Overview • Why SQL Server – Huge Data Manipulation – Fast response time – Automated Database Backups – Main Customers – Volvo Cars – Great Western Bank – MSN http://www.youtube.com/watch?v=8HIUXfTQGEg
- 8. Installing SQL Server • Prerequisites: – Windows Professional Edition or Server Edition – .NET Framework 3.5
- 9. Installing SQL Server • STEP 1 : Copy the installation files
- 10. Installing SQL Server • STEP 2 : Setup
- 11. Installing SQL Server • STEP 3 : SQL Server Installation Center
- 12. Installing SQL Server • STEP 4 : Initializing Setup
- 13. Installing SQL Server • STEP 5 : Product Key (Optional)
- 14. Installing SQL Server • STEP 5: Setup
- 15. Installing SQL Server • STEP 6 : Setup Support Files
- 16. Installing SQL Server • STEP 7: Select Features
- 17. Installing SQL Server • STEP 8: Instance Configuration
- 18. Installing SQL Server • STEP 9: Disk Space Requirements
- 19. Installing SQL Server • STEP 10: Server Configuration
- 20. Installing SQL Server • STEP 11:
- 21. Installing SQL Server • STEP 12: Database Engine Configuration – Data Directories
- 22. Installing SQL Server • STEP 13 :Ready to Install
- 23. Installing SQL Server • STEP 14: Finally Finished
- 24. Installing SQL Server • STEP 15: Restart
- 25. Configuring SQL Server • SQL Server Services – Check this whenever you have problems with your database – SQL Server – SQL Server Agent – SQL Server Browser – SQL Server VSS Writer
- 26. Configuring SQL Server • Enable TCP Connections
- 27. Configuring SQL Server • Disable your firewall for SQL Server connections Port 1434 UDP & TCP • Disable your antivirus firewall for SQL server connections
- 28. Connecting to remote SQL Server • Try to your SQL server from another computer on the same network
- 29. SQL Server Management Studio
- 30. SQL Server Management Studio • Object Explorer
- 31. SQL Server Management Studio
- 32. SQL Server Management Studio • Read More About Management Studio Features http://msdn.microsoft.com/en-us/library/ms174173.aspx
- 34. Creating Tables • Create Single Table
- 35. Self Reading • SQL Server Management Studio features http://msdn.microsoft.com/en-us/library/ms174173.aspx • Built-in Databases http://www.dotnetspider.com/resources/1231-Built-In-Databases-MS- SQL-Server.aspx
Editor's Notes
- In the following slide we are going to know 25 stupid mistakes that should be avoided to get better query readability, maintainability, security and performance.