Sales Capacity Planning in Excel with team capacity, sales target and hiring ramp, 13 lectures, 1h 14m, Beginner, English
Sales Capacity and Quota Planning in Excel Original price was: ₹499.00.Current price is: ₹99.00.
Back to products
AI Productivity course with BRIEF, VERIFY, source evidence and human review, 27 lectures, 4h 34m, All Levels, English
AI Productivity Masterclass: From Prompts to Verified Work Original price was: ₹999.00.Current price is: ₹499.00.

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

Original price was: ₹499.00.Current price is: ₹99.00.

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 Server and databasesQueries and relationshipsBackup and restore
67 minutesVideo duration
EnglishCourse language
HD 720p1280 x 720 video
SQL ServerCourse platform

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.

Learner reviews

Explore more courses

Original price was: ₹499.00.Current price is: ₹199.00.
Original price was: ₹999.00.Current price is: ₹499.00.
Original price was: ₹999.00.Current price is: ₹499.00.
Original price was: ₹999.00.Current price is: ₹499.00.
Original price was: ₹499.00.Current price is: ₹199.00.
Original price was: ₹499.00.Current price is: ₹199.00.
Original price was: ₹499.00.Current price is: ₹199.00.
Original price was: ₹499.00.Current price is: ₹99.00.
Original price was: ₹499.00.Current price is: ₹99.00.
Original price was: ₹499.00.Current price is: ₹199.00.
Original price was: ₹999.00.Current price is: ₹499.00.