This course provides a foundation for MSSQL database administration and discusses the fundamental models of database management systems. It covers the definition, development, and management of databases for information systems.
Microsoft SQL Server 2019 will be used extensively to convey database concepts, design, and processing. Topics include normalization, indexing, querying, data analysis, data modeling concurrency, transaction processing and control, security, views, stored procedures, triggers, and backup and recovery. Data Definition Language (DDL) and Data Manipulation Language (DML) will be discussed at length as will query building and three-tier applications.
Per course: $1,995
All 7 developer courses: $12,995