SQL Database Administration & Query Skills: For Beginners
Explore this SQL Course for SQL Server setup, databases, tables, SELECT, JOINs, UNION, sorting, grouping, keys and introductory backup/restore.
67 minutes • English • HD 720p
Course Overview
SQL Database Administration & Query Skills: For Beginners
Get started with databases, tables and SQL queries.
This SQL Course introduces database concepts and query skills using SQL Server. Explore server setup, databases and tables, then connect data entry and basic SQL statements with selecting, combining, sorting and grouping information.
The beginner-friendly course brings together the structure of a database and the queries used to work with its contents. Backup and restore topics complete the introductory view of working with databases.
SQL Course: 6 introductory skill areas
Connect database structure with the SQL statements used to retrieve and organize stored information.
Set up the server and database
Explore SQL Server and database-server setup, databases and basic folder structure. Connect the setup topics with the environment used for storing and working with data.
Create tables and add data
Learn about tables, adding data, NULL and NOT NULL, and primary and foreign keys. Relate these concepts to the structure and relationships within a database.
Select information from a table
Explore basic SQL statements and SELECT queries on a single table. Connect the query you write with the information you want to retrieve from stored data.
Combine tables and query results
Work with JOINs across multiple tables and UNION to combine query results. Explore these approaches as different parts of working with related information and query results.
Sort and group information
Explore ORDER BY for sorting and GROUP BY for grouping. Connect these statements with the way query results are organized for the question you are examining.
Explore backup and restore
The SQL Course introduces database backup and restore within the introductory course scope. Connect these topics with the broader workflow of setting up a database and working with its data.
Explore the course details
Course focus and database context
The SQL Course connects server and database setup with table structure, data entry, query statements, keys and introductory backup/restore. SQL Server is the named platform used in the course.
General contexts include databases associated with social applications, bank customers, and website users or comments. These examples help introduce why information is stored and queried while the lessons focus on fundamental database and SQL skills.
Starting point and who it is for
No prior SQL or database knowledge is required. You will need internet access and a PC or laptop.
The SQL Course is intended for beginners who want an introduction to database administration and query skills. Follow how the setup, table and query topics relate to one another as you build familiarity with database concepts.
Course format
- Duration
- 1 hour 7 minutes
- Language
- English
- Video
- MP4 / H.264, 1280 x 720
- Audio
- AAC, 44.1 kHz
Explore related Development courses or browse IT & Software courses on CourseLinc. For product reference, see Microsoft’s database-objects introduction and UNION reference.


