SELECT Statement
INSERT, UPDATE and DELETE Statements
Database Backups and Restores
SELECT Statement Demonstration
Securing Databases and Objects
This course begins by discussing how the SELECT statement retrieves data from your database. You will learn that the SELECT statement can include the WHERE clause to define the conditions used to determine what rows will be returned. This course will also teach you how to modify your database using INSERT, UPDATE and DELETE. It will also teach you that predicates are used in the search condition of WHERE clauses and HAVING clauses, the join conditions of FROM clauses, and other constructs where a Boolean value is required.
You will then study how to secure your database and its objects. With this course, you will learn that a database user is a security-level principal that must be mapped to be able to log in at the server level and connect to the database. It will also teach you how to add users and set their permission levels as well as backup and restore your database. In addition, you will learn how aggregate functions work with the SELECT statement.
Learning how to query a database and apply security to it will greatly enhance your computer skills and with this course, you will learn all these, and more. You will study the three-tiered approach to accessing content which includes SQL Server access, Database access, and Object access. You will also learn that accessing the database is on a different level compared to accessing the Server. Check out the course and boost your computer skills now!
0 Reviews
Teach Academy eLearning provides corporate, government and education sectors with proven on-demand training for employees. The company was founded in 2015 and has had more than 1.3 million students taking their courses. Teach Academy eLearning is a name you can trust for workforce training. The company specialises in video-based technology training content. The goal has always been to engage learners through an immersive, hands-on learning approach. Teach Academy prides itself on releasing titles on the cutting edge of technology. The subject matter experts are deeply involved in the subjects they teach, so the courses go into great depth and provide learners with the skills they need to implement real-world solutions with a given technology. The courses offered by Teach Academy vary from data analytics, software development and marketing to productivity in meetings and data visualisation.
Send this course as a gift to your friends
