-
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsql.html
126 lines (108 loc) · 5.79 KB
/
sql.html
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
117
118
119
120
121
122
123
124
125
126
<!DOCTYPE html>
<html lang="en">
<head>
<base href="./" />
<link rel="shortcut icon" type="image/png" href="/assets/img/favicon.png"/>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="Site description">
<meta name="author" content="Biljana Zobenica">
<link rel="canonical" href="/">
<title>Biljana Zobenica</title>
<!-- Bootstrap core CSS -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet">
<!-- Custom fonts for this template -->
<link href="assets/css/all.min.css" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet" type="text/css">
<link href='https://fonts.googleapis.com/css?family=Kaushan+Script' rel='stylesheet' type='text/css'>
<link href='https://fonts.googleapis.com/css?family=Droid+Serif:400,700,400italic,700italic' rel='stylesheet' type='text/css'>
<link href='https://fonts.googleapis.com/css?family=Roboto+Slab:400,100,300,700' rel='stylesheet' type='text/css'>
<!-- Custom styles for this theme -->
<link href="assets/css/agency.css" rel="stylesheet">
<!-- Page container change top padding when nav shrinks -->
</head>
<body id="page-top">
<div class="container">
<div class="row">
<div class="col-lg-12">
<!-- Navigation -->
<nav class="navbar navbar-expand-lg navbar-dark fixed-top" id="mainNav">
<div class="container">
<a class="navbar-brand js-scroll-trigger" href="#page-top">Biljana Zobenica</a>
<button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
Menu
<i class="fas fa-bars"></i>
</button>
<div class="collapse navbar-collapse" id="navbarResponsive">
<ul class="navbar-nav text-uppercase ml-auto"><li class="nav-item"><a class="nav-link js-scroll-trigger" href="#services">Likes</a></li>
<li class="nav-item"><a class="nav-link js-scroll-trigger" href="#portfolio">Portfolio</a></li>
<li class="nav-item"><a class="nav-link js-scroll-trigger" href="#timeline">About</a></li>
<li class="nav-item"><a class="nav-link js-scroll-trigger" href="#contact">Contact</a></li>
<li class="nav-item"><a class="nav-link js-scroll-trigger" href="./blog.html">Blog</a></li>
</ul>
</div>
</div>
</nav>
<section id="content" class="section-top-padding">
<article class="article-top-padding">
<h1>
<a href="https://github.com/biljana-zobenica/Querying_with_Transact-SQL"
rel="bookmark"
title="Premalink to SQL repo"
target="_blank">
Database Fundamentals with SQL
</a>
</h1>
<i><time datetime="2014-09-06T00:00:00-04:00"> Sun 25 April 2021</time></i>
<div class="entry-content">
<div class="panel">
<br/>
</div>
<div class="container">
<br/>
<img class="img-responsive" style="width: 50%; min-width: 300px" src="/assets/img/blog/sql_background.png">
</div>
<hr class="featurette-divider">
<h2>Creating Relationships in SQL</h2>
<br>
<p>I took the Macrosoft Technology Associate Course: <a href="assets/img/blog/mta.jpg" target="_blank" title="Microsoft Certificate of Achievement">
40364 Database Administration Fundamentals</a>, which covers core SQL Server concepts, manipulating data, creating queries and database administration.
As a result, the course participants are equipped with the fundamental and practical knowledge to get them started on building their own relational databases.
</p>
<br>
<p>Some of the exercies done in SQL are demonstrated on GitHub repo <a href="https://github.com/biljana-zobenica/Querying_with_Transact-SQL" target="_blank">
Querying_with_Transact-SQL</a>.</p>
<br>
<p>Additionally, SQL complete tutorial, from beginner to advanced concepts, covering MySQL database fundamentals and advanced topics, created
by Mosh Hamedani, was covered. Also, interactively, exercises from MODE website are covered as well. All solutions are demonstrated here:
<a href="https://github.com/biljana-zobenica/SQL-complete-tutorial" target="_blank">SQL complete tutorial</a>.</p>
<br>
</article>
</section>
</div>
</div>
</div>
<!-- End Navigation -->
<!-- Footer -->
<footer class="footer" id="footer" style="background-color:white;">
<div class="container">
<div class="row align-items-center">
<div class="col-md-12 text-left">
<span class="copyright">Copyright © Biljana Zobenica 2021-Present</span>
</div>
</div>
</div>
</footer>
<!-- End Footer -->
<!-- Bootstrap core JavaScript -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<!-- Plugin JavaScript -->
<script src="assets/js/jquery.easing.min.js"></script>
<!-- Contact form JavaScript -->
<script src="assets/js/jqBootstrapValidation.js"></script>
<script src="assets/js/contact_me.js"></script>
<!-- Custom scripts for this template -->
<script src="assets/js/agency.min.js"></script>
</body>
</html>