sqlwork/index.html at main · ambilian/sqlwork · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Data Exploring with SQL</title>
        <!-- Link to the heading.css file -->
        <link rel="stylesheet" href="heading.css">
        <style>
            body {
                font-family: "Arial", sans-serif;
                background-color: #f4f4f4;
                color: #333;
                margin: 0;
                padding: 0;
            }
            .container {
                max-width: 900px;
                margin: 40px auto;
                background: white;
                padding: 30px;
                border-radius: 10px;
                box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
                text-align: justify;
            }
            h1 {
                color: #2c3e50;
                font-size: 28px;
                text-align: center;
                margin-bottom: 10px;
            }
            p {
                font-size: 16px;
                line-height: 1.6;
                margin-bottom: 20px;
            }
            .skills-section {
                margin-top: 20px;
            }
            .skills-section p {
                font-size: 16px;
                line-height: 1.5;
                margin-bottom: 15px;
            }
            .button-container {
                text-align: center;
                margin-top: 30px;
            }
            .button {
                background-color: #007bff;
                color: white;
                padding: 12px 25px;
                border: none;
                cursor: pointer;
                font-size: 16px;
                border-radius: 5px;
                text-decoration: none;
                display: inline-block;
            }
            .button:hover {
                background-color: #0056b3;
            }
        </style>
    </head>
<body>
    <div class="container">
        <h1>Welcome to SQL Projects</h1>
        <h2>Ambili - The Data Specialist</h2>
        <p>This website showcases my professional journey and the insights I’ve gathered through my projects in SQL projects.</p>

        <h2>About Me</h2>
        <p>My name is Ambili, a Data Analyst with extensive experience in data analysis, visualization, and reporting.
        I hold a Master's in Business Data Science from the University of Otago. With expertise in  Python, Advanced Excel, R, SQL, and Power BI,
        I specialize in transforming complex datasets into actionable insights. My strengths include problem-solving, critical thinking, and stakeholder communication.</p>
        <h2>My Skills in SQL</h2>
        <div class="skills-section">
            <h3>Proficient in SQL</h3>
            <p>Demonstrated expertise in using SQL for data analysis and reporting, including creating complex queries to extract and manipulate data from databases.</p>

            <h3>Data Modeling and Analysis</h3>
            <p>Skilled in designing and managing relational databases, transforming raw data into meaningful insights through SQL queries, joins, subqueries, and aggregations.</p>

            <h3>Database Design</h3>
            <p>Experienced in creating and maintaining database schemas, tables, and indexes for optimized data storage and retrieval, ensuring efficient database performance.</p>

            <h3>Data Integration</h3>
            <p>Adept at integrating data from multiple sources (SQL databases, Excel, APIs) into SQL databases, ensuring seamless data flow for analysis and reporting.</p>

            <h3>Advanced SQL Queries</h3>
            <p>Proficient in writing advanced SQL queries, including complex joins, CTEs (Common Table Expressions), window functions, and stored procedures to meet business requirements.</p>

            <h3>Performance Optimization</h3>
            <p>Knowledgeable in optimizing SQL queries for performance, ensuring quick and efficient data retrieval by using indexing, query optimization, and execution plans.</p>

            <h3>Data Security and Integrity</h3>
            <p>Experienced in implementing security measures like user roles, permissions, and data integrity constraints to ensure safe and consistent database usage.</p>

            <h3>Database Maintenance</h3>
            <p>Skilled in performing database backup and restore operations, handling data migrations, and managing scheduled tasks in SQL Server and other relational database systems.</p>

            <h3>Training and Support</h3>
            <p>Provided training and support to team members on writing efficient SQL queries and best practices, fostering a strong data-driven culture within the organization.</p>

            <h3>Continuous Learning</h3>
            <p>Committed to staying up-to-date with the latest SQL features, best practices, and database technologies through ongoing training and professional development.</p>
        </div>


        <div class="button-container">
            <a href="https://github.com/ambilian/sqlwork/blob/main/SQL%20Projects.pdf" target="_blank" class="button">MY SQL Works</a>
        </div>
    </div>
</body>
</html>