Embedded Files
Career and Technical Education (CTE) Course Description
Career and Technical Education (CTE) Course Description
LearnKey's Databases course is an introduction to building, entering information into, and querying databases. The course also provides a solid introduction to Structured Query Language (SQL), the primary language used to get the desired information from a database. This course helps one get ready to take and pass the IT Specialist Databases exam and will help one’s employability prospects in any job requiring querying and junior database administration skills.
LearnKey's Databases course is an introduction to building, entering information into, and querying databases. The course also provides a solid introduction to Structured Query Language (SQL), the primary language used to get the desired information from a database. This course helps one get ready to take and pass the IT Specialist Databases exam and will help one’s employability prospects in any job requiring querying and junior database administration skills.
Students will have the opportunity to showcase their accomplishments by participating in Business Professionals of America (BPA) Competitions. It is a “hand-on” class and much of the work is completed independently. There will also be opportunities in Soft Skills and Work Based Learning.
Students will have the opportunity to showcase their accomplishments by participating in Business Professionals of America (BPA) Competitions. It is a “hand-on” class and much of the work is completed independently. There will also be opportunities in Soft Skills and Work Based Learning.
Topics Covered
Topics Covered
- Database Design
- Database Object Management
- Data Retrieval
- Data Manipulation
- Troubleshooting.
Course Prerequisites
Course Prerequisites
- Java or Python
- Good Work Ethic
- 8th grade reading skills
- Some familiarity with data organization concepts
- Critical thinking and problem-solving skills
- Digital literacy skills, including the ability to research, create content, and solve problems using technology
Certification Preparation:
Certification Preparation:
- Certiport IT Specialist: Databases
Required (BPA Contest 345 - SQL Database Fundamentals - Free testing at NLC)
Certification Test Total Points: 1000
Certification Test Passing Points: 700
Certification Retake Policy:
If you don’t receive a passing score on an exam the first time, you must wait 24 hours before retaking the exam.
If you don’t receive a passing score on your second attempt, you must wait seven days before retaking the exam a third time.
A seven-day waiting period is imposed between each subsequent exam retake.
You may not take a given exam any more than five times per year/12-month period, which starts from your first attempt. If you take a given exam five times in that period, you will become eligible to retake the exam 12 months from the date of your first attempt.
If a candidate achieves a passing score on an IT Specialist exam, the candidate cannot take it again.
- Microsoft Office Specialist: Access 2019 Expert (Certiport)
Optional (BPA contest 240 - Database Applications - Free testing at NLC)
Certification Test Total Points: 1000
Certification Test Passing Points: 700
Certification Test Attempts: Unlimited
Articulation
Articulation
- Language Other Than English: The second credit can be substituted with CTE program completion
- Physical Education & Health: PE/Health credit can be substituted with additional CTE program completion
- Science: One credit of Physics or Chemistry can be substituted with CTE program completion
- Social Studies: One credit of Social Studies (except Govt) can be substituted with additional CTE program completion
- Visual, Performing, and Applied Arts: Credit can be substituted with CTE program completion
Other
Other
- Grades: 9-12
- Length: 1 semester
- Credits: 1/2
- CTE CIP: 11.0201 Computer Programming/Programmer
- PSN: 20362
Agenda:
Agenda:
Links:
Links:
Database Connection Steps using SSMS
Open SSMS: Start SQL Server Management Studio. The Connect to Server window usually opens automatically. If it does not, you can open it manually by selecting Object Explorer > Connect > Database Engine.
Specify Server Type: In the dialog box, ensure the Server type is set to Database Engine.
Enter Server Name: In the Server name box, provide the identifier for your SQL Server instance.
Local Default Instance: Use localhost, 127.0.0.1, or a single period (.).
Local Named Instance: Use the format <computer_name>\<instance_name> (e.g., MyServer\SQLExpress).
Remote Server: Use the remote server's name or IP address. If a custom port is used, specify it with a comma (e.g., tcp:MyServer,51433).
Azure SQL Database: Use the fully qualified server name (e.g., <servername>.database.windows.net).
Select Authentication: Choose the appropriate Authentication method.
Windows Authentication: This is the default and uses your current Windows login credentials. This is common for local or domain-joined servers.
SQL Server Authentication: Select this if you have a specific SQL login name and password. Enter the Login and Password in the fields provided.
Microsoft Entra ID (Azure SQL): Various Azure Active Directory authentication options are available for connecting to Azure SQL services.
Connect: Select Connect. If successful, the Object Explorer window will open, displaying your connected server instance and its databases.
Install AdventureWorks Database123
The AdventureWorks database is a sample database provided by Microsoft for learning and testing SQL Server features. Below are the steps to install it using the .bak file.
Step 1: Download the AdventureWorks .bak File
Visit the AdventureWorks GitHub page or Microsoft Learn to download the appropriate .bak file for your SQL Server version (e.g., AdventureWorks2019.bak).
Save the file to your SQL Server backup directory, typically:
C:\Program Files\Microsoft SQL Server\MSSQL<version>.MSSQLSERVER\MSSQL\Backup
Step 2: Restore the Database Using SQL Server Management Studio (SSMS)
Open SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
In Object Explorer, right-click on Databases and select Restore Database....
In the Source section: Choose Device and click the ellipsis (...) button. Click Add, navigate to the .bak file location, and select it.
In the Destination section: Ensure the database name matches your desired name (e.g., AdventureWorks2019).
Go to the Files tab: Verify that the paths for .mdf and .ldf files are correct.
Click OK to start the restore process.
Step 3: Verify Installation
Once restored, expand the Databases node in SSMS to see AdventureWorks.
Run a query on one of its tables to confirm successful installation:
SELECT TOP 10 * FROM Person.Person;
Alternative: Restore Using T-SQL
You can also restore using a T-SQL script:
USE master;
GO
RESTORE DATABASE AdventureWorks2019
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL<version>.MSSQLSERVER\MSSQL\Backup\AdventureWorks2019.bak'
WITH MOVE 'AdventureWorks2017' TO 'C:\SQLData\AdventureWorks2019.mdf',
MOVE 'AdventureWorks2017_log' TO 'C:\SQLData\AdventureWorks2019_log.ldf',
STATS = 10;
GO
Tips
Ensure you have appropriate permissions for accessing the .bak file.
Use a version of AdventureWorks compatible with your SQL Server version.
If you encounter issues, check that your SQL Server instance has access to the backup directory.
This process ensures a smooth installation of AdventureWorks for testing or learning purposes.
Page updated
Report abuse