The latest articles on DEV Community by Brenda Aluoch (@brenda22). https://dev.to/brenda22 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F973550%2Fd21c0cce-6bc3-4a90-911b-e9e1dda2aaf9.jpeg https://dev.to/brenda22 en Brenda Aluoch Thu, 17 Nov 2022 09:22:24 +0000 https://dev.to/brenda22/my-first-sql-query-19d1 https://dev.to/brenda22/my-first-sql-query-19d1 <p>This is my first Microsoft server SQL, I can't believe it! I really longed for this opportunity .I must thank BlackTech Academy for giving me the opportunity to join 'The free SQL cohort2 training'.<br> How can I forget to thank the 'DEV COMMUNITY ' for giving me a platform to document my projects and learn more !! #Thank your ,THE DEV COMMUNITY.</p> <p><strong>Database Overview.</strong><br> The database was AdventureWorks2017 database with several tables and <a href="https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure" rel="noopener noreferrer">https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure</a> is the link to access the database</p> <p>1.#SELECT STATEMENT<br> -Is a built-in function used to select entire table or column in a table.</p> <p>a. Showing person from Person. Person table with the first name Rob or Roberto<br> I applied the following select query command :. Person from person. Person table with the firstname as Rob or Roberto</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fyc374rnyhoq64uz5v479.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fyc374rnyhoq64uz5v479.png" alt="Image description" width="309" height="569"></a></p> beginners Brenda Aluoch Thu, 17 Nov 2022 08:01:19 +0000 https://dev.to/brenda22/my-first-sql-query-2o3k https://dev.to/brenda22/my-first-sql-query-2o3k <p>This is my first Microsoft server SQL, I can't believe it! I really longed for this opportunity .I must thank BlackTech Academy for giving me the opportunity to join 'The free SQL cohort2 training'.<br> How can I forget to thank the 'DEV COMMUNITY ' for giving me a platform to document my projects and learn more !! #Thank your ,THE DEV COMMUNITY.</p> <p><strong>Database Overview.</strong><br> The database was AdventureWorks2017 database with several tables and <a href="https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure" rel="noopener noreferrer">https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure</a> is the link to access the database</p> <p>1.#SELECT STATEMENT<br> -Is a built-in function used to select entire table or column in a table.</p> <p>a. Showing person from Person. Person table with the first name Rob or Roberto<br> I applied the following select query command :. Person from person. Person table with the firstname as Rob or Roberto</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fyc374rnyhoq64uz5v479.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fyc374rnyhoq64uz5v479.png" alt="Image description" width="309" height="569"></a></p> watercooler Brenda Aluoch Wed, 16 Nov 2022 11:35:40 +0000 https://dev.to/brenda22/my-first-sql-query-3p2a https://dev.to/brenda22/my-first-sql-query-3p2a <p>This is my first Microsoft server SQL command, I can't believe it! I really longed for this opportunity .I must thank BlackTech Academy for giving me the opportunity to join 'The free SQL cohort2 training'.<br> How can I forget to thank the 'DEV COMMUNITY ' for giving me a platform to document my projects and learn more !! #Thank your ,THE DEV COMMUNITY.</p> <p><strong>Database Overview.</strong><br> The database was AdventureWorks2017 database with several tables . <a href="https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure">https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure</a> is the link to access the database</p> <p>1.#SELECT STATEMENT<br> -Is a built-in function used to select entire table or column in a table.</p> <p>a. Showing person from Person. Person table with the first name Rob or Roberto<br> I applied the following select query command to get Person from person. Person table with the firstname as Rob or Roberto</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--eFxNsBuT--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/yc374rnyhoq64uz5v479.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--eFxNsBuT--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/yc374rnyhoq64uz5v479.png" alt="Image description" width="309" height="569"></a></p> <p>b. showing the first 10 records from [Sales].[SalesOrderDetal]</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--PussnwEU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/y5e0eef7oz19p5txme77.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--PussnwEU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/y5e0eef7oz19p5txme77.png" alt="Image description" width="685" height="460"></a></p>