This course Exam 70-761: Basic Database Concepts is the first part of the series-Basic Database ConceptsManage data with Transact-SQLQuery data with advanced Transact-SQL ComponentsProgram Database by using Transact-SQLIn this course, you will learn-Basic Database ConceptsWhat is Data, Field, Record and database? Limitations of File Management System. Basic Concepts of Advantages of DBMSLevels of AbstractionExploring Relational DBMSUnderstanding E-R Modeling With ExampleUnderstanding Normalization with ExampleSQL Server InstallationInstalling SQL Server various VersionsInstalling SQL Server Mangement StudioUnderstanding SQL Server Instances Connecting to SQL Server Instance using SSMSIntroduction to SQL SERVER and SQLHistory and Editions of SQL Server Server Components and Tools Instance and Browser Service Starting and Stopping SQL Server Service Types of Authentication Management Studio Types of System Databases Introduction to SQL Create DatabaseCreate Database Using User InterfaceUnderstanding Files and FileGroupCreate Database Using T-SQLAlter DatabaseWorking With TableWorking With SCHEMACREATE/ALTER/DROP SCHEMA
