Level 1 – Beginner (Database management course)
Recorded training
Who is this course for?
- SHS Students and Recent Graduates
- Individuals Seeking Career Transitions
- Freelancers and Junior devs who is interested to learn about database management
Why choose this course?
- To understand more about SQL Server Database platform
- Gain more knowledge about SQL Database and create sample use cases
Overview
- Welcome to the Introduction to Database using SQL Server Database Platform Course, it is said that data is new oil of the 21st century, with data being of utmost importance in any facets of business organizations, there is a need to understand the system that helps us to store and manage data in standardized structure. The Microsoft SQL Server is one of the popular database platforms in the industry so if you are looking for an easy, fast and you want to know advanced concepts of database and basic SQL querying, you are in the right place.
Prerequisites:
- Basic knowledge in programming and data structures and algorithms.
- Basic understanding of databases and database structures.
Tools:
- Database Engine, SQL Server Management Studio
Course Outline
Session 1: RDBMS Advanced Concepts and SSMS Environment
- What is the difference between database and DBMS?
- Types of Databases
- DBMS Architecture and Components
- Career Opportunities of Learning DBMS
- Getting Started with SQL Server
- SQL Server Installation
- SQL Server Management Studio
- Database Structure
Session 2: SQL Server Basic
- Querying data
- Sorting data
- Limiting Rows
- Filtering data
- Joining tables
- Sample Use cases.
Session 3: Types of SQL Languages
- SQL Server Data Types
- Data Definition
- CREATE
- DROP
- TRUNCATE
- ALTER
- Data Manipulation
- INSERT
- UPDATE
- DELETE
- Sample Use Cases
Learn now
₱350.00
✅ Digital badge
✅ Video Recording of All Live Sessions
✅ Learning materials from our trainer
As an SQL Server DBA, he has extensive experience managing and maintaining databases. Proficient in administering Windows Server environments. Skilled in automating backend processes for efficiency. Adept at planning, executing, and delivering IT projects. Proven experience in managing and maintaining IT infrastructure.
