السعر: 340 USD
680 USD
100% ضمان استعادة الاموال
No questions asked refund With a goal of giving you a worry-free and secure enrollment experience, We offer a 24 hour money-back guarantee. Just send us a refund request via email within 24 hours after first class and we will refund 100% of your payment, no questions asked!
تدريب إفتراضي أونلاين. المحاضرات قد تكون فردية أو ضمن مجموعة.
- مدة الدورة التدريبية: 20 ساعة
- مواعيد الدورة: استفسار
تفاصيل الدورة
Microsoft SQL Server is a Relational Database Management System (RDBMS) used to store and retrieve data requested by other applications. The course is to excel the skills in database and learn the performance of Microsoft SQL Server for delivering fast data insights that drive business transformation. Through the SQL Server course, you will be learning all necessary skills in storage scenarios and real-world data collection. Dive into expert-authored courses and a vast function that covers every essential part for a SQL programmer.
What you will Learn?
SQL Overview
- Outlining SQL as the cornerstone of database activity
- Introduction to RDBMS
- Describing the fundamental building blocks: tables, columns, primary keys and foreign keys
- Creating tables and columns·
- Building tables with CREATE TABLE
- Modifying table structure with ALTER TABLE
- Adding columns to an existing table
- Removing tables with DROP TABLE
- Guaranteeing uniqueness with primary key constraints
- Enforcing integrity with foreign key constraints
- Imposing business rules with check constraints
- Enabling and disabling constraints
- Removing constraints with ALTER TABLE.
- Improving performance with indexes
- Modifying table contents
- Adding table rows with INSERT
- Changing row content with UPDATE
- Removing rows with DELETE
- Atomic Consistent Isolated Durable (ACID) rules
- Controlling transactions with COMMIT and ROLLBACK
- Retrieving data with SELECT
- Restricting rows with the WHERE filter
- Sorting the result with ORDER BY
- Handling NULL values in expressions
- Avoiding NULL value pitfalls in filter conditions
- Applying the ANSI/ISO standard join syntax
- Matching related rows with INNER JOIN
- Including non matched rows with OUTER JOIN
- Creating a Cartesian product with CROSS JOIN
- Combining results with set operators
- Stacking results with UNION
- Identifying matching rows with INTERSECT
- Summarizing data using SUM, AVG and COUNT
- Finding the highest/lowest values with MAX and MIN
- Defining the summary level with GROUP BY
- Applying filter conditions with HAVING
- Applying subqueries in filter conditions
- Correlated vs. noncorrelated subqueries
- Testing the existence of rows Including subqueries in expressions
- Placing subqueries in the column list
- Creating complex expressions containing subqueries
- Stored Procedures
- Selecting data from a query result set
- Subqueries in the FROM clause
- Creating views in a database
- Building reusable code
- Updateable vs. non-updateable views
This course is suitable for
- Web Programmers
- Software Developers
- Database Administrators
- Web Designers
- Business Analysts
- You don’t need any specific knowledge to learn SQL Server, Basic knowledge of computer is all you need to get started.
Content / Syllabus
تحديث بتاريخ 26 September, 2024Course Outline:
Important topics that will be covered:
SQL Overview:
- Outlining SQL as the Cornerstone of database activity
- Introduction to RDBMS
- Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys
Building The Database Schema:
- Creating tables and columns
- Building tables with CREATE TABLE
- Modifying table structure with ALTER TABLE
- Adding columns to an existing table
- Removing tables with DROP TABLE
Executing a Simple Query:
- Connect to the SQL Database using SQL Server Management Studio
- Query a Database using the SELECT Statement
- Save a Query Script to a File
- Modify and Execute a Saved Query
Protecting Data Integrity With Constraints:
- How to create Primary Key and Foreign Key
- Enabling and disabling constraints Removing constraints with ALTER TABLE
- Improving performance with indexes
Manipulating Data:
- Modifying table contents
- Adding table rows with INSERT
- Changing row content with an UPDATE
- Removing rows with DELETE
Performing a Conditional Search:
- Use the WHERE Clause to Search and Filter Data using One or More Conditions
- Use the WHERE Clause to Search for a Range of Values with BETWEEN and IN Clauses
How to Handle NULL Values in Data:
- Search Text Data Based on Patterns using the LIKE Operator
Working with Functions:
- Format and Manipulate Dates using Date Functions
- Summarize Data using Aggregate Functions Like COUNT, SUM, AVG, MIN, MAX
- Use Functions to Manipulate String Values
Organizing Data:
- Sort Data using the ORDER BY Clause
- Group Data with the GROUP BY Clause
- Filter Grouped Data using the HAVING Clause
Retrieving Data from Multiple Tables:
- Query Data from Multiple Tables using the JOIN Clause
- Combine the Results of Two Queries with the UNION Statement
- Compare the Results of Two Queries with the INTERSECT and EXCEPT Statements
Developing In-Line And Stored Views:
- Stored Procedures
- Selecting data from a query result set
- Subqueries in the FROM clause
- Creating views in a database
المتطلبات
You don’t need any specific knowledge to learn SQL Server, Basic knowledge of computer is all you need to get started.
استفسر عن هذه الدورة
يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.
