What you'll learn
Introduction of SQL Server
How to create Table in SQL Server
How to Insert Data into Table
Select Statement with Join
Use of Common Table Expression
Use of Case in Select and Update Statements
Requirements
No Programming experience needed for this course.
Description
Embark on a journey to become a proficient SQL user with our comprehensive course designed for beginners and advanced learners alike. Whether you are a database novice or looking to enhance your SQL skills, this course covers everything you need to know about Structured Query Language (SQL) and its application in database management.1 Foundation of SQL:- Understanding the fundamentals of relational databases. Mastering the basics of SQL syntax and structure. Creating and manipulating database tables.2 Querying data:- Writing powerful SQL queries to retrieve and filter data. Employing advanced querying techniques for complex data extraction.3. Data Modification:- Inserting, updating and deleting records in a table. Ensuring data integrity through constraints.4. Joins and Relationships:- Exploring relationship between tables Utilizing different types of joins for comprehensive data retrieval.5 Data Aggregation and Grouping:- Understanding aggregate functions for summarizing data Grouping and transforming data for insightful analysisBy the end of this course, you will have the knowledge and hands-on experience to confidently work with SQL databases, manage data effectively, and optimize database performance.Whether you are pursuing a career in database administration, data analysis BI developer.This course equips you with the skills needed to excel in the world of databases.
Overview
Section 1: Introduction
Lecture 1 Introduction of SQL Server
Lecture 2 SQL Server Installation
Lecture 3 SQL Server Interface
Lecture 4 Server and Database
Lecture 5 Table, Record, Field
Section 2: Database
Lecture 6 Create Database
Lecture 7 Delete Database
Lecture 8 Activate Database
Lecture 9 Full Database Backup
Section 3: Table
Lecture 10 Create Table
Lecture 11 Delete Table
Lecture 12 Alter Table
Section 4: Data Insert, Import and Export
Lecture 13 Insert Data with Graphical User Interface
Lecture 14 Insert Data into Table
Lecture 15 Bulk Insert Data into Table
Lecture 16 Import Data into Table
Lecture 17 Export Data from Table
Section 5: Delete and Truncate
Lecture 18 Delete Data on Condition
Lecture 19 Delete Entire Data from Table
Section 6: Update Data
Lecture 20 Update Entire Field Data in Table
Lecture 21 Update Data on Condition
Lecture 22 Update Single Column Data from Another Table
Lecture 23 Update Multiple Columns Data from Another Table
Section 7: Select Statement to View Data (Where Clause)
Lecture 24 View Data
Lecture 25 View Distinct Data
Lecture 26 View Filtered Data
Section 8: Filter Data with Where Clause (And, Or, IN, Between, LIKE Operators)
Lecture 27 View Filtered Data with AND Operator
Lecture 28 View Filtered Data with OR Operator
Lecture 29 View Filtered Data with IN Operator
Lecture 30 View Filtered Data with BETWEEN Operator
Lecture 31 View Filtered Data with LIKE Operator
Section 9: Order By
Lecture 32 Sort Data in Ascending or Descending Orders
Lecture 33 Sort Data In Ascending Orders
Lecture 34 Sort Data in Descending Orders
Lecture 35 Sort Data on Two Fields
Section 10: Like Operator with Wild Card
Lecture 36 Filter Data with Pattern Match
Lecture 37 Filter Data with Single Character Match
Section 11: Group By and Having
Lecture 38 Extract Distinct Data
Lecture 39 Aggregate Data with Group By
Lecture 40 Apply Condition with Having Clause
Section 12: Sub Query
Lecture 41 Extract Data of Max Value
Lecture 42 Extract Data of Min Value
Lecture 43 Extract Data more than Average Value
Lecture 44 Extract 3rd Largest Value
Lecture 45 Extract 3rd Smallest Value
Section 13: Joins in SQL
Lecture 46 Join Introduction
Lecture 47 Inner Join
Lecture 48 Left Join
Lecture 49 Right Join
Lecture 50 Full Join
Lecture 51 Cross Join
Lecture 52 Self Join
Section 14: SQL Append
Lecture 53 Union
Lecture 54 Union ALL
Lecture 55 Intersect
Lecture 56 Except
Section 15: Case Statement
Lecture 57 Use Case Statement to Add Virtual Column
Section 16: CTE(Common Table Expression)
Lecture 58 Row_Number Function
Lecture 59 Rank Function
Lecture 60 Dense_Rank Function
Lecture 61 Extract Product Name of 3rd Largest Sales
Lecture 62 Remove Duplicate Data from Table
Lecture 63 Two Smallest Sales Based on Category
Lecture 64 Two Largest Sales Based on Category
This course is for them who want to mark career as a Data Analyst, Business Analyst, BI Developer


Homepage

https://www.udemy.com/course/sql-for-data-analyst-business-analyst-and-bi-developer/