This course with database expert Ben Sawang introduces you to creating relational databases with SQL Server and the graphical interface, SQL Server Management Studio. Ben walks you through your first steps in the newest edition of Microsoft's database management system. He takes a detailed look at creating efficient tables and adding rows of data, importing existing tabular data from spreadsheets, and writing queries to view and process that data. Ben also covers important database management tasks such as creating backups, securing access to sensitive information, and leveraging the capabilities of Microsoft’s Azure cloud infrastructure.
1 LessonsCreate databases with SQL Server 2022 and What you should know
2 LessonsCore concepts, Choose a SQL Server 2022 edition, Install SQL Server & Management Studio, Enable features with Configuration Manager, Deploy SQL Server 2022 in the Azure cloud and Work with SQL Server in Docker
7 LessonsUser permissions and authentication, Log in with Management Studio, Enable the System Administrator account and Connect to Azure and Docker servers
4 LessonsCreate the first database, Database configuration options, Table structures, Create a simple table, Edit a table's structure...
9 LessonsChoose appropriate data types, SQL Server data type options, Automatically assign record identities, Primary key fields, Establish a default value....
10 LessonsUnderstand the role of T-SQL, Use the T-SQL editor, Create a table with T-SQL, Add data to a table, Retrieve records with SELECT, Sort records ...
10 LessonsCreate a view of the data, Data table indexes, Create additional indexes on a table, Aggregate functions, Use built-in functions ...
9 LessonsCreate a full backup of the database, Create a differential backup, Restore a backup, Business continuity solutions and Continuously replicate data to the cloud
5 LessonsCreate a new user account, User roles and permissions, Database schemas, Dynamic data masking and Always on data encryption
5 LessonsExplore the role of system databases
4 LessonsNext steps
1 LessonsLogin To Leave Review