Uncategorized

Permissions – lab Let’s share some drives and folders. Let’s start on the server. What we want to achieve is, let’s say, Mike, right? That’s the name we gave it. Let’s say he has a lot of files, and he asks the administrator, “Can I have a place on your server, please?” And he said, “Yeah, whatever. I can do that for you.” So you go into the reword. In most cases, you would have a dedicated hard drive. We will use the C drive for a small company, and…

What to expect in this section This section is really important. We are going to talk about Active Directory, something that you really need to know if you want to work with Microsoft services. We will set it up from scratch. Add a PC to the domain, discuss group permissions, and go over everything you need to know if you want to work with Active Directory. Active Directory Infrastructure Windows Server. Active Directory, if you ask me. Can you name one topic that is really important? If I want to…

Tables Welcome back. In this video, we’re going to start with the creation of tables. But first, we’re going to create a new database. There are two ways we can create a database in SQL Server Management Studio. We can use the graphical user interface or we can write the Transact SQL script ourselves. So, in the Object Explorer, right-click on Databases and select New Database. The following window opens. The first thing we need to specify is a name for the database. We’re going to name this database fundamental….

Normalization Normalization is the process of structuring a relational database in order to improve data integrity and reduce data redundancy. So there are basically two main reasons why we would want to normalise a database. The first one is to improve data integrity by creating rules for our data and enforcing these rules. The second one is to reduce data redundancy by splitting tables into smaller logical units and creating relationships between them. Imagine you have a customer table storing the name, date of birth, email, and address information of…

Querying Databases – Joins Hi, welcome back. In this video, we’re going to combine data from multiple tables using joins. Earlier in this course, we covered the process of normalising a relational database. We saw that this process involves breaking down tables into smaller logical units or entities. As a result of this, the data no longer resides within one table. So in order to get all the data, we have to combine it by relying on the relationships that are formed during the normalisation process. These relationships are formed…

Querying Databases – Ordering Welcome back. In this video, we’re going to look at ordering data using Transact-SQL. Data within a table can be physically sorted and stored in one specific way, and that completely depends on the clustered index key columns. These are, by default, the primary key columns. The problem is, we don’t always want to retrieve data in that specific way. Say we have a student’s table in which the student ID is the primary key column. This means that the data is physically sorted and stored…

Querying Databases Welcome back. In this video, we’re going to start with querying databases, which means we’re going to request information from the database using Transact-SQL. If we head over to the Object Explorer, expand the Databases node, select the North Wind database, and expand it, you’ll see all the objects that are in this database. For now, we’ll focus only on tables; as you can see, the alt table name starts with DBO, which stands for Database Owner. This is the default database schema. A schema is basically a…

Introduction to T-SQL DQL is used for querying or selecting data from a database. This involves the famous select command; with which we can get data or a subset of data from a database. Secondly, we have the data manipulation language, or DML. This is a subset of transact-SQL commands that are used for manipulating data in a database. The most common DML commands are Insert, which is used for inserting new rows into a table or view. Update, which is used for updating columns in a table or view….

Securing a SQL Server Database Database administration is the function of managing and maintaining a database management system, with the primary goal of ensuring maximum uptime for the databases so they can be made available as needed. Some of the most important activities performed as part of database administration are installing, configuring, and upgrading the DBMS along with related application tools. Securing the database is done by managing authentic communication and authorization, database tuning, and performance. Monitoring, the primary goal of which is to assess how a server is performing…

Stored Procedures Is a group of one or more transact SQL statements that form a single logical unit and are stored as an object in the database? Stored procedures are useful for a number of reasons. First of all, they can massively increase performance. That’s because a stored procedure is cached on the server, and also because fewer calls are made to the database. Imagine you have an application that performs a rather complex task wherein multiple transact SQL statements are sent to the database and multiple result sets are…